Sr Oracle PL SQL Developer

IQVIA; Bengaluru; On-site; INR 350,000 - 550,000; Full time

Job summary

IQVIA in Bengaluru, Karnataka, seeks an experienced Oracle PL/SQL Developer to design, implement, and maintain ETL processes for data warehouse environments. You will work on large datasets, optimize queries, ensure data quality, and document architectures end-to-end.

Essentials include 6–10+ years of Oracle development and ETL experience, strong SQL, Unix/Linux scripting, and familiarity with ETL tools and schedulers like Airflow or Control-M.

Qualifications

• 6-10+ years of experience in Oracle development and ETL projects.
• Hands-on experience with enterprise-scale data warehouse implementations.
• Experience integrating data from multiple source systems and performing complex transformations.

Responsibilities

• Design, develop, and maintain ETL processes using Oracle PL/SQL packages, procedures, functions, and scripts.
• Build and support data warehouse and data mart solutions.
• Analyze source systems and create data mapping and transformation logic.
• Develop and optimize complex SQL queries for large datasets.
• Perform data quality validation, reconciliation, and troubleshooting.
• Design dimensional models, fact tables, and reporting structures.
• Automate data loads and scheduling workflows using tools such as Airflow or enterprise schedulers.
• Conduct code reviews and enforce development standards.
• Collaborate with business analysts, architects, QA teams, and stakeholders.
• Provide production support and resolve ETL performance issues.
• Create technical documentation, deployment guides, and support procedures.

Skills

Oracle PL/SQL

Advanced SQL

ETL & DW concepts

Performance tuning

Data modeling

Unix/Linux scripting

Git version control

Airflow

Data quality validation

Cross-functional collaboration

Tools

Git

Airflow

Control-M

Autosys

Job description

Job Description:

• Oracle PL/SQL Developer (G140):
  • Design, develop, and maintain ETL processes using Oracle PL/SQL packages, procedures, functions, and scripts.
  • Build and support data warehouse and data mart solutions.
  • Analyze source systems and create data mapping and transformation logic.
  • Develop and optimize complex SQL queries for large datasets.
  • Perform data quality validation, reconciliation, and troubleshooting.
  • Design dimensional models, fact tables, and reporting structures.
  • Automate data loads and scheduling workflows using tools such as Airflow or enterprise schedulers.
  • Conduct code reviews and enforce development standards.
  • Collaborate with business analysts, architects, QA teams, and stakeholders.
  • Provide production support and resolve ETL performance issues.
  • Create technical documentation, deployment guides, and support procedures.

  • Technical Skills

    • Oracle Database (11g/12c/19c/23AI or later)
    • Advanced SQL and Oracle PL/SQL
    • ETL and Data Warehousing concepts
    • Performance tuning and query optimization
    • Data modeling (Star Schema, Snowflake Schema)
    • Oracle packages, triggers, views, and stored procedures
    • Unix/Linux scripting
    • Data quality and data validation techniques
    • Version control tools such as Git
    • Scheduling tools such as Airflow, Control-M, Autosys, or equivalent

  • Preferred Skills

    • Oracle AI/Oracle 23AI or 26AI capabilities
    • Python/Gen AI for automation

  • Experience

    • 6-10+ years of experience in Oracle development and ETL projects.
    • Hands-on experience with enterprise-scale data warehouse implementations.
    • Experience integrating data from multiple source systems and performing complex transformations.

IQVIA is a leading global provider of clinical research services, commercial insights and healthcare intelligence to the life sciences and healthcare industries. We create intelligent connections to accelerate the development and commercialization of innovative medical treatments to help improve patient outcomes and population health worldwide. Learn more at https://jobs.iqvia.com

IQVIA is committed to integrity in our hiring process and maintains a zero tolerance policy for candidate fraud. All information and credentials submitted in your application must be truthful and complete. Any false statements, misrepresentations, or material omissions during the recruitment process will result in immediate disqualification of your application, or termination of employment if discovered later, in accordance with applicable law. We appreciate your honesty and professionalism.