Oracle Data Integrator Developer

Cloudxtreme; Hyderabad; Hybrid; INR 1,200,000 - 2,000,000; Full time

Job summary

Cloudxtreme is seeking an ODI Specialist to collaborate with technical teams on ETL solutions for on-premises and Oracle cloud platforms for Fortune 1000 clients. You will migrate ETL to Oracle Cloud, build cross-platform data workflows, and lead projects from design through deployment.

The role requires extensive ODI/SQL/PL/SQL expertise, strong communication, and the ability to mentor junior practitioners in a fast-paced environment.

Qualifications

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

Responsibilities

• 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 to 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 processes such as RTR, PTP, OTC, ATR, 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 reusable 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

SQL/PLSQL

Oracle objects

Git

PL/SQL packages

SQL tuning

Partitioning/Indexing

Communication

ETL requirements

Tools

Git

Job description

Role & responsibilities

Description
As anODISpecialist, 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 anODIdeveloper 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 ofODIvs other platforms
• socialize solution design and enable knowledge transfer
• drive train-the trainer sessions to drive adoption ofODI
• partner with clients to drive outcome and deliver value
• Collaborate with cross functional teams to
• 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 deliveringODIjobs and frameworks
• Merge, Customize and DeployODIdata model as per client business requirements
• Deliver large/medium DWH programs, demonstrate expert core consulting skills and advanced level ofODI, 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 optimizeODIjobs performance to meet client SLA
• Designing and architectingODIprojects including upgrade/migrations to cloud
• Design and implement security inODI
• 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
Ideally, you should also have

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

Analytics & Cognitive

Our Analytics & Cognitive team