ETL Developer

Overview

CTG is seeking to fill an ETL Developer position for our client.

Location: Atlanta, GA
Duration: 12 months

Duties:

• Design, develop, test, and deploy ETL processes to support data integration, transformation, and migration initiatives.

• Develop and maintain ETL workflows using Ab Initio to extract, transform, and load data across enterprise systems.

• Write and optimize complex SQL queries, including joins, subqueries, common table expressions (CTEs), window functions, and stored procedures.

• Work with Oracle, SQL Server, and PostgreSQL databases to support data processing and integration requirements.

• Develop and maintain cloud-based applications using microservices architecture and integrate front-end, back-end, and middleware components as needed.

• Support application development and data persistence across relational and NoSQL databases.

• Collaborate with senior technical team members to design, build, and maintain cloud environments.

• Apply DevOps practices and automation tools to support efficient development, testing, deployment, and application maintenance.

• Troubleshoot performance issues, resolve data integration challenges, and ensure data accuracy and reliability.

Skills:

• Strong ETL development and data integration skills, including hands-on experience with Ab Initio.

• Advanced SQL skills, including joins, subqueries, CTEs, window functions, and stored procedures.

• Experience working with Oracle, SQL Server, and PostgreSQL databases.

• Understanding of data transformation, data mapping, and database performance optimization.

• Familiarity with cloud-based application development, microservices architecture, and REST/SOA services.

• Knowledge of DevOps methodologies, automation, and configuration management tools.

• Strong analytical, problem-solving, communication, and collaboration skills.

Experience:

• Demonstrated experience developing and supporting ETL solutions using Ab Initio.

• Experience writing, troubleshooting, and optimizing complex SQL queries across relational database platforms.

• Experience with enterprise data integration and database technologies, including Oracle, SQL Server, and PostgreSQL.

• Exposure to cloud-based application development and microservices environments.

• Familiarity with application development technologies such as Java, JEE, Spring, Hibernate, Angular, React, HTML5, CSS3, Groovy, APIGEE, or API Connect is beneficial.

• Experience supporting application deployment, testing, and maintenance using DevOps practices and automation tools.

Education:

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent relevant 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.

To Apply:

To be considered, please apply directly to this requisition using the link provided. Kindly forward this to any other interested parties. Thank you!