What are the responsibilities and job description for the ETL QA Tester (W-2/1099) position at Avenues International, Inc.?
Job Details
Note-This position is not available for corp-to-corp
Job Title: ETL QA Tester
Location: Hybrid work in Jersey City,NJ (2 day/week onsite,3 days/week remote)
Work Hours: 9 am 5 pm EST
Duration-Contract- 12 months
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.
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, Google Cloud Platform) and their data services is a plus.
Best Regards,
Santy Kumar
Senior Business Manager
Avenues International Inc.
Email:
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
ETL Tester
Petabyte Technologies LLC -
Weehawken, NJ
ETL Tester (to work in W2)
Raag Solutions -
Jersey, NJ
QA/ ADA Testing/ETL; NJ
Genesis10 -
Jersey, NJ
