Job Role:
Seeking a seasoned ODI developer who Designs, develops, and maintains ETL/data integration solutions using Oracle Data Integrator (ODI) to enable efficient data flow for analytics and business intelligence
Your responsibilities:
Exposure to OLAP, OLTP, Data Warehouse, Data Marts development, data stores to facilitate data analytics and insights.
Should have experience in developing Fact and Dimension tables using ODI. Explicit working knowledge on SCD types.
Ability to design and develop Mappings, Reusable mappings, Packages, Procedures, Load plans, User functions, Variables and Sequences in ODI 12c.
Configure Physical and Logical topologies as per requirement for all the technologies and experience on Context creation and mapping.
Knowledge on ODI master and work repositories and experience on ETL control tables, error logging, auditing, data quality.
Build data integration and transformation routines from source systems to target stores using ODI 12C. Experience on Batch/Real-time integrations using ODI.
Must be well versed and hands-on in using and customizing knowledge modules (KM). Monitoring Operator and exposure on Agents.
Strong SQL/PL SQL expertise and Oracle Golden Gate exposure would be advantage. Oracle and SQL server database experience.
Experience in high data volume environments. Strong Database experience working on understanding cost of queries/optimization of queries.
Essential skills/knowledge/experience:
Oracle Data Integrator
Proficient to analyse, design, build, test and implement enhancements to existing systems and/or new applications.
Experience with SQL and SQL Scripting.
Understanding technical specifications for ETL.
Ability to work in an agile environment with the ability to pick and learn new data tools very quickly.
Ability to effectively prioritise and execute tasks in a fast-paced environment.
Desirable skills/knowledge/experience:
Strong analytic and problem resolution skills
Excellent communication.
