We are seeking a Data Engineering Specialist to design, build, and support ETL/data integration solutions using Ab Initio with integration to different databases including Databricks, and cloud data platforms.
Requirements
- 8+ years of hands-on experience in data engineering or ETL development
- Strong expertise in Ab Initio GDE and web-based tools (Express>It, Query>It, Control Center, TRW)
- Proven experience designing and maintaining Ab Initio plans, graphs, job schedules, and production workloads
- Practical experience with Ab Initio components including Excel, database components, join, rollup, normalize, partition/de-partition, sort, dedup, FBE, and multi-file I/O
- Experience working with Databricks, including reading from and writing to Delta tables as part of end-to-end data pipelines
- Strong SQL skills, with hands-on experience across SQL Server and PostgreSQL
- Experience with cloud data platforms such as Google Cloud BigQuery and familiarity with data warehousing concepts (zones, medallion-style architectures, etc.)
- Experience building reports or analytical datasets in BigQuery or similar cloud data warehouses
- Familiarity with CI/CD practices for database and ETL deployments using Git/GitHub and Azure pipelines
