ETL Developer

Computer Task; Atlanta, Charlotte, Raleigh (GA, NC, NC); On-site; USD 90,000 - 125,000; Full time

Job summary

CTG, a Cegeka company, is seeking an ETL Developer to design, develop, and maintain ETL solutions for our client. Location options include Atlanta, GA; Charlotte, NC; or Raleigh, NC with no remote work. This is a 12-month contract.

Design, develop, and optimize ETL processes using Informatica PowerCenter, DBT, and Snowflake; work with Oracle SQL/PLSQL on Unix/Linux; contribute to data warehousing, data governance, and regulatory reporting.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or related field.
• Excellent verbal and written English communication skills.
• Hands-on experience developing and supporting enterprise ETL, data integration, and data warehouse solutions.

Responsibilities

• Design, develop, enhance, and maintain ETL solutions using Informatica PowerCenter, DBT, and Snowflake.
• Support enterprise data warehousing, data integration, and regulatory reporting initiatives.
• Translate business and technical requirements into scalable data integration solutions.
• Perform data profiling, source-to-target mapping, data validation, reconciliation, and quality checks.
• Optimize ETL workflows and troubleshoot production issues, data discrepancies, and performance bottlenecks.
• Conduct root cause and impact analysis for source system changes, database enhancements, and business rule modifications.
• Assess upstream and downstream dependencies across ETL processes, databases, reports, and applications.
• Support testing, UAT, deployments, monthly releases, and environment migrations.
• Collaborate with cross-functional teams and maintain technical documentation supporting data governance, lineage, audit, and compliance requirements.

Skills

Informatica PowerCenter

DBT

Snowflake

Oracle SQL/PLSQL

Unix/Linux

ETL Development

Data Integration

Data Warehousing

Data Profiling

Quality Assurance

Performance Tuning

Root Cause Analysis

Impact Analysis

Release Management

Data Governance

Data Lineage

Education

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

Job description

CTG is seeking to fill an ETL Developer position for our client. Location: Atlanta, GA; Charlotte, NC; or Raleigh, NC - No Remote Duration: 12 months

Duties:

• Design, develop, enhance, and maintain ETL solutions using Informatica PowerCenter, DBT, and Snowflake.
• Support enterprise data warehousing, data integration, and regulatory reporting initiatives.
• Translate business and technical requirements into scalable data integration solutions.
• Perform data profiling, source-to-target mapping, data validation, reconciliation, and quality checks.
• Optimize ETL workflows and troubleshoot production issues, data discrepancies, and performance bottlenecks.
• Conduct root cause and impact analysis for source system changes, database enhancements, and business rule modifications.
• Assess upstream and downstream dependencies across ETL processes, databases, reports, and applications.
• Support testing, UAT, deployments, monthly releases, and environment migrations.
• Collaborate with cross-functional teams and maintain technical documentation supporting data governance, lineage, audit, and compliance requirements.

Skills:

• Informatica PowerCenter, DBT, and Snowflake
• Oracle SQL/PLSQL and Unix/Linux
• ETL Development, Data Integration, and Data Warehousing
• Data Profiling, Validation, Reconciliation, and Quality Assurance
• Performance Tuning, Root Cause Analysis, and Impact Analysis
• Release Management, Data Governance, and Data Lineage

Experience:

• Hands-on experience developing and supporting enterprise ETL, data integration, and data warehouse solutions using Informatica PowerCenter, DBT, Snowflake, and Oracle SQL/PLSQL.
• Experience troubleshooting production issues, optimizing ETL performance, validating data quality, and managing upstream/downstream dependencies.
• Experience supporting the full development lifecycle, including testing, UAT, deployments, release management, and production support in complex enterprise environments.
• Strong analytical, problem-solving, documentation, and cross-functional communication skills.

Education:

Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field, or equivalent combination of education and experience.

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

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.