Senior Etl Test Engineer

About Iris-

At Iris Software, our vision is to be our clients most trusted technology partner, and the first choice for the industrys top professionals to realize their full potential.

With over 4,300 associates across India, U.S.A, and Canada, we help our enterprise clients thrive with technology-enabled transformation across financial services, healthcare, transportation & logistics, and professional services.

Our work covers complex, mission-critical applications with the latest technologies, such as high-value complex Application & Product Engineering, Data & Analytics, Cloud, DevOps, Data & MLOps, Quality Engineering, and Business Automation.

https://www.linkedin.com/company/iris-software-inc./

Working at Iris: Be valued, be inspired, be your best.

At Iris Software, we invest in and create a culture where colleagues feel valued, can explore their potential, and have opportunities to grow.

Being Your Best

Total Exp

Mode-

Location

Skills Required-

Data Testing Strategy & Execution: Design, develop, and execute comprehensive test plans and test cases for data-centric applications, ETL processes, data warehouses, data lakes, and reporting solutions.
• SQL-Driven Validation: Utilize advanced SQL queries to perform complex data validation, data reconciliation, data integrity checks, and data quality assurance across various financial data sources. • ETL Testing: Conduct thorough testing of ETL (Extract, Transform, Load) processes, ensuring data is accurately extracted, transformed according to business rules, and loaded correctly into target systems. • Data Quality Assurance: Implement and monitor data quality checks, identify data discrepancies, anomalies, and inconsistencies, and work with development and business teams to resolve issues. • Performance Testing (Data Focus): Contribute to performance testing efforts for data pipelines and database operations, ensuring optimal query and data load performance. • Test Data Management: Create and manage robust test data sets for various testing phases, including positive, negative, and edge case scenarios. • Defect Management: Identify, document, track, and re-test defects in data, collaborating closely with development and data engineering teams for timely resolution. • Documentation & Reporting: Maintain clear and concise documentation of test plans, test cases, test results, and data quality reports. Provide regular status updates to stakeholders. • Collaboration: Work effectively with business analysts, data architects, data engineers, and project managers to understand data flows, business requirements, and ensure data quality standards are met. • Process Improvement: Proactively identify opportunities for process improvements in data testing methodologies and tools. • Global Team Collaboration: Provide consistent overlap with EST working hours (until noon EST) to facilitate effective communication and collaboration with US-based teams.

Required Skills & Experience:
• Experience: 7+ years of hands-on experience in Data Quality Assurance, Data Testing, or ETL Testing roles.

• SQL Expertise:

Mandatory Competencies

ETL - ETL - Tester

Database - Database Programming - SQL

Database - PostgreSQL - PostgreSQL

Beh - Communication

Database - Oracle - Database Design

Domain Areas - FS Domain - Financial Services

Domain Areas - FS Domain - Market Risk

kanika.singh@irissoftware.com

Notice Period- Max 1 month