Datawarehouse Test Lead

Job Title: Datawarehouse Test Lead

Job ID: POS-20690

Primary Skill: ETL Testing

Key Skills: Data QA, ETL Testing, SQL, Python, Data Validation, P&C Insurance

Job Location: Hyderabad / Pune / Coimbatore / Bengaluru

Experience: 7–10 Years

Mode of Work: Hybrid

About the job:

The source JD describes a Data Test Engineer responsible for validating data sources, checking transformation logic, and validating data loaded into target tables. The role involves designing, testing, and troubleshooting client data storage systems before release. Strong technical capabilities and knowledge of Python, SQL, XML, data warehousing concepts, and ETL troubleshooting are required.

Know your team:

At ValueMomentum Technology Solution Centers, we are a team of passionate software engineering teams who thrive on tackling complex business challenges with innovative solutions catering to the P&C insurance value chain. We achieve this through a strong software engineering foundation and by continuously refining our processes, methodologies, tools, agile delivery teams, and core engineering archetypes. Our core expertise lies in six key areas: Platforms, Infra/Cloud, Application, Data, Core, and Quality Assurance.

Join our team that invests in your growth. Our Infinity Program empowers you to build your career with role-specific skill development, leveraging immersive learning platforms. You'll have the opportunity to work with some of the best minds serving insurance customers in the US, UK and Canadian markets.

Responsibilities:

• Develop and implement data testing strategies and methodologies to ensure data accuracy, completeness, and integrity in P&C insurance software solutions.
• Conduct data validation to identify and resolve data quality issues.
• Design test plans, test cases, and scenarios covering data completeness, correctness, and consistency.
• Execute manual and automated data testing according to defined test plans.
• Analyze source-to-target mappings and perform source-system data verification.
• Validate data transformations, aggregations, and business rules.
• Identify data anomalies and perform root-cause analysis with developers and data engineers.
• Participate in data migration and reconciliation testing across legacy and modern systems.
• Develop and maintain automated data validation scripts and frameworks using SQL, Python, or similar languages.
• Implement automated data validation checks to improve efficiency and detect data issues early.
• Test ETL extraction, transformation, and loading, ensuring data flows correctly through pipeline stages.
• Collaborate with development and data engineering teams to prioritize and resolve defects.
• Perform regression testing and follow established quality standards and testing practices.

Requirements:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Experience in software quality assurance, with a focus on data testing and validation.
• Understanding of P&C insurance concepts, data models, workflows, and regulatory requirements.
• Strong SQL skills for data validation and analysis.
• Knowledge of data testing principles and both manual and automated testing.
• Experience developing data validation scripts and frameworks using Python, SQL, or similar tools.
• Familiarity with ETL testing tools and data quality platforms such as Informatica, Azure Data Factory, Databricks, Talend, or similar.
• Knowledge of BI reporting testing tools such as Power BI, Tableau, Qlik Sense, or similar.
• Familiarity with Jira, HP ALM, or similar defect tracking and test management tools.
• Understanding of regression testing and Agile delivery.
• Strong communication, analytical, problem-solving, and collaboration skills.

Good To Have:

• Relevant certifications such as ISTQB, ICP, or Agile certifications.

About the Company:
Founded in 2000 with the core belief that impactful change comes from deep commitment, ValueMomentum specializes in delivering measurable results across the P&C value stream. For more than 25 years, we have empowered more than 100 carriers to reimagine their businesses with AI and emerging technologies, navigate market shifts, unlock speed to value, and become future-ready. We help insurers in the US, Canada, and Europe stay ahead with sustained growth and high performance to enhance stakeholder value and foster resilient societies.

Our culture – Our fuel
At ValueMomentum, we believe in making employees win by nurturing them from within, collaborating and looking out for each other.

• People firs - Empower employees to succeed.
• Nurture leaders - Nurture from within.
• Enjoy wins - Recognize and celebrate win.
• Collaboration - Foster a culture of collaboration and people-centricity.
• Diversity - Committed to diversity, equity, and inclusion.
• Fun - Create a fun and engaging work environment

Company Benefits:

• Compensation - Competitive compensation package comparable to the best in the industry.
• Career Growth - Career development, comprehensive training & certification programs, and fast track growth for high potential associates.
• Health Benefits: Comprehensive health benefits and life insurance.