Logo
Saxon Global

ETL QA Tester

Saxon Global, Jersey City, New Jersey, United States, 07390

Save Job

Job Summary: We are seeking a meticulous

ETL QA Tester

with strong

SQL skills

and experience in

Data warehouse ETL testing

to ensure data integrity, accuracy, and completeness throughout our data transformation processes.

Needs to be strong with ETL testing and strong SQL Queries experience- need someone senior level who can come in and hit the ground running- start date of April 1st .

Key Responsibilities: • Design, develop, and execute

ETL test cases

to validate data extraction, transformation, and loading processes. • Write and execute

complex SQL queries

to perform data validation and back-end testing. • Identify, report, and track

defects

systematically. • Participate in project meetings and collaborate with developers to resolve the issues •

Clarify requirements when necessary

and ensure comprehensive coverage of all requirements in the testing process.

Required Skills & Qualifications: •

Must-have:

Strong SQL skills with hands-on experience in writing and optimizing complex queries. •

Experience in ETL Testing:

Understanding of data extraction, transformation, and loading (ETL) processes. •

Knowledge of Agile Methodologies and Defect Tracking Tools:

Familiarity with Agile development processes and proficiency in using defect tracking tools like JIRA. •

Data Validation & Reconciliation:

Ability to compare large datasets between sources and targets. •

Experience with SQL DBMS Tools:

Knowledge of database management systems such as Oracle, Azure Databricks, Denodo. • Familiarity with

data warehouses and data lake

is required. • Strong analytical and problem-solving skills with attention to detail. • Excellent communication skills with the ability to work in a

collaborative and fast-paced

environment.

Nice to Have: • Knowledge of

Python

is an advantage. • Knowledge of Azure Databricks is a great plus. • Familiarity with

cloud platforms

(AWS, Azure, GCP) and their data services is a plus.