Hi,

Role    : ETL Tester

Location : Whippany, NJ (Hybrid)

Duration : Contract - Long Term - W2

Job Description:

Skilled and experienced in ETL testing for AbInitio ETLs with more 8+ years of experience.

1. An ETL tester validates data accuracy, completeness, and consistency in data extraction, transformation, and loading (ETL) processes. 
2. Their job description includes designing and executing test cases, troubleshooting data discrepancies, and ensuring the ETL system meets business and technical requirements by collaborating with developers and data analysts.

 Key duties:

1. Data source and target testing: Test both the source databases to ensure data is extracted correctly and the target tables to ensure data is loaded accurately.
2. Transformation logic verification: Analyze and verify that transformation rules and logic are applied correctly during the ETL process.
3. Data integrity and quality assurance: Ensure data integrity is maintained throughout the entire ETL pipeline.
4. Reporting and documentation: Document test results, defects, and the overall testing process.
5. SQL and scripting: Use SQL queries to validate data and may use scripting or automation tools to assist in testing.