ETL Tester

Groupe Kardol; Princeton (NJ); On-site; USD 85,000 - 120,000; Full time

Job summary

K&K Global Talent Solutions is seeking a data validation and ETL testing specialist to verify data accuracy across source and target systems. You will develop comprehensive test plans and scripts grounded in ETL design documents, and perform backend validation using complex SQL queries.

The role requires experience with Informatica or similar ETL tools and Oracle/SQL Server databases, with a focus on identifying and resolving data quality issues in collaboration with developers.

Qualifications

• Strong SQL proficiency and backend validation experience.
• Experience with ETL concepts and data quality.
• Familiarity with Informatica and Oracle databases is preferred.

Responsibilities

• Verify data accuracy, completeness, and consistency between source systems and target warehouses.
• Develop and implement detailed test plans, test cases, and test scripts based on ETL design documents.
• Write complex SQL queries for backend validation and data checks.
• Identify, log, and track bugs, collaborating with developers to resolve data quality issues.

Skills

SQL

ETL concepts

Tools

Informatica

Oracle

SQL Server

Job description

Our client, K&K Global Talent Solutions, is seeking the following.

Verify data accuracy, completeness, and consistency between source systems and target warehouses.

Strong understanding of ETL concepts.

Develop and implement detailed test plans, test cases, and test scripts based on ETL design documents.

Ability to write complex SQLs and able to do sql based backend validation

Identify, log, and track bugs, working with developers to resolve data quality issues.

Experience working on informatica or similar and oracle database

Skills required

SQL , informatica or similar ETL tools, oracle or SQL server databases.