Job Title: Senior Consultant | Technical (ETL -ODI), Technical (PL/SQL),Technical (OBIEE) | Bengaluru | Oracle
Designing and Developing Data Integration Workflows:
Designing data integration workflows using ODI, including defining data sources, targets, transformations, and mappings.
Implementing and Configuring ODI:
Implementing ODI solutions in the cloud environment, configuring connections, and managing user access.
Data Transformation and Cleaning:
Performing data transformations and cleaning processes to ensure data quality and consistency, using ODI's transformation capabilities.
Performance Tuning and Optimization:
Optimizing ODI workflows for performance and scalability, addressing bottlenecks and ensuring efficient data movement.
Metadata Management:
Managing ODI metadata, including data lineage and documentation.
Troubleshooting and Problem Solving:
Troubleshooting and resolving issues related to data integration processes, including error handling and debugging.
Experience with Cloud Technologies:
Familiarity with cloud-based data integration platforms, such as Oracle Cloud Infrastructure (OCI), and cloud-specific technologies.
Strong SQL Skills:
Proficiency in SQL and database technologies, including querying, updating, and manipulating data.
Knowledge of Data Integration Concepts:
Understanding of data integration concepts, such as ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform), and best practices.