ETL Tester Azure

Robotic Process Automation LLC; Irving (TX); On-site; USD 110,000 - 150,000; Full time

Job summary

Robotic Technologies Automation in the United States is seeking a Senior ETL Tester with hands-on expertise in ETL testing, Azure, and Databricks. The role focuses on validating data quality, migration, transformation, and data validation across cloud-based environments.

You will perform end-to-end testing of ETL pipelines, work with Azure Data Factory and Databricks, write complex SQL queries, and collaborate with data engineers, developers, and business teams to resolve issues.

Qualifications

• Experience in ETL and data warehouse testing in cloud environments.
• Strong SQL with complex queries for validation.
• Hands-on with Azure Data Factory and Databricks.
• Experience with data migration and data quality testing.
• Ability to validate data across source and target systems.

Responsibilities

• Perform ETL testing and validate data extraction, transformation, and loading processes.
• Validate data accuracy, completeness, integrity, and consistency across source and target systems.
• Write and execute complex SQL queries for data validation and reconciliation.
• Identify, troubleshoot, and report data-related defects.
• Perform end-to-end, functional, regression, and integration testing.
• Collaborate with data engineers, developers, and business teams to resolve issues.

Skills

ETL Testing

Data Warehouse Testing

Azure Data Factory

Databricks

PySpark

SQL

Data Validation

Data Migration

Data Quality Testing

Cloud-based Pipelines

Tools

Databricks

PySpark

Azure Cloud

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Description :

We are looking for an experienced Senior ETL Tester with strong hands-on experience in ETL testing, Azure, and Databricks. The ideal candidate should have a solid understanding of data validation, data migration, data transformation, and data quality testing in cloud-based data environments.

Key Responsibilities :

• Perform ETL testing and validate data extraction, transformation, and loading processes.
• Work with Azure Data Factory and Databricks for data pipeline validation.
• Validate data accuracy, completeness, integrity, and consistency across source and target systems.
• Write and execute complex SQL queries for data validation and reconciliation.
• Identify, troubleshoot, and report data-related defects.
• Perform end-to-end, functional, regression, and integration testing.
• Collaborate with data engineers, developers, and business teams to resolve issues.

Required Skills :

• Strong experience in ETL Testing and Data Warehouse Testing.
• Hands-on experience with Azure Data Factory and Azure cloud services.
• Working experience with Databricks and PySpark.
• Strong SQL skills, including complex queries and data validation.
• Experience with data migration, data reconciliation, and data quality testing.
• Understanding of cloud-based data pipelines and workflows.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.