Shift Timing : Rotational: 05:30 AM IST or 12:30 PM IST
Weekend Work : Rotational weekend shifts (Comp-off on weekdays)
Looking for an Oracle PL/SQL Developer with ETL exposure to develop, maintain, and support high-volume financial data pipelines and reporting systems.
Key Responsibilities:
- Develop and maintain PL/SQL packages, procedures, functions, triggers, and views.
- Manage ETL workflows, batch data movement, and bulk ingestion using SQL*Loader and Shell scripts.
- Tune and optimize complex queries using Explain Plan, indexing, partitioning,
and bulk processing (`BULK COLLECT` / `FORALL`).
- Monitor scheduled batch jobs, investigate errors, perform root-cause analysis (RCA), and support production runs.
- Support rotational shifts (05:30 AM / 12:30 PM IST) and rotational weekend schedules.
Requirements:
- 6+ years of solid experience in Oracle SQL and PL/SQL development.
- Hands-on ETL and high-volume batch data processing experience.
- Solid Unix/Linux shell scripting skills for task and job automation.
- Willingness to work onsite in rotational shifts and weekend rosters.