SUMMARY:

• 10 + years of professional experience with a comprehensive technical skill set and expertise in development and implementation of Data Warehouses & Datamarts with Informatica Power Center 7.X/8.X/9.X .
• Involved in all phases of Software Development Life Cycle( SDLC ): Requirement gathering, analysis, design, development, testing, production support and maintenance. Also worked on waterfall and Agile/Scrum methodology project.
• Experience in working with Informatica components like workflows, mappings, mapplets, sessions, tasks, User Defined Functions (UDF), Debugger, partitioning, reusable components and also extensively worked with session logs,workflow logs for error handling and troubleshooting on mapping failures along with partitions and performance tuning measures .
• Proficient in Data warehouse concepts, Dimensional Modeling using Star schema and Snow Flake schema.
• Expertise in working with various database systems such as Netezza, DB2, Teradata, Oracle and SQL Server Databases as well as complex SQL queries along with Informatica interfacing with Sales Force .
• Certified in Oracle SQL and SQL SERVER 2005 - Implementation and Maintenance.
• Expertise with UNIX shell scripts extensively for job execution, updating parameter file and file transfers ( FTP ).
• Expertise in setting up new jobs and job dependencies using Control-M and Autosys .
• Experience in Property and Casualty Insurance and Banking domains.
• Created documentation for all aspects of ETL processes like technical design documents, mapping specifications document, migration document and project transition documents.
• Experience in workingwith Onsite-Offshore model . Currently leading a program of 20 developers across projects and locations ( India, USA and Mexico ).
• Effectively leading the program without effecting the quality and timeline of the projects.
• Excellent communication and interpersonal skills, problem solving skills, analytical skills, flexible, self-direct, ability to work with minimum supervision and a team player  

TECHNICAL SKILLS:

ETL Tools: Informatica Powercenter 9.X/8.X/7.X (Repository Manager, Designer, Work Flow Manager,Workflow monitor)

Database Systems: IBM DB2, Netezza, SQL Server, Teradata, Oracle

Databases Tools: Squirrel, Teradata SQL Assistant,Oracle SQL developer, SQL Server Studio

CRM Platform - SalesForce:

Version Control: Star team,IBM RTC(Rational Team Concert), PVCS

Languages: Shell Scripting

Operating Systems: Windows XP/7, UNIX

Scheduling Tools: Control M, Autosys

Other Tools: Putty,WinSCP,Visio

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Informatica Developer

Responsibilities:

• Worked with business analysts and SMEs to first analyze data and business requirements in order to transform those into effective technology solutions.
• Worked closely withManager, Architects, Data SMEs and Data Modelersto understand the business process and functional requirements of moving data across platforms and then create an architectural flow to depict data movement for all clients within specific domains
• Created High level, low level design documents, ETL specification documents,Data model document and test cases document. Responsible for creating/quantifying Agile epics, stories and assigned tasks for the team on JIRA.
• Worked with Offshore team to oversee the development activity, reviewed code and make sure it conforms to standard programming practice at TWG.
• Reviewed the design document and code with support team and also conducted the Knowledge transfer sessionsabout the project to support team.

Environment: Informatica Power Center 9.5.1 on Windows (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Flat files, DB2, Azure Cloud, Sales Force,, Visio, Control-M

Confidential

Sr. Informatica Developer / BI Program Lead 

Responsibilities:

• Worked with business analysts and SMEs to first analyze data and then understand business requirements in order to transform those into effective technology solutions.
• Worked closely withManager, Architects, and Data Modelersto understand the business process and functional requirements.
• Bi-weekly meetings with the client delivery manager to go over TCS staffing plan, resource feedback, identifying potential bottlenecks as part of being the Program lead for FINPAL.
• Created High level, low level design documents, ETL specification documents,Data model document and test cases document. Responsible for creating/quantifying Agile epics, stories and assigned tasks for the team on RTC
• Expertise in implementing complex business rules by creating robust mappings, mapplets, and reusable transformations using Informatica Power Center using different transformations which include Joiner Transformations, Look-up Transformations, Rank, Filter Transformations, Router Transformations, Expressions, Aggregators and Sequence Generator, Sorter, Update Strategy, Partitioningand Debugging Mappings to identify performance issues in existing mappings by analyzing the data flow and evaluating transformations.
• Created reusable objects like Mapplets,worklets, transformations and user defined functions to use across multiple mappings.
• Developed complex mappings using various sources data which includes Flat files, DB2 & Netezza database to load data into Netezza tables and to generate reports.
• Involved in handling change requests and performance enhancement for the existing mappings.
• Creating deployment groups,rollout plan documents forproduction migration (mappings, workflows, parameter files and UNIX scripts) and supporting the post production support during warranty.
• Created a shell scripting in UNIX platform for running Informatica workflows, updating the Parmfiles, sending emails and the FTPing the Files.
• New jobs are created and scheduled using batch scheduler Control-M. Job dependencies are setup with different control-M cycles.
• Wrote complex SQL queries to perform large scale data validation as part of the migration process from old system to the new one.
• Developed the simple Excel macros to convert the reports and to do the calculations based on the user inputs.
• Worked with Offshore team to oversee the development activity, reviewed code and make sure it conforms to standard programming practice at USAA.
• Reviewed the design document and code with support team and also conducted the Knowledge transfersessionsabout the project to support team.

Environment:Informatica Power Center 9.1 (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Flat files, DB2, Netezza, SQL Server, UNIX Scripting, Putty, Visio, Control-M.

Confidential

Sr. Informatica Developer / Project Lead

Responsibilities:

• Worked with business analysts to understand business requirements in order to transform business requirements into effective technology solutions in line with the IBM data warehouse model.
• Worked closely with Manager, Architects, and Data Modelers to understand the business process and functional requirements.
• Created High level, low level design documents, ETL specification documents, Data model document and test cases documents for the offshore team as well as reviewing offshore deliverables.
• Attended weekly status meeting with the client Project Manager to provide updates on all modules within the project.
• Extensively worked on Performance Tuning at the mapping level, session level, source level, and the target level for the mappings which were taking long time to complete.
• Analyze source data for potential data quality issuesand created the exception mappings/clean up scripts to clean up the bad data in data warehouse.
• Built many reusable components in informatica, like mapplets, worklets, reusable transformations and User Defined Functions.
• Wrote complex SQL queries to retrieve information from the databases depending on the requirement and also for data cleanup process.
• Createdshell scriptsfor running Informatica workflows, updating the Parmfiles, sending emails and the FTPing the Files.
• Well acquainted using Teradata utilities BTEQ, Fast Load, Multi Load, Fast Export, Tpump, SQL Assistant and SQL Administrator.
• Used the Autosys scheduling toolto schedule the jobs and to set the job dependencies.
• Reviewed the design document and code with support team and also conducted the Knowledge transfer sessions about the project to support team

Environment:Informatica Power Center 8.6 (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Flat files, Oracle10g, Teradata V2R5, UNIX, Autosys, Visio.

Confidential

Sr. Informatica Developer / Module Lead

Responsibilities :

• Analyzingtherequirements and having discussion with onsite and business team to understand the requirements.
• Created the mapping design documents for business requirements also to help the team in their design process, involved in code reviews as the offshore lead in this project.
• Worked with various active transformations in Informatica PowerCenter like Normalizer Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, Sequence generator Transformation and Update Strategy Transformation.
• Extensively worked with Slowly Changing Dimensions(SCD) Type1, Type2, and Type3 for Data Loads.
• Extensively worked with both Connected and Un-Connected Lookups and Look up Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations.
• Extensively worked with Incremental Loading using parameter files, mapping variables, and mapping parameters.
• Created Pre/Post Session SQL commands in sessions and mappings on the target instance.
• Created and Documented ETL test plans, test cases, test scripts, expected results, assumptions and validations for unit, integration and system tests for mappings developed.
• Involved in post production support and monitoring the activity in various environments.

Environment: Informatica Power Center 8.6 (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Flat Files, IBM DB2, UNIX Scripting, Putty,Visio.

Confidential

Sr. Informatica Developer / Onshore coordinator

• Analyzingthe requirements and having discussion with business team to understand the requirements and prepare the design documents for the offshore development team
• Created the mapping design documents for business requirements also to help the team in their design process, involved in code reviews as the onshore lead in this project.
• Worked with various active transformations in Informatica PowerCenter like Normalizer Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, Sequence generator Transformation and Update Strategy Transformation.
• Extensively worked with various Active andPassive transformations.
• Extensively worked with Slowly Changing Dimensions(SCD) Type1, Type2, and Type3 for Data Loads
• Created job cycles from scratch using jil files via Autosys job scheduler
• Extensively worked with Incremental Loading using parameter files, mapping variables, and mapping parameters.
• Created and Documented ETL test plans, test cases, test scripts, expected results, assumptions and validations for unit, integration and system tests for mappings developed.
• Involved in post production support and monitoring the activity in various environments.

Environment: Informatica Power Center 7.1 (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Flat Files, Oracle 9i, UNIX Scripting, Putty.

Confidential

Jr. Informatica Developer

• Analyzingthe requirements and having discussion with business team to understand the requirements and prepare the design documents for the offshore development team
• Created the mapping design documents for business requirements also to help the team in their design process, involved in code reviews as the onshore lead in this project.
• Worked with various active transformations in Informatica PowerCenter like Normalizer Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, Sequence generator Transformation and Update Strategy Transformation.
• Extensively worked with various Passive transformations in Informatica PowerCenter like Expression Transformation, Sequence Generator, Sorter Transformation, and Lookup Transformation.
• Extensively worked with both Connected and Un-Connected Lookups and Look up Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations.
• Extensively worked with Incremental Loading using parameter files, mapping variables, and mapping parameters
• Extensively worked with Slowly Changing Dimensions(SCD) Type1, Type2, and Type3 for Data Loads
• Extensively worked with Incremental Loading using parameter files, mapping variables, and mapping parameters.

Environment: Informatica Power Center 7.1 (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Flat Files, Oracle 9i, UNIX Scripting, Putty.