SUMMARY

• Informatica developer with 10+ Years of solid experience in Data warehousing & Extraction, Transformation & Load (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center 9.1/8.x/7.x/6.x/5.x (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager and Informatica server), Informatica Power Exchange, Autosys
• Experience include Banking, Pharmaceutical and Insurance Domains
• Nine Plus (9+) years of experience with Database objects, writing stored procedures, functions, triggers, DDL, DML SQL query performance tuning using Oracle 11gR2/10g/9i/8i, PL/SQL, SQL*Plus, SQL*Loader
• Extensive experience in tuning Informatica Mappings and Sessions for optimum performance.
• Excellent working knowledge of ODS, Datawarehouse models using Star and Snow - Flake scheme. Efficient utilization of “Bottom-up” and “Top-Down” methodologies.
• Experience in command line programs such as pmcmd, infacmd, infasetup and pmrep.
• Extensively worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• Good understanding of Software Development Life Cycle (SDLC) and Project Life Cycle.
• Good Understanding knowledge of Ralph Kimball & Bill Inman Methodologies.
• Experienced with dimensional and relational database design.
• Good experience of working with process models like CMMi Level5
• 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.
• Expert in implementing business rules by creating Re-Usable Transformations like Mapplets and Mappings
• Proficient in using Informatica Repository Manager to create & schedule sessions and batches.
• Expert in using debugger in Informatica Designer tool to test and fix errors in the mappings.
• Experience in PL/SQL development and SQL Query Tuning for better performance.
• Good working knowledge on SQL*Loader for Bulk Loading.
• Good knowledge in Scheduling ETL Jobs tool like Autosys.
• Experience in UNIX shell scripting, FTP, SFTP and file management in various UNIX environments.
• Production support, handling new enhancements and customer support.
• Exceptionally well organized, strong work ethics and willingness to work hard to achieve employer objectives.
• Effective in cross-functional and global environments to manage multiple tasks & assignments concurrently.
• Excellent communication, documentation and presentation skills using tools like Visio and PowerPoint.

TECHNICAL SKILLS

Technologies: Informatica Power Center 8.x, 9.1, Informatica Power Exchange.

Work Model: Waterfall model, Agile

Configuration Management Tools: Subversion, Perforce, Visual source safe.

RDBMS: Oracle 11g, Teradata, SQL Server

Operating Systems: Windows 7/2003/2013/Unix

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Senior Informatica Lead Developer

Responsibilities:

• Interacted with Business partners for requirement analysis and implemented the same into a functional ETL design
• Participated in data modelling (logical and physical) for operational database for the review tool.
• Worked as ETL Lead for all the tracks in IAM ETL projects.
• Developed High and Low level design documents
• Designed the ETL processes using Informatica to load data from Oracle, SQL Server, Flat Files (Fixed Width), XML and Excel files to staging database and from staging to the target Oracle database
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms
• Imported XML target definitions from an XML, DTD, and XML schema files
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter.
• Setting up Batches and sessions to schedule the loads at required frequency using Autosys
• Monitored the status of Workflows/Work lets/Sessions in Gantt chart and Task view mode using Workflow Monitor
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse
• Involved in Unix Shell Scripts for automation of ETL process
• Error Handling: Handled in Informatica Mappings & sessions and also through Validation Scripts
• Involved in preparing Test script documentation for Load Testing and involved in ping tests conducted on servers from different theaters across the globe
• Participated in weekly end user meetings to discuss data quality, performance issues, ways to improve data accuracy and new requirements, etc.

Environment: Informatica Power Center 8.x, Power Center 9.1, Informatica Oracle 10g, Oracle, Teradata, Unix, Autosys

Confidential

Senior Informatica Lead Developer

Responsibilities:

• Analyzing the source data and working with business users to develop the Model.
• Used Informatica Power Exchange for Change Data Capture in Source Tables.
• Extracted data from Oracle Sources and loaded them into Stage tables in SQL Server.
• Applied business logic with transformation rules in Power Center to load in to SQL Server Warehouse.
• Developed Design documents and Mapping documents.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Powermart 7.1.
• Created reusable transformations and mapplets and used them in mappings.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented slowly changing dimensions to maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Wrote many SQL/PLSQL scripts to verify data in the DB.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Stored Procedure.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Created E-mail notifications tasks using post-session scripts.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Created deployment groups, migrated the code into different environments.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Provided support to develop the entire warehouse architecture and plan the ETL process.

Environment: Informatica Power Center 8.1.1, Informatica Power Exchange, Oracle 10g, SQL Server 2005, UNIX

Confidential, Groton CT

ETL Informatica Lead Developer

Responsibilities:

• Worked with business partners to understand the requirements.
• Developed design documents and mapping documents based on BRD.
• Developed mappings/Transformation/ by using mapping designer, transformation developer and mapplet designer in Informatica Powermart 7.1.
• Created reusable transformations and mapplets and used them in mappings.
• Implemented Informatica recommendations, methodologies and best practices.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Wrote many SQL/PLSQL scripts to verify data in the DB.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Stored Procedure.
• Scheduled the workflows using the Informatica scheduling functionality.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Responsible for end to end implementation of code in Production.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 7.1, Oracle 9i, Unix

Confidential, Manchester, NH

ETL Developer

Responsibilities:

• Analyzing the source data and working with business users to develop the Model.
• Extracted data from flat files and Teradata Database and applied business logic and loaded in to Teradata Warehouse.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Powermart 6.1.
• Created reusable transformations and mapplets and used them in mappings.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented slowly changing dimensions to maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Worked on different data sources such as DB2, Oracle, Teradata, SQL Server, Flat files etc.
• UsedTeradata utilities Fastload, Multiload, TPumpto load data
• Wrote BTEQ scripts to transform data
• Wrote Multiload and Fastexport scripts to export data
• Wrote many SQL/PLSQL scripts to verify data in the DB.
• Involved in Data Validating, Data integrity, Performance related to DB, Filed Size Validations, Check Constraints and Data Manipulation and Updates by using SQL Single Row Functions.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Stored Procedure.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Created E-mail notifications tasks using post-session scripts.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Created deployment groups, migrated the code into different environments.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Documented technical design documents based on the BRD and SRS.

Environment: Informatica Power Center 5.x/6.x/7.1, Teradata 5.2, Oracle 8i, Unix