Sr. Automation Engineer

Sr. Automation Engineer - Data Warehouse Support - - Frisco, TX
Interviews: 1 Virtual, final onsite. Sales dropped the ball here not discovering this sooner. They have moved quickly on local folks. If you have a perfect fit who needs to relocate feel free to send. on site work is 2X/month max

ob 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.
Job Responsibilities

• Strong Data and Automation expertise to support large-scale 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.