SUMMARY

• IT professional with 8+ years of experience in Data Warehousing using Informatica Power Center 9.x/8.x/7.x.
• Strong working experience with various clients which includes Finance, Pharma, Telecom, Retail andBanking related industries.
• Excellent analytical skills in understanding the client systems and organizational structure.
• Heavily involved in complete life cycle of enterprise data warehouse.
• Experienced in OLTP/OLAP system study, analysis & reviewing of ER modeling, Database schemas like Star schema and Snowflake schema used in relational and multidimensional modeling by using MS Visio.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De - normalization Concepts.
• Ability to write complex SQL needed for ETL jobs and analyzing data, proficient with databases like Oracle 12i/11g/10g/9i, SQL Server 2012/2008/2005,Teradata,My Sql, DB2, Flat Files, Sybase, COBOL files and XML files.
• Worked on Dimension modeling to identify facts and dimension tables.
• Developed complex mappings by using various transformations like Unconnected/ Connected lookups, Router, Filter, Expression, Sorter, Aggregator, Joiner, Union, Update Strategy and rarely used transformations like Java, Stored procedure, etc.
• Provided high level optimization ideas to other ETL team members to improve code performance.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques, pushdown optimization and also identifying performance bottlenecks.
• Experience in doing Database level Query Performance Tuning.
• Experience in working with Teradata utilities - BTEQ, M-Load, F-Load, TPT & Fast Export.
• Good exposure to Development, Testing, Debugging, Implementation, Documentation, End-user training and Production support.
• Expertise in Unit Testing, Integration Testing, System Testing and Data Validation for developed Informatica Mappings.
• Research oriented, raise issues upfront and address them as soon as they have been identified.
• Experienced in doing Error Handling and Troubleshooting using various log files.
• Experienced in using Batch, Perl and UNIX shell scripts.
• Experience in using different scheduling tools - Control M, Autosys, Maestro & Informatica Scheduler.
• Experience in Implementing DWH Projects using both Water fall & Agile methodologies.
• Experience in using Agile tools like - Rally & Jira.
• An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hardworking and high level of motivation. A quick learner with an aptitude for taking responsibilities.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6.1/9.5/9.1/8.6.1/8.5/8.1/7.x

Data Bases: Oracle 12i/11g/10g/9i, MS SQL Server 2008 and DB2

Languages: SQL, PL/SQL, XML, UNIX Shell Scripting

Modeling: Erwin and MS-Visio, ER Model, Dimensional Modeling,Star Schema Modeling,Snowflake Schema

Scheduling Tools: Control-M, Autosys, Maestro, Informatica Scheduler

Database Connecting Tools: Toad, SQL Developer, Sql Assistant and Putty, Win SCP

Operating Systems: Windows and Unix / Linux

PROFESSIONAL EXPERIENCE

Confidential, Quincy, MA

Sr. Informatica ETL Consultant / Analyst

RESPONSIBILITIES:

• Involved in the Analysis of Physical Data Model for ETL mapping development and the process flow diagrams.
• Created and maintained metadata and ETL documentation that supported business rules and detailed source to target data mappings.
• Designed data extraction, transformation, clean and load using Informatica 9.6.1/9.5.1 for the enterprise Data Warehouse environment.
• Used Informatica transformations such as the Source Qualifier, Aggregators, and Connected & Unconnected lookups, Filters, Sequence Generator and Stored Proc. etc.
• Created sessions (Sequential, Parallel) to run the mappings.
• Created mapplets and reusable transformations to use across different mappings.
• Created Stored Procedures in PL/SQL for various needs at source level.
• Maintained Informatica Standards & Procedures.
• Created complex mappings to maintain history using SCD 1 & SCD 2.
• Handled incremental data using CDC concept.
• Implemented various performance tuning techniques at Informatica level to increase the throughput by finding out the bottlenecks.
• Involved in Regression testing for Informatica upgrade from 9.5.1 to 9.6.1
• Involved in doing Database tuning for the queries written at override level in Informatica.
• Involved in doing Unit Testing & Creating Unit Test Cases.
• Experienced in working with QA team for getting done the QA testing
• Created Migration templates for getting done the code migration with ETL Admin across different repositories.
• Involved in creating technical design documentaions for the dev work done.
• Good experience in managing the task using Jira & attending scrum meetings.

ENVIRONMENT: ETL/Informatica Power Center 9.6.1/9.5.1, Oracle12i, DB2 BLU, SQL, PL/SQL, XML, Flat files, UNIX, Toad, SQL Developer, Maestro, DB2, Perl, Putty, Winscp, Windows.

Confidential, Wisconsin

Sr. ETL Informatica Developer

RESPONSIBILITIES:

• Developed internal and external Interfaces to send the data in regular intervals to Data warehouse systems.
• Extensively used Power Center to design multiple mappings with embedded business logic.
• Involved in discussion of user and business requirements with business team.
• Performed data migration in different sites on regular basis.
• Involved in upgrade of Informatica from 9.1 to 9.5.
• Created complex mappings using Unconnected Lookup, Sorter, and Aggregator and Router transformations for populating target tables in efficient manner.
• Attended the meetings with business integrators to discuss in-depth analysis of design level issues.
• Involved in data design and modeling by specifying the physical infrastructure, system study, design, and development.
• Extensively involved in performance tuning of the Informatica ETL mappings by using the caches and overriding the SQL queries and also by using Parameter files.
• Developed complex SQL queries to develop the Interfaces to extract the data in regular intervals to meet the business requirements and extensively used Teradata Utilities like M - load, F- Load, TPT, BTEQ and Fast Export.
• Analyzed session log files in session failures to resolve errors in mapping or session configuration.
• Written various UNIX shell Scripts for scheduling various data cleansing scripts, loading process and automating the execution of maps.
• Created transformations like Expression, Lookup, Joiner, Rank, Update Strategy and Source Qualifier Transformation using the Informatica designer.
• Created mapplet and used them in different mappings.
• Worked on Flat Files and XML, My Sql, Oracle as sources.
• Written PL/SQL Procedures and functions and involved in change data capture (CDC) ETL process.
• Implemented Slowly Changing Dimension Type II for different Dimensions.
• Involved in Informatica, Teradata and oracle upgrade process and testing the environment while up gradation.
• Worked with Informatica version Control excessively.
• Experience in using SVN as version control for migration.
• Written Unit test scripts to test the developed interfaces.
• Managed enhancements and coordinated with every release with in Informatica objects.
• Provided support for the production department in handling the data warehouse.
• Worked under Agile methodology and used Rally tool one to track the tasks.
• Written thorough design docs, unit test documentation, Installation and configuration guide documents.
• Performed bulk data imports and created stored procedures, functions, views and queries.

ENVIRONMENT: Informatica Power Center 9.6.1/9.5.1, Teradata 14/12, Oracle 10g, My Sql, XML, Flat Files, Sql Assistant, Toad, PL/SQL, Unix shell scripting, Cognos, SVN, Windows 7.

Confidential, Woonsocket, RI

ETL/ Informatica Developer

RESPONSIBILITIES:

• Worked with Business Analyst to gather business requirements and involved in weekly team meetings.
• Worked on different data sources such as Oracle, XML, DB2, Sybase and Flat files.
• Involved in Creating the Dimensions, Facts, Mappings &Transformations, Validating the Mappings, Generating & Loading the Data.
• Worked extensively on different types of transformations like Source qualifier, Expression, Filter, Aggregator, Rank, Lookup, XML, Stored procedure, Sequence generator and Joiner.
• Implemented complex mappings such as Slowly Changing Dimensions (Type II) using Flag.
• Developed stored procedures and complex packages extensively using PL/SQL.
• Created shell scripts for utilizing UNIX utilities in users applications, file conversions & migrations
• Involved in Optimizing and Performance tuning logic on targets, sources, mappings, and sessions to increase the efficiency of session.
• Scheduled Workflows using Control - M application.
• Used SQL Override and reduced the number of transformations used in the mappings and improved the performance of the sessions.
• Involved in Unit Testing of code which I developed and supported System Integration Testing and UAT Testing.

ENVIRONMENT:Informatica Power Center 9.1, Oracle 11g, Sybase, DB2, Teradata, Control-M, UNIX Shell Scripting, Windows, Red hat Linux.

Confidential, Dallas, TX

Sr. Informatica Developer

RESPONSIBILITIES:

• Involved with Business Analyst while gathering Business requirements and translate into technical requirements.
• Involved in Modelling review sessions.
• Developed Mapping by using various transformations to suit the business user requirements and business rules to load and eliminate unrequired data from, Oracle and other data sources into Sybase target.
• Expertise in debugging and production support.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Control, Command, Decision, Session in the workflow manager.
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for cleanup and update purposes extensively worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet Designer.
• Used transformations like Joiner, Expression, Connected, Unconnected lookups, Filter, Aggregator, Stored Procedure, Rank, Update Strategy, Router, Sorter, Sequence generator etc.
• Involved in Debugging & error handling.
• Involved in data quality profiling, standardization and testing.
• Monitored daily loads and provided on call production support (L2) during data Loads.
• Involved in preparing Migration documents for migrating repository objects, and scripts from development environment to QA/production environment.
• Extensive experience in troubleshooting and solving migration issues and production issues.
• Troubleshooting in multi-dimensional universe and reports in SAP Business Objects Environment.
• Creating Change Control Requests as required by assigned projects and ensuring end to end extensive support as Data Analyst and address overall data quality.

ENVIRONMENT:ETL/Informatica Power Center 8.6.1/9.1.1, Oracle11g, Sybase, PL/SQL, XML, Flat files, UNIX, Toad, XML files, Perl, Shell Scripting, HPQC, Red hat Linux

Confidential

ETL Informatica Developer

RESPONSIBILITIES:

• Worked with ETL Architects to understand the requirements for enhancements & Improvements.
• Extensively worked with Informatica Power Center and options available in to improve the performance of existing Informatica objects.
• Creating mappings, session, workflows, worklets for transforming the data.
• Creating Mapplet for re using the logic.
• Created Database Triggers, Stored Procedure, Functions and Packages
• Optimized queries using rule based & cost based approach.
• Used Teradata Loaders for data loading.
• Various Performance and Tuning techniques used to improve the load.
• Involved in Testing the Informatica mappings and creating Unit Test Plans.
• Involved in solving the Trouble tickets raised by business.
• Involved in supporting data warehouse environments making sure all loads are going fine as per BAU.

ENVIRONMENT:Informatica Power Center 7.1.1/8.1.1, Oracle, Flat Files, XML, My Sql, Teradata 12, Unix, Putty, Windows XP, AOTS.