Job Description

Roles and Responsibilities
Lead testing activities for ETL processes, data warehouses, and data services.
Design and execute comprehensive ETL and Data Warehouse test strategies and test cases.
Develop complex SQL queries to validate data, perform reconciliation, and verify business scenarios.
Validate data across source and target systems for completeness, accuracy, consistency, and integrity.
Perform data mapping, transformation, and reconciliation testing.
Identify, analyze, document, and track data-related defects through resolution.
Work closely with developers, data engineers, business analysts, and other stakeholders to resolve data quality and integration issues.
Validate ETL workflows, data transformations, and data loads across various environments.
Support end-to-end testing of data services and data warehouse solutions.
Review requirements and technical specifications to develop effective testing approaches.
Lead defect triage, root-cause analysis, and resolution activities.
Mentor QA team members and provide technical guidance on ETL and SQL testing best practices.

Required Qualifications

6–8+ years of experience in software testing, with strong expertise in ETL and Data Warehouse Testing.
Strong hands-on experience with SQL and complex SQL query development.
Ability to write SQL queries independently based on business and technical scenarios.
Strong understanding of ETL processes, data transformation, data mapping, and data validation.
Experience testing Data Warehouses and data integration solutions.
Strong knowledge of data reconciliation, source-to-target validation, and data quality testing.
Experience with defect management and test lifecycle processes.
Strong analytical, troubleshooting, and problem-solving skills.
Excellent communication and stakeholder collaboration skills.

Preferred Qualifications

Experience in Capital Markets, Investment Banking, or Financial Services.
Experience with Microsoft Azure and cloud-based data platforms.
Experience with ETL/data integration tools and modern data warehouse technologies.
Experience leading QA/testing teams or complex data testing initiatives.
Familiarity with Agile/Scrum development methodologies.

Job Tags

Contract work

Similar Jobs

American Honda Motor Co., Inc.

Creative Design & Research Co-op/Intern Job at American Honda Motor Co., Inc.

...vehicles or individual components Contribute to styling proposals for color, graphics, and materials Support UX, UI graphics, and animation work Attend meetings and collaborate with cross-functional teams to advance projects through animations, model building, and...

E-Z Bel Construction, LLC

Heavy Equipment Mechanic Job at E-Z Bel Construction, LLC

...POSITION SUMMARY The Heavy Equipment Mechanic performs repairs, preventive maintenance, and diagnostics on fleet trucks, trailers, and construction equipment. This role uses hand tools, power tools, and diagnostic software to troubleshoot and service hydraulic, pneumatic...

M3 Design Inc.

Design Intern Job at M3 Design Inc.

...sketching and visualization (e.g.Photoshop, Illustrator), 3D CAD modeling (Rhino, Solidworks or Creo), and computer rendering and/or animation (e.g. Keyshot). You have used Adobe and Microsoft Office suites and have applied human factors principles to the design of...

AIL

Remote Insurance Sales Representative Job at AIL

...Training Provided Experience: Entry-Level Candidates Welcome Work From Home. Help Families. Build Your Future. Are you looking for a... .... There is no hourly wage or base salary. Commission is paid weekly on eligible completed business. Additional opportunities...

Acestack

Test Automation QE - ETL and API Job at Acestack

Test Automation QE - ETL and API Job Type: Full Time Location: Toronto, ON Work Model: Onsite / 4 Days Primary Skills: ETL Test Automation, SQL & Python, AWS S3 & Hadoop Job Description We are seeking a skilled Test Automation QE - ETL and API...

Senior ETL Test Lead Job at PB consulting, Princeton, MA