- Robust experience with ODI 12C, Oracle SQL/PLSQL, ETL/ELT pipeline creation, and data transformation
- Create and manage ETL jobs, perform data transformations, ensure data quality and consistency, support data replication across sources, collaborate with BAs and teams
Role Summary The Data Engineer (Migration) will be responsible for data transformation and orchestration activities, creating ETL/ELT pipelines from on-premises and cloud sources into Data Lakes and Enterprise Data Warehouses (EDW). The role requires working with structured, semi-structured, and unstructured data while ensuring data quality, consistency, and reliability.
Key Responsibilities
- Understand data models and database structures.
- Create ODI ETL jobs for data replication from source systems to EDW.
- Perform data transformations using ODI ETL and Oracle PL/SQL.
- Develop SQL queries, procedures, and functions for data extraction and processing.
- Deliver assigned tasks within agreed timelines.
- Ensure quality and accuracy of data delivery.
- Work with structured, semi-structured, and unstructured datasets.
- Support replication across multiple heterogeneous data sources.
- Ensure 100% data consistency and integrity.
Required Skills Experience****Technical Skills
- Strong experience with ODI 12C.
- Hands-on experience in Oracle SQL and PL/SQL.
- Experience in Data Transformation and Orchestration.
- Experience creating ETL/ELT pipelines and data integration workflows.
- Knowledge of AWS/Azure cloud environments is an advantage.
- Understanding of S3 Buckets, Azure Blob Storage, and cloud data structures.
- Experience working with multiple database platforms.
- Strong understanding of Dimensional Data Modeling (Facts Dimensions).
- Ability to ensure data quality, consistency, and governance.
Educational Qualification
- Any Graduate or higher qualification.
Key Interactions
- Collaborate with Business Analysts (BA) to understand business requirements.
- Coordinate with delivery and development teams for successful implementation.
📌 Data Engineer (Pune)
🏢 Honeybee Tech Solutions
📍 Pune
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.