Job Summary:

We are seeking a skilled PLSQL Developer with strong 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

- Strong 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)
🏢 Relevantz Technology Services
📍 Pune