Birlasoft
Location
Pune | India
Job description
ODI Hands on with end to end DWH Implementation experience using ODI. Should have experience in developing ETL processes - ETL control tables, error logging, auditing, data quality, etc. Should be able to implement reusability, parameterization, workflow design, etc. Expertise in the Oracle ODI toolset and Oracle PL/ SQL knowledge of ODI Master and work repository Knowledge of data modelling and ETL design Setting up topology, building objects in Designer Monitoring Operator, different type of KMs, Agents etc Packaging components, database operations like Aggregate pivot, union etc. Using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects Design and develop complex mappings, Process Flows and ETL scripts Must be well versed and hands-on in using and customizing Knowledge Modules (KM) Experience of performance tuning of mappings Ability to design ETL unit test cases and debug ETL Mappings Expertise in developing Load Plans, Scheduling Jobs Integrate ODI with multiple Source / Target Experience on Error recycling / management using ODI,PL/SQL Expertise in database development (SQL/PLSQL) for PL/SQL based applications. Experience in Data Migration using import/ export. SOA12c Collaborate with senior team members to design, develop, and maintain Oracle SOA Suite components and integrations. Assist in troubleshooting and resolving issues related to SOA applications. Work on designing and implementing integration solutions, ensuring they meet business requirements and adhere to best practices. Solid understanding of Oracle SOA Suite and its components. Knowledge of XML, XSLT, and Web Services standards. Familiarity with Oracle Fusion Middleware and related technologies. Basic understanding of database concepts, SQL, and PL/SQL. Strong analytical and problem-solving skills. Excellent communication and interpersonal skills. Ability to work collaboratively in a team environment
Job tags
Salary
