Senior ETL Tester (SQL, Azure, ETL Testing)

About Company

Papigen

is a fast-growing global technology services company, delivering innovative digital solutions through deep industry experience and cutting-edge expertise. We specialize in technology transformation, enterprise modernization, and dynamic areas like Cloud, Big Data, Java, React, DevOps, and more. Our client-centric approach combines consulting, engineering, and data science to help businesses evolve and scale efficiently.

About The Role

We are seeking an experienced

Senior Data QA Analyst

to support data integration, transformation, and reporting validation for enterprise-scale systems. This role involves close collaboration with data engineers, business analysts, and stakeholders to ensure the quality, accuracy, and reliability of data workflows, especially in

Azure Data Bricks

and

ETL pipelines

.

Key Responsibilities

Test Planning and Execution:

• Collaborate with Business Analysts and Data Engineers to understand requirements and translate them into test scenarios and test case
• Develop and execute comprehensive test plans and test scripts for data validation
• Log and manage defects using tools like Azure DevOps
• Support UAT and post-go-live smoke testing
  

Data Integration Validation

• Understand data architecture and workflows, including ETL processes and data movement
• Write and execute complex SQL queries to validate data accuracy, completeness, and consistency
• Ensure correctness of data transformations and mappings based on business logic
  

Report Testing

• Validate the structure, metrics, and content of BI reports
• Perform cross-checks of report outputs against source systems
• Ensure reports reflect accurate calculations and align with business requirements
  

Required Skills & Experience

• Bachelor’s degree in IT, Computer Science, MIS, or related field
• 8+ years of experience in QA, especially in data validation or data warehouse testing
• Strong hands-on experience with SQL and data analysis
• Proven experience working with Azure Data Bricks, Python, and PySpark (preferred)
• Familiarity with data models like Data Marts, EDW, and Operational Data Stores
• Excellent understanding of data transformation, mapping logic, and BI validation
• Experience with test case documentation, defect tracking, and Agile methodologies
• Strong verbal and written communication skills, with the ability to work in a cross-functional environment
  

Benefit And Perks

• Opportunity to work with leading global clients
• Exposure to modern technology stacks and tools
• Supportive and collaborative team environment
• Continuous learning and career development opportunities
  

Skills: data marts,pyspark,databricks,test case design,agile methodologies,sql,python,test planning,data warehousing,etl testing,test case documentation,testing,operational data stores,azure data bricks,data analysis,etl,agile,edw,defect tracking