Snowflake Data Warehouse Tester | Must be independent to work on 1099/C2C

Snowflake Data Warehouse Tester | Must be independent to work on 1099/C2C

Posted 5 days ago by 1750266072

Negotiable
Outside
Remote
USA

Summary: The Snowflake Data Warehouse Tester role involves testing ETL processes and data integrity within a Snowflake environment. The position requires strong SQL skills and experience with data warehousing concepts, ideally within a cloud technology framework. Candidates should have a hands-on approach and may benefit from team lead experience, particularly in automation and quality assurance. The role is a 6-month contract with the potential for hire, and it is fully remote.

Key Responsibilities:

  • Build and execute test cases to ensure the integrity of all production solutions deployed on the enterprise data platform including data pipelines, data warehouses, data marts and data sharing repositories.
  • Deep understanding of data warehousing concepts.
  • Expert in SQL and knowledge on Python will be a plus.
  • Experience working on cloud technologies like Snowflake.
  • Strong knowledge of SDLC process.
  • Experience with Enterprise Database technologies like SQL Server, Oracle, Data Integration (Informatica, DataStage), business intelligence, and reporting tools.
  • Experience creating test automation frameworks and test cases.
  • Identify opportunities for productivity gains through quality engineering process improvements and in the Agile development lifecycle; develop procedures and proposals and lead the implementation of these changes.
  • Demonstrated experience performing functional, end-to-end and regression testing.
  • Document and analyze test results and recommend corrective action.
  • Isolate, reproduce, manage, and maintain defects and test case databases, and verify fixes.
  • Support user acceptance testing conducted by business partners or end users.
  • Identify opportunities to reduce testing time and effort by automating repeatable tests.
  • Define and champion quality and testing best practices among development teams.

Key Skills:

  • Strong ETL & DW skills.
  • Advanced SQL abilities.
  • Experience with Snowflake, AWS, or Azure.
  • Hands-on experience with automation and data validation.
  • Team lead experience preferred.
  • Healthcare experience is a plus.
  • Over 12 years of professional work experience or equivalent.
  • Strong knowledge of SDLC process.
  • Experience with Enterprise Database technologies.
  • Ability to create test automation frameworks and test cases.
  • Experience in functional, end-to-end, and regression testing.
  • Strong analytical skills for documenting and analyzing test results.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Role: Snowflake Data Warehouse Tester (ETL Tester)
Location: Remote
Job Type: 6 months contract to hire

Must Haves:

  • Snowflake SQL testing.
  • Medallion architecture in Snowflake: Bronze, silver, gold and testing
  • Bridge tables
  • Validation testing for Snowflake

Ideal candidate should have strong ETL & DW skills; Advanced SQL abilities; Snowflake would be highly preferred, but would also accept someone with either AWS and/or Azure experience; Must be hands-on and it would be great if they had some sort of Team Lead experience; Strong Automation background (Data Validation & Quality skills); If they have Healthcare experience, it'll be a huge plus, but just as long as they are strong technically, they would consider any industry.

Description:

Over 12 years of professional work experience (or equivalent experience) is required.

  • Build and execute test cases to ensure the integrity of all production solutions deployed on the enterprise data platform including data pipelines, data warehouses, data marts and data sharing repositories
  • Deep understanding of data warehousing concepts
  • Expert in SQL and knowledge on Python will be a plus.
  • Experience working on cloud technologies like Snowflake
  • Strong knowledge of SDLC process.
  • Experience with Enterprise Database technologies like SQL Server, Oracle, Data Integration (Informatica, DataStage), business intelligence, and reporting tools.
  • Experience creating test automation frameworks and test cases
  • Identify opportunities for productivity gains through quality engineering process improvements and in the Agile development lifecycle; develop procedures and proposals and lead the implementation of these changes.
  • Demonstrated experience performing functional, end-to-end and regression testing.
  • Document and analyze test results and recommend corrective action.
  • Isolate, reproduce, manage, and maintain defects and test case databases, and verify fixes.
  • Support user acceptance testing conducted by business partners or end users.
  • Identify opportunities to reduce testing time and effort by automating repeatable tests.
  • Define and champion quality and testing best practices among development teams

-- Asher Williams Desk: 2o1.497.1o1o X:1o5 | Direct: 551.272.o129 asher (at) pullskill dot com