Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Jobs

Interviews

Home
>
Jobs in Noida
>
Iris Software
>
ETL QA - Lead

ETL QA - Lead

Iris Software

8 - 10 years

10 - 15 Lacs

Noida

Posted:6 days ago| Platform:

Apply

Skills Required

sql etl testing data warehousing concepts etl etl process sql*plus snowflake oracle data testing data warehousing dbms warehouse sql server data quality postgresql qe database creation quality assurance qa automation mysql bigquery finance

Work Mode

Work from Office

Job Type

Full Time

Job Description

Key Responsibilities:
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: 8-10 years of hands-on experience in Data Quality Assurance, Data Testing, or ETL Testing roles.SQL Expertise:o Advanced proficiency in SQL: Ability to write complex queries, subqueries, analytical functions (Window functions), CTEs, and stored procedures for data validation, reconciliation, and analysis.o Experience with various SQL databases (e.g., SQL Server, Oracle, PostgreSQL, MySQL, Snowflake, BigQuery).o 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).Domain Expertise:o 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).o 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.

Mandatory Competencies

Database - PostgreSQL - PostgreSQL

Database - Sql Server - SQL Packages

ETL - ETL - Tester

QA/QE - QA Automation - ETL Testing

Beh - Communication

More Jobs at Iris Software

Python Automation Tester with Robot Framework

Noida, Gurugram

7 - 12 yrs

INR 22 - 37 Lacs

.Net - Intern

Noida, Uttar Pradesh

Experience: Not specified

Salary: Not disclosed

ETL Tester

Pune, Delhi / NCR

5 - 8 yrs

INR 14 - 24 Lacs

Java Architect

Noida

14 - 18 yrs

INR 25 - 40 Lacs

QA Tester - Intern

Noida, Uttar Pradesh

Experience: Not specified

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

Iris Software

Information Technology & Services

Centennial

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

ETL QA - Lead