Senior Data Engineer

Senior Data Engineer – Ab Initio / Snowflake

Description:

We are looking for a Senior Data Engineer with strong experience in Ab Initio and Snowflake to design, develop, and support enterprise-scale data integration and data warehouse solutions.

You will work within a large-scale Azure data environment, supporting high-volume ETL/ELT processes, complex data pipelines, metadata management, and cloud modernization initiatives. The role is ideal for a hands-on technical expert comfortable working with complex data ecosystems and hundreds of Ab Initio processes.

Responsibilities:

• Design, develop, and support high-volume ETL/ELT data integration solutions using Ab Initio and Snowflake.
• Develop and maintain Ab Initio graphs, Plans, PSETS, Continuous Flows, and batch processing frameworks.
• Build reusable ETL components, transformations, DML files, XFRs, and PDL scripts.
• Manage and support Ab Initio EME / Metadata Hub, including metadata, lineage, impact analysis, and dataset mapping.
• Develop and optimize Snowflake solutions, including Snowpipe, Streams, Tasks, Time Travel, and Zero-Copy Cloning.
• Perform advanced SQL development, query optimization, data reconciliation, and data quality validation.
• Design and maintain data warehouse solutions using dimensional modeling, Star/Snowflake schemas, and Data Vault concepts.
• Develop automation and operational support tools us