Job Summary:

We are seeking a skilled PLSQL Developer with solid experience in ETL development, Data Warehousing, and database performance optimization. The ideal candidate will be responsible for designing, developing, and maintaining robust data pipelines, stored procedures, ETL processes, and database solutions that support business intelligence and analytics initiatives.

Key Responsibilities
Design, develop, test, and maintain Oracle PL/SQL packages, procedures, functions, triggers, and views.
Develop and support ETL workflows for extracting, transforming, and loading data from multiple source systems.
Create and optimize SQL queries for large-scale data processing and reporting.
Design and implement Data Warehouse solutions, including fact and dimension models.
Perform data analysis, data profiling, data validation, and reconciliation activities.
Troubleshoot and resolve database performance issues through query tuning and indexing strategies.
Work closely with business analysts, data architects, and application teams to understand data requirements.




Develop and maintain technical documentation for ETL processes, database objects, and data flows.
Ensure data quality, integrity, security, and compliance across data platforms.
Support production deployments and provide ongoing maintenance for ETL and database solutions.

Required Skills

Technical Skills
Robust experience in Oracle Database and PL/SQL Development.
Expertise in writing complex SQL queries, stored procedures, functions, packages, cursors, and triggers.
Hands-on experience with ETL Tools such as:
Informatica PowerCenter
ODI (Oracle Data Integrator)
SSIS
Talend
DataStage (any relevant ETL tool)
Solid understanding of Data Warehousing concepts:
Star Schema
Snowflake Schema
Fact & Dimension Modeling
Slowly Changing Dimensions (SCD)
Experience in performance tuning and query optimization.
Knowledge of data migration and data integration techniques.
Hands-on experience with Unix/Linux shell scripting.
Familiarity with version control tools such as Git.

📌 Excellent Opportunity For Oracle Plsql Relevantz Pune (India)
🏢 Relevantz Technology Services
📍 India