ETL Data Engineer | Informatica PowerCenter Expert

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