Oracle PL/SQL Developer+Azure Data Engineer _ Exp: 10+ Years

Atyeti Inc; Pune District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Atyeti Inc in Pune, India seeks an experienced Data Integration Engineer to design, implement, and optimize Oracle PL/SQL routines and end-to-end ETL pipelines on Azure. You will work with Azure Data Factory, ADLS, and Azure data platforms, perform on-prem to cloud migrations, tune SQL performance, and collaborate with developers, data architects, and business teams to ensure data quality and governance.

The role emphasizes robust monitoring, logging, error handling, and adherence to security

Qualifications

• Strong experience in Oracle SQL and PL/SQL development.
• Hands-on experience with Azure Data Factory (ADF).
• Experience with Azure Data Lake Storage (ADLS).
• Strong understanding of ETL/ELT concepts and data integration.
• Experience in database performance tuning and optimization.
• Experience with Oracle-to-Azure data migration.
• Good understanding of data warehousing concepts.
• Strong analytical and problem-solving skills.

Responsibilities

• Develop and maintain Oracle PL/SQL procedures, functions, packages, triggers, and SQL queries.
• Design and develop ETL/data integration pipelines using Azure services.
• Work with Azure Data Factory (ADF) for data ingestion, transformation, and orchestration.
• Perform data migration from on-premises Oracle databases to Azure.
• Work with ADLS and Azure-based data platforms.
• Optimize SQL queries, stored procedures, and database performance.
• Develop data models and implement data transformation processes.
• Perform data validation, reconciliation, and troubleshooting.
• Collaborate with application developers, data architects, and business teams.
• Implement monitoring, logging, and error-handling mechanisms for data pipelines.
• Follow best practices for data security, governance, and quality.

Skills

Oracle SQL & PL/SQL

Azure Data Factory (ADF)

Azure Data Lake Storage (ADLS)

ETL/ELT data integration

SQL performance tuning

Oracle to Azure migration

Data warehousing concepts

Analytical & problem solving

Tools

Azure Synapse Analytics

Databricks / PySpark

Azure DevOps

Python

Job description

• Develop and maintain complex Oracle PL/SQL procedures, functions, packages, triggers, and SQL queries.
• Design and develop ETL/data integration pipelines using Azure services.
• Work with Azure Data Factory (ADF) for data ingestion, transformation, and orchestration.
• Perform data migration from on-premises Oracle databases to Azure.
• Work with Azure Data Lake Storage (ADLS) and Azure-based data platforms.
• Optimize SQL queries, stored procedures, and database performance.
• Develop data models and implement data transformation processes.
• Perform data validation, reconciliation, and troubleshooting.
• Collaborate with application developers, data architects, and business teams.
• Implement monitoring, logging, and error-handling mechanisms for data pipelines.
• Follow best practices for data security, governance, and quality.

Required Skills

• Strong experience in Oracle SQL and PL/SQL development.
• Hands‑on experience with Azure Data Factory (ADF).
• Experience with Azure Data Lake Storage (ADLS).
• Strong understanding of ETL/ELT concepts and data integration.
• Experience in database performance tuning and optimization.
• Experience with Oracle-to-Azure data migration.
• Good understanding of data warehousing concepts.
• Strong analytical and problem‑solving skills.

Good to Have

• Experience with Azure Synapse Analytics.
• Knowledge of Databricks / PySpark.
• Experience with Azure DevOps and CI/CD.
• Knowledge of Python.
• Understanding of cloud security and data governance.