Ab Initio Developer

Ampstek; Irving (TX); Presencial; USD 110.000 - 160.000; Jornada completa

Descripción de la vacante

Ampstek is seeking an Ab Initio Developer to join our Enterprise Data Engineering team in a full-time onsite role in Irving, TX. You will design, migrate, and optimize large data pipelines from on-prem to Google Cloud Platform, blending traditional ETL with cloud-native architectures.

You will leverage Ab Initio, GDE, and BigQuery, plus Dataflow and Cloud Composer, while building automation with Python and CI/CD tools. Strong SQL and Unix scripting are essential.

Formación

• Experience designing and migrating large-scale ETL/ELT pipelines.
• Strong Python proficiency for data processing and automation.
• Hands-on GCP experience with BigQuery and data tools.

Responsabilidades

• Design and develop scalable ETL/ELT pipelines using Ab Initio.
• Migrate legacy graphs to GCP cloud-native solutions.
• Write Python scripts for data processing and automation.
• Optimize data warehouse design in BigQuery.
• Build deployment pipelines with CI/CD tools.

Conocimientos

ETL design

Python

Cloud data engineering

UNIX/Linux scripting

SQL optimization

Herramientas

Ab Initio

GDE

Co-Operating System

Enterprise Meta-Environment

BigQuery

Cloud Dataflow

Cloud Composer

Jenkins

GitLab CI/CD

Cloud Build

Descripción del empleo

Location - Hartford,CT/ Irving, TX(onsite )

Position Summary

We are seeking a skilled Ab Initio Developer with strong expertise in Python and Google Cloud Platform (GCP) to join our Enterprise Data Engineering team. In this role, you will design, develop, and migrate large-scale data integration pipelines from legacy on-premises systems to our modern GCP data platform. You will bridge traditional ETL processing with modern cloud-native data architectures.

Key Responsibilities

• Pipeline Development: Design and develop scalable ETL/ELT pipelines using Ab Initio (Continuous Flows, GDE, Co-Operating System).
• Cloud Migration: Migrate legacy Ab Initio graphs and data frameworks into GCP cloud-native solutions like BigQuery, Cloud Dataflow, and Cloud Composer (Airflow).
• Automation & Scripting: Write clean, efficient Python scripts for data processing, pipeline orchestration, API integrations, and workflow automation.
• Data Modeling: Optimize data warehouse performance, partition strategies, and schema designs specifically within Google BigQuery.
• CI/CD Integration: Build and maintain deployment pipelines using Jenkins, GitLab CI/CD, or GCP Cloud Build for automated code promotions.

Required Technical Skills

• Ab Initio Suite: Expert-level knowledge of GDE, Co-Operating System, Enterprise Meta-Environment (EME), and Conduct>It.
• Google Cloud Platform: Hands-on experience with BigQuery, Cloud Storage (GCS), Pub/Sub, and Dataflow.
• Programming: Advanced proficiency in Python (Pandas, NumPy, Apache Beam), and robust Unix/Linux Shell Scripting.
• Databases: Strong SQL skills for complex query optimization and data analysis.