SUMMARY

• Around 8 Years of IT Experience in Analysis, Design, development, implementation and Testing of Data warehouse applications using Informatica as primary skillset.
• Demonstrated expertise in utilizing Informatica power center 10.x/9.x/8.x for developing the Data warehouse loads as per client requirement.
• Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse and Data Marts using Informatica Power Center tool (Repository Manager, Designer, Workflow Manager, Workflow Monitor, and Informatica Administration Console).
• Created complex mappings from varied transformations like Lookup, Sorter, Aggregator, Union, Rank, Normalizer, Update strategy and Router transformations in an efficient manner.
• Extracted Data from multiple operational sources and loaded into staging area, Data Warehouse and Data Marts using SCD (Type1/Type2/Type3) loads.
• Experience in deploying Informatica code using Informatica deployment groups, Import/Export option.
• Experience in all data processing phases, from the Enterprise Data Model, Dimensional Modeling, design and modeling Star & Snow flake schemas.
• Experience in implementing incremental loads and change data capture.
• Experience in integration of various data sources like Oracle, SQL server and flat files, Excel and Xml files. Strong experience in using SQL, PL/SQL Procedures/Functions.
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments.
• Experienced in working with various Scheduling tools like Tidal Enterprise Scheduler, Informatica Scheduler, Control - M, ESP and Crontab.
• Experience using Data Management Platform like Informatica IDQ development - Address Validation, Data Profiling, Cleansing, Parsing, Standardization, Label, Verification, Matching, Merging. Has good knowledge on Python scripting.
• Developed automated mappings and workflows using python script.
• An excellent team player in handling teams as well as an individual contributor with good communication and interpersonal skills. Quick learner and flexible to learn new technologies and their application in business solutions

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.X/9.X/10.X(Repository Manager, Designer, Workflow Monitor, Workflow Manager),Informatica Data Quality 10.0.

Databases: MS SQL SERVER 2008/2005, Oracle 10g/11g, 12c, Teradata 15,Netezza, DB2.

Data Modeling Tools: Erwin 4.5/3.5.2 (Star Schema Modelling, Snow Flake Modelling).

Operating systems: Windows 98//2000/XP/NT/Vista, Windows 7, UNIX.

Scheduling Tools: Crontab, Tidal, Control-M, ESP.

Programing Languages: C, SQL, PL/SQL.

Web Technologies: HTML, XML, Unix Shell scripting,Python scripting.

Other Tools: SQL Developer, Putty, Win SCP,Github.

PROFESSIONAL EXPERIENCE

Confidential, CT

Informatica Developer

Responsibilities:

• Involved in analyzing the business requirements and translating theRequirements into functional and technical design specifications. As part of it,created system design specification document, Technical design documentand STM documents.
• Worked on profiling the Data to understand the data quality issues.
• Interacted with Source system Business Analysts to understand and analyzebusiness processes across the source and target tables.
• Extracted the data from the operational databases into staging area and populated onto Data Warehouse.
• Extracted the data from different sources like Flat files, Mainframe datasets, XML files etc.,
• Developed Mappings, Mapplets, Transformations and Reusable transformations, Tasks, worklets,workflows by using PowerCenter Designer.
• Created Data load validation scripts as per the requirements.
• Scheduled and monitored the jobs based on business requirement inESP.
• Coordinated with the offshore team and made sure deliverables are met.
• Involved in code review for fellow team members.

Environment: Informatica Power Center 10.5.1, Informatica Data Quality 10.0, SQL Server 2008, DB2, Netezza, UNIX, Mainframe.

Confidential, Livonia, MI

Informatica Developer/Data Developer

Responsibilities:

• Involved in analyzing the business requirements and translating theRequirements into functional and technical design specifications. As part of it,created system design specification document, Technical design documentand STM documents.
• Interacted with Source system Business Analysts to understand and analyzebusiness processes across the source and target tables.
• Created DDL and DML scripts as per the requirements.
• Used stored procedures for extracting and loading the data into target tables and reporting views.
• Provided production support in diagnosing the issues, and provide a fix
• Resolving performance issues by understanding the bottles necks at variouslevels and tuning them for better performance.
• Scheduled and monitored the jobs based on business requirement in Control-M.
• Worked closely with BO developers to understand the Reporting needs and modify the views accordingly.
• Involved in code review for fellow team members.
• Production support - Involved in Production Support in a 24/7 environment and troubleshooting data quality and integrity issues.
• Extensively used performance tuning techniques to tune ETL jobs and attended Daily production support calls
• Responsible for monitoring production metrics, updating the production incident reports and submitting a summary report to management once each month.

Environment: Informatica Power Center 10.5.1, Informatica Data Quality 10.0, Oracle, SQL Server 2008, Teradata 15, UNIX.

Confidential

Responsibilities:

• Involved in analyzing the business requirements and translating the Requirements into functional and technical design specifications. As part of it, created system design specification document, Technical design document and STM documents.
• Interacted with Source system Business Analysts to understand and analyze business processes across the source and target tables.
• Used legacy systems, Oracle and SQL Server sources to extract the data and to load the data.
• Designed and developed initial, incremental and full data loads using Informatica.
• Created DDL and DML scripts as per the requirements.
• Used stored procedures for loading the data from stage to ODS.
• Provided production support in diagnosing session problems, fix mappings for minor business changes etc.
• Made use of post session success and failure commands in the session task to execute scripts for cleanup and updates.
• Resolving performance issues by understanding the bottles necks at various levels and tuning them for better performance.
• Scheduled and monitored the ETL jobs based on business requirement in Control-M.
• Used Data Management Platform like Informatica IDQ development for Address Validation, Data Profiling.
• Work closely with BA and Application developers to understand the source data, application structure to develop and create data warehouse process, which is consistent with the application screens.
• Created data flow diagram in visual paradigm.
• Worked closely with BO developers to understand the Reporting needs and modify the views accordingly
• Involved in code review for fellow team members.

Environment: Informatica Power Center 10.5.1, Informatica Data Quality 10.0, Oracle, SQL Server 2008,Teradata 15, UNIX.

Confidential, Troy, MI

Informatica Developer

Responsibilities:

• Involved in Dimensional modeling (Star Schema) of the Data warehouse.
• Extracted the data from the flat files and other operational databases into staging area and populated onto Data Warehouse.
• Created sources and targets scripts based on the required columns.
• Developed Mappings, Mapplets, Transformations and Reusable transformations, Tasks, worklets, workflows by using PowerCenter Designer.
• Used various transformations during mapping development like Unconnected and Connected lookups, Source Qualifier, Expression, Router, Filter, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Rank, Sorter, Normalizer, Transaction Control etc.
• Extensively used mapping parameters, variables, parameter files, user-defined functions in Informatica.
• Optimized Sources, Targets, Mappings, Transformations and Sessions to increase session performance.
• Configured sessions with email when failure and configured and used command task and Decision task.
• Responsible for operational/production support for monitoring and analyzing the session failures and to perform corrective actions.
• Created DDL scripts, indexes on database tables (SQL) and tuned the queries to improve the performance, Performed Unit Testing and documented the results
• Used stored procedures to drop and create indexes before and after loading data into targets
• Scheduled and monitored automated weekly jobs under UNIX environment.
• Performed Unit testing and participated in integration and User Acceptance testing

Environment: Informatica Power Center 9.5.1, Oracle, SQL Server 2008, UNIX.

Confidential

SQL Developer/Technical Consultant

Responsibilities:

• Involved in Requirements Gathering and analysis.
• Understanding and Collecting requirements from Business users and developedSQLqueries or PL/SQLprocedures.
• Oversaw installations, upgrades ofSQL2008,SQL2005 toSQL2008.
• Created tables and views.Creating complex views, materialized views on multiple tables as per customer requirement.
• Have done Code reviews and optimizations
• Monitor and recommend changes as required for all PL/SQLpackages and stored procedures.
• Trained and mentored junior associates in their day-to-day work
• Responsible for review of unit test cases and unit testing
• Involved in integration and Unit testing
• Responsible for Client Co-ordination.