Senior Ab Initio ETL Engineer (Hybrid)

7Th Sky Tech; Charlotte (NC); Hybrid; USD 100,000 - 140,000; Full time

Job summary

7Th Sky Tech is seeking an experienced Ab Initio Developer to join our data engineering team in Charlotte, NC. The role focuses on Ab Initio ETL development, data integration, data transformation, and batch processing, with strong SQL and database skills.

The candidate will design, develop, test, and support scalable ETL solutions across multiple systems, collaborating with Business Analysts, Data Engineers, QA teams, and other stakeholders to enable production deployments and documentation.

Qualifications

• The role requires 5+ years of Ab Initio development experience.
• Strong hands-on experience with Ab Initio GDE, Ab Initio Co>Operating System, Ab Initio Components, Ab Initio Plans, Graph development, and parallel processing.
• Strong SQL skills.
• Experience working with databases such as Oracle, SQL Server, Teradata, DB2, or PostgreSQL.
• Strong understanding of ETL concepts and data warehousing.
• Experience with large-volume data processing and batch jobs.
• Experience with Unix/Linux shell scripting.
• Strong debugging and troubleshooting skills.
• Experience with source-to-target mapping and data transformation.
• Understanding of SDLC, Agile/Scrum methodologies, and software development best practices.

Responsibilities

• Design, develop, and maintain Ab Initio ETL applications and data pipelines.
• Develop and optimize Ab Initio graphs, plans, components, and workflows.
• Perform data extraction, transformation, validation, and loading from multiple source systems.
• Develop complex ETL processes using Ab Initio Co>Operating System, GDE, and related components.
• Write and optimize SQL queries, stored procedures, and database processes.
• Work with relational databases and large-volume datasets.
• Perform data mapping, data validation, reconciliation, and quality checks.
• Analyze performance issues and optimize ETL jobs and Ab Initio graphs.
• Develop reusable components and follow established ETL development standards.
• Schedule and monitor production jobs and troubleshoot failures.
• Participate in unit testing, integration testing, regression testing, and production support.
• Work closely with Business Analysts, Data Engineers, QA teams, and other technical stakeholders.
• Prepare technical documentation for ETL workflows and data processes.
• Support deployment activities across development, QA, and production environments.

Skills

Ab Initio GDE

Ab Initio Co>Operating System

Ab Initio Components

Ab Initio Plans

Graph development

Parallel processing

SQL

Oracle

SQL Server

Teradata

DB2

PostgreSQL

ETL concepts

Data warehousing

Unix/Linux shell scripting

Debugging

Education

Bachelor's degree in Computer Science, Information Technology, Engineering, or related field

Equivalent professional experience may be considered

Tools

Control-M

Autosys

Python

Java

Perl

AWS

Azure

GCP

Snowflake

Databricks

Hadoop

CI/CD

Job description

7Th Sky Tech is seeking an experienced Ab Initio Developer to join our data engineering team in Charlotte, NC. The role focuses on Ab Initio ETL development, data integration, data transformation, and batch processing, with strong SQL and database skills.

The candidate will design, develop, test, and support scalable ETL solutions across multiple systems, collaborating with Business Analysts, Data Engineers, QA teams, and other stakeholders to enable production deployments and documentation.