Senior ETL Tester with Data Engineer

Cloud Hybrid Technologies, LLC; Jersey City (NJ); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading technology firm is seeking a meticulous ETL QA Tester with over 6 years of experience in ETL testing and strong SQL skills. The role involves designing and executing ETL test cases, validating data processes, and communicating effectively across time zones. Familiarity with data warehouses and cloud platforms is beneficial. The position offers a collaborative and dynamic work environment, with opportunities for professional growth.

Qualifications

• 6+ years of experience in ETL testing and strong SQL skills.
• Hands-on experience in writing and optimizing complex SQL queries.
• Familiarity with data warehouses and data lakes.

Responsibilities

• Design, develop, and execute ETL test cases to validate data processes.
• Write and execute complex SQL queries for data validation.
• Identify, report, and track defects systematically.

Skills

Strong SQL skills

ETL Testing experience

Data Validation & Reconciliation

Analytical skills

Excellent communication skills

Tools

Oracle

SQL Server

JIRA

Azure Databricks

Job description

We are seeking a meticulous ETL QA Tester with 6+ years of experience, strong SQL skills and experience in ETL testing to ensure data integrity, accuracy, and completeness throughout our data transformation processes. This role demands flexibility in working hours to facilitate effective communication with developers and project teams across various time zones.

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 be available for discussions in US EST working hours as needed.
• 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.
• Familiarity with data warehouses and data lake is a must.
• 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, Denodo, Azure Databricks, SQL Server.
• 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.

Good to Have

• Knowledge of Python is an advantage.
• Knowledge of Azure Databricks is a plus.
• Familiarity with cloud platforms (AWS, Azure, Google Cloud Platform) and their data services is a plus.

Cloud Hybrid is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. Cloud Hybrid will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will Cloud Hybrid require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.