Birlasoft
Location
Bangalore | India
Job description
Role Summary: We're seeking a skilled professional with over 10 years of experience in developing, enhancing, tuning, and supporting ETL/ELT and data integration solutions using Oracle Data Integrator (ODI). The ideal candidate will have expertise in the Oracle ODI toolset, Oracle PL/SQL, and data warehouse concepts.
Experience Required: 8+ years of experience in developing, enhancing, tuning, and supporting ETL/ELT and data integration solutions using Oracle Data Integrator (ODI). Expertise in the Oracle ODI toolset and Oracle PL/SQL. Strong understanding of data warehouse concepts, DBMS, dimensional warehouse, scripting, reporting tools, and Oracle SQL tuning. Experience with XML/SOAP-based web services and REST API integrations using ODI-based KMs. Hands-on experience with ODI mappings, error handling, automation using ODI, load plans, and migration of objects. Roles and Responsibilities: Develop, enhance, tune, and support ETL/ELT and data integration solutions using Oracle Data Integrator (ODI). Utilize Oracle ODI toolset and Oracle PL/SQL for efficient solution development. Manage ODI master and work repository, ensuring data structure and database concepts are well understood and applied. Interpret conceptual, logical, and physical ER modeling and dimensional data modeling to design effective data solutions. Implement XML/SOAP-based web services and REST API integrations using ODI-based KMs. Design and implement ETL/ELT architecture designs, leveraging SQL analytical skills for optimal performance. Utilize ODI mappings, error handling, automation, load plans, and object migration for seamless solution deployment. Develop load plans, schedule jobs, and effectively communicate technical concepts to stakeholders.Job tags
Salary
