Sr Oracle PL/SQL Developer

IQVIA; Bengaluru; Presencial; INR 3.200.000 - 5.200.000; Jornada completa

Descripción de la vacante

IQVIA Bengaluru is seeking an experienced Oracle PL/SQL Developer to design, develop, and maintain ETL processes, build data warehouses, and implement scalable data pipelines for large datasets.

You will optimize queries, enforce data quality, model star and snowflake schemas, automate loads with Airflow or schedulers, review code, and collaborate with analysts, QA, and stakeholders to ensure production stability.

Formación

• 6-10+ years of experience in Oracle development and ETL projects.
• Hands-on experience with enterprise-scale data warehouses.
• Proficient in Oracle PL/SQL and SQL.
• Experience integrating data from multiple sources.
• Knowledge of star/snowflake schema and data modeling.
• Unix/Linux scripting experience.
• Version control with Git.
• Scheduling tools such as Airflow, Control-M or Autosys.

Responsabilidades

• Design, develop, and maintain ETL processes using Oracle PL/SQL packages, procedures, 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.

Conocimientos

Advanced SQL

Oracle PL/SQL

Data warehousing concepts

Performance tuning

Data modeling (Star/Snowflake)

Git

Airflow scheduling

Unix/Linux scripting

Python/Gen AI for automation

Herramientas

Airflow

Git

Control-M/Autosys

Unix/Linux scripting

Descripción del empleo

• 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
• 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.

• 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.