ETL Developer

Published: 6/14/2022

Technology

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!