Senior PL/SQL & ETL Developer

About the role

We are hiring a Senior PL/SQL & ETL Developer to design, build and tune high-volume Oracle data pipelines. You will own complex PL/SQL code, ETL workflows and data warehouse structures that feed business-critical and regulatory reports. The role suits a hands-on engineer who writes performant, well-tested database code and can diagnose production issues end to end.

What you'll do

• Design, develop and maintain PL/SQL packages, stored procedures, functions and triggers for transactional and analytical workloads
• Build and enhance ETL workflows in Informatica PowerCenter, Talend or Oracle Data Integrator (ODI) to extract, transform and load data from multiple source systems
• Design multi-tier staging layers (landing, staging, curated) with robust data validation, reconciliation and reject-handling rules
• Implement dimensional models (star and snowflake schemas) and Slowly Changing Dimensions (Type 1, 2 and 3)
• Load bulk and file-based data using SQL*Loader, External Tables and Oracle Data Pump (expdp/impdp)

What you need

• 6–11 yrs of experience
• SQL
• ETL
• Data warehousing
• Informatica
• Snowflake
• Linux
• MCA or B.Tech or B.E. or M.Sc or B.Sc or BCA or M.Tech

Good to have

• Python
• AWS
• Oracle Database
• CI/CD
• Jenkins
• Azure