Windchill Test Analyst

Birlasoft; Dadri; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

A global technology leader is seeking an experienced Test Lead for their ETL and Data Analytics testing team. The ideal candidate will have over 7 years in IT with a focus on leading testing efforts and validating data using SQL. Responsibilities include designing test strategies, leading the team, and ensuring high-quality data through monitoring and reporting. This full-time position is based in Dadri, India, offering a dynamic work environment focused on quality assurance.

Qualifications

• 7+ years of IT experience, 4+ years as Test Lead focused on ETL and Data Analytics testing.
• Proven ability to lead a team with strong SQL proficiency.
• Understanding of data warehousing concepts and ETL/ELT processes.

Responsibilities

• Design and develop comprehensive test strategies, test plans, and test cases.
• Lead and mentor the ETL testing team, providing technical guidance.
• Monitor and report on testing progress and quality metrics.

Skills

SQL

ETL and Data Analytics testing

Leadership

Problem-solving

Communication skills

Tools

Azure Notebook

Databricks

Power BI

Python

PySpark

ADO

Job description

About Birlasoft

Birlasoft, a global leader at the forefront of Cloud, AI, and Digital technologies, seamlessly blends domain expertise with enterprise solutions. The company’s consultative and design‑thinking approach empowers societies worldwide, enhancing the efficiency and productivity of businesses. As part of the multibillion‑dollar diversified CKA Birla Group, Birlasoft with its 12,000+ professionals is committed to continuing the Group’s 170‑year heritage of building sustainable communities.

Key Responsibilities

• Design and develop comprehensive test strategies, test plans, and test cases for ETL workflows and data pipelines.
• Lead and mentor the ETL testing team, allocating tasks, and providing technical guidance.
• Work closely with business analysts, data engineers, and developers to understand requirements and resolve issues.
• Monitor and analyse data quality metrics, identifying and resolving data issues.
• Perform data validation, reconciliation, and verification between source and target systems using SQL and other tools to ensure data accuracy and completeness.
• Oversee the execution of test cases and automation scripts.
• Identify, document, and track defects, working with developers to ensure timely resolution.
• Monitor and report on testing progress, quality metrics, and defect summaries to stakeholders.
• Create and maintain documentation for test plans, results, and process maps.

Required Skills and Qualifications

• 7+ years of experience in IT, and 4+ years as Test Lead with a focus on ETL and Data Analytics testing, and proven ability to lead a team.
• Strong proficiency in SQL for data validation and analysis.
• Knowledge of data warehousing concepts and ETL/ELT processes.
• Experience with ETL and Data Analytics tools (e.g., Azure Notebook, Databricks, Power BI).
• Familiarity with test management and defect tracking tools (e.g., ADO).
• Good database and data warehousing testing knowledge.
• Experience with test automation tools and frameworks (e.g., Python, PySpark).
• Experience managing a team of QA Engineers.
• Understanding of software development lifecycle and best practices.
• Strong knowledge of software quality assurance best practices and methodologies.
• Excellent communication and stakeholder management skills.
• Strong leadership and problem‑solving abilities.

Job Details

Seniority Level: Mid‑Senior level

Employment Type: Full‑time

Job Function: Quality Assurance