Arjun Walia

• Handling a team of 7 professionals.
• Experience in Information Technology including analysis Design, Development, Implementation of Data Warehousing in ETL Worked extensively in developing ETL for supporting Data Extraction, Transformation and Loading using Oracle Data Integrator (ODI).
• Experience in building BI DW’s/performing Data Integration from source systems to EDW, ODS, BI Reporting solution systems using Oracle Data Integrator v.12c.
• Expertise in Oracle Data Integrator and ETL loads.
• Experience of having worked with ELT Tool ODI against different databases Oracle (11g), MS SQL Server (2005, 2008).
• In addition has knowledge of ODI 12 C and other tools like OBIEE, Informatica.
• Extensive development experience in Extraction, Transformation and Loading of data from multiple sources such as Oracle, MS SQL Server,DB2, Legacy systems, Flat Files into ODS (Operational Data Store) and EDW (Enterprise Data Warehouse) systems.
• Worked extensively with complex interfaces using ODI.
• Expertise in implementing complex business rules by creating ODI interfaces.
• Used Topology Manager to define data servers and physical schemas for various sources and target databases.
• Implemented the Change Data Capture (CDC) feature of ODI to minimize the data load times.
• Used ODI Designer to develop complex interfaces (mappings) to load the data from the various sources into dimensions and facts.
• Hands on experience on dealing with ODI Knowledge Modules like, LKM, IKM and JKM, CKM.
• Experience in debugging Interfaces. Identified bugs in existing Interfaces.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Experience in analyzing, requirement gathering, documenting and editing Business/User Requirements.
• Created several scripts in UNIX for data transformations to load the base tables by applying the business rules based on the given data requirements.
• Strong in analysis, design, coding and a good Team player in full life cycle / SDLC support from Initial design phase to production support.
• Proven track record of providing value-added service to the Business.
• Hands on experience in Performance Tuning at all levels
• ODI Best Practices Implementation.

Responsible for support activities and to provide the data to the user as it is a support project.

Write SQL queries for data testing.

Make the necessary changes in the tasks according to the requirement of the client.

Experience in extracting data from excel files, CSV, flat files system and other source system.

Design, Development and Implementation of Mappings

Analysis and Bug Fixing of issues

Creation of transformations and extensively used Expression, lookup, update strategy, router, sequence generator.

Monitoring the tasks in Informatica Monitor.

Activate the Informatica services in UNIX and making the parameter files in UNIX.

Worked with Sources such as Oracle and Flat files.

Involved in creating Daily load status sheets.

Hands-on experience in OBIEE. For eg. Restarting the services, checking the data in agents, verifying the physical relationship between the tables, schemas etc while doing the back-tracking.

Making duplicates agents (BOTS) and changing the prompts values depending on the data.

Involve in Creating the ETL Specification (LLD, HLD) on the basis of BA sheet or Functional Specification

Design, Development and Implementation of Mappings

Design the Informatica session and Workflow.

Analysis and Bug Fixing of issues

Creation of transformations and extensively used Expression, lookup, update strategy, router, sequence generator

Worked with Sources such as Oracle and Flat files.

Involved in creating Daily load status sheets.

ETL – The project, being based upon onsite-offshore model, required a robust and accurate coordination.

Develop new mappings for fact table.

Develop reusable mapping and sessions,

Write functions and procedure for reusable logic.

Write SQL queries for data testing.

Experience in extracting data from excel files, CSV flat files system.

Work as team member in development and enhancement.

Worked extensively in design, development and testing of mappings for several projects.

Channelizing work to offshore

To train freshers in Informatica, SQL, and Data Warehousing concepts

To make an inventory of all the mappings, procedures, which are impacted.

Rewrite the SQL of mappings, procedure which uses source table, to get the same output as before.

System testing of other related mapping, procedure, so that the application continues to run as before.

Work on other small enhancement.

Report Preparation for business user.

To train newly joined team member on Informatica.