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

  • PB consulting
  • Princeton, MA

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

Temporary work

Similar Jobs

Rolling Plains Management Corporation

Early Head Start Teacher Job at Rolling Plains Management Corporation

Job Details Job Location: Olney, TX 76374Salary Range: $12.98 HourlyEarly Head Start Teacher Olney Child Development CenterLocation: Olney, TexasEmployer: Rolling Plains Management Corporation (RPMC)Status: Full-Time (40 hours per week, primarily MondayFriday; ...

Balanced Body Inc

Trade Show Logistics Coordinator Job at Balanced Body Inc

 ...Description Balanced Body is Hiring! The Trade Show Logistics Coordinator owns the end-to-end logistics of Balanced Bodys trade show and event presence from booth contracting through show-day execution and post-event wrap-up. Show selection is determined by Sales... 

Alpine Solutions Group

Creative Strategist Job at Alpine Solutions Group

 ...Job Title Creative Strategy Own creative strategy across paid social and performance marketing channels, with a strong focus on...  ...and performance-oriented. Direct creators, editors, freelancers, agencies, and internal team members to produce high-performing assets. Build... 

Apex Systems

Research Assistants Job at Apex Systems

 ...professionals can contribute to meaningful scientific work. Everforth Apex is a world-class IT services company that serves thousands of...  ...an Everforth Apex team member can provide. Everforth Apex Systems is an equal opportunity employer. We do not discriminate or... 

Northern Star Solutions

Sales Representative - $800 - $1,500+/Week Job at Northern Star Solutions

 ...Sales Representative - $800 - $1,500+/Week No Experience Necessary | $800 - $1500/Week Potential | Uncapped Commission + Bonuses Northern Star Solutions is seeking motivated, energetic, and driven individuals to join our growing team as Entry-Level Roofing Sales...