Oracle PLSQL Developer

Alike Thoughts; Hyderabad, Chennai District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Alike Thoughts is seeking a Specialist with 6+ years of experience in Oracle ETL and scripting to design, develop and optimize data integration pipelines. The role focuses on building robust ETL workflows, writing efficient Oracle SQL and PL/SQL scripts, and ensuring data quality across processes.

You will collaborate with cross-functional teams, monitor ETL workloads for reliability, and stay updated with Oracle ETL tools to improve development efficiency.

Qualifications

• 6+ years of experience in Oracle ETL and scripting.
• Experience designing and maintaining robust data integration pipelines.
• Ability to optimize Oracle SQL and PL/SQL code for performance.
• Knowledge of data validation and quality assurance across ETL processes.

Responsibilities

• Design, develop and optimize ETL workflows using Oracle ETL tools and scripting languages.
• Implement error handling, logging and monitoring mechanisms to maintain pipeline robustness.
• Tune SQL queries and PL/SQL code for optimal performance on Oracle databases.
• Automate repetitive tasks and data processing using scripting.
• Collaborate with data engineers, analysts and stakeholders to translate business requirements into technical solutions.
• Participate in code reviews, testing and deployment activities following SDLC practices.
• Mentor junior team members and contribute to knowledge sharing within the Oracle ETL cluster.

Skills

Oracle ETL

SQL

PL/SQL

Data Integration

Data Quality

Scripting

ETL Tools

Pipeline Monitoring

Tools

Oracle SQL

PL/SQL

Job description

Role Summary:

We are seeking a Specialist with 6+ years of experience in Oracle ETL and scripting to design develop and optimize data integration pipelines

Job Description:

Develop and maintain robust Oracle ETL pipelines to ingest transform and load data from various sources Write efficient Oracle SQL and PLSQL scripts to support data processing and automation tasks Perform data validation and ensure data quality and integrity across ETL processes Collaborate with cross functional teams to understand data requirements and deliver scalable solutions Monitor and troubleshoot ETL workflows to ensure pipeline reliability and performance Document ETL processes data mappings and technical specifications Stay updated with the latest Oracle ETL tools and scripting techniques to improve development efficiency

Roles and Responsibilities

Design develop and optimize ETL workflows using Oracle ETL tools and scripting languages Implement error handling logging and ing mechanisms to maintain pipeline robustness Tune SQL queries and PLSQL code for optimal performance on Oracle databases Automate repetitive tasks and data processing using scripting Collaborate with data engineers analysts and stakeholders to translate business requirements into technical solutions Participate in code reviews testing and deployment activities following best practices and SDLC methodologies Mentor junior team members and contribute to knowledge sharing within the Oracle ETL skill cluster