ETL Tester OR Data Quality Engineer

ETL Tester OR Data Quality Engineer

Posted Today by MHK TECH INC

Apply
Negotiable
Undetermined
Remote
Remote
Apply
Ab Initio (Software) Agile Methodology Airflow Apache Airflow Apache Kafka Application Lifecycle Management Application Programming Interface (API) Automation Azure Kubernetes Service Bash (Scripting Language) Big Data Business Intelligence Business Operations Continuous Integration and Continuous Delivery Datamodel Data Modeling Data Quality Data Warehousing Er Diagrams Extract Transform Load (ETL) File Servers Generic Programming Informatica JIRA Kubernetes Management Microsoft SQL Servers Nice (Unix Utility) Power BI Python (Programming Language) Rally Software Snowflake (Data Warehouse) Software Development SQL (Programming Language) SQLDB Tableau (Business Intelligence Software) Talend Test Automation Test Management Test Management Tools Test Planning Test Strategy Test Suite Unit Testing User Acceptance Testing (UAT) User Interface Verification And Validation Web SQL Databases

Summary: The role of ETL Tester/Data Quality Engineer involves writing and executing test cases, managing large data sets, and creating automation scripts while collaborating with data professionals to address reporting needs. The position requires expertise in SQL queries, ETL processes, and automation testing, with a strong focus on data quality and validation. Candidates should have experience with various data tools and methodologies, including Agile and CI/CD practices. This is a fully remote contract position.

Key Responsibilities:

  • Write and execute test cases for ETL processes.
  • Manage and analyze large sets of data.
  • Create automation scripts and communicate insights to the team.
  • Collaborate with data professionals and business operation experts.
  • Create and maintain complex SQL queries.
  • Execute ETL jobs using orchestration tools.
  • Conduct and facilitate User Acceptance Testing (UAT).
  • Implement CI/CD through Jenkins/GitLab/Maven.
  • Create test plans and strategies for software releases.
  • Review technical requirements and produce test strategies for the data warehouse team.

Key Skills:

  • Solid understanding of test automation architecture and frameworks.
  • Proficiency in programming languages such as Python and Bash.
  • Strong knowledge of SQL queries for database validation.
  • Hands-on experience with data models and ER diagrams.
  • Experience with traditional SQL databases and cloud-native data warehouses.
  • Familiarity with ETL tools and reporting tools like Tableau and PowerBI.
  • Experience with agile test management tools like HP ALM and Jira.
  • Ability to generate test scenarios using frontend (UI) and validate backend data.
  • Experience with Kafka messaging and REST APIs is desired.
  • Docker and Kubernetes experience is a plus.

Salary (Rate): undetermined

City: undetermined

Country: undetermined

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:
ETL Tester/ Data Quality Engineer
100% Remote
Contract
Be an expert in writing and executing test cases, managing and analyzing large sets of data, creating automation scripts, and communicating relevant insights to the team
Love to collaborate with other data professionals, engineers, and business operation experts to understand and address reporting needs
Experience with both traditional and big data streaming
Create and maintain complex SQL queries such as; type 2 triggers, various joins, aggregations, groupings, and more
Execute ETL jobs using orchestration tools (airflow/scheduler/SQL agent)
Have a working knowledge and testing experience of ETL
Be proactive with leadership abilities with a strong can do attitude
Possesses heavy experience with automation testing for ETL
Highly detailed oriented
Strong willingness & comfort in taking on and challenging development approaches
Conduct and facilitate UAT
Previously worked in Agile and Scrum
What You Will Need:
Solid understanding of test Automation architecture, framework, and Automation script creation using programming language Python, Bash Scripts, etc. and Orchestration tools like Apache Airflow, Luigi
Strong knowledge of creating SQL queries for source to target database validation and Data warehouse testing
Hands-on experience interpreting and understanding data models and ER diagrams
Experienced in traditional SQL DB (MySQL, Postgres, SQL server) and cloud-native data warehouses Snowflake or Redshift
Experienced in ETL tools Informatica, ab initio, Talend, and reporting tools - Tableau and PowerBI
Create and execute strategies and test cases for applications that use ETL components
CI/CD implementation through Jenkins/GitLab/Maven
Experienced with HP ALM, Jira, rally any agile test management tools
Implement the orchestration of business flows on given problem statements for the automation of complex scenarios
Review technical requirements with data warehouse and business intelligence terminology to produce test strategies, test scenarios, and test cases for the data warehouse team
Create the test plan for the software release, defining resources, and test suites required for each test cycle, dependencies, risks, and the overall strategy for testing complex systems and applications
Experienced in using frontend (UI) to generate test scenarios and validate data in the backend
Write Python test using unit test framework
Experience with Kafka messaging is desired
Rest APIs
Docker and Kubernetes experience is a nice to have
Apply
Similar Jobs
Loading data...