ETL Data Engineer – Informatica PowerCenter

Computer Task Group, Inc•Atlanta, GA

1d•Onsite

About The Position

CTG is seeking to fill an ETL Data Engineer – Informatica PowerCenter position for our client. This role involves designing, developing, testing, and maintaining ETL solutions using Informatica PowerCenter to support enterprise data warehouse and regulatory reporting requirements. The engineer will analyze business and technical requirements, perform data profiling, source system analysis, and design/implement ETL processes. Optimization of ETL workflows for performance, reliability, and scalability is key, as is investigating and resolving production issues, data discrepancies, and performance bottlenecks. Data validation, reconciliation, and quality checks are essential, along with performing impact analysis for source system changes. Collaboration with business analysts, data architects, developers, and other technical teams is expected, as is the development and maintenance of technical documentation.

Requirements

Strong proficiency with Informatica PowerCenter and enterprise ETL development.
Solid understanding of ETL architecture, data integration patterns, and data warehouse concepts.
Experience with data profiling, source-to-target mapping, data validation, reconciliation, and data quality processes.
Strong SQL skills for data analysis, validation, troubleshooting, and performance tuning.
Ability to analyze complex data flows and identify data integration issues and performance bottlenecks.
Strong troubleshooting and root cause analysis skills.
Knowledge of enterprise data warehouse and business intelligence environments.
Excellent analytical, problem-solving, communication, and collaboration skills.
Bachelor’s degree in Computer Science, Information Systems, Engineering, Data Analytics, or a related field, or equivalent professional experience.
Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.

Nice To Haves

Familiarity with other enterprise data integration tools such as Ab Initio or IBM DataStage/WebSphere Data Integration Suite is a plus.
Experience supporting regulatory reporting or other data-intensive enterprise applications is preferred.

Responsibilities

Design, develop, test, and maintain ETL solutions using Informatica PowerCenter to support enterprise data warehouse and regulatory reporting requirements.
Analyze business and technical requirements and translate them into scalable, reliable data integration solutions.
Perform data profiling, source system analysis, and business rule validation to support data integration initiatives.
Design and implement Extract, Transform, and Load (ETL) processes to transfer data from operational and external environments into business intelligence and data warehouse environments.
Optimize ETL workflows for performance, reliability, scalability, and maintainability using established tuning techniques and best practices.
Investigate and resolve production issues, ETL failures, data discrepancies, and performance bottlenecks through detailed root cause analysis.
Conduct data validation, reconciliation, and quality checks to ensure data accuracy, completeness, consistency, and integrity.
Perform impact analysis for source system changes and assess downstream effects on ETL processes, data warehouses, and reporting solutions.
Collaborate with business analysts, data architects, developers, and other technical teams throughout the data integration lifecycle.
Develop and maintain technical documentation, data mappings, ETL specifications, and operational procedures.