Job Description
Greetings from Advent global.
Excellent opportunity for Oracle Data Integrator (ODI) Bangalore.
Looking for the resource having very strong experience Oracle Data Integrator (ODI).
Exp-3-7yrs
NP-only 15 days
flexible for all shift
Location-PAN India willing to work in Bangalore after Pandemic.
JD
Worked as a ETL Developer on ODI 12c.
Knowledge on creation of master & work repositories and configured ODI connections
for source and target Systems in topology.
Experience in ODI designer, Topology, Operator and ODI Tools.
Worked with multiple sources such as Relational database, Flat files for Extraction,
Transforming and Loading data from source into target tables.
Developed packages, scenarios using Mappings and variables.
Debugging the jobs and packages by using operator navigator.
Monitoring the execution logs in operator and performance Tuning in ODI.
Experienced in Working with Scenarios and knowledge on Load Plans .
Implemented odiSend E mail to the concern team on mappings execution success /
failure.
Knowledge on all phases of project development, testing, deployment and support.
Good knowledge in creating File to DB and DB to DB related mappings.
Working knowledge of Knowledge Modules (LKM, IKM, JKM , CKM and RKM).
Used ODI commands like OdiFileMove, odiFileAppend,odiFilecopy and sqlunload etc.
Implemented SCD type1 and SCD type2.
Have knowledge about Changed Data Capture.
Involved in unit testing at various levels of ELT flows..
Knowledge in OLTP / OLAP System Study and like Star schema and Snowflake
schema.
Knowledge with Fact, dimensional tables, slowly changing dimensions.
Experience in SQL on creating DDL and DML commands.
Interested candidates can share the resume to the mentioned mail id.
Employement Category:
Employement Type: Full time
Industry: IT
Functional Area: IT
Role Category: Software Engineer
Role/Responsibilies: Excellent opportunity for Oracle Data Integrator (ODI) Bangalore.
Contact Details:
Company: Advent Global
Location(s): Hyderabad