Data Transformation Engineer MAINFRAME

Job Description – Data Transformation Engineer (Primary Skill: Mainframe Development) Role Overview

We are seeking a skilled Data Transformation Engineer with strong expertise in Mainframe Development, ETL processing, and enterprise data integration. The ideal candidate should have hands-on experience in designing scalable ETL pipelines, translating complex business rules into technical solutions, and working across the full software development lifecycle.

The candidate will collaborate with cross-functional teams to build reliable, high-performance data transformation and reporting solutions within enterprise environments.

Key Responsibilities

• Design, develop, and maintain scalable ETL/data transformation pipelines for enterprise data warehouses and MIS/reporting systems.
• Translate business requirements and transformation rules into optimized ETL workflows and batch processes.
• Develop and support Mainframe applications using COBOL, JCL, DB2, and related technologies.
• Build and optimize SQL queries, stored procedures, and data extraction routines.
• Develop and maintain UNIX shell scripts and scheduling jobs using tools like Control-M.
• Perform data validation, reconciliation, debugging, and troubleshooting of ETL workflows and batch jobs.
• Collaborate with business analysts, data engineers, QA teams, and infrastructure teams to ensure data accuracy and system reliability.
• Participate in the complete SDLC including:
  • Requirement analysis
  • Design
  • Development
  • Unit testing
  • Deployment
  • Documentation
  • Production support
• Support CI/CD and DevOps practices for deployment automation and release management.
• Prepare technical documentation, process flows, and operational support documents.

Required Technical Skills Mainframe Technologies

• COBOL
• JCL
• DB2
• Mainframes

ETL & Data Integration

• DataStage or Ab Initio
• ETL pipeline development
• Data transformation and reconciliation
• Data warehousing concepts

Database & Querying

• Strong SQL proficiency
• DB2 / relational databases
• Query optimization and performance tuning

Scripting & Scheduling

• UNIX Shell Scripting
• PowerShell (preferred)
• Control-M / Airflow / enterprise schedulers

DevOps & SDLC

• CI/CD tools and deployment practices
• Version control systems
• Agile/Scrum methodologies

Preferred Qualifications

• Experience working on enterprise data warehouse or reporting projects.
• Exposure to cloud migration or modernization initiatives.
• Knowledge of batch processing frameworks and enterprise scheduling tools.
• Experience handling high-volume transactional datasets.
• Understanding of data governance and data quality practices.

Soft Skills

• Strong analytical and problem-solving abilities
• Excellent communication and stakeholder interaction skills
• Ability to multitask in fast-paced environments
• Strong documentation and process management skills
• Team collaboration and ownership mindset

Experience Required

• 4+ years of relevant experience in Mainframe Development and ETL/Data Transformation.