$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
ODI Developer
Swetha Minukuri
,
ILFORD, United Kingdom
Experience
Other titles
Skills
I'm offering
Having around 10+ years of Experience in Data warehousing and RDBMS.
Experience in Oracle Knowledge Analytics with ODI and OBIEE
Data warehousing experience using Oracle Data Integrator & ELT Concepts.
Extensively worked on ODI Designer Component Interfaces, Packages and Scenarios.
Developed and supported Extraction, Loading and Transformation process (ELT) using Oracle Data Integrator to populate the tables in Enterprise Data Warehouse and Data marts.
Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like Flat Files, Oracle, SQL Server and Hyperion Essbase.
Working experience in using Oracle 10g/11g/12c, SQL, SQL Plus, PL/SQL, SQL SERVER, MY SQL, Windows XP/2000/98/95, and UNIX.
Developed complex mappings and Interfaces in ODI to load the data from various sources into the Data Warehouse, using different transformations like joins, filter, aggregations, lookups, sequence etc.
Developed Slowly Changing Dimension Mappings of type I, II and III.
Worked for different concepts like pivoting and parallel job execution in ODI.
Experience in implementing mappings, packages and scenarios in ODI 12c environment.
Experience in creating reusable mapping in ODI 12c.
Created Flow based mappings in ODI12c by using components like Set, Join, Aggregator, Lookup, split and Filter.
Experience in migration of projects from ODI 11g to ODI 12c.
Experience in creating Master and Work repositories in different RDBMS products like Oracle11g on different platforms like UNIX, Linux and windows servers.
Involved in Performance tuning for the jobs in ODI.
Scheduling jobs and load balancing in ODI.
Extensive experience in implementation of, transformations, Stored Procedures and execution of test plans for loading the data successfully into the targets.
Knowledge in Control-M (Job Scheduler) and OBIEE (Reporting Tool)
Good in ODI administration, Topology, Contexts, Repository Configurations and Security level.
knowledge on ODI Administration tasks and experience in creating master and work repository in the initial set up of the environment.
Had experience in end to end development of OBIEE Reports.
Had experience in RPD creation and modeling star schema.
Experience on Cache management and security management in OBIEE.
Experience in merging RPD’s and moving RPD and web cat files to different environments.
Experience in Oracle Knowledge Analytics with ODI and OBIEE
Data warehousing experience using Oracle Data Integrator & ELT Concepts.
Extensively worked on ODI Designer Component Interfaces, Packages and Scenarios.
Developed and supported Extraction, Loading and Transformation process (ELT) using Oracle Data Integrator to populate the tables in Enterprise Data Warehouse and Data marts.
Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like Flat Files, Oracle, SQL Server and Hyperion Essbase.
Working experience in using Oracle 10g/11g/12c, SQL, SQL Plus, PL/SQL, SQL SERVER, MY SQL, Windows XP/2000/98/95, and UNIX.
Developed complex mappings and Interfaces in ODI to load the data from various sources into the Data Warehouse, using different transformations like joins, filter, aggregations, lookups, sequence etc.
Developed Slowly Changing Dimension Mappings of type I, II and III.
Worked for different concepts like pivoting and parallel job execution in ODI.
Experience in implementing mappings, packages and scenarios in ODI 12c environment.
Experience in creating reusable mapping in ODI 12c.
Created Flow based mappings in ODI12c by using components like Set, Join, Aggregator, Lookup, split and Filter.
Experience in migration of projects from ODI 11g to ODI 12c.
Experience in creating Master and Work repositories in different RDBMS products like Oracle11g on different platforms like UNIX, Linux and windows servers.
Involved in Performance tuning for the jobs in ODI.
Scheduling jobs and load balancing in ODI.
Extensive experience in implementation of, transformations, Stored Procedures and execution of test plans for loading the data successfully into the targets.
Knowledge in Control-M (Job Scheduler) and OBIEE (Reporting Tool)
Good in ODI administration, Topology, Contexts, Repository Configurations and Security level.
knowledge on ODI Administration tasks and experience in creating master and work repository in the initial set up of the environment.
Had experience in end to end development of OBIEE Reports.
Had experience in RPD creation and modeling star schema.
Experience on Cache management and security management in OBIEE.
Experience in merging RPD’s and moving RPD and web cat files to different environments.
Markets
United Kingdom
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2017 - ?
job
ODI Developer
Worldpay FIS.
Software/Tools: ODI11g, OBIEE 11g, PL/SQL Developer, XML Files,
, LINUX.
Worldpay has been a pioneer in card payments, multi-currency processing, online payments and contactless, and is aiming to lead the way in expanding global reach, data analytics and optimisation, and the emerging field of integrated payments.
We process over 31 million mobile, online and in-store transactions - that's around 400 a second. Worldpay support 400,000 merchants in 126 currencies across 146 countries, offering over 300 payment methods. We are the leader in payments in the UK, where we process approximately 42% of all transactions.
● Involved in Extraction, Transformation, Loading data to warehouse and Datamarts using ODI 11g
● Extracted data from different sources like Oracle, flat files, XML, MY SQL and SQL SERVER implemented Business logic and loaded into target warehouse (Oracle).
● Experience in ODI designer, Topology, Operator, Master repository and work repository creation.
● Prepared detailed design for the ELT & PLSQL part of the system for each interface.
● Worked in Interface creation, Packages, Scenarios, Variables, Sequences, Procedures and User Functions in ODI.
● Created end to end error handling process to handle the errors in ODI.
● Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
● Worked for different concepts like pivoting and parallel job execution in ODI.
● Involved in Performance tuning for the jobs in ODI.
● Created different schemas in database using oracle 11g to configure the different objects implementation.
● Worked in SCD TYPE1, TYPE 2 and CDC implementation.
● Extensive Experience on Topology Navigator with developing Physical and Logical Architecture, Contexts and Configuring Agents.
● Migrating scenarios to Gerrit to control the versioning.
● Worked on Production support on daily basis and fix the issues in production
● Creating Work repositories to maintain the version for the development/deployments.
● Prepared unit & system test cases.
, LINUX.
Worldpay has been a pioneer in card payments, multi-currency processing, online payments and contactless, and is aiming to lead the way in expanding global reach, data analytics and optimisation, and the emerging field of integrated payments.
We process over 31 million mobile, online and in-store transactions - that's around 400 a second. Worldpay support 400,000 merchants in 126 currencies across 146 countries, offering over 300 payment methods. We are the leader in payments in the UK, where we process approximately 42% of all transactions.
● Involved in Extraction, Transformation, Loading data to warehouse and Datamarts using ODI 11g
● Extracted data from different sources like Oracle, flat files, XML, MY SQL and SQL SERVER implemented Business logic and loaded into target warehouse (Oracle).
● Experience in ODI designer, Topology, Operator, Master repository and work repository creation.
● Prepared detailed design for the ELT & PLSQL part of the system for each interface.
● Worked in Interface creation, Packages, Scenarios, Variables, Sequences, Procedures and User Functions in ODI.
● Created end to end error handling process to handle the errors in ODI.
● Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
● Worked for different concepts like pivoting and parallel job execution in ODI.
● Involved in Performance tuning for the jobs in ODI.
● Created different schemas in database using oracle 11g to configure the different objects implementation.
● Worked in SCD TYPE1, TYPE 2 and CDC implementation.
● Extensive Experience on Topology Navigator with developing Physical and Logical Architecture, Contexts and Configuring Agents.
● Migrating scenarios to Gerrit to control the versioning.
● Worked on Production support on daily basis and fix the issues in production
● Creating Work repositories to maintain the version for the development/deployments.
● Prepared unit & system test cases.
Test cases, Transactions, Tuning, Processing, Oracle data integrator, Production, Logic, Server, Online, Software, Development, Support, Developer, Transformation, Design, Implementation, Test, Analytics, Architecture, Oracle database, Optimization, Pl/sql, Database, XML, SQL Server, Oracle, Linux, Sql
2015 - ?
job
ODI Developer
Coral Group.
Software/Tools: ODI11g/12c, OBIEE11g/12c, PL/SQL Developer, My SQL, SQL
SERVER, LINUX
Gala Coral Group Ltd is a British betting shop, bingo and casino operator. The acquisition made it the UK's third largest bookmaker and largest bingo operator. It owns over 30 casinos. Coral will remain a brand and trading division of the new group. Coral owns two greyhound racing stadia in Britain.
● Involved in business requirement analysis and data modelling.
● Involved in Extraction, Transformation, Loading data to warehouse using ODI
● Extracted data from different sources like Oracle, flat files, XML, MY SQL and SQL SERVER implemented Business logic and loaded into target warehouse (Oracle).
● Experience in ODI designer, Topology, Operator, Master repository and work repository creation.
● Prepared detailed design for the ELT & PLSQL part of the system
● Worked in Interface creation, Packages, Scenarios, Variables, Sequences, Procedures and User Functions in ODI.
● Experience in implementing mappings, packages and scenarios in ODI 12c environment.
● Experience in creating reusable mapping in ODI 12c.
● Created Flow based mappings in ODI12c by using components like Set, Join, Aggregator, Lookup, split and Filter.
● Experience in migration of projects from ODI 11g to ODI 12c.
● Worked for different concepts like pivoting and parallel job execution in ODI.
● Involved in Performance tuning for the jobs in ODI.
● Scheduling jobs and load balancing in ODI.
● Created different schemas in database using oracle 11g to configure the different objects implementation.
● Worked in SCD TYPE1, TYPE 2 and CDC implementation.
● Implemented CDC on SQL SEVER database for one of the project.
● Migrating scenarios and load plans to production repository.
● Experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 11G.
● Worked on Production support on daily basis and fix the issues in production
● Worked on production ODI agents restart when there is an issue.
● Implemented security features and cache management in OBIEE.
● Prepared unit & system test cases
SERVER, LINUX
Gala Coral Group Ltd is a British betting shop, bingo and casino operator. The acquisition made it the UK's third largest bookmaker and largest bingo operator. It owns over 30 casinos. Coral will remain a brand and trading division of the new group. Coral owns two greyhound racing stadia in Britain.
● Involved in business requirement analysis and data modelling.
● Involved in Extraction, Transformation, Loading data to warehouse using ODI
● Extracted data from different sources like Oracle, flat files, XML, MY SQL and SQL SERVER implemented Business logic and loaded into target warehouse (Oracle).
● Experience in ODI designer, Topology, Operator, Master repository and work repository creation.
● Prepared detailed design for the ELT & PLSQL part of the system
● Worked in Interface creation, Packages, Scenarios, Variables, Sequences, Procedures and User Functions in ODI.
● Experience in implementing mappings, packages and scenarios in ODI 12c environment.
● Experience in creating reusable mapping in ODI 12c.
● Created Flow based mappings in ODI12c by using components like Set, Join, Aggregator, Lookup, split and Filter.
● Experience in migration of projects from ODI 11g to ODI 12c.
● Worked for different concepts like pivoting and parallel job execution in ODI.
● Involved in Performance tuning for the jobs in ODI.
● Scheduling jobs and load balancing in ODI.
● Created different schemas in database using oracle 11g to configure the different objects implementation.
● Worked in SCD TYPE1, TYPE 2 and CDC implementation.
● Implemented CDC on SQL SEVER database for one of the project.
● Migrating scenarios and load plans to production repository.
● Experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 11G.
● Worked on Production support on daily basis and fix the issues in production
● Worked on production ODI agents restart when there is an issue.
● Implemented security features and cache management in OBIEE.
● Prepared unit & system test cases
It, Agent, Tuning, Production, Logic, Server, Software, Load balancing, Support, Developer, Transformation, Test cases, Implementation, Design, Test, Security, Management, Pl/sql, Database, Unix, XML, SQL Server, Oracle, Linux, Sql
2016 - 2017
job
Senior ODI Developer
LadbrokesCoral Group.
Developer
2012 - 2015
job
Senior Software Engineer
Trianz Solutions Private Limited.
Project #3
Project: ESilicon
Project: ESilicon
Software
2011 - 2012
job
Developer
SBI.
Software/Tools: ODI11g, OBIEE11g, PL/SQL Developer
SBIG-DWBI is used to consolidate the data spread across applications (more than 10 applications) into a single reference system, which will be used by various departments in the company. The reference data thus maintained is taken back to OBIEE applications for consumption by several departments, specific to each business type.
Responsibilities:
● Involved in Extraction, Transformation, Loading data to warehouse using ODI.
● Extracted data from different sources like Oracle and flat files implemented Business logic and loaded into target warehouse (Oracle).
● Experience in ODI designer, Topology, Operator, Master repository and work repository creation.
● Prepared detailed design for the ELT & PLSQL part of the system
● Worked in Interface creation, Packages, Scenarios, Variables, Sequences, Procedures and User Functions in ODI.
● Created different schemas in database using oracle 11g to configure the different objects implementation.
● Worked in SCD and CDC implementation.
● Developed few of the Static and analytical reports Prepared unit & system test cases
● Executed test cases with multiple data sets to attain exact test results and capture faulty construction.
Project #5
Project: Integrated Marketing Sales Management
SBIG-DWBI is used to consolidate the data spread across applications (more than 10 applications) into a single reference system, which will be used by various departments in the company. The reference data thus maintained is taken back to OBIEE applications for consumption by several departments, specific to each business type.
Responsibilities:
● Involved in Extraction, Transformation, Loading data to warehouse using ODI.
● Extracted data from different sources like Oracle and flat files implemented Business logic and loaded into target warehouse (Oracle).
● Experience in ODI designer, Topology, Operator, Master repository and work repository creation.
● Prepared detailed design for the ELT & PLSQL part of the system
● Worked in Interface creation, Packages, Scenarios, Variables, Sequences, Procedures and User Functions in ODI.
● Created different schemas in database using oracle 11g to configure the different objects implementation.
● Worked in SCD and CDC implementation.
● Developed few of the Static and analytical reports Prepared unit & system test cases
● Executed test cases with multiple data sets to attain exact test results and capture faulty construction.
Project #5
Project: Integrated Marketing Sales Management
Marketing, Design, Sql, Oracle, Sales management, Database, Pl/sql, Management, Sales, Test, Implementation, Test cases, Transformation, Developer, Software, Logic
2010 - 2012
job
Software Engineer
HCL Technologies Ltd.
Software Engineer
HCL Technologies Ltd, Chennai
Aug 2010 to Nov 2012
Project #4
HCL Technologies Ltd, Chennai
Aug 2010 to Nov 2012
Project #4
Software
2010 - 2011
job
Developer
USAA.
Software/Tools: ODI11g, OBIEE10g, PL/SQL Developer, UNIX
VOM project deals with the analysis of member's feedback of the organization and presenting them to the High Level Managers for analyzing the business trends. The basic scope of this project can be adding new Listening Posts (sources) to the already defined VOM ETL Framework. Handled different sources like ACS (After Call Survey), BV (Bazaar Voice), Email, Echo (Every Customer Has Opportunity), Apple Ipad, Salesforce.com, Social Media etc. Data comes from above sources in the form of Mainframe DB2, Text files, Xml files etc.
Responsibilities:
● Involved in Extraction, Transformation, Loading data to warehouse using ODI.
● Extracted data from different sources like Oracle, flat files and XML implemented Business logic and loaded into target warehouse (Oracle).
● Experience in ODI designer, Topology, Operator, Master repository and work repository creation.
● Prepared detailed design for the ELT & PLSQL part of the system
● Worked in Interface creation, Packages, Scenarios, Variables, Sequences, Procedures and User Functions in ODI.
● Created different schemas in database using oracle 11g to configure the different objects implementation.
● Worked in SCD and CDC implementation.
● Developed few of the Static and analytical reports by using OBIEE and Prepared unit & system test cases
VOM project deals with the analysis of member's feedback of the organization and presenting them to the High Level Managers for analyzing the business trends. The basic scope of this project can be adding new Listening Posts (sources) to the already defined VOM ETL Framework. Handled different sources like ACS (After Call Survey), BV (Bazaar Voice), Email, Echo (Every Customer Has Opportunity), Apple Ipad, Salesforce.com, Social Media etc. Data comes from above sources in the form of Mainframe DB2, Text files, Xml files etc.
Responsibilities:
● Involved in Extraction, Transformation, Loading data to warehouse using ODI.
● Extracted data from different sources like Oracle, flat files and XML implemented Business logic and loaded into target warehouse (Oracle).
● Experience in ODI designer, Topology, Operator, Master repository and work repository creation.
● Prepared detailed design for the ELT & PLSQL part of the system
● Worked in Interface creation, Packages, Scenarios, Variables, Sequences, Procedures and User Functions in ODI.
● Created different schemas in database using oracle 11g to configure the different objects implementation.
● Worked in SCD and CDC implementation.
● Developed few of the Static and analytical reports by using OBIEE and Prepared unit & system test cases
Mainframe, Basic, Customer, Framework, Social, Logic, Software, Developer, Transformation, Presenting, Test cases, Implementation, Social Media, Test, DB2, Pl/sql, Database, Salesforce, ETL, Unix, XML, Oracle, Sql, Design
My education
?
-
2008
Jawaharlal Nehru Technological University
Bachelors, Information Technology
Bachelors, Information Technology
Swetha's reviews
Swetha has not received any reviews on Worksome.
Contact Swetha Minukuri
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Swetha directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark