ETL Data Engineer – Informatica PowerCenter

Computer Task; Atlanta (GA); On-site; USD 90,000 - 120,000; Full time

Job summary

CTG is seeking an ETL Data Engineer – Informatica PowerCenter for our client in Atlanta, GA. The role focuses on designing, developing, testing, and maintaining ETL solutions to support enterprise data warehouse and regulatory reporting requirements.

You will analyze requirements, perform data profiling and validation, optimize workflows, troubleshoot production issues, and collaborate with analysts and architects to deliver scalable data integration across BI environments.

Qualifications

• Experience designing, developing, and supporting enterprise ETL solutions using Informatica PowerCenter.
• Experience with production support, ETL troubleshooting, data discrepancies, and performance optimization.
• Experience performing source system analysis, impact analysis, data profiling, and business rule validation.

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.

Skills

Informatica PowerCenter

ETL development

SQL

Data warehousing

Troubleshooting

Data profiling

Education

Bachelor's degree in Computer Science, Information Systems, Engineering, Data Analytics, or a related field

Tools

Ab Initio

IBM DataStage

Job description

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

Location: Atlanta, GA
Duration: 4 months

Duties

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

Skills

• 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.
• Familiarity with other enterprise data integration tools such as Ab Initio or IBM DataStage/WebSphere Data Integration Suite is a plus.

Experience

• Experience designing, developing, and supporting enterprise ETL solutions using Informatica PowerCenter.
• 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.

Education

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

About CTG

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 highest-growth industries.

Together, we shape what’s next—working shoulder to shoulder to deliver impactful solutions for our clients and society. Our culture is built by the people who work at CTG, the values we hold, and the actions we take. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. At CTG, you’ll find a workplace where you are encouraged to grow, supported in your ambitions, and empowered to shape your own career journey. For more information, visit www.ctg.com.

CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.

CTG is an Equal Opportunity Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law. CTG is fully committed to promoting employment opportunities for members of protected classes.