SUMMARY

• Over 6 years of IT experience working with ETL tools like Oracle Warehouse Builder, Oracle Data Integration and Informatica, and Oracle SQL developer.
• Working knowledge of Software Development Life Cycle (SDLC), having thorough Understanding of various phases like Requirements, Analysis/Design, development and Testing.
• Extensively followed Ralph Kimball and Bill Inman Methodologies.
• Developed, documented and validated complex business rules vital for data transformation.
• In - depth knowledge of data mapping, warehousing tools, unit testing, process documentation.
• Competent in data warehouse project planning,data modeling, maintenance, development, and enhancements.
• Working Experience in Oracle PL/SQL programming.
• Excellent team player with an ability to work independently.

TECHNICAL SKILLS

ETL tools: Oracle warehouse builder, ODI, Informatica

Database: Oracle 9i / 10g/12c

Operating Systems: Windows 2000/NT/XP/Vista/7/8/8.1/10

Tools: /Utilities: Toad, SQL Loader, SQL Developer, Putty

Data Modelling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snowflake schema, Fact tables, Dimensional tables), Entities, Attributes, E-R Diagrams

Web Technologies: HTML, CSS

PROFESSIONAL EXPERIENCE

Confidential, GA

ODI Developer

RESPONSIBILITIES:

• Experience in building and maintaining database objects (Tables, Views, Procedures and Functions etc) used in the Data Models.
• Developed Technical Design Document based on user’s requirement.
• Collected requirements from the business and developed some tables accordingly.
• Developed mappings to load the data using flat files to oracle database.
• Retrieving files from UNIX server using variables and procedures to load into tables.
• Performed Designing, Developing and implementing tasks of multiple ODI interfaces.
• Customized Knowledge Mappings according to the requirements.
• Worked on Performance Tuning and make sure to complete the loads in very minimum time.

ENVIRONMENT: Oracle Data Integrator (ODI) v.12.1.1.2, Oracle 12c, Oracle SQL developer.

OWB & ODI Developer

Confidential

RESPONSIBILITIES:

• Involved in Low Level Design preparation
• Designed and implemented a reusable ETL mapping document per business requirement using OWB.
• Developed back end stored procedures and functions in Oracle 10g.
• Providing information to customers with data analysis work.
• Analyzed and Documented database system specifications, diagrams, and connectivity charts.
• Evaluated actual and estimated execution plans for queries with performance issues to alter queries for better optimal query performance.
• Provided front-line support for daily business operations within the OLTP environment.
• Good knowledge of Data Marts, OLAP, Dimensional Data Modeling, Star Schema and Snow-Flake schema for FACTs and Dimensions.
• Knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Foreign Keys.
• Designed the ETL process that pulled data from various sources.
• Maintained indexes, created backups, and optimized query performance utilizing execution plan and parameter sniffing.
• Loaded reports into dashboard using SQL Loader.
• Involved in migration of OWB to ODI.
• Involved in creating ODI packages, scenarios using interfaces, variables, procedures.
• Involved in developing, support and maintenance for the Extract, Load and Transform processes using ODI.
• Involved in performance tuning of ODI Interfaces
• Created documentation of details that is implemented in ODI objects such as interfaces, procedures, variables, packages.
• Involved in Unit testing, Continuous integration testing
• Achieved Automated Deployment.

ENVIRONMENT: OWB10g, ODI 12c, APEX Oracle 10g, PL/SQL, Tortoise Subversion, MS Excel

INFORMATICA DEVELOPER

Confidential

Responsibilities:

• Developed ETL jobs for extracting, cleansing, transforming, integrating and load for a ODS from various data sources using Informatica power Designer.
• Write complex SQL queries for validating the data against different kinds of reports.
• Performance tuning on sources, targets mappings and SQL (Optimization) tuning.
• Responsible for scheduling workflows, error checking, maintenance and testing of ETL procedures usingInformatica session logs.
• Created mappings which involved Slowly Changing Dimensions Type 1 and Type 2 to implement business logic and capturing the deleted records in the source systems.
• Experienced in writing Unix shell scripts for different purposes such as scheduling jobs and moving the files from remote server to localInformatica server.
• Experienced in working with data modeler to understand the business model using Erwin.
• Executing the project both in agile and waterfall methodologies.
• Involved in writing technical specifications, and analyzing Functional Specifications.
• Involved in executing unit test cases.

ENVIRONMENT: Informatica 9.1, Oracle10g and UNIX

Confidential

Oracle PL/SQL Developer

RESPONSIBILITIES:

• Established an automated deployment environment using Unix Shell Scripting
• Developed and modified existing user defined stored procedures and user defined functions.
• Implemented various error handling techniques with inSQL scripts by utilizing try catch and transactions.
• Excellent working experience in PL/SQL and well-versed with advanced PL/SQL Concepts like PL/SQL, tables, Cursors, Ref Cursors, REGEXP, exceptions, database triggers, database packages, procedures & functions etc.
• Expertise in using Oracle Scheduler including External Jobs scheduling.
• Excellent SQL skills, experience writing complex queries and working with database objects (i.e. tables / views / sequences / synonyms, etc.)
• Expertise in Performance Tuning using Explain Plans and Trace File methodologies of SQL Queries and PL/SQL.
• Expertise in using Hints for changing the Query optimization plan.
• Performed Unit testing

ENVIRONMENT: Oracle PIM, Oracle 9i, Tortoise Subversion.