SUMMARY

• Over 7+ years of IT experience in Data Warehouse and Business Intelligence applications.
• Hands on experience in Data Migration, Data Integration and Conversation.
• Involved in the full Project Life Cycle of the Enterprise Data Warehouse (EDW) Projects.
• Strong working experience in Informatica Data Integration Tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Expertise in Developing Mappings, Mapplets and Transformations between Source and Target using Informatica Designer.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, Sybase, MS Access and DB2.
• Worked on integrating data from flat files - fixed width and delimited files.
• Used Oracle, SQL, PL/SQL, Complex SQL queries using TOAD, SQL developer, WinSQL, RapidSQL to truncate the data in the target tables before loading and tune the ETL Mappings to achieve the required Performance timing.
• Experience in Performance tuning of Informatica (sources/targets/mappings/sessions).
• Extensively worked on Informatica Version Control in 8.x and 7.x.
• Experience in modifying existing UNIX shell scripts and accessing ParmFiles through FTP.
• Designed and developed various mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Experience in writing various Stored Procedures, SQL Cards, PL/SQL Blocks, and Triggers
• Good understanding of physical and logical data models.
• Extensive professional experience in preparing and maintaining project design documents like Preliminary Design Document, Detailed Design Document, and Mapping Document.
• Involved in Unit Testing and User Acceptance Testing (UAT).
• Possessing excellent leadership quality with good verbal and communication skills.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter v 9.0.1/8.6.1/8.5.1/8.1.1/7. x, PowerExchange 8.x

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2000/2005, Sybase, DB2, MS Access

Database Tools: SQL Plus, Toad, SQL Navigator, PLSQL Developer, RapidSQL, WinSQL

Others: OLAP, ERWin 6.0, MicroSoft Visio, MicroSoft Office, CuteFTP

Languages: C, C++, Java, Visual Basic, HTML, ASP, Perl, SQL, Shell Scripting

Operating Systems: Windows 9x/NT/2000/XP, UNIX

Reporting: SQL Reporting Services

PROFESSIONAL EXPERIENCE

Confidential - Chicago, IL

Sr. Informatica Developer

Responsibilities:

• Analyze, design, develop, test, install, and configure the data warehousing applications. Conduct unit testing, integration testing and system testing of the mappings and writing the Unit and System Test Plan.
• Responsible for Production Turnover for moving Informatica objects (workflows/mappings/ sessions), Oracle objects (functions, stored procedures, DDL queries) & UNIX objects (shell scripts) from Test to QA to PROD. Migrating Harvest packages (UNIX shell scripts) from Test to QA to Production Environments. Creating PTMs and DTG requests for developers in order to migrate objects to the Production Environment.
• Install and Configure informatica developer platform / Tool on Model repository service, Create a Data Integration Service and download and Install appropriate version of Informatica developer platform tool that matches with your power center version.
• Create Sessions and Workflows to load data from the Oracle Databases that were hosted on UNIX servers.
• Write complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy. Executing jobs in Tivoli scheduler.
• Modify the existing ETL code (mappings, sessions and workflows) and the shell scripts as per the user requirements. Monitoring workflows/mappings in Informatica for successful execution.
• Serve as point of contact between the developer and the administrators for communications pertaining to successful execution of job. Resolve issues that cause the production jobs to fail by analyzing the ETL code and log files created by failed jobs on the Informatica server.
• Develop mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Update strategy and Sequence Generator.
• Utilize Microsoft Lync for communicating with the developers as well as the managers and upload documents in SharePoint.
• Involved in analysis of data for creation of test data and improving data quality by embedding logics in mapping programs. Create high level technical documentation. Involved in developing design documents.
• Participate in weekly end user meetings to discuss data quality, performance issues and ways to improve data accuracy and new requirements, etc.

Environment: Informatica Power Center 9.1.0/8.6.1 , Oracle 11g/10g, SQL Server, PL/SQL,TOAD 9.5.1, SQL Plus, UNIX Shell Scripting, Tivoli scheduler.

Confidential - Bloomington, IL

Sr. Informatica Developer

Responsibilities:

• Involved in design and development of ETL process full data warehouse life cycle.
• Worked with Informatica PowerCenter 9.5 (PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager).
• Developed Informatica mappings, sessions and workflows to load data from the Oracle Databases that were hosted on UNIX servers.
• Extracted the data from different sources systems like Sybase, Oracle, DB2, and flat files. Loaded them into Oracle database.
• Written complex SQL overrides scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance due to heavy volume of data.
• Modified the existing ETL codes (mappings, sessions and workflows) and the shell scripts as per the user requirements. Monitored workflows/mappings in Informatica for successful execution.
• Created tables, indexes and constraints through SQL tool - TOAD
• Analyzed end user requirements and based on findings; mock-up.
• Assisted in troubleshooting post-production performance issues with end user.
• Worked with various IT teams to show them the best practices for their own solutions that help end users access and analyzed data in the data warehouse and data.
• Worked with relational databases to facilitate programming software with complete knowledge and understanding of Bill Inmon and Ralf Kimball.
• Worked multi-tasks and manage multiple priorities while working independently.
• Worked with cross functional, diverse and geographically distributed teams.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data.
• Used Win Merge to compare data/mappings etc between different environments.
• Use Analytical and problem solving skills for design, creation and testing of programs.
• Responsible for migrating the folders or mappings and sessions from development to UAT environment.
• Actively communicate to work effectively with team members, support personnel and clients.
• Participate in weekly end user meetings to discuss data quality, performance issues and ways to improve data accuracy and new requirements, etc.

Environment: Informatica PoweCenter 9.5, Oracle 10g/11g, SQL Server 2005/2008, DB2, Sybase, UNIX, TOAD.

Confidential - Pittsburg, PA

Sr. Informatica Developer

Responsibilities:

• Involved in developing mappings to populate data from various Source Systems like flat files, Sybase, SQL Server, Oracle to the single data warehouse
• Experience in using Mapping Parameters/Variables and Parameter files for connections to different databases
• Extensively worked with SQL Querying tool namely, Rapid SQL for unit testing, creating DDL scripts etc
• Involved in Agile Environment with daily Scrum meetings
• Created reusable Transformations, User-defined Functions, Mapplets and Sessions
• Highly adaptive with Version Control environment in DEV, QA and UAT environment
• Highly involved in creating Type1 and Type2 Slowly Changing Dimension Mappings using Informatica PowerCenter Designer ver. 9.0.1
• Used PL/SQL scripts to drop and create columns on the Target tables for Oracle
• Created mapping using various transformations like Joiner, Filter, Aggregator, Lookup, Stored Procedure, Router, Sorter, Rank, Update Strategy, Expression, Router and Normalizer
• Worked with Informatica Shortcuts in order to maintain the consistencies in the Sources and Targets throughout the Informatica Mappings
• Worked with Informatica Debugger in order to debug the mapping and session and to find the bottlenecks in the mappings
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions
• Created and Executed workflows and Worklets using Workflow Manager to load the data into the Target Database
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters

Environment: Informatica PoweCenter 9.0.1, Oracle 10g/11g, SQL Server 2005/2008, Sybase, UNIX, RapidSQL, CuteFTP, Borland Starteam.

Confidential - Des Moines, IA

Sr. ETL/Informatica Developer

Responsibilities:

• Worked with the Business Analysis team in collecting business requirements and enhanced the existing Mappings according business requirements
• Responsible for preparing Source to Target Mapping (STM) specifications & Transformation rules and Design Specification Document
• Designed mappings using Informatica Designer and coded it using reusable mapplets.
• Designed ETL process flow for entire DWH application and developed data mapping spread sheets to define transformation rules for each stage of ETL process
• Responsible to define ETL load mechanisms and design the Extract/Transform/Load process
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads. Also extensively worked with Target load order.
• Implemented Type 2 dimension mapping to update Slowly Changing Dimensions (SCD).
• Maintained history of data with an effective date with the ranges.
• Used most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator, Update Strategy, Rank, Expression and lookups (connected and unconnected) in many different mappings
• Involved in writing PL/SQL Stored Procedures and also modified existing stored procedures to improve the query performance.
• Actively Participated in Team meetings and discussions to propose solutions to the problems.
• Involved in application testing, bug fixes and Production support.
• Managed Change control implementation & coordinating daily, monthly releases and reruns.
• Responsible in providing the loading and unloading of data between tables at databases level to DBA.

Environment: Informatica 8.6.1/8.5.1 DTS, SSIS, Oracle 10g/9i, SQL Server 2005/2008, UNIX, Toad, PVCS, Hummingbird FTP.

Confidential - Ann Arbor, MI

Sr. Informatica Developer

Responsibilities:

• Studying the existing environment, validating the requirements and gathering source data by interacting with clients on various aspects.
• Worked on complete DW SDLC right from Extraction, Transformation and Loading of data.
• Involved in designing metadata tables and the ETL process.
• Designed the Functional Requirements and Mapping Technical Specifications on the basis of Functional Requirements.
• Developed complex mappings using Lookups connected and unconnected, Rank, Sorter, Joiner, Aggregator, Filter, Router transformations to transform the data per the target requirements.
• Involved in the physical & logical design of the Banking Analysis System using ERwin.
• Worked on Informatica Designer tool to develop mappings and mapplets to extract and load the data from flat files, Oracle, Teradata and Sybase.
• Used Debugger to validate the mappings and gain troubleshooting information.
• Worked extensively on creating complex PL/SQL Stored Procedures and Functions and optimizing them for maximum performance.
• Involved in documentation of complete life cycle of the project.
• Involved in preparing a handbook of standards and documented standards for Informatica code development.
• Environment: Informatica PowerCenter 8.1.1/7.1.2 ERwin 3.5, Business Objects 5.1, Oracle 9i, Sybase, Snagit, WinSQL.

Confidential, Kansas City, MO

Sr. Informatica Developer

Responsibilities:

• Worked on a Highly Visible Time Constraint project with different Databases.
• Performed the migration of 100+ mappings from Ascential ETL tool to Informatica ETL tool.
• With limited guidelines and with no documentation available, studied the existing jobs in DataStage and created specifications for respective mappings in Informatica.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Developed the Low complexity, Medium complexity and High complexity corresponding mappings along with any defects in the old processes.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/ Unconnected, and filter.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance (finding bottleneck).
• Performed the Unit Testing and Integration testing with the help of Integrity queries.
• Involved in migrating the newly developed Informatica process in QA environment
• Co-ordinate between different teams across the circle and organization to resolve release related issues.

Environment: Informatica PowerCenter 7.1.2 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Ascential DataStage, MicroStrategy 7.1.5, Oracle 9i, TOAD 8.6.1, UNIX Sun Solaris & Windows NT, Shell Scripting.