Oracle Data Integrator

Total Exp:3-5 years
Work Mode : Onsite
Location:Hyderabad/Bangalore/Kolkata/Mumbai
Job Type:Contract

Job Description

Roles and responsibilities: 

  • Experience between 3-5 years in Oracle Data Integrator (ODI)
  • 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 of Load Plan.
  • Implemented odi Send E-mail to the concern team on mappings execution success / failure.
  • Knowledge of 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 Star schema and Snowflake schema.
  • Knowledge of Fact, dimensional tables, slowly changing dimensions.

Skills: Experience in SQL in creating DDL and DML commands.

Got any queries still? Contact us  

Email ID: engage@heptarc.com
Contact: 8971100504

Job Category: Oracle Data Integrator
Job Type: Contract
Job Location: Bangalore Hyderabad Kolkata Mumbai

Apply for this position

Allowed Type(s): .pdf, .doc, .docx
× How can I help you?