SUMMARY

• Having 7+ years professional experience in IT industry and wide range of progressive experience in providing product specifications, design, analysis, development, documentation, coding and implementation including but not limited to Databases, Reporting, Data Warehouse and ETL Design Applications.
• Worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads.
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Have an extensively worked in Data Warehousing by using Informatica Power Mart and Power Center.
• Worked on ETL Informatica transformations including - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Union, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator and created complex mappings.
• Experienced in scheduling of UNIX shell scripts and Informatica workflows.
• Proficiency in ORACLE, SAS, Teradata, Teradata Utilities, BTEQ, Teradata SQL Assistant, SQL, PL/SQL, MS Access, MS Excel on UNIX and Windows platforms.
• Experience in populating the data warehouse tables using SQL*Loader, TPUMP, MULTILOAD, FASTLOAD, Oracle Packages, Stored procedures, Stored functions.
• Good Experience in writing, testing and implementation of the triggers, stored procedures, functions, views, materialized views, Cursors at database level using SQL, PL/SQL for Oracle 9i/10G.
• Knowledge in all areas of Project Life Cycle including requirements analysis, system analysis, design, development, documentation, testing, implementation and maintenance.
• Knowledge in Data Analyzer tools like Informatica Power Exchange (Power Connect) to capture the changed data
• Data Processing Experience in Designing and implementing Data Mart applications, mainly transformation Process using ETL tools like Informatica.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Expertise in writing/debugging/enhancing UNIX Shell Scripts.
• Good work experience in Informatica Data Integration Tools - Such as Repository Manager, Designer, Workflow Manager, Workflow Monitor and Scheduled workflows using Workflow Manager.
• Hands on experience on Oracle Data Integrator (ODI) as business intelligence tool, for real time data integration.
• Experience in using the Informatica command line utilities to execute or control sessions, tasks, workflows and deployment groups in non-windows environments.
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.

TECHNICAL SKILLS

Data Warehousing Tools: Informatica Power Center 8.6/8.5, Powermart 6.2, Informatica Power Analyzer

Dimensional Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling.

Databases: Oracle 10g/9i/8i, SQL BTEQ, Teradata, MS Access, MS Excel, VBA, SQLServer 2000 7.0/6.5, Informix.

Other Tools: Mercury Quality Center, Toad, SQL *Loader, and Teradata SQL Assistant, Data Mart, Oracle Data Integrator (ODI)

Languages: SQL, PL/SQL, HTML, XML, Unix Shell Scripting

Operating Systems: MS Windows 2000/XP, Solaris, Linux

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Informatica Developer

Responsibilities:

• Involved in analyzing the source data coming from different data sources such as Flat files, oracle and SQL Server and identifying data anomalies in operational data
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, MappletDesigner, Informatica Repository Manager and Informatica Workflow Manager
• Used all the transformations like Filter, Joiner, Expression, Aggregator, Router, Rank, Lookup and Update Strategy transformations
• Implemented depending on required dimension tables. Type 1, Type 2, Type 3 slowly changing dimension
• Used Parameter files to define values for parameters and variables used in mappings, sessions, worklet or workflow.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle, DB2, SQL server and Flat files into the target EDW.
• Created Error handling strategy for trapping errors in a mapping and sending errors to an error table
• Used Debugger to validate mappings and also for gaining troubleshooting information about data by inserting breakpoints.
• Developed fine tuned Transformations, Mappings and Mapplets between source systems and warehouse components
• Worked on codeMigration Strategies between Development, Test and Production repositories
• Created and scheduled Workflows using Informatica workflow manager.
• Coordinated tasks and issues with team lead and project manager on daily basis
• Prepared Unit test documents, which captures the test conditions and scripts, expected/actual results and data cross-section and volume for Individual interfaces components
• Was responsible to support related activities during warranty period.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development Parsing high-level design spec to simple ETL coding and mapping standards.

Environment: Informatica Power Center 9, Oracle, Flat files, DB2/400, TOAD, MS SQL SERVER 7.0/2000, Windows XP, HP-Unix.

Confidential, Irving TX

Informatica Developer

Responsibilities:

• Involved in full project life cycle - from analysis to production implementation and support with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into BI database.
• Based on the business requirements created Functional design documents and Technical design specification documents for ETL Process.
• Designing and developing ETL solutions in Informatica Power Center 8.1
• Designing ETL process and creation of ETL design and system design documents.
• Developing code to extract, transform, and load (ETL) data from inbound flat files and various databases into various outbound files using complex business logic.
• Created automated shell scripts to transfer files among servers using FTP, SFTP protocols and download files.
• Developed Informatica mappings, enabling the ETL process for large volumes of data into target tables.
• Designed and developed process to handle high volumes of data and high volumes of data loading in a given SLA.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Informatica scheduling tool.
• Expertise in creating control files to define job dependencies and for scheduling using Informatica.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment.

Environment: Informatica Power Center 8.1, ETL, Business Objects, Oracle 10g/9i/8i, HP - Unix, PL/SQL.

Confidential, IL

Informatica Developer/ QA Tester

Responsibilities:

• Workedwith Business users to collect requirements and prepared ETL technical specifications.
• Performance tuned various mappings, Sources, Targets and transformations by optimizing caches for lookup, joiner, rank, aggregator, sorter transformation and tuned performance of Informatica session for data files by increasing buffer block size, data cache size, sequence buffer length and used optimized target based commit interval and Pipeline partitioning to speed up mapping execution time.
• Worked on SQL tools like TOAD to run SQL queries to validate the data.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Created reusable transformations and Mapplets in the designer using transformation developer and Mapplets designer tools.
• Extensively used transformations like router, aggregator, lookup, source qualifier, joiner, expression, aggregator and sequence generator transformations in extracting data in compliance with the business logic developed.
• Documented handbook of standards for Informatica code development.
• Validating the data using SQL in Toad and BO Reports in Desktop intelligence
• Performed Unit, Security, Functional, and Regression Testing
• Validating the Objects created in the Universe and checking security roles to it.

Environment: Informatica Power Center 7.1.5, Oracle 10G, Toad 9.6.1, Unix, BO XI Release2.

Confidential

Informatica/ETL Consultant

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a STAR SCHEMA.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Involved in creating and maintaining various database objects like SQL Joins, synonyms and aggregate conditions and worked on various databases and their connectivity from various parts of the Source Systems.
• Involved in extracting the data from the Flat Files and other RDMS databases into staging area and pro-actively involved in Storage of data.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica PowerCenter Designer.
• Worked on Informatica Power Center tools- Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Migrated Mappings, Sessions, Workflows from Development to Test and then to Production environment and development.
• Prepare DR plan and recovery process for GDW application.
• Monitoring all the environments regularly and provided 24x7 production support for Informatica/Hyperion.
• Create RTM, Document process and transfer knowledge.

Environment: Informatica Power Center 5.1, ETL, Oracle 9i, DB2, PL/SQL, TOAD, SQL* Plus, SQL*Loader, SQL Server 2000, Windows Server 2000.