Consulting-AI & Data-ODI - - 303091

Artificial Intelligence & Engineering

AI & Engineering leverages cutting-edge engineering capabilities to help build, deploy, and operate integrated/verticalized sector solutions in software, data, AI, network, and hybrid cloud infrastructure. These solutions insights are powered by engineering for business advantage, helping transforming mission-critical operations.

Join our AI & Engineering team to help in transforming technology platforms, driving innovation, and helping help make a significant impact on our clients' success achievements. You’ll work alongside talented professionals reimagining and re-engineering operations and processes that are could be critical to businesses.

Position Summary

Level: Consultant

As an experienced Consultant at Deloitte Consulting, you will be responsible for individually delivering high quality work products within due timelines. Need-basis you will be mentoring and/or directing junior team members/liaising with onsite/offshore teams to understand the functional requirements.

Work you’ll do:

Apply industry knowledge to requirements gathering and analysis, ensuring alignment with sector needs. Demonstrate expertise across the entire software development lifecycle, from design and coding to deployment and defect resolution, collaborating with stakeholders for effective delivery. Conduct peer and team reviews to maintain quality standards. Actively engage in Agile practices, including sprint planning, retrospectives, and effort estimation. Build and share business process knowledge, supporting project knowledge management and team training. Proactively recommend process improvements, track efficiency gains, and contribute to automation and innovation, all aimed at enhancing project outcomes and delivering greater value to clients.

The team:

AI & Data offers a full spectrum of solutions for designing, developing, and operating cutting-edge Data and AI platforms, products, insights, and services. Our offering helps clients innovate, and enhance their data, AI, and analytics capabilities, ensuring they can mature and scale effectively.

AI & Data professionals will work with our clients to:

Design and modernize large-scale data and analytics platforms including data management, governance and the integration of structured and unstructured data to generate insights leveraging cloud, edge and AI/ML technologies, platforms and methodologies for storage, processing
Leverage automation, cognitive and AI based solutions to manage data, predict scenarios and prescribe actions
Drive operational efficiency by managing and upgrading their data ecosystems and application platforms, utilizing analytics expertise and providing As-a-Service models to ensure continuous insights and enhancements.

Qualifications

Must Have Skills/Project Experience/Certifications:

3-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 KM’s, 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
Expertise 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 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.

Good to Have Skills/Project Experience/Certifications:

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 object 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.

Education:

BE/B.Tech/M.C.A./M.Sc (CS) degree or equivalent from accredited university

Location:

Bengaluru/Hyderabad/Pune/Chennai/Kolkata

Our purpose

Deloitte’s purpose is to make an impact that matters for our people, clients, and communities. At Deloitte, purpose is synonymous with how we work every day. It defines who we are. Our purpose comes through in our work with clients that enables impact and value in their organizations, as well as through our own investments, commitments, and actions across areas that help drive positive outcomes for our communities.

Our people and culture

Our inclusive culture empowers our people to be who they are, contribute their unique perspectives, and make a difference individually and collectively. It enables us to leverage different ideas and perspectives, and bring more creativity and innovation to help solve our clients' most complex challenges. This makes Deloitte one of the most rewarding places to work.

Professional development

At Deloitte, professionals have the opportunity to work with some of the best and discover what works best for them. Here, we prioritize professional growth, offering diverse learning and networking opportunities to help accelerate careers and enhance leadership skills. Our state-of-the-art DU: The Leadership Center in India, located in Hyderabad, represents a tangible symbol of our commitment to the holistic growth and development of our people. Explore DU: The Leadership Center in India.

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 financially—and 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

From developing a stand out resume to putting your best foot forward in the interview, we want you to feel prepared and confident as you explore opportunities at Deloitte. Check out recruiting tips from Deloitte recruiters.