Data Engineer – Oracle PL/SQL & ETL

LetzBizz; Chennai District; On-site; INR 2,070,000 - 2,530,000; Full time

Job summary

LetzBizz is seeking an experienced Data Engineer with Oracle PL/SQL and ETL expertise to design, develop, optimize, and maintain enterprise-scale data solutions in Chennai or Pune.

You will work with cross-functional teams to deliver scalable data pipelines, perform data modeling, and ensure data quality, governance, and security across BI and analytics initiatives.

8+ years of experience required; 5 days working from office. Immediate joiners preferred.

Qualifications

• 8+ years of experience in Data Engineering and database development.
• Strong hands-on Oracle PL/SQL development experience.
• Proven ETL design and implementation on large-scale enterprise platforms.

Responsibilities

• Design, develop, and maintain Oracle PL/SQL objects including: Stored Procedures, Functions, Packages, Triggers, Cursors, Collections, Materialized Views.
• Develop and support robust ETL pipelines for data extraction, transformation, and loading from multiple source systems.
• Data modeling activities including: Logical Data Modeling, Physical Data Modeling, Database Normalization, Dimensional Modeling.
• Optimize SQL and PL/SQL code for performance, scalability, and maintainability.
• Design and implement data validation, reconciliation, and error-handling frameworks.
• Analyze business requirements and translate them into technical data solutions.
• Troubleshoot production data issues and provide root-cause analysis.
• Develop batch processing solutions and automate data workflows.
• Work closely with Business Analysts, Architects, Application Teams, and Data Analysts.
• Ensure data quality, governance, security, and compliance standards are met.
• Participate in code reviews, design discussions, and CI/CD deployment activities.

Skills

Oracle PL/SQL

ETL Pipelines

Data Warehousing

Unix/Linux scripting

Python

Tools

Informatica PowerCenter

Apache Airflow

PySpark

Hadoop Ecosystem

AWS Data Services

Snowflake

Git

Job description

Position Details

Position: Data Engineer (PLSQL with ETL)

Experience: 8+ yrs

Location Option

• Thoraipakkam, Chennai (Chennai One IT Park)
• Pune (Kharadi – Client Office)

Work Mode: WFO All 5 days

Budget: 23 LPA Max.

Notice Period: Immediate joiners are preferred (max 1 week’s notice period)

Levels of Interview

• Technical Interview – Virtual
• Client Technical – Virtual
• HR Interview – Virtual

Job Details

Job Title: Data Engineer (PLSQL, Oracle, ETL & Python)

Location: Chennai / Pune

Experience: 8+ years

Location: Chennai / Pune – Client Office

Job Title: Data Engineer – Oracle PL/SQL & ETL

Experience: 8+ Years

Location: Chennai || Pune

Employment Type: Full-Time

Job Summary

We are seeking an experienced Data Engineer with strong expertise in Oracle PL/SQL Development and ETL processes to design, develop, optimize, and maintain enterprise-scale data solutions.

The ideal candidate will have extensive experience in database development, data modeling, ETL pipeline development, performance tuning, and data integration across multiple source systems.

The candidate should be capable of working with cross-functional teams to deliver scalable, high-performance data solutions that support business intelligence, analytics, and operational applications.

Key Responsibilities

• Design, develop, and maintain complex Oracle PL/SQL objects including:
  • Stored Procedures
  • Functions
  • Packages
  • Triggers
  • Cursors
  • Collections
  • Materialized Views
• Develop and support robust ETL pipelines for data extraction, transformation, and loading from multiple source systems.
• Perform data modeling activities including:
  • Logical Data Modeling
  • Physical Data Modeling
  • Database Normalization
  • Dimensional Modeling
• Optimize SQL and PL/SQL code for performance, scalability, and maintainability.
• Design and implement data validation, reconciliation, and error-handling frameworks.
• Analyze business requirements and translate them into technical data solutions.
• Troubleshoot production data issues and provide root-cause analysis.
• Develop batch processing solutions and automate data workflows.
• Work closely with Business Analysts, Architects, Application Teams, and Data Analysts.
• Ensure data quality, governance, security, and compliance standards are met.
• Participate in code reviews, design discussions, and CI/CD deployment activities.

Required Technical Skills

Oracle Database

• Oracle 11g/12c/19c or above
• Advanced SQL & PL/SQL Programming
• Query Optimization
• Performance Tuning
• Explain Plans
• Indexing Strategies
• Partitioning
• Materialized Views
• Oracle Scheduler

ETL Technologies

• Strong understanding of ETL/ELT concepts
• Experience in large-scale data migration and transformation
• Data Cleansing & Data Quality Validation
• Batch Processing & Workflow Automation

Data Engineering

• Data Warehousing Concepts
• Star Schema & Snowflake Schema
• Fact & Dimension Modeling
• Data Lake & Data Integration Concepts

Scripting

• Unix/Linux Shell Scripting
• Python (Preferred)

Preferred Skills

• Informatica PowerCenter / Informatica Cloud
• Apache Airflow
• PySpark
• Hadoop Ecosystem
• AWS Data Services (S3, Glue, Redshift)
• Azure Data Factory
• Snowflake
• CI/CD & DevOps Practices
• Git Version Control

Required Experience

• 8+ years of experience in Data Engineering and Database Development.
• Strong hands-on experience in Oracle PL/SQL development.
• Proven experience in ETL design and implementation.
• Experience working with large-scale enterprise data platforms.
• Experience in performance tuning and optimization of database objects.
• Experience supporting production environments and handling critical incidents.

Soft Skills

• Strong analytical and problem-solving abilities.
• Excellent communication and stakeholder management skills.
• Ability to work independently and in Agile environments.
• Strong documentation and technical design skills.
• Ability to mentor junior developers and lead technical discussions.

Nice to Have

• Banking / Financial Services domain experience
• Healthcare domain experience
• Cloud Migration projects
• Oracle to Cloud Data Migration initiatives
• Certification in Oracle, Cloud, or Data Engineering technologies