ETL Data Engineer – Informatica PowerCenter

CTG is seeking to fill an ETL Data Engineer – Informatica Power Center position for our client.

Location: Atlanta, GA
Duration: 4 months

• Design, develop, test, and maintain ETL solutions using Informatica Power Center 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.

• Strong proficiency with Informatica Power Center 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.
• Familiarity with other enterprise data integration tools such as Ab Initio or IBM Data Stage/Web Sphere Data Integration Suite is a plus.

• Experience designing, developing, and supporting enterprise ETL solutions using Informatica Power Center.
• Experience working with data integration projects involving operational, external, data warehouse, and business intelligence environments.
• Experience analyzing business and technical requirements and converting them into effective ETL solutions.
• Experience with production support, ETL troubleshooting, data discrepancies, and performance optimization.
• Experience performing source system analysis, impact analysis, data profiling, and business rule validation.
• Experience supporting regulatory reporting or other data-intensive enterprise applications is preferred.

• 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.

CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee based recruitment services for this role.

CTG, a Cegeka company, delivers IT and business solutions that enhance clients’ digital agility, empowering them to seize new opportunities and overcome any challenge. Backed by more than 60 years’ experience and a commitment to being a reliable, results-driven partner, we work shoulder to shoulder with clients to shape digital together. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts.

With more than 9,000 team members in over 15 countries, we combine global expertise with local insight to deliver innovative solutions. We operate across the Americas, Europe, and India, working with over 3,000 clients in many of today's…