ETL Testing with Mainframe

N Consulting Limited; Hyderabad; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

N Consulting Limited in Hyderabad is seeking an experienced ETL Test Engineer with strong expertise in ETL Testing, SQL, Python, and Mainframe technologies. The role focuses on validating data across source and target systems and ensuring data quality within pipelines and reporting.

Responsibilities include designing test plans, executing data validation, and developing Python automation scripts. Collaboration with cross-functional teams and participation in Agile ceremonies are expected.

Qualifications

• 5+ years of ETL/Data Warehouse Testing experience.
• Hands-on SQL and database validation expertise.

Responsibilities

• Design, develop, and execute ETL test cases and test scripts.
• Validate data movements between source and target systems.
• Write and optimize complex SQL queries for data validation.
• Perform end-to-end testing of ETL workflows and reports.
• Analyze mappings and requirements with stakeholders.
• Develop Python scripts for test automation and data prep.
• Validate Mainframe data and downstream data integrity.
• Track defects using JIRA/ALM and participate in Agile ceremonies.
• Collaborate with developers, data engineers, and analysts.
• Ensure data quality, completeness, and consistency across apps.

Skills

ETL Testing

SQL

Python Programming

Mainframe (JCL, COBOL, DB2, VSAM)

Data Validation

RDBMS Databases

Agile/Scrum

Test Automation

Unix/Linux Basics

Data Warehousing Concepts

Tools

JIRA

ALM

Unix/Linux

Job description

Role: Quality Engineering Analyst (ETL, SQLs, Python Programming, Mainframe)

Location: Hyderabad

Experience: 5+ Years

Job Description :–We are looking for an experienced ETL Test Engineer with strong expertise in ETL Testing, SQL, Python, and Mainframe technologies. The ideal candidate should have hands‑on experience in validating data across source and target systems, performing data quality checks, developing test scenarios, and working in Agile environments. The candidate will collaborate closely with developers, business analysts, and data engineers to ensure the accuracy and integrity of data pipelines and reporting systems.

Primary Skills

• ETL Testing
• SQL
• Python Programming
• Mainframe (JCL, COBOL, DB2, VSAM)
• Data Validation & Data Reconciliation
• RDBMS Databases

Secondary Skills

• Agile/Scrum Methodology
• JIRA / ALM
• Test Automation
• Unix/Linux Basics
• Data Warehousing Concepts

Key Responsibilities

• Design, develop, and execute ETL test cases, test plans, and test scripts.
• Validate data movement and transformations between source and target systems.
• Write and optimize complex SQL queries for data validation and reconciliation.
• Perform end-to-end testing of ETL workflows, data warehouses, and reporting systems.
• Analyze source-to-target mappings and business requirements.
• Develop Python scripts for test automation, data validation, and test data preparation.
• Validate data extracted from Mainframe systems and ensure accuracy in downstream applications.
• Identify, track, and report defects using JIRA/ALM.
• Participate in Agile ceremonies including sprint planning, daily stand‑ups, and retrospectives.
• Collaborate with cross‑functional teams including Developers, Data Engineers, Business Analysts, and Product Owners.
• Ensure data quality, completeness, consistency, and integrity across applications.

Required Qualifications

• 5+ years of experience in ETL/Data Warehouse Testing.
• Strong hands‑on experience in SQL and database validation.
• Experience working with Mainframe technologies such as JCL, COBOL, DB2, VSAM, and ISPF.
• Proficiency in Python scripting for automation and data validation.
• Experience with RDBMS databases such as Oracle, SQL Server, DB2, PostgreSQL, or MySQL.
• Strong understanding of Software Testing Life Cycle (STLC) and Defect Life Cycle.
• Experience working in Agile/Scrum projects.
• Excellent analytical, communication, and problem-solving skills