Job Title: Sr Automation Engineer – Data Warehouse Support

Location: Frisco, TX

Duration: Contract

Interview Process: 2 Virtual Rounds

Visa: USC / GC Only

Job Description

We are seeking an experienced Sr Automation engineer in DWH, with strong Data and Automation expertise to support large-scale 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 GitOps-based 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 real-time 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 fast-paced, multi-modal delivery environments (Waterfall, Agile, Hybrid), ensuring consistent, high-quality delivery across data, integration, and business workflows.