Sr Automation Engineer- Data Warehouse Projects

Job Summary

We are looking for a high-caliber Sr. Automation Engineer to spearhead data validation and automation for our large-scale Cloud DWH migration and modernization initiatives. This role is a blend of strategic leadership and hands-on technical execution, focusing on ensuring data integrity across complex, multi-cloud enterprise platforms.

Strategy & Leadership:
Define comprehensive test strategies and lead end-to-end execution (Functional, API, Data Validation) across onshore/offshore teams and multi-app business processes.

Automation Engineering:
Build robust automation utilities and frameworks using Python (PyTest) and Postman, fully integrated into CI/CD and Git Ops workflows.

Data Validation:
Perform complex data profiling and integration testing using advanced SQL and stored procedures.

Cross-Platform Testing:
Validate seamless data flow across Cloud DWH (Snowflake/Databricks), No

SQL databases, and real-time streaming services like Kafka.

Expertise:
Deep experience in Python-based automation and API testing.

Data Stack:
Proven track record with Snowflake, Databricks, or Big Query, plus Informatica tools (IDMC, DVO).

Modern Infrastructure:
Proficiency with Jenkins, Azure Dev Ops, and messaging queues (Kafka/SQS).

Agility:
Ability to lead in fast-paced Agile, Waterfall, or Hybrid environments.

Location:

Frisco, Texas

Job type:
Contract

Salary: $55 – 60 per hour

Work hours:

8am to 5pm

Education:

Bachelors

• 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.

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

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 Dev Ops, and Git Ops-based automation.

Have strong working knowledge of cloud and data platforms such as relational DB (Informatica Cloud IDMC, DVO, CDV, Snowflake, Databricks, Big Query, or Redshift) and No

SQL 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.

Equal Opportunity

Employer:

Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact

Pay offered to a successful candidate will be based on several factors including the candidate’s education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).

This posting is open for thirty (30) days.