ETL Development: Design, develop, test, and deploy ETL processes using ETL tools (ODI) to extract, transform, and load data into various data warehouses and systems.
PL/SQL Development: Write complex PL/SQL queries to extract, manipulate, and analyze data from relational databases (e.g., Oracle, SQL Server).
Data Modeling: Develop and maintain data models, data dictionaries, and data mappings to ensure data consistency and integrity.
Data Quality: Identify and resolve data quality issues, ensuring data accuracy, completeness, and consistency.
Collaboration: Work closely with business stakeholders, data analysts, and data scientists to gather requirements, design solutions, and implement data integration projects.
Testing and Deployment: Test ETL processes and PL/SQL queries to ensure data integrity and deploy changes to production environments.
Performance Optimization: Optimize ETL processes and PL/SQL queries to improve performance, scalability, and reliability.
Documentation: Maintain accurate and up-to-date documentation of ETL processes, PL/SQL queries, and data models.
