Sr. Automation Engineer - DWH

We are seeking an experienced Sr Automation engineer in DWH, with strong Data and Automation expertise to support largescale Data Warehouse (DWH) cloud migration and Modernization initiatives across complex enterprise platforms. The ideal candidate will: Define and drive a comprehensive test strategy, develop detailed test plans, and lead execution across functional, integration, data validation, API, and automation testing. Bring deep hands-on expertise in Python, API automation, and modern data engineering testing practices, including building automation utilities using PyTest, Postman/Newman, or similar frameworks, and integrating them within CI/CD pipelines using Git, Jenkins, Azure DevOps, and GitOpsbased automation. Have strong working knowledge of cloud and data platforms such as relational DB ( Informatica Cloud IDMC, DVO, CDV, Snowflake, Databricks, BigQuery, or Redshift) and NoSQL DB like Cassandra, MongoDB Possess additional experience in realtime data streaming, messaging queues like Kafka, SQS etc. and ability to test/automate these cases Strong working knowledge of building complex SQL queries and stored procedures for validations, data profiling, and complex data integration validations. Demonstrate strong coordination and leadership skills, including leading Business Process Testing (BPT) with multiple upstream and downstream application teams at an enterprise scale, as well as managing onshore/offshore QE teams. Be comfortable operating in fastpaced, multimodal delivery environments (Waterfall, Agile, Hybrid), ensuring consistent, highquality delivery across data, integration, and business workflows.

Job Responsibilities

Strong Data and Automation expertise to support largescale Data Warehouse (DWH) cloud migration and Modernization initiatives across complex enterprise platforms.

Define and drive a comprehensive test strategy, develop detailed test plans, and lead execution across functional, integration, data validation, API, and automation testing.