Senior Oracle Data Integrator (Full Time)
8 to 10 yrs (Experience)
Location : India, Delhi, Delhi
Skill Required: checking and migrating complex datasets in oracle Experience in SQL tuning and optimization using explain plan and SQL trace files Partitioning and Indexing strategy for optimal performance, manipulating,and exception handling for retrieving,Triggers, Functions,procedures, Materialized Views and Analytical functions. Experience of creating PL/SQL packages,Packages,Stored Procedures & Functions in PL/SQL,Partitions,Indexes,Views,design and coding Expertise in database development (SQL/ PLSQL) for PL/SQL based applications. Experience in designing and developing Oracle object such as Tables,Strong knowledge of ELT/ETL concepts,import/export,Scheduling Jobs Experience in Data Migration using SQL loader,Process Flows and ETL scripts Experience of performance tuning of mappings Ability to design ETL unit test cases and debug ETL Mappings Expertise in developing Load Plans,Migration of Objects Design and develop complex mappings,Load plans,automation using ODI,error handling,union etc. Using ODI mappings,database operations like Aggregate pivot,Packaging components,different type of KM?s,Monitoring Operator,building objects in Designer,Load Plans and ETL scripts Setting up topology,Process Flow,Webservices etc.) Must be well versed and hands-on in using and customizing Knowledge Modules (KM) Knowledge of data modelling and ETL design Design and develop complex mappings,etc. Integrate ODI with multiple Source / Target (through APIs,Workflow design,parameterization,etc. Should be able to implement reusability,Minimum of 8-10 Years? experience in Oracle Data Integrator (ODI-Development + Admin) and DWH concepts Minimum 4-6 end to end DWH Implementation experience. Should have experience in using Python/Jython codes in ODI. Auditing,Data quality
Job Description :
.Support client needs by delivering ODI jobs and frameworks
.Support client needs by delivering Various Integrations with third party application
.Merge, Customize and Deploy ODI data model as per client business requirements
.Experience working with clients throughout various parts of implementation lifecycle
.Proactive with Solution oriented mind-set, ready to learn new technologies for Client requirements.
.Deliver large/medium DWH programmer, demonstrate expert core consulting skills and
advanced level of ODI 12c knowledge and industry expertise to support delivery to clients