Required Skills: PL/SQL development, including writing stored procedures, functions, and triggers, ETL processes using tools like Informatica, Oracle Data Integrator (ODI), Talend,Data Warehouse design and architecture. Solid understanding of data modeling, dimensional modeling, and star schema design.

Job Description

• Design, develop, and optimize PL/SQL code to support data integration, transformation, and loading processes within an ETL framework.
• Develop and implement ETL pipelines for extracting data from multiple sources, transforming it into the required formats, and loading it into Data Warehouses.
• Work closely with the Data Warehouse team to ensure efficient data modeling, query optimization, and data integrity.
• Develop complex SQL queries and stored procedures to extract, manipulate, and load data into the Data Warehouse.
• Collaborate with stakeholders to understand data requirements and translate business logic into technical solutions.
• Ensure high performance and scalability of the ETL processes by optimizing PL/SQL scripts and query execution.
• Troubleshoot and resolve issues related to data integration, performance, and data quality.
• Perform data validation and reconciliation between source and target systems.
• Participate in code reviews, design sessions, and project planning to ensure best practices and standards are followed.
• Continuously monitor and improve the ETL and data pipeline processes for better efficiency and reliability.