United States


Atlanta, Los Angeles, Nashville, Portland, San Francisco, Seattle

Area of expertise:

Software Engineering

Job Description

This is a W2 contract only- no C2C-

3633692 – ETL Test Automation Architect

Duration: Immediate through December 2021

Independently develop strategic plans for testing efforts. Advise the customer on innovative testing products and solutions. Define and administer standard testing architecture methodologies, processes and tools across the engagement. Create test estimates and define/build reusable testing assets for large/complex projects. Test architect is responsible to analyze the system and define the automation scope, automation approach, framework, implement and drive the automation till completion and demo to the clients.

  • Experience analyzing ETL environments, and assessing and recommending scope of test automation as a consultant necessary
  • Experience with various ETL test automation tools (e.g. Python, Informatica) to automate ETL testing with heterogenous databases (example: Oracle or Hadoop , ETL in ADF and target in Azure Synapse) a must
  • Experience with Azure Data Factory, Azure Synapse, Hive a nice to have
  • Create POCs of ETL automation scripts for demos to stakeholders
  • Create and deliver automation frameworks for the build / data engineering team

  1. ETL automation tools - Expert and at least 3+ years’ experience in ETL automation testing.
  2. 2. Python - Expert (minimum 3-5 years of experience in automation with Python)
  3. 3. Scripting - Expert (minimum 2 years of experience in scripting to validate data)
  4. 4. Microsoft Cloud (Azure data factory or Synapse) - Good to have

Apply now

Share this job:

Share Facebook Twitter Email

About Avanade

Avanade leads in providing innovative digital services, business solutions and design-led experiences for its clients, delivered through the power of people and the Microsoft ecosystem. Our professionals combine technology, business and industry expertise to build and deploy solutions to realize results for clients and their customers. Avanade has 29,000 digitally connected people across 23 countries, bringing clients the best thinking through a collaborative culture that honors diversity and reflects the communities in which we operate. We welcome all, and seek talented individuals who can bring their whole self to work, build inclusive teams and encourage diversity inside and outside the organization. Majority owned by Accenture, Avanade was founded in 2000 by Accenture LLP and Microsoft Corporation. Learn more at