Manual Data Tester - Senior Engineer

Iris Software; Dadri; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Iris Software in India is seeking a Senior Engineer in Manual Data Testing to drive ETL validation and data quality across complex data pipelines.

You will design and implement testing strategies, develop SQL queries for large-scale data validation, review transformations, and lead the ETL testing effort across multiple systems, ensuring data integrity and timely delivery.

Mentor teammates, collaborate with stakeholders, and advocate best practices in testing, reporting, and automation.

Qualifications

• Experience designing ETL testing strategies and data validation.
• Proficiency in SQL for data validation and reconciliation.
• Experience with large-scale data warehouse testing.
• Strong understanding of data models and transformation logic.
• Mentor teammates and collaborate with stakeholders.

Responsibilities

• Design ETL testing strategies covering data validation, reconciliation, and data warehouse testing.
• Develop complex SQL queries for large-scale data validation and performance tuning.
• Analyze ETL workflows, data models, and transformations to find risks.
• Lead ETL testing across multiple systems ensuring data integrity.
• Own ETL validation across source-to-target workflows, including root-cause analysis.
• Review test cases, SQL scripts, and validation processes for standards.
• Mentor team members in ETL testing and SQL optimization.
• Collaborate with stakeholders to align data validation with reporting.

Skills

PySpark

Databricks

API Testing

Informatica PowerCentre

Risk Management

Test Case Creation

CI/CD

ETL Testing

Communication

Job description

Job Summary

Manual Data Tester - Senior Engineer

Responsibilities

• Design and implement comprehensive ETL testing strategies covering data validation, reconciliation, and data warehouse testing.
• Develop complex SQL queries for large-scale data validation and performance tuning.
• Analyze ETL workflows, data models, and transformation logic to identify risks and inconsistencies.
• Lead ETL testing efforts across multiple systems ensuring data integrity and quality.
• Own ETL validation across source-to-target workflows, including reconciliation, root cause analysis, and resolution support.
• Review test cases, SQL scripts, and validation processes ensuring adherence to standards.
• Mentor team members in ETL testing, data validation, and SQL optimization techniques.
• Collaborate with stakeholders to align data validation with reporting and analytics requirements.

Behavioral Competencies

• Demonstrates ownership of ETL validation activities to ensure data quality and testing excellence.
• Collaborate effectively with teams and stakeholders for successful delivery.
• Apply strong analytical and problem-solving skills to complex testing challenges.
• Communicates proactively to ensure stakeholder alignment and transparency.
• Mentors team members and promote knowledge sharing across testing practices.
• Ensures end-to-end quality delivery through effective test ownership.
• Drives innovation in testing strategies, processes, and automation adoption.
• Adapts effectively to changing requirements and testing priorities.
• Maintains attention to detail in testing, validation, and defect management.
• Takes initiative in improving test coverage, processes, and quality practices.

Mandatory Competencies

• Big Data - Big Data - Pyspark
• Data Science and Machine Learning - Data Science and Machine Learning - Databricks
• QA/QE - QA Manual - API Testing
• ETL - ETL - Informatica Power Centre
• QA - Risk Management
• QA/QE - QA Manual - Test Case Creation, Execution, Planning, Reporting with risks/dependencies
• Data AI - BI Reporting and Data Visualization - ETL Concepts
• QA/QE - QA Automation - Basic Build, Deployment and CI/CD
• QA/QE - QA Automation - ETL Testing
• Beh - Communication and collaboration