Data Warehouse ETL Developer
Share
Job Location:
Florham Park, NJ - USA
Monthly Salary:
Not Disclosed
Posted on:
Yesterday
Vacancies:
1 Vacancy
Job Summary
Data Warehouse ETL Developer
Job Summary:
We are seeking a skilled Data Warehouse / ETL Developer with expertise in Informatica PowerCenter to design develop and maintain enterprise-level ETL solutions. The ideal candidate will have hands-on experience in data warehousing concepts ETL processes and strong problem-solving skills to ensure high-quality timely and accurate data integration.
Key Responsibilities:
- Design develop and deploy ETL mappings workflows and sessions using Informatica PowerCenter.
- Extract data from heterogeneous source systems (e.g. Oracle SQL Server flat files SAP) and load into target data warehouse environments.
- Collaborate with business analysts and data architects to understand data requirements and translate them into efficient ETL solutions.
- Optimize ETL processes for performance scalability and maintainability.
- Conduct data validation reconciliation and troubleshooting to ensure data quality and integrity.
- Maintain ETL documentation including data flow diagrams technical specifications and process design documents.
- Participate in code reviews unit testing and UAT support.
- Monitor ETL jobs and workflows identify bottlenecks and implement improvements.
- Provide production support and resolve data-related issues in a timely manner.
Required Skills and Qualifications:
- Bachelors degree in Computer Science Information Technology or a related field.
- 5 years of experience in ETL development using Informatica PowerCenter.
- Strong understanding of data warehousing concepts dimensional modeling and star/snowflake schemas.
- Experience with SQL PL/SQL and performance tuning of database queries.
- Knowledge of data quality data governance and best practices in ETL development.
- Strong analytical problem-solving and communication skills.
- Experience with version control systems and ETL deployment processes.
Preferred Qualifications:
- Exposure to real-time ETL and data streaming technologies.
- Knowledge of scheduling tools such as Informatica Workflow Manager and IBM Workload Automation
Flexible Working
At Conduent we value individuality and flexible working this role you can expect:
- Remote Work: Enjoy the flexibility of working from home while optimizing your work-life balance.
Working for You
We offer perks and rewards designed to support you:
- Health & Welfare Benefits:Comprehensive plans tailored to your needs effective from day one.
- Retirement Savings:Robust programs to help you secure your financial future.
- Employee Discounts:Access to a wide range of discounts on merchandise services travel and more.
- Career Growth Opportunities:Paths for advancement within a global organization.
- Paid Training:Learn while you earn with award-winning learning platforms.
- Paid Time Off:Competitive PTO packages to help you recharge.
- Great Work Environment:Join an award-winning culture that values diversity and inclusion.
Join Us:
At Conduent we are united by a shared mission. We understand that our success is driven by the success of our associates. When you join us youll find opportunities to:
- Bring your authentic self to work every day.
- Grow and thrive both personally and professionally.
- Make a meaningful impact with our clients in our communities and for the millions of people we serve.
With a large workforce across 24 countries were proud to foster a truly global cultureone that supports well-being values every contribution and empowers our people to grow both personally and professionally.
Pay Transparency Laws in some locations require disclosure of compensation and/or benefits-related information. For this position actual salaries will vary and may be above or below the range based on various factors including but not limited to location experience and addition to base pay this position based on business need may be eligible for a bonus or addition Conduent provides a variety of benefits to employees including health insurance coverage voluntary dental and vision programs life and disability insurance a retirement savings plan paid holidays and paid time off (PTO) or vacation and/or sick time. The estimated salary range for this role is ($80080-$104000).
Required Experience:
IC
Key Skills
- SQL
- Pentaho
- PL/SQL
- Microsoft SQL Server
- SSIS
- Informatica
- Shell Scripting
- T Sql
- Teradata
- Data Modeling
- Data Warehouse
- Oracle
About Company
COVID-19 presents an unprecedented and challenging situation for all of us. At Conduent, our top priority is to protect our associate base and the communities where we live and work, while continuing to serve and help our clients at a time when they need us most. We’d like to thank ev ... View more
