ETL Tester - Senior Engineer

Iris Software

5–8 yrs Noida, Gurugram, Pune Full Time Hybrid (office + remote)
Iris Software logo
Posted : 1 week ago
Actively hiring

Job description

Join Iris Software as a Senior Engineer – Quality Assurance and contribute to one of India's Top 25 Best Workplaces in the IT industry. We are a fast-growing IT services company committed to empowering our clients with technology-enabled transformations and providing a platform for our professionals to realize their full potential. Our work spans across financial services, healthcare, transportation & logistics, and professional services, utilizing cutting-edge technologies like Data & Analytics, Cloud, DevOps, and Quality Engineering.

At Iris, your career is a journey you own. We foster a culture where your contributions matter, your voice is heard, and you have the opportunities to shape your success. With opportunities for continuous learning, mentorship, and involvement in complex, mission-critical projects, we are dedicated to supporting your personal and professional growth.

Responsibilities

As an ETL Tester, you will be instrumental in designing and implementing robust ETL testing strategies, focusing on data validation, reconciliation, and data warehouse integrity. You will develop complex SQL queries for large-scale data validation and performance tuning, while meticulously analyzing ETL workflows and data models to pinpoint risks and inconsistencies. Your role involves leading ETL testing efforts across diverse systems, ensuring seamless source-to-target data flow, conducting root cause analysis, and supporting issue resolution. You will also review test cases and SQL scripts, ensuring adherence to established standards, and mentor team members in advanced ETL testing and SQL optimization techniques. Effective collaboration with stakeholders to align data validation with reporting and analytics needs is crucial.

Qualifications

We are seeking a Senior Engineer with 5-8 years of experience in ETL testing. Essential skills include strong proficiency in ETL Testing, SSIS, and MS SQL. You should possess the ability to design and implement comprehensive testing strategies, including data validation, reconciliation, and data warehouse testing. Developing complex SQL queries for data validation and performance tuning is a key requirement. The role demands the capacity to analyze ETL workflows and data models to identify risks. Experience in leading ETL testing efforts, owning source-to-target validation, performing root cause analysis, and supporting resolution is expected. You will also be responsible for reviewing test cases and SQL scripts and mentoring junior team members.

Essential Skills

ETL TestingSSISMS SQLSQL QueriesData ValidationData ReconciliationData Warehouse TestingRoot Cause AnalysisTest Case CreationTest ExecutionTest PlanningTest ReportingRisk Management

Good to Have

QA AutomationBuild DeploymentCI/CD

Highlights

  • Actively hiring

More Details

RoleETL Tester - Senior Engineer
IndustryInformation Technology & Services
DepartmentQuality Assurance
Employment TypeFull Time, Hybrid (office + remote)

About the Company

Iris Software logo

Iris Software

Information Technology & Services