SUMMARY

• 8+ years of IT experience in Analysis, design, development, testing, implementation, maintenance and supporting Data warehouse/Data Mart applications using ETL tool Informatica 9.5 and earlier versions.
• Experience in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing, in a corporate with ETL Solution using Informatica Power Center 9.5/9.1/8.6/8.1.0/7.1.2, Power Exchange and Power mart.
• Have good understanding of data warehousing concepts (Kimball/Inmon)
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional modeling(Star schema and snow flake schema)
• Experience in integration of various data sources like Oracle, DB2, SQL server, XML files and flat file(Fixed and Delimited files)
• Implemented Slowly Changing dimensions Type 1, Type 2, and Type 3 methodology for accessing the full history of accounts and transaction information.
• Experience in developing complex Mapplets, Worklets and re-usable Tasks.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Filter, Router, Aggregator, Expression, Joiner, Update Strategy and more.
• Proficient in SQL*Loader, SQL*Plus, ODBC, Toad, SQL Developer applications to manage database and development.
• Excellent skills in retrieving the data by writing simple/ complex SQL Queries.
• Strong experience in writing stored procedures, Functions, Views and Triggers, complex queries using SQL/T-SQL/PL SQL.
• Created Schemas (Star and Snow Flake) to fit reporting, query and business requirements.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Experience in identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience with Unix and Linux Shell Scripting.
• Experience in scheduling of ETL jobs using Informatica scheduler, Control-M.
• Have performed various testing activities like unit testing, Integration-system testing, Regression testing and user-acceptance testing and ensure that code is ideal.
• Highly adaptive to a team environment and proven ability to work in a fast paced teaming environment with excellent communication skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5/9.1/8.6/8.1.0/7.1.2, Power Exchange 8.x/7.x

Database: Oracle11g/10g/9i/8i, SQL Server 2000/2005, DB2 UDB 9.5

Data Modelling Tool: Erwin 3.5/4.0, MS Visio 2007/10

Scheduling Tools: Informatica Scheduler, Control-M

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, XML, JAVA

Tools: and Utilities: Oracle SQL Developer, MS Visio, DAC, Toad

Operating System: Win9x/NT/2000/XP, NIX HP-UX, IBM-AIX, Sun Solaris 5.8/2.6.

Web Technologies: HTML, XML, Java Script, Front page.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, Ohio

Informatica Developer

Responsibilities:

• Interacted with business users, analysts for requirements, developed conceptual and logical data models.
• Parsed high-level design spec to simple ETL coding and mapping standards and used Informatica mapping designer to develop various mappings.
• Developed mappings for Type 1, Type 2 Slowly Changing Dimension to update a slowly changing dimension tables to keep full history. Implemented versioning by having date range fields and versions flags to maintain full history data in type 2 SCD.
• Created and maintained metadata and ETL documentation that support business roles and detailed source to target data mappings.
• Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations
• Responsible for designing, developing and implementing the ETL process which include the incremental load strategy and full load.
• Created and scheduled concurrent and sequential Sessions and Batch Processes based on run on demand, run on time, run once, and run continuously.
• Testing and validation of the developed Informatica mappings.
• Applied performance-tuning logic to optimize session performance.
• Wrote PL/SQL Packages, procedures, functions in oracle for business rules conformity.
• Migrated Informatica ETL code and Database objects through various environments such as Development, Testing and Production environments.
• Involved in Unit Testing, Integration, and User Acceptance Testing of Mappings.
• Involved in designing and building of Universe, Classes and Objects.
• Developed objects in the universe using some calculations on existing columns in database tables.
• Used drill analysis in Business Objects which will allow the user to view data at a more detail level, than current level.
• Involved in production support and done knowledge transfer to team members.

Environment: Informatica Power Center 9.5/9.6, Oracle 11g/10g, PL/SQL, Business Objects 6.5, SQL*Loader, ERWIN, DB2 UDB V7.5, Unix, SQL Server 2008.

Confidential, Dallas, Texas

Informatica developer

Responsibilities:

• Participated in requirement gathering meetings with business analysts and ETL architect to understand Source Data, Data Warehouse data model, Technical Metadata, etc.
• Involved in ETL mapping design, coding and implementing the client business logics and prepared mapping specification document.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated into Data Warehouse.
• Designed and developed moderate to complex initial load and incremental load mappings to provide data for enterprise data warehouse.
• Used Debugger to check the data flow from source to target in the mapping and fixed the bugs.
• Used Power Center server manager/Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process using Control M auto scheduling tool.
• Created multiple SCD Type 2 mappings in the Customer mart for both Dimension as well as Fact tables, implementing both date based and flag based versioning logic.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Developed UNIX shell scripts to move source files to archive directory.
• Used Informatica Power Connect to connect external Databases.
• Involved in Unit, Integration, system, and performance testing levels.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Migrated mappings, sessions, and workflows from Development to testing and then to Production environments.
• Created various data marts from data warehouse and generated reports using Cognos
• Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Drill through Reports and Master Detail Reports Using Report Studio.
• Created Query prompts, Calculations, Conditions, Filters, Multilingual Reports Using Report Studio.
• Good knowledge in Framework Manager, Report Studio, Query Studio, Cognos Connection, Analysis Studio.

Environment: Informatica Power Center 9.1, Informatica power connect,Oracle10g, DB2,SQL, PL/SQL, UNIX Shell Scripts, Flat files, Windows XP, and MS-Office tools, Control-M, Cognos.

Confidential, Dublin, Ireland

Informatica developer

Responsibilities:

• Designed the Mapping Technical specification documents on the basis of functional requirements.
• Designed and developed complex mappings using various transformations in Designer to extract the data from sources like Oracle, SQL Server and flat files to perform mappings based on company requirements and load into Oracle tables.
• Extensively worked on various source like flat files, Databases, XML and Web services.
• Extensively worked in the performance tuning of ETL procedures and processes.
• Error checking & testing of the ETL procedures & programs using Informatica and Oracle procedures.
• Performance Tuned Informatica Targets, Sources, mappings & sessions for large data files by increasing data cache size, sequence buffer length and target based commit interval.
• Responsible for production support.
• Any issues with the daily running jobs, find out the errors and fix them within time limit
• Always be on alert 24/7 with a company pager for monitoring daily workflows.
• Mainly responsible for solving Informatica and Database Issues for different departments if ticket is opened.
• Used Debugger utility of the Designer tool to check the errors in the mapping and made appropriate changes in the mappings to generate the required results for various tickets.
• Created Oracle Stored Procedure, Function, Cursor, Package and Triggers.
• Wrote Analytical queries to generate report, designed normal and materialized View.
• Created daily and weekly workflows and scheduled to run based on business needs
• Conducted knowledge transfer sessions for support team to familiarize to the business rules of the applications and issues raised in the UAT for ease of project maintenance.

Environment: Informatica Power Center 8.6, Oracle 10g, XML, TOAD,SQL, PL/SQL,IBM AIX, UNIX Shell Scripts, Web Intelligence, DSBASIC, Erwin 6.1, Maestro job scheduler, Mercury Quality Center.

Confidential, Dublin, Ireland

Informatica developer

Responsibilities:

• Parsed high level design document to simple ETL coding and mapping standards.
• Developed customized routine (ETL system) to capture and load data from external (Oracle 8x, Flat files) data sources into Oracle database.
• Extensively used Informatica to load data into Centralized Data Warehouse.
• Worked on Informatica tool - Source Analyzer, Target Designer, Power Center Designer, Mapping Designer, Mapplet Designer and Transformations.
• Created sessions and batches to run the mappings and set the session parameters to improve the load performance.
• Created Informatica mappings to build business rules to load data.
• Wrote stored PL/SQL procedures for certain Business Requirements.
• Involved in Unit Testing and tuning process for better performance.
• The ETL tool is an integral part of the data warehousing architecture that will be used to model and create target Warehouse, extract data from multiple data sources, transform the data to make it Accessible to business analysis, and loading target data marts.
• Performed code migration from DEV to QA and to PROD environments.

Environment: Informatica Power Center 8.1, Oracle 9i, SQL*PLUS, SQL, PL/SQL, Erwin, UNIX, MS Excel, MS Visio.

Confidential

Informatica developer

Responsibilities:

• Interacting with business users for gathering, understanding & analyzing the business requirements. Involved in review and finalizing the technical specs of source-target mapping documents.
• Designed and developed new mappings in Mapping designer and sessions and workflows in Workflow manager and modified existing ones to extract data from SQL Server, Excel, and Flat files and load to Oracle database as per business requirements.
• Writing validation packages using PL/SQL package.
• Developed Installation scripts for all the deliverables.
• Worked Extensively on Informatica tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Implemented SCD type 2 to keep track of historical data.
• Familiar with parameter file and its usage.
• Used SQL*Loader for bulk loading the data into the target tables.
• Generated various UNIX Shell scripts for automating daily load processes.

Environment: Informatica power center 7.1.1, Oracle 9i, PL/SQL, SQL Server, Unix.

Confidential

Oracle programmer

Responsibilities:

• Created forms for new policy entry details.
• Responsible for maintaining Policies as per the customer requirement.
• Wrote PL/SQL Stored Procedures for data extraction.
• Creation of Reports that allows the user to retrieve complete information as required for the
• Financial status like monthly reports, day to day transaction etc.

Environment: Oracle 8i, UDB DB2, PL/SQL, UNIX AIX 4.2, Windows XP/2000.