Oracle Data Integrator (ODI) Specialist- Sr consultant

As an ODI developer you will have multiple responsibilities depending on project type. One type of project may involve migrating existing ETL to Oracle cloud infrastructure. Another type of project might involve building ETL solution on both on-premises and Oracle Cloud.
The key responsibilities may involve some or all the areas listed below:Engage with clients toConduct workshops, understand business requirements and identify business problems to solve with integrations.Lead and build Proof-of-concept to showcase value of ODI vs other platformssocialize solution design and enable knowledge transferdrive train-the trainer sessions to drive adoption of ODIpartner with clients to drive outcome and deliver valueCollaborate with cross functional teams tounderstand source applications and how it can be integratedanalyze data sets to understand functional and business contextcreate Data Warehousing data model and integration designunderstand cross functional process such as Record to Report (RTR), Procure to Pay (PTP), Order to Cash (OTC), Acquire to Retire (ATR), Project to Complete (PTC)communicate development status and risks to key stakeholdersLead the team to design, build, test and deploySupport client needs by delivering ODI jobs and frameworksMerge, Customize and Deploy ODI data model as per client business requirementsDeliver large/medium DWH programs, demonstrate expert core consulting skills and advanced level of ODI, SQL, PL/SQL knowledge and industry expertise to support delivery to clientsFocus on designing, building, and documenting re-usable code artifactsTrack, report and optimize ODI jobs performance to meet client SLADesigning and architecting ODI projects including upgrade/migrations to cloudDesign and implement security in ODIIdentify risks and suggest mitigation planAbility to lead the team and mentor junior practitionersProduce high-quality code resulting from knowledge of the tool, code peer review, and automated unit test scriptsPerform system analysis, follow technical design and work on development activitiesParticipate in design meetings, daily standups, backlog groomingLead respective tracks in Scrum team meetings, including all Agile and Scrum related activitiesReviews and evaluates designs and project activities for compliance with systems design and development guidelines and standards; provides tangible feedback to improve product quality and mitigate failure risk.Develop environment strategy, Build the environment & execute migration plansValidate the environment to meets all security and compliance controlsLead the testing efforts during SIT and UAT by coordinating with functional teams and all stakeholdersContribute to sales pursuits by helping the pursuit team to understand the client request and propose robust solutionsIdeally, you should also haveExpertise in database development (SQL/ PLSQL) for PL/SQL based applications.Experience in designing and developing Oracle object such as Tables, Views, Indexes, Partitions, Stored Procedures Functions in PL/SQL, Packages, Materialized Views and Analytical functionsWorking knowledge of GIT or similar source code control systemExperience of creating PL/SQL packages, procedures, Functions, Triggers, views, and exception handling for retrieving, manipulating, checking and migrating complex datasets in oracleExperience in SQL tuning and optimization using explain plan and SQL trace filesPartitioning and Indexing strategy for optimal performanceGood verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.Experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High- and Low-level design documents.

6+ years ETL Lead / developer experience and a minimum of 3-4 Years experience in Oracle Data Integrator (ODI)

Expertise in the Oracle ODI toolset and Oracle PL/SQL, ODI

Minimum 2-3 end to end DWH Implementation experience.

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.

knowledge of ODI Master and work repository

Knowledge of data modelling and ETL design

Design and develop complex mappings, Process Flows and ETL scripts

Must be well versed and hands-on in using and customizing Knowledge Modules (KM)

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 in Data Migration using SQL loader, import/export

Consulting Requirements

6-10 years of relevant consulting, industry or technology experience

Proven experience assessing clients workloads and technology landscape for Cloud suitability

Experience in defining new architectures and ability to drive project from architecture standpoint

Ability to quickly establish credibility and trustworthiness with key stakeholders in client organization.

Strong problem solving and troubleshooting skills

Strong communicator

Willingness to travel in case of project requirement

Preferred

Experience in Oracle BI Apps

Exposure to one or more of the following: Python, R or UNIX shell scripting.

Location: Mumbai/ Hyderabad/ Bangalore/ Delhi/ Pune/ Kolkata/ Chennai