: Worker Data Hub ETL DataStage & PL/SQL Developer (4-6 Years) Role Overview

We are looking for a Worker Data Hub ETL DataStage & PL/SQL Developer with 4-6 years of experience to support the development, enhancement, and maintenance of ETL processes and database solutions. The role primarily involves working on data pipelines, writing SQL/PLSQL scripts, resolving issues, and collaborating with senior team members on enterprise data integration projects.

Primary

Skills (Core Expertise) Hands-on experience in ETL development using IBM DataStage

Positive knowledge of Oracle SQL and PL/SQL

Experience with: Unix/Linux Shell scripting Basic exposure to: Windows PowerShell scripting Familiarity with job scheduling tools (AutoSys or similar)

Awareness of REST/SOAP APIs

Experience in file handling (SFTP/SSH) Mandatory Supporting Skills Understanding of ETL concepts and data warehousing basics

Ability to write and optimize SQL queries (basic to intermediate level)

Hands-on experience in: Developing and supporting DataStage jobs Exposure to: Python scripting (basic usage)

Power BI data support concepts (data preparation level) Basic understanding of: Tomcat server (monitoring/support level)

Java/Spring Boot (awareness) Valuable to Have Skills Exposure to: SSL/TLS concepts Familiarity with tools: ServiceNow (ticket handling)

Confluence (documentation)

Splunk (log monitoring basics)



Awareness of change management processes Type of Work Allocation ETL & PL/SQL Development: 80-85%

Production Support & Minor Admin Tasks: 15-20% Key Responsibilities Develop and support ETL jobs using IBM DataStage

Write and maintain SQL and PL/SQL scripts (procedures, functions)

Assist in building and maintaining data integration pipelines

Perform basic SQL query optimization and debugging

Monitor scheduled jobs and handle failures (AutoSys or similar)

Support secure file transfers using SFTP/SSH

Assist in API-based data integration (REST/SOAP)

Work with reporting teams (Power BI) for data readiness

Provide L1/L2 production support for ETL pipelines

Troubleshoot data issues and ETL job failures

Follow data governance, security, and release processes

Assist senior developers in enhancements and system improvements Required Experience 4-6 years of overall IT experience

At least 3+ years of hands-on ETL (DataStage) and Oracle PL/SQL experience

Experience in basic production support and data pipeline development

Exposure to data warehouse environments Preferred Qualifications Bachelor's degree in Computer Science / IT / related field

Basic certifications in DataStage or Oracle (optional) Soft Skills Good analytical and debugging skills

Strong willingness to learn and grow

Ability to work in a team environment

Effective communication with peers and leads

Ability to follow processes and deliver quality work

📌 Analyst (Bengaluru)
🏢 Mphasis
📍 Bengaluru