W-2 Jobs Portal
  • W-2 Open Positions Need to be Filled Immediately. Consultant must be on our company payroll, Corp-to-Corp (C2C) is not allowed.

    • Candidates encouraged to apply directly using this portal. We do not accept resumes from other company/ third-party recruiters


Job Overview

  • Job ID:

    J51617

  • Specialized Area:

    ETL

  • Job Title:

    Senior ETL QA (Data, Power BI)

  • Location:

    Woodbridge Township,NJ

  • Duration:

    24 Months

  • Domain Exposure:

    Insurance

  • Work Authorization:

    US Citizen, Green Card, OPT-EAD, CPT, H-1B,
    H4-EAD, L2-EAD, GC-EAD

  • Client:

    To Be Discussed Later

  • Employment Type:

    W-2 (Consultant must be on our company payroll. C2C is not allowed)

  • Bench Recruiter:

    Nina Stephens




Job Description

Job Details

JD:

Role Overview

  • The Onsite Senior ETL QA will lead quality assurance efforts for data platforms and Power BI solutions, ensuring accuracy, reliability, and compliance across MDM, ETL, and reporting layers.
  • This role involves defining test strategies, mentoring junior QA engineers, and collaborating with onshore teams to deliver high-quality solutions in a global delivery model.

Key Responsibilities

Define and implement comprehensive QA strategies for data pipelines, MDM outputs, and Power BI dashboards.

  • Lead functional, regression, and performance testing for large-scale data and BI solutions. Validate complex data transformations, DAX calculations, KPIs, and visualization logic.
  • Develop automated testing frameworks for data quality and BI validation where applicable.
  • Review and approve test plans, cases, and scripts prepared by junior QA engineers. Collaborate with architects, developers, and business analysts to ensure alignment with requirements.
  • Document defects, provide root cause analysis, and drive resolution with development teams.
  • Ensure adherence to data governance, security, and compliance standards during QA processes.
  • Mentor and guide offshore QA team members, ensuring best practices and continuous improvement.

Required Skills & Experience

  • 12 years of experience in QA for data platforms and BI solutions, with leadership exposure. Strong expertise in SQL for data validation and ETL testing.
  • Hands-on experience with Power BI testing, including advanced DAX and performance optimization.
  • Familiarity with Informatica MDM data flows and AWS-based data environments. Experience in test automation tools for data and BI validation (e.g., Selenium, PyTest, or custom frameworks).
  • Excellent communication skills for offshore/onshore coordination and stakeholder reporting. Knowledge of P&C Insurance domain is highly desirable.

Apply Now
Equal Opportunity Employer

Amtex is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. Amtex will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will Amtex require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract