SUMMARY

• Over 6 plus years of Professional experience as Datawarehousing specialist with experience in the total life cycle of ETL including Requirements Analysis, Solution Architecture, Solution Design, Implementation, Integration Testing and Maintenance, Support and Documentation.
• Experience and Expertise in Data Architecture, Extraction, Transformation and Loading (ETL) process Using Informatica PowerCenter 9.5.1/9.1.0/8.6/7.1.1, Informatica Data Quality 9.1.0 and Informatica PowerExchange.
• Experience with Designer, Source Analyzer, Target Designer, Transformation Developer, Mapplets Designer, Mapping Designer, Workflow Manager and Workflow Monitor in Informatica.
• Extensively worked on transformations like Source Qualifier, Filter, Sorter, Joiner, Router, Ranking, Connected and Unconnected Lookup, Aggregator, Normalizer, Update Strategy, Sequence Generator, Expression, Stored Procedures, and have implemented SCD (Slowly Changing Dimensions SCD1, SCD2, SCD3, SCD4) mappings.
• Good knowledge on writing the PL/SQL Scripts like Procedures, Triggers and Functions.
• Expert in using Debugger in Informatica Designer tool to troubleshoot mappings.
• Extensively worked on performance tuning of Mappings and Sessions by using Session Partitions and Pushdown Optimization.
• Designed complex ETL mappings, reusable transformations using Regular Expressions, Dynamic Lookups, and Update Strategies for slowly changing dimensions, critical performance tweaking stages with partitioning, persistent cache, and extensive use of mapplets for common sub routines.
• Expertise in OLAP/OLTP System Study, Analysis and ER Modeling, developing database Schemas like Star Schema, Snowflake Schema, Conforming Dimensions and Slowly Changing Dimensions used in relational, dimensional and multi - dimensional modeling.
• Good understanding of relational database management systems like Oracle, Teradata, Netezza, DB2, SQL Server and worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems.
• Experience with design and implementation of Informatica Data Quality (IDQ v9.1) applications for the business and technology users across the entire full development life-cycle.
• Expert in Oracle 11g/10g, DB2, SQL Server 2008/2005/2008, SQL, PL/SQL Stored procedures, functions, and exception handling using PL/SQL.
• Extensively used the Teradata utilities like MLOAD, FLOAD, TPUMP and FASTEXPORT to improve the load performance.
• Proficient in Analyzing Business processes requirements and translating them into technical requirements.
• Excellent team player and can work on both development and maintenance phases of the project.
• Highly skilled in providing instantaneous and workable solutions to business problems.
• Excellent communication, interpersonal skills, enthusiastic, knowledge-hungry self-starter, eager to meet challenges and quickly assimilate latest technologies concepts and ideas.
• Experience with Sales, Retailing and Healthcare Domains.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 7.1/8.x/ 9.1.0/9.5.1, Informatica Data Quality 8.6, Informatica Developer 9.x, Informatica Power Exchange 9.x, Informatica Analyst 9.x, IBM Netezza.

Databases: Teradata TD13/TD12, Oracle 11g/10g/9i, Netezza.

Languages: SQL, PL/SQL, C.

Operating systems: Windows XP/Vista/7, UNIX (Sun-Solaris, HP/UX), LINUX.

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

Sr. Informatica Developer

Responsibilities:

• Responsibilities include meeting with business stakeholders and other technical team members to Gather and analyze application requirements.
• Involved in development of Logical and Physical data models that capture current state Developed and tested all the Informatica Data mappings, sessions and workflows - involving several Tasks.
• Responsible for designing, testing, deploying, and documenting the data quality procedures and their outputs using Informatica Data Quality (IDQ).
• Analyzed data throughout each project phase, and provide relevant outputs and results from the data quality procedures, including any ongoing procedures that will run after project end.
• Partnered with data analyst’s to provide summary results of data quality analysis, which will be used to make decisions regarding how to measure business rules and quality of the data.
• Worked on source analyzer, Target Designer, Mapping and Mapplet Designer, Workflow manager and Workflow Monitor.
• Created mappings for initial load in Power Center Designer using the transformations Expression, Router and Source Qualifier.
• Created complex mappings for full load into target in Power Center Designer using Sorter, Connected Lookup, Unconnected Lookup, Update Strategy, Router, Union etc.
• Created Mapplets to reuse all the set of transformations for all mappings.
• Created work flows and sessions for each mapping that we are extracting from source systems to staging area; staging area to target.
• Responsibilities include creating the sessions and scheduling the sessions.
• Created various tasks to give various conditions in the workflows.
• Extensively created Re-usable Transformations and Mapplets to standardized Business logic.
• Mappings, Mapplets and Sessions for data loads and data cleansing. Enhancing the existing mappings where changes are made to the existing mappings using Informatica Power center.
• Involving in extracting the data from Oracle and Flat files. Developed and implemented various enhancements to the application in the form of Production and new production rollouts.
• Worked on identifying facts, dimensions and various other concepts of dimensional modeling which are used for data warehousing projects.
• Extensively worked on confirmed Dimensions for the purpose of incremental loading of the target database.
• Worked on Fast Load, MultiLoad, TPUMP and FastExport loading techniques through Informatica into Teradata.
• Performed Unit testing on the Informatica code by running in the debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for the optimum performance.
• Created parameters and variables for the reusable sessions.
• Analyzed the various bottlenecks at source, target, mapping and session level.
• Tuning of the mappings and SQL Scripts for a better performance.
• Designed the ETL processes using Informatica to load data from DB2, SQL Server and Flat files to the Target Database.
• Responsible for providing technical assistance for the design and execution of ETL projects to onshore and offshore developers.

Environment: Informatica Power Center 9.1/Power Exchange/Informatica Cloud, IDQ 9.1, Teradata, Oracle 11g, PLSQL, DB2, XML, MS SQL Server 2005,SQL* PLUS,MS Excel, UNIX(AIX), UNIX Shell.

Confidential, Miamisburg, OH

Informatica Developer

Responsibilities:

• Interacted with the Functional Analysts to understand the process flow and the business.
• Involved in gathering the business requirements from Business Analyst.
• Analyzing Source to Target mapping Excel document.
• Coordinating the team and assigning dependencies tasks to team.
• Created Data Flow Mappings to extract data from source system and Loading to staging area.
• Analyzed the AR data and developed the code to extract the data for the AR module and implemented in the Informatica.
• Extensively worked on Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Worked on various tasks like Session, E-Mail task and Command task.
• Used mapplets, parameters and variables in mappings as per the requirement.
• Used Informatica Data Quality (IDQ) for data quality, integration and profiling.
• Worked on Informatica Scheduler for scheduling the delta loads and master loads.
• Used versioning and shared folders for better control on Informatica jobs among the team and across different projects.
• Worked on slowly changing dimension Type2.
• Involved in performance tuning of the process at mapping, session, source level and at target level.
• Involved in testing by using Informatica workflow manager and monitor, etc. and extensive testing on log files to detect errors.
• Tested different data load databases by comparing source and target table counts and tested Informatica data loads from database to database.

Environment: Informatica Power Center 9.5.1, Oracle, DB2, SQL Loader.

Confidential, Houston,TX

Informatica Developer

Responsibilities:

• Designed and Implemented data profiling, cleansing, name-address enrichment and matching merging solutions using Informatica Data Quality (IDQ).
• Created mappings, mapplets, sessions, worklets and workflows for jobs in Informatica.
• Implemented shell scripts to run the jobs in UNIX through Informatica.
• Worked in changing the existing development code according to the new requirement.
• Implemented shell scripts to capture the unique process ids for job which are initiated by Informatica.
• Implemented shell scripts to kill the unique process ids for job which are initiated by Informatica.
• Accessed Informatica data director and DT Studio projects created well versed DT Studio scripts which are uploaded in server for usage of modifying existing Informatica schemas using unstructured data transformation and did governance using Informatica data director tool.
• Created several Design patterns, Standards documents, ETL strategies explaining all above mentioned processes, used DT Studio Data transformation studio authoring and created scripts.
• Developed complex PL/SQL procedures and packages as part of Transformation and data cleansing
• Performed unit testing by running Informatica sessions.
• Created structures for new Work Lets in Power Center application
• Develop reusable modules to transform data into a generic output.
• Design and develop solutions for new strategic initiative
• Assisted other developers and other groups in identifying and correcting issues with data and/or programming

Environment: Informatica Power Center 8.6/9.1, Oracle, Teradata, Flat Files, UNIX, shell scripting, Cognos.

Confidential, Irving, TX

Informatica Developer

Responsibilities:

• Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager and Informatica Power Exchange.
• Worked with Data modeler, according to changes in the model worked on changes in the Informatica.
• Imported the source definition into source analyzer from oracle and for DB2, VSAM files used Informatica power exchange in the source analyzer.
• Imported the Target definitions into Target Designer from oracle and for DB2, VSAM files used Informatica power exchange in the Target Designer.
• Working with Business Analyst, Translating Business requirements into Functional requirements.
• Developed and Tested new mappings.
• Created and configured the sessions for work flow.
• Created and maintained parameter files for workflows in the UNIX and CVS.
• Worked on Joiner, Aggregator, Update Strategy, Rank, Router, Lookup (static and Dynamic), Sequence Generator, Filter, Sorter, Source Qualifier.
• Implemented slowly changing dimensions - Type I, II &III in different mappings as per the requirements.
• Created connections for relational, Non-relational and applications in the workflow manager.
• Created mappings using Reusable Transformations.
• Migrating mappings, workflows and parameter files from development to production.
• Developed PL/SQL scripts line packages and store procedures for data updates.

Environment: Informatica Power Center 8.1/8.5/8.6, Informatica Power Exchange 8.1/8.5/8.6, Oracle 10g, DB2, Flat files, UNIX, shell scripting, SQL Developer, Windows XP.

Confidential

Informatica Developer

Responsibilities:

• Creating prototype of SCD type 2 mapping which maintain history and also have applied PDO to improve performance applying strategic rules
• Writing the Unit test cases.
• Ownership of modules from development to unit testing.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Implemented performance tuning to provide efficiency and performance.
• Involved in creating parameter files and maintaining the same for all environments(dev, cit, sit and uat)
• Maintained static scripts throughout the SDLC.

Environment: Informatica PowerCenter 7.1/6.1,SQL, PL/SQL, Windows, UNIX, PL/SQL Developer.