27 Oct
|
TRIGENT SOFTWARE PRIVATE
|
Bengaluru
27 Oct
TRIGENT SOFTWARE PRIVATE
Bengaluru
Locations: Bangalore, Hyderabad, Chennai, Pune
Experience : 6+ Years
Primary Skills : PL/SQL, ETL, SQL, Stored Procedures, Performance Tuning
Secondary Skills: Unix Shell Scripting, SQL*Loader, Autosys / Control-M
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.
📌 Oracle PL/SQL Developer_Bangalore /Hyderabad/Pune/Chennai_Hybrid (Bengaluru)
🏢 TRIGENT SOFTWARE PRIVATE
📍 Bengaluru