REF66865M - ODI Developer (2-4yrs exp) - Senior Program Analyst - EAG

WNS (Holdings) Limited (NYSE: WNS), is a leading Business Process Management (BPM) company. We combine our deep industry knowledge with technology and analytics expertise to co-create innovative, digital-led transformational solutions with clients across 10 industries. We enable businesses in Travel, Insurance, Banking and Financial Services, Manufacturing, Retail and Consumer Packaged Goods, Shipping and Logistics, Healthcare, and Utilities to re-imagine their digital future and transform their outcomes with operational excellence.We deliver an entire spectrum of BPM services in finance and accounting, procurement, customer interaction services and human resources leveraging collaborative models that are tailored to address the unique business challenges of each client. We co-create and execute the future vision of 400+ clients with the help of our 44,000+ employees.

• Oracle Data Integrator (ODI) consultant with overall experience of 3+ years of relevant experience in the implementation of Batch/Real-time Integrations using ODI 11g.
• Ability to customize knowledge modules as per the requirement. Should have strong design and development skills.
• Ability to design and develop Interfaces, Packages, Load plans, user functions, variables and sequences in ODI.
• Understanding of ODI/ODQ administration, maintenance and configuration skills.
• Experience working with multiple source/target systems such as Oracle, MS SQL Server, XML files, flat files, MS access/excel documents.
• Exposure to OLAP, OLTP, Data warehouse, Data mart development, Fact and Dimensional DB designs.
• Should have experience in developing dimensions and fact tables using ODI.
• Experience in high data volume environments/ performance tuning in ODI.
• Good to have exposure on ODI Administration and Load Balancing.
• Should be able to configure topology for all the technologies.
• Should be able to configure Standalone and Java EE agents.
• Exposure to CDC / Journalizing implementations and customizing knowledge modules.
• Experience in Modelling (logical and Physical) Warehouse and Marts Strong database design, relational and dimensional data modelling.
• Experience in writing complex queries, Stored Procedures in PL/SQL.
• Experience with UNIX Operating System, Windows Systems.
• Experience on ODI version 12c would be an added advantage

Bachelors Degree