Data Engineer-Data Integration

Computer Task; Atlanta (GA); On-site; USD 83,000 - 152,000; Full time

Job summary

CTG is seeking a Data Engineer - Data Integration for our client in Atlanta, GA. You will design, develop, and maintain ETL solutions, focusing on Informatica PowerCenter, data warehouses, and data quality.

This 4-month contract requires 5+ years in data engineering, strong SQL, and a proven ability to translate business needs into scalable data integration pipelines. Excellent communication in English is essential.

Qualifications

• Bachelor’s degree in Computer Science, IT, Engineering, Data Science, or related field.
• 5+ years of experience in Data Engineering, Data Integration, ETL, or related roles.
• Strong SQL and relational database experience.
• Experience with ETL/ELT, data warehousing, business intelligence, and data integration.
• Experience with data profiling, data quality, reconciliation, and source system analysis.
• Strong troubleshooting, performance tuning, and root cause analysis skills.

Responsibilities

• Design, develop, and maintain ETL solutions using Informatica PowerCenter.
• Build and support data integration processes for enterprise data warehouses and regulatory reporting.
• Translate business and technical requirements into scalable ETL solutions.
• Perform data profiling, source system analysis, data validation, reconciliation, and quality checks.
• Optimize ETL workflows for performance, reliability, and scalability.
• Troubleshoot ETL failures, production issues, data discrepancies, and performance bottlenecks.
• Perform root cause analysis and impact analysis for source system changes.
• Document data mappings, business rules, ETL processes, and technical solutions.

Skills

Data Integration

ETL

SQL

Data Warehousing

Data Quality

Education

Bachelor’s degree in Computer Science, IT, Engineering, Data Science, or related field

Tools

Informatica PowerCenter

Ab Initio

IBM DataStage

Job description

CTG is seeking a Data Engineer - Data Integration for our client. This contract opportunity focused on enterprise data integration, ETL development, data quality, and data warehouse solutions.

Location: Atlanta, GA

Duration: 4 months

Key Responsibilities

• Design, develop, and maintain ETL solutions using Informatica PowerCenter.
• Build and support data integration processes for enterprise data warehouses and regulatory reporting.
• Translate business and technical requirements into scalable ETL solutions.
• Perform data profiling, source system analysis, data validation, reconciliation, and quality checks.
• Optimize ETL workflows for performance, reliability, and scalability.
• Troubleshoot ETL failures, production issues, data discrepancies, and performance bottlenecks.
• Perform root cause analysis and impact analysis for source system changes.
• Document data mappings, business rules, ETL processes, and technical solutions.

Required Skills & Experience

• 5+ years of experience in Data Engineering, Data Integration, ETL, or related roles.
• Strong hands-on experience with Informatica PowerCenter.
• Strong SQL and relational database experience.
• Experience with ETL/ELT, data warehousing, business intelligence, and data integration.
• Experience with data profiling, data quality, reconciliation, and source system analysis.
• Strong troubleshooting, performance tuning, and root cause analysis skills.
• Experience supporting production ETL environments.
• Knowledge of Ab Initio and/or IBM DataStage is a plus.

Education

• Bachelor’s degree in Computer Science, Information Technology, Engineering, Data Science, or a related field, or equivalent experience.

Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.

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