Senior Informatica PowerCenter ETL Engineer

Infinite Computer Solutions; New Jersey; On-site; USD 100,000 - 140,000; Full time

Job summary

Infinite Computer Solutions is seeking a Data Warehouse ETL Developer with hands-on experience in Informatica PowerCenter to design, develop, and maintain enterprise-level ETL solutions. The role focuses on building robust data integration workflows and ensuring timely, accurate data delivery.

You will extract data from Oracle, SQL Server, flat files, and SAP, optimize processes for performance and scalability, and collaborate with business analysts and data architects.

Qualifications

• Bachelor’s degree in CS/IT or related field.
• 7+ years ETL development with Informatica PowerCenter.
• Strong understanding of data warehousing concepts, star/snowflake schemas.
• SQL/PL/SQL, performance tuning of queries.
• Knowledge of data quality and data governance best practices.
• Strong analytical, problem-solving, and communication skills.
• Experience with version control and ETL deployment processes.

Responsibilities

• Design, develop, and deploy ETL mappings, workflows, and sessions using Informatica PowerCenter.
• Extract data from Oracle, SQL Server, flat files, SAP, and load into target data warehouse environments.
• Collaborate with business analysts and data architects to translate requirements into 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.

Skills

ETL Development

Informatica PowerCenter

Data Warehousing

SQL

PL/SQL

Data Quality

Data Governance

Version Control

Communication

Problem Solving

Education

Bachelor’s degree in Computer Science, Information Technology, or a related field

Tools

Informatica PowerCenter

Informatica Workflow Manager

IBM Workload Automation

Job description

Infinite Computer Solutions is seeking a Data Warehouse ETL Developer with hands-on experience in Informatica PowerCenter to design, develop, and maintain enterprise-level ETL solutions. The role focuses on building robust data integration workflows and ensuring timely, accurate data delivery.

You will extract data from Oracle, SQL Server, flat files, and SAP, optimize processes for performance and scalability, and collaborate with business analysts and data architects.