As an ODI Developer the person requires experience with Oracle Data Integrator (ODI) and development of ODI Interfaces, Procedures, Packages, and Scenarios utilizing technologies such as Oracle, File, SQL, and PL/SQL. Demonstrated high level of understanding of ETL/ELT development concepts and patterns.
This role based in Gurgaon involves the following:
Using the in house developed TLM application to develop and customize the user requirements, system workflow and database structures to meet new and changed business requirements. Working closely with the stakeholders and other Team members to ensure that the changes being developed are in-line with business needs and is scalable and stable.
What the Business does
This role is based in the Currencies Ops Technology in Ops Technology, at NWM
As an ODI Developer, your key responsibilities will include:
ODI Development including ODI Interfaces, Procedures, Packages, and Scenarios utilizing technologies such as Oracle, File, SQL, and PL/SQL. Co-ordinating with the Production team and helping them in debugging the issue and fixing those.
Providing full and comprehensive documentation of all changed and new components so that they can be successfully promoted from Development to UAT and ultimately into Production.
Liaising with Team Members and Environment Management team to provide refreshed Development and testing environments before commencing work packages.
Liaising with testing team to schedule and execute regression test processes, and to create new regression test scripts as directed
Liaising with Development Team to integrate application solutions into the end to end systems environment as directed.
Working closely with the other Team Leads and other Team members to ensure that the changes being developed are fit for purpose and meet the documented business requirements.
The Skills youll need
In order to be successful in this role, you must have the following skills & experience:
Minimum 5 Years Hands on experience in designing and implementing the E-LT architecture that is required to build data warehouse, including source-to-staging area, staging-to-target area, data transformations, and EL-T process flows.
Implementing the extraction, loading, and transformation EL-T of data using Oracle Data Integrator configuring the ODI master and work repositories, ODI models, defining and organizing the ODI project including interfaces, packages, procedures, variables, user defined-functions, and knowledge modules.
Worked with different sources like Flat Files, CSV Files, XML Files and Relational Databases.
Involved in developing scenarios and scheduled them for loading the Data.
Importing and exporting scenarios from development, test and production environments.
Customization of knowledge modules using jython scripting language.
Strong Knowledge in Data Warehouse architecture and Data Warehousing concepts like Star Schema, Snowflake Schema, Data Marts, Dimension and Fact tables.
Good exposure in SQL and Hands on experience in PL\SQL.
Pro-active individual with ability to form key relationship with both IT and business colleagues.
Proven record of working individually and as part of a team.
Good organisation, planning and time management skills.
Motivation to take ownership and resolve issues and get decisions made.
Confident and good communicator, both upwards and downwards in the organisation.
Have excellent attention to detail.
Ability to work under pressure when necessary and multi-task.
SummitWorks IT Services allows us to focus on providing you with the most flexible,... cost-effective technology solutions crucial to sustaining your competitive advantage in this increasingly complex marketplace. We deliver the strategies, personnel, tools and resources that enable you to succeed. Read full description