Ab Initio Developer (GCP)

Location: Charlotte, North Carolina, United States; hybrid work required

Company

hirify.global provides staffing and technology consulting services for enterprise clients.

What you will do

• Design, develop, and maintain scalable batch and near real-time data pipelines using Ab Initio, Python, PySpark, PL/SQL, and SQL.
• Build and optimize BigQuery datasets, transformations, and data models, including partitioning, clustering, and query performance improvements.
• Migrate legacy Teradata and Ab Initio solutions to Google Cloud Platform, supporting validation, reconciliation, parallel processing, and production cutovers.
• Modernize workflow orchestration from Autosys to Cloud Composer with Apache Airflow and implement metadata management through Dataplex.
• Monitor production pipelines, troubleshoot failures, perform root cause analysis, and improve reliability, performance, security, and scalability.
• Collaborate with product owners, architects, analysts, and engineers while documenting data dictionaries, runbooks, reconciliation processes, and technical specifications.

Requirements

• 4+ years of professional data engineering experience and enterprise ETL development with Ab Initio, including graph development, Psets, and performance tuning.
• 4+ years of experience with PL/SQL and SQL, including complex query development, optimization, and troubleshooting.
• 3+ years of Python programming with hands-on PySpark development.
• Experience with Oracle, Teradata, and/or Google BigQuery, plus data warehousing, dimensional modeling, ETL architecture, and data integration.
• Strong understanding of enterprise data governance, metadata management, data lifecycle management, and scalable batch or near real-time processing.
• Required: experience using AI-assisted coding tools such as GitHub Copilot or Devin while maintaining code reviews, testing, and secure coding standards.

Nice to have

• Experience with Google Cloud Platform services including BigQuery, Dataplex, and Cloud Composer.
• Experience migrating on-premises enterprise data platforms to cloud-native architectures.
• Experience with Informatica Data Quality, Autosys, and regulated data engineering environments.
• Experience in Agile/Scrum and financial services or mortgage/lending.

Culture & Benefits

• Work on enterprise-scale data modernization within a home lending data and insights organization.
• Collaborate across product, architecture, analytics, and engineering functions.
• Support production-grade systems with an emphasis on security, data quality, operational excellence, and continuous improvement.
• 24-month contract engagement in a hybrid work environment.