SUMMARY

• Over 7+ years of IT experience with extensive Data Warehousing implementations across Financial, Health Care, and Pharmaceuticals.
• Extensive experience in using Informatica tool for implementation of ETL methodology in Data Extraction, Transformation and Loading.
• Experienced in Installation, Configuration, and Administration of Informatica PowerCenter on Client/Server environment.
• As an ETL developer involved in development, testing stages of software development lifecycle in multiple projects of different companies with development process such as waterfall and agile methodology.
• Have extensively worked on Oracle 11g/10g/9i/8i, SQL Server.
• Extensively worked on Dimensional modeling, Data migration, Data cleansing and Data Staging of operational sources using ETL processes for data warehouses.
• Complete understanding of Informatica Power Center 9.x/8.x architecture and experience using InformaticaPowerCenter9.5/9.1/8.x/7.x.
• Experience in Informatica PowerCenter Designer, Source Analyzer, Warehouse Designer, Repository Manager, Repository Server, Administration Console, Server Manager, Workflow Manager, Workflow Monitor.
• Have extensively worked on data conversion projects.
• Experience in Debugging/Optimizing/Tuning Informatica mappings for better
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Good Knowledge of Teradata architecture, SQL, utilities.
• Experience in creatingReusable Transformations(Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and processing tasks usingWorkflow Managerto move data from multiple sources into targets.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables and developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.
• Well versed inOLTP Data Modeling, Data warehousing concepts.
• Involved in Data modeling to determine data definitions and establish referential integrity of the system.
• Performed system Analysis and QA testing and involved in Production Support.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Data modeling experience using Dimensional Data modeling, Star Schema modeling, Physical & logical data modeling in ERWIN.
• Extensive experience in writing PLSQL, Stored Procedures, Packages, Views, Synonyms, and Triggers.
• Experience in UNIX shell scripting and PERL scripting, FTP and file management in various UNIX environments.
• Developed and maintained UNIX shell, awk, sed and Perl scripts using VI Editor for automated daily load processes and batch processing.
• Extensive functional and technical exposure. Experience working on high-visibility projects.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

TECHNICAL SKILLS

ETL Tools: Informatica9.5/9.1/8.x/7.x

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005

Data Modeling: Physical and Logical Data Modeling, MS Visio, Star Schema Modeling, Snow Flake Modeling

Programming Skills: C/C++, SQL, PL/SQL, JAVA, Unix Shell Scripting

Operating Systems: UNIX, Windows 2000/2003/NT/XP

Web Technologies: HTML, DHTML, CSS, JavaScript

Others: SQL*plus, Toad, PL/SQL Developer, SQL*LOADER

Scheduling Tool: Control M, Crontab

PROFESSIONAL EXPERIENCE

Confidential, VA

Informatica Developer

Responsibilities:

• Coordinating with the client and gathering the user requirements.
• Created analysis of source systems, business requirements and identification of business rules.
• Analyzed the source system and involved indesigning the ETL data load.
• Developed various transformations like Source Qualifier, Sorter transformation, Joiner transformation, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Extensively used Informatica power center 9.5.1 for extraction, transformation and loading process.
• Documented Mapping and Transformation details, user requirements, implementation plan and schedule.
• Worked with various Passive transformations in Informatica Power center like Expression Transformation, Sequence Generator, and Lookup Transformation.
• Worked with various active transformations in Informatica Power Center like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
• Created differentparameter files and changed Session parameters, mapping parameters,and variables at run time.
• Identify the flow of information, analyzing the existing systems, evaluating alternatives and choosing the "most appropriate" alternative.
• Developed PL/SQL scripts at the database level that were used in the mappings through stored procedure transformation.
• Developed re-usable components in Informatica.
• Responsibilities include creating the sessions and scheduling the sessions.
• UsedSQL Overridein Source qualifier to customize SQL and filter data according to requirement.
• Used SQL overrides in Source Qualifier and Lookups to improve mapping performance.
• WrotePRE and POST SQL commandsin session properties to manage constraints that improved performance and written SQL queries and PL/SQL procedures to perform database operations according to business requirements.
• Created system end to end testing (Unit and System Integration Testing) as part of the SDLC process and performance tuning at the mapping level, session level, source level, and the target level.
• Worked with Session Logs, Informatica Debugger, and Performance Logs for error handling the workflows and session failures.
• Used Workflow Manager for creating, validating, testing and running thesequential and concurrent sessions.
• Involved inUnit testing, System testingto check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.

Environment: Informatica Power Center 9.5.1, Oracle 11g, SQL Server 2008, AIX UNIX, Windows, Oracle SQL Developer, SQL Server Management Studio, Unix shell scripting.

Confidential, Des Moines, IA

Informatica Developer

Responsibilities:

• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Designed Informatica mappings by translating the business requirements.
• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Developed mappings for customers, Investments and Risk analysis.
• Developed reusable Transformations.
• Widely used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
• Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively.
• Maintaining the shared objects and taking care of import and export.
• Worked on Control M for processing classification file and classification delta file.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Done extensive bulk loading into the target using Oracle SQL Loader.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
• Involved in the process design documentation of the DW Dimensional Upgrades.
• Installed, and Documented the Informatica Power Center setup on multiple environments.

Environment: Informatica 9.1/8.6.1, Oracle 11g, SQL, AIX UNIX, Windows, Toad, Oracle SQL Developer, SQL Server Management Studio, Unix shell scripting, Control M.

Confidential, St. Louis, MO

Informatica Developer

Responsibilities:

• Involved in designing of Data Validation for accurate data loads.
• Worked on Informatica Designer, Workflow Manager, and Repository Manager for Migration of Code from Informatica Power Center Component.
• Worked on a number of key enhancement requirements and responsible for adding extra functionalities to some of the most crucial modules.
• Developed ETL Mappings using various Informatica transformations like Expression, Lookup, Aggregate, Joiners, Router, Filter, Stored Procedure, SQL Transformation, Update Strategy etc.
• Tasked to review and evaluate proposed system design resolutions (such as table structure, table relationships) and determine feasibility and practicability in real time environment.
• Created complex Stored Procedures, triggers, cursors, views and user-defined functions.
• Knowledge in all phases of SDLC and specifically worked on Define, Build, Test, Deploy and Post Production Phases.
• Involved in debugging of the mappings using Informatica Debugger by creating breakpoints to gain troubleshooting information about data and error conditions.
• Overriding the default query in the Source Qualifier by incorporating SQL queries and applying the business rules at the source itself to improve efficiency and avoid cumbersome transformations.
• Developed Error handling mechanism and delta logic in different mappings. Developed mappings using XML files as sources
• Worked on Push down Optimization, which improves the mapping performance.
• Performance tuning the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
• Scheduled different workflows using Informatica scheduler.
• Developed Unit Test Cases to ensure successful execution of the data loading processes.
• Was involved in 24/7 Production support as required.
• Used type I and type II dimensions to update and insert the information in the data warehouse.
• Developed FTP/SFTP process to move data in Flat files to receive/send from/to various systems.

Environment: Informatica 9.1/8.6.1, Oracle 11g, SQL Server 2008, UNIX, Windows, Toad, Oracle SQL Developer, SQL Server Management Studio.

Confidential, Durham, NC

Informatica Developer

Responsibilities:

• Interacted with Business Analysts to gather and analyze the Business Requirements.
• Involved in Designing, forward engineering using Erwin.
• Prepared Technical Required Documents along with Design and Mapping documents.
• Worked with BA/BSA, Data Modeler/Architect team in designing the Data Model for the project.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline the data to Database.
• Used Informatica Power Center to create mappings, mapplets, User defined functions, workflows, worklets, sessions and tasks.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, Union, Rank, Normalizer, Update strategy and Router transformations for populating target table in efficient manner.
• Used shell scripts for performing initial file validations like duplicate checks, counts(control & balance), file size & structural validations, date and data type format validations on input and intermediate files coming from a third party system.
• Implemented control and balance piece at all required levels by using ABC layer.
• Created Sessions, Workflows, Link Tasks and Command Tasks using Workflow Manager and monitored the workflows/sessions using Workflow Monitor.
• Extensively used stored procedures, functions and also worked with parallel processing.
• Worked with events such as Timer, Event Wait, Event Rise, Control and Decision.
• Created Unix Shell scripts for FTP/MFT, Error handling, Error reports, Parameter files etc.
• Involved in performance tuning of the complex mappings.
• Performed Unit testing and worked closely with offshore testing team in preparing test cases for System Integration testing.
• Involved in migration of the mappings, Sessions and other Objects from Development to QA and to Production environment.

Environment: Informatica 8.6, Oracle 10g, SQL Server 2008, UNIX, Windows, Toad, Oracle SQL Developer, SQL Server Management Studio.

Confidential, Richmond, VA

Informatica Developer

Responsibilities:

• Worked closely with Business Analysts in understanding the Business requirements.
• Responsible for data analysis.
• Responsible for Maintaining Warehouse metadata, naming standards and warehouse standards for future application development.
• Worked on Dimension/Fact tables to implement the business rules and get required results.
• Assisted in designing Logical/Physical Data Models, forward engineering using ERWIN.
• Utilized Informatica Data Explorer to analyze legacy data for data profiling.
• Used Informatica Data Explorer to find hidden data problems, wherever they are - that put the project at risk. Using this software we used to discover and analyze all anomalies across all data sources.
• Developed mappings to extract data from SQL Server, Oracle, Flat files, XML files, and load into Data warehouse using the Mapping Designer.
• Used Java to get files from Java code and used for uploading files.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Created reusable transformations in transformation developer/ mapplets in mapplet designer.
• Developed Mappings using various Transformations like Aggregate, Expression, Filter, Lookup, Joiner, Sequence Generator, Stored Procedure, Update strategy and Rank.
• Used Workflow Manager extensively to create tasks, worklets, and workflows and executed the tasks.
• Extensively worked to implement Type-2 slowly changing dimensions using Version number and time stamping to keep track record of changed data.
• Developed PL/SQL stored procedures to implement complex business rules.
• Monitored database performance tuning and implemented the session partitions and made changes to database by re-building the indexes.
• Used to create reusable transformations.
• Used command line mode to embed Pmcmd commands in to shell scripts and used Pmcmd, Pmrep commands in Interactive mode to access repository and workflows.
• Implemented reconciliation process for data consistency between source systems.
• Defects were tracked, reviewed and analyzed.
• Involved in migration of the mappings and workflows from the development server to the Test Server to perform the integration and system testing.

Environment: Informatica Power Center 7.2, Informatica Data Explorer, Erwin, Oracle 9i, SQL Server 2005, Windows XP, Sun Solaris, SQL, PL/SQL, TOAD, UNIX, UNIX Shell Scripting