SUMMARY

• 6+ years of experience in IT industry with strong background in Data Warehousing, Business Intelligence and ETL process using Informatica PowerCenter.
• Experience in Business Analysis and Data Analysis, User Requirement Gathering, User Requirement Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Experience in integration of various data sources with multiple Relational Databases like Oracle, SQL Server and worked on integrating data from flat files like fixed width and delimited.
• Well acquainted with Informatica Designer Components - Source Analyzer, Target Designer, Transformation developer, Mapplet and Mapping Designer.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected/ Connected Lookups, Stored procedure and Aggregators.
• Extensively used Informatica Repository manager and Workflow monitor.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Hands on experience in Performance tuning of sources, targets, transformations and sessions.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Having Strong hands on experience in extraction of the data from various source systems ranging from Mainframes like DB2, Flat files, etc. to RDBMS like oracle, SQL Server etc.
• Proficient in using Informatica Server Manager to create and schedule sessions and batches.
• Experience in PL/SQL programming (Stored Procedures, Functions and Triggers).
• Extensively used various Performance Tuning techniques to improve the session performance.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica PowerCenter.
• Strong experience in Extraction, Transformation and Loading data from various sources into Data warehouses and Data Marts using Informatica Power center (Repository Manager, Designer, Workflow Manager, Workflow monitor), Power Exchange, Power Connect as ETL tool on Oracle Database.
• Worked extensively with slowly changing dimensions (SCD Type 1,2).
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Worked on existing mapping for the performance tuning to reduce the total ETL process time.
• Extensively worked on SQL override in Source qualifier transformation for better performance.
• Hands on experience using query tools like SQL developer, PLSQL developer, Teradata SQL.
• Designed and developed stored procedures using PL/SQL and tuned SQL queries for better performance.
• Extensively used Informatica debugger to find out the problems in mapping. Also involved in troubleshooting and rectify the bugs.
• Have worked with JIRA tool to track the Development status and Bug tracking status for Project.
• Have used Jenkins tool for Informatica Build Deployment for Informatica code migration to QA and UAT and RT.
• Worked with version control tool - Tortoise SVN for promoting code changes to other environment within the project.

TECHNICAL SKILLS

ETL Tool: Informatica PowerCenter 10x, 9.6,9.0, SSIS, Talend

Bug Tracking Tool: JIRA tool: Jenkins

Operating System: MS-Windows, Mac OS, Linux, Unix, DOS

Testing Tool: Quick test Professional, Selenium, Firebug, HP QC

Database: Oracle 11g XE, SQL Server 2017, SSMS, SQL DEVELOPER.

Languages: SQL, PL/SQL. Java, Python

Version Control: Tortoise SVN

Others: Putty, FileZilla

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Technical Consultant

Responsibilities:

• Responsible for business analysis and requirement collection.
• Worked on Informatica Power center tools - Designer, Repository manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Involved in building the ETL architecture and Source to Target mapping to load data into data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Used various transformations like Filter, Expression, Sequence generator, Updated Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplet to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and Scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Designed Informatica design for full refresh and incremental load.
• Wrapped all the Informatica coding with ABC framework for Audit maintenance.
• Created separate mappings for incremental coverage to support other sectors.
• Used Jenkins tool to build, deploy and test this project.
• Used JIRA tool to Track bugs and for tracking project deadlines.
• During last stages of development and release time was involved in continuous build and continuous deployment phase.
• Developed complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Loaded Data into Oracle Tables using SQL Loader.

Tools used: Informatica Power center 9.6, Jenkins, JIRA, Oracle, Netezza.

Confidential

Technical Analyst

Responsibilities:

• Responsible for business analysis and requirement collection.
• Worked on Informatica Power center tools - Designer, Repository manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Involved in building the ETL architecture and Source to Target mapping to load data into data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
• Used various transformations like Filter, Expression, Sequence generator, Updated Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and Scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote Unix shell scripts and PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power center 10.x, 9.6, 9.0, Oracle DB, MS SQL Server, SQL Plus, SQL Developer, SSIS, SSMS.