AI & Data
In this age of disruption, organizations need to navigate the future with confidence, embracing decision making with clear, data-driven choices that deliver enterprise value in a dynamic business environment.
The AI & Data team leverages the power of data, analytics, robotics, science and cognitive technologies to uncover hidden relationships from vast troves of data, generate insights, and inform decision-making. The offering portfolio helps clients transform their business by architecting organizational intelligence programs and differentiated strategies to win in their chosen markets.
Oracle Data Integrator (ODI) Specialist
As an ODI Specialist, you will work with technical teams and projects to deliver ETL solutions on-premises and Oracle cloud platforms for some of our Fortune 1000 clients. You will have the opportunity to contribute to work that may involve building new ETL solutions, migrating an application to co-exist in the hybrid cloud (On-Premises and Cloud). Our teams have a diverse range of skills and we are always looking for new ways to innovate and help our clients succeed.
Work Youll Do
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 to conduct 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 platforms.
Socialize solution design and enable knowledge transfer.
Drive train-the trainer sessions to drive adoption of ODI.
Partner with clients to drive outcome and deliver value.
Collaborate with cross functional teams.
Understand source applications and how it can be integrated.
Analyze data sets to understand functional and business context.
Create Data Warehousing data model and integration design.
Understand 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 stakeholders.
Lead the team to design, build, test and deploy.
Support client needs by delivering ODI jobs and frameworks.
Merge, Customize and Deploy ODI data model as per client business requirements.
Deliver 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 clients.
Focus on designing, building, and documenting re-usable code artifacts.
Track, report and optimize ODI jobs performance to meet client SLA.
Designing and architecting ODI projects including upgrade/migrations to cloud.
Design and implement security in ODI.
Identify risks and suggest mitigation plan.
Ability to lead the team and mentor junior practitioners.
Produce high-quality code resulting from knowledge of the tool, code peer review, and automated unit test scripts.
Perform system analysis, follow technical design and work on development activities.
Participate in design meetings, daily standups, backlog grooming.
Lead respective tracks in Scrum team meetings, including all Agile and Scrum related activities.
Reviews 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 plans.
Validate the environment to meets all security and compliance controls.
Lead the testing efforts during SIT and UAT by coordinating with functional teams and all stakeholders.
Contribute to sales pursuits by helping the pursuit team to understand the client request and propose robust solutions.
Skills:
Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
Experience in designing and developing Oracle objects such as Tables, Views, Indexes, Partitions, Stored Procedures & Functions in PL/SQL, Packages, Materialized Views and Analytical functions
Working knowledge of GIT or similar source code control system
Experience of creating PL/SQL packages, procedures, Functions, Triggers, views, and exception handling for retrieving, manipulating, 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
Good 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.
Analytics & Cognitive
Our Analytics & Cognitive team focuses on enabling our clients end-to-end journey from On-Premises to Cloud, with opportunities in the areas of: Cloud Strategy, Op Model Transformation, Cloud Development, Cloud Integration & APIs, Cloud Migration, Cloud Infrastructure & Engineering, and Cloud Managed Services. We help our clients see the transformational capabilities of Cloud as an opportunity for business enablement and competitive advantage.
Analytics & Cognitive team supports our clients as they improve agility and resilience, and identifies opportunities to reduce IT operations spend through automation by enabling Cloud. We accelerate our clients towards a technology-driven future, leveraging vendor solutions and Deloitte-developed software products, tools, and accelerators.
Technical Requirements
Education: B.E./B.Tech/M.C.A./M.Sc (CS)
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.
Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
Experience in designing and developing Oracle objects such as Tables, Views, Indexes, Partitions, Stored
Procedures & Functions in PL/SQL, Packages, Materialized Views and Analytical functions
Working knowledge of GIT or similar source code control system
Experience of creating PL/SQL packages, procedures, Functions, Triggers, views, and exception handling for retrieving, manipulating, 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
Good 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
Systematic problem-solving approach, coupled with strong communication skills
Ability to debug and optimize code and automate routine tasks.
Experience writing scripts in one or more languages such as Python, UNIX Scripting and/or similar.
Experience working with technical customers.
How youll grow
At Deloitte, weve invested a great deal to create a rich environment in which our professionals can grow. We want all our people to develop in their own way, playing to their own strengths as they hone their leadership skills. And, as a part of our efforts, we provide our professionals with a variety of learning and networking opportunitiesincluding exposure to leaders, sponsors, coaches, and challenging assignmentsto help accelerate their careers along the way. No two people learn in the same way. So, we provide a range of resources including live classrooms, team-based learning, and eLearning. DU: The Leadership Center in India, our state-of-the-art, world-class learning Center in the Hyderabad offices is an extension of the Deloitte University (DU) in Westlake, Texas, and represents a tangible symbol of our commitment to our peoples growth and development.
Benefits
At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits.
Deloittes culture
Our positive and supportive culture encourages our people to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them to be healthy, centered, confident, and aware. We offer well-being programs and are continuously looking for new ways to maintain a culture that is inclusive, invites authenticity, leverages our diversity, and where our people excel and lead healthy, happy lives.
Corporate citizenship
Deloitte is led by a purpose: to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our people and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our community.
Our purpose
Our people and culture
Professional development
Benefits to help you thrive
At Deloitte, we know that great people make a great organization. Our comprehensive rewards program helps us deliver a distinctly Deloitte experience that helps that empowers our professionals to thrive mentally, physically, and financiallyand live their purpose. To support our professionals and their loved ones, we offer a broad range of benefits. Eligibility requirements may be based on role, tenure, type of employment and/ or other criteria. Learn more about what working at Deloitte can mean for you.
Recruiting tips