🤖 15+ AI Agents working for you. Find jobs, score and update resumes, cover letter, interview questions, missing keywords, and lots more.
Cookies & analytics consent
We serve candidates globally, so we only activate Google Tag Manager and other analytics after you opt in. This keeps us aligned with GDPR/UK DPA, ePrivacy, LGPD, and similar rules. Essential features still run without analytics cookies.
Read how we use data in our Privacy Policy and Terms of Service.
🤖 15+ AI Agents working for you. Find jobs, score and update resumes, cover letter, interview questions, missing keywords, and lots more.
Iris Software Inc. • Noida, Uttar Pradesh, India
Role & seniority: Data Quality Assurance / Data Testing Specialist, mid–senior (5–8 years)
Stack/tools: SQL (advanced), databases: SQL Server, Oracle, PostgreSQL, MySQL, Snowflake, BigQuery; ETL testing; data warehousing concepts; test data management; documentation tools; collaboration with data engineers/analysts
Design, develop, and execute test plans and cases for data-centric apps, ETL processes, data warehouses/lakes, and reporting solutions
Perform SQL-driven validation, data quality checks, data reconciliation, and data integrity testing; manage defects and re-test
Ensure data pipeline performance, create robust test data sets, document results, and collaborate with business/technical teams; support process improvements and global-timezone coordination
5–8 years in Data QA, Data Testing, or ETL Testing
Advanced SQL: complex queries, analytic functions, CTEs, stored procedures; experience across SQL Server, Oracle, PostgreSQL, MySQL, Snowflake, BigQuery
Strong data warehousing/ETL testing knowledge; finance/risk domain familiarity; analytical problem-solving; effective communication; willingness to overlap hours with EST
Domain expertise in Risk and Finance IT, regulatory reporting, and familiarity with financial products and risk metrics
Location & work type: India-based role; full-time; requires regular overlap with US/EST teams (noon EST); remote/hybrid options not speci
Why Join Us?
Are you inspired to grow your career at one of India’s Top 25 Best Workplaces in IT industry? Do you want to do the best work of your life at one of the fastest growing IT services companies? Do you aspire to thrive in an award-winning work culture that values your talent and career aspirations? It’s happening right here at Iris Software.
About Iris Software
At Iris Software, our vision is to be our client’s most trusted technology partner, and the first choice for the industry’s 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.
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.
Our employee value proposition (EVP) is about “Being Your Best” – as a professional and person. It is about being challenged by work that inspires us, being empowered to excel and grow in your career, and being part of a culture where talent is valued. We’re a place where everyone can discover and be their best version.
Job Description
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: 5-8 years of hands-on experience in Data Quality Assurance, Data Testing, or ETL Testing roles.
Advanced proficiency in SQL: Ability to write complex queries, subqueries, analytical functions (Window functions), CTEs, and stored procedures for data validation, reconciliation, and analysis. Experience with various SQL databases (e.g., SQL Server, Oracle, PostgreSQL, MySQL, Snowflake, BigQuery).
Strong understanding of database concepts: normalization, indexing, primary/foreign keys, and data types.
Data Testing Methodologies: Solid understanding of data warehousing concepts, ETL processes, and various data testing strategies (e.g., source-to-target mapping validation, data transformation testing, data load testing, data completeness, data accuracy).
Strong understanding and proven experience in Risk and Finance IT domain: Familiarity with financial data (e.g., trading data, market data, risk metrics, accounting data, regulatory reporting). Knowledge of financial products, regulations, and risk management concepts.
Analytical & Problem-Solving Skills: Excellent ability to analyze complex data sets, identify root causes of data issues, and propose effective solutions.
Communication: Strong verbal and written communication skills to articulate data issues and collaborate with diverse teams.
Time Zone Overlap: Proven ability and willingness to provide consistent working hour overlap until noon EST to collaborate with teams in the Eastern Standard Time zone.
Mandatory Competencies
ETL - ETL - Tester
Database - Database Programming - SQL
Beh - Communication
Database - PostgreSQL - PostgreSQL
Database - Oracle - Database Design
Domain Areas - FS Domain - Financial Services
Domain Areas - FS Domain - Market Risk
Perks And Benefits For Irisians
At Iris Software, we offer world-class benefits designed to support the financial, health and well-being needs of our associates to help achieve harmony between their professional and personal growth. From comprehensive health insurance and competitive salaries to flexible work arrangements and ongoing learning opportunities, we're committed to providing a supportive and rewarding work environment.
Join us and experience the difference of working at a company that values its employees' success and happiness. Show more Show less