Ab Initio ETL Engineer — Hybrid, 6+ Month Contract

Pyramid, Inc; Alpharetta (GA); Hybrid; USD 83,000 - 90,000; Full time

Benefits offered by this job

Health insurance

401(k) plan

Paid sick leave

Job summary

Pyramid Consulting, Inc. in Alpharetta, GA is seeking an Ab initio Developer for a 6+ month contract with long-term potential. The role is on a hybrid basis in Alpharetta, GA and offers an immediate start for a seasoned ETL specialist.

Responsibilities include designing and maintaining Ab Initio ETL workflows, optimizing graphs, and integrating diverse data sources. Strong SQL, Unix/Linux scripting, and data modeling knowledge are essential.

Qualifications

• 7+ years of ETL development and data warehousing experience.
• Hands-on Ab Initio (GDE, CoOperating System, EME) expertise.
• Strong SQL skills (Oracle, Teradata, SQL Server or equivalent).
• Unix/Linux shell scripting experience.
• Understanding of star schema data modeling.
• Experience with performance tuning and job optimization.

Responsibilities

• Design, develop, and maintain ETL workflows using Ab Initio (GDE).
• Create and optimize graphs, reusable components, and parallel processing logic.
• Integrate data from databases, flat files, APIs, and cloud sources.
• Perform performance tuning and optimization of Ab Initio jobs.
• Conduct data validation, quality checks, and error handling.
• Collaborate with analysts and stakeholders to understand data needs.
• Write complex SQL queries for data manipulation.
• Maintain technical documentation and support deployments.

Skills

ETL development

Data warehousing concepts

SQL

Unix/Linux shell scripting

Data modeling

Performance tuning

Parallel processing

Large datasets

Tools

Ab Initio (GDE)

Ab Initio CoOperating System

Ab Initio EME

Job description

Pyramid Consulting, Inc. in Alpharetta, GA is seeking an Ab initio Developer for a 6+ month contract with long-term potential. The role is on a hybrid basis in Alpharetta, GA and offers an immediate start for a seasoned ETL specialist.

Responsibilities include designing and maintaining Ab Initio ETL workflows, optimizing graphs, and integrating diverse data sources. Strong SQL, Unix/Linux scripting, and data modeling knowledge are essential.