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

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.