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
Valuable 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)
Good 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 r
📌 Analyst (Bengaluru)
🏢 Mphasis
📍 Bengaluru
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.