What are the responsibilities and job description for the ETL QA Tester position at Meta Resources Group?
Job Description
Job Description
Our Client is seeking a seasoned ETL QA Tester with strong SQL skills and experience in Data warehouse ETL testing to ensure data integrity, accuracy, and completeness throughout their data transformation processes.
This is a 1 year contract role that is hybrid, where it is required to be on-site twice per week in the company's Jersey City, NJ office.
Job 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
Requirements
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
Preferred additional skills :
Knowledge of Python is an advantage
Knowledge of Azure Databricks is a plus
Familiarity with cloud platforms (AWS, Azure, GCP) and their data services is a plus
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a ETL QA Tester?
Sign up to receive alerts about other jobs on the ETL QA Tester career path by checking the boxes next to the positions that interest you.