Sr Automation Engineer- Data Warehouse Projects

Frisco, TX, US • Posted 13 days ago • Updated 27 minutes ago
Contract W2
On-site
USD55 - USD60/hr
Fitment

Dice Job Match Score™

👤 Reviewing your profile...

Job Details

Skills

  • Sr Automation Engineer- Data Warehouse Projects

Summary

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.


Core Responsibilities


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 GitOps 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), NoSQL databases, and real-time streaming services like Kafka.


Top Requirements


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


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


Modern Infrastructure: Proficiency with Jenkins, Azure DevOps, 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



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.



qualifications:

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




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.


Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: cxsapwma1
  • Position Id: 1325072
  • Posted 13 days ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Frisco, Texas

Today

Contract

$55.00 - $60.50 hourly

Dallas, Texas

7d ago

Easy Apply

Full-time, Contract

$DOE

Hybrid in Richardson, Texas

Yesterday

Easy Apply

Contract

Depends on Experience

Hybrid in Plano, Texas

14d ago

Easy Apply

Contract

$60 - $65

Search all similar jobs