ETL Tester - Senior Engineer
Iris Software
Iris Software
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.
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.
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.
Iris Software
Information Technology & Services