SUMMARY

• Over 12.5+ years of IT experience and extensive ETL tool experience using, Informatica Power Center 9.x/8.x, Informatica MDM, Informatica Cloud(SalesForce), Informatica IDQ, SSIS with strong working experience in Oracle SQL,PL/SQL,Unix, Autosys
• Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM (Siperian)
• Responsible for all phases of the System Development Life Cycle (SDLC), from Requirement gathering, Analysis, Design, Development, Production in various industries viz., Insurance, Telecom, Banking
• Strong understanding of the principles of Data warehousing Fact Tables, Dimension Tables, Star Schema and Snowflake models
• Proficient in the Integration of various data sources like Netezza, SQL server, Oracle10g/9i, Flat Files into the staging area, Data Warehouse, Data Mart and SalesForce
• Extensively worked with Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier
• Expertise in developing Mappings and Mapplets, Sessions, Workflows, Worklets and Tasks using Informatica Designer, Workflow Manager and Batch processes using PMCMD command
• Expertise in unit testing of Informatica mappings using debugger
• Experience in Performance Tuning and Debugging of existing ETL processes
• Excellent communication skills, good organizational skills, self - motivated and extremely hardworking with ability to implement business concepts quickly and efficiently
• Excellent communicator with exceptional team-building skills

TECHNICAL SKILLS

Data Warehousing ETL: Informatica PowerCenter 9.x/8.x/7.x/6.x/5.x, Informatica MDM, Power Exchange 8.0, SSIS, Pentaho Data Integration(kettle)

Databases: Netezza, Oracle 11g/10g/9i/8.0, MS SQL Server 7.0/2000/2005/2008 , Teradata, MySQL

Programming: Unix, Shell Scripting, SQL/ PLSQL (MS SQL Server,Oracle,Netezza,Teradata), Python

Tools: TOAD, SQL*Plus, Excel, Word, Autosys, SalesForce, Visual Cron

Operating Systems: Linux, UNIX, Win 95/NT/98/2000/XP

PROFESSIONAL EXPERIENCE

Confidential

Senior Solution Architect

Hardware/Software: Informatica Power Center 9.5.1(Repository Manager, Designer, Workflow Manager, Workflow Monitor, Repository Administration Console), Informatica Cloud, SQL server, Visual Cron, Redshift.

Responsibilities:

• Serve as lead Solution Architect during Discovery and Build phases of Customer Data Platform (CDP) implementations as well as other data driven solutions
• Interface with client’s technical and business teams to design high-level and component architecture for Marketing Services solutions spanning
• ETL and data processing (including data migration, integration, and curation) Data engines and storage, data availability and access software integrations, Martech/Adtech tools and integrations
• Experience with Informatica cloud integration with SalesForce using cloud connectors
• Worked with ETL Developers in creating External Batches to execute mappings, Mapplets using Informatica workflow designer to integrate Shire’s data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.
• Design and schedule ETL and data processing using various tools like informatica cloud, SSIS, Kettle(pentaho), Visual Cron and databases
• Engage Solution Engineers (e.g., Cloud Engineers) and other domain-specific SMEs (e.g., Adobe Architects) to support solution design and execution when needed
• Lead technical resource planning and level-of-effort estimation to support project scoping, pricing and planning
• On-board and manage developers in building designed solutions; work with Functional Project Manager (PM) to remove “blockers” as needed to deliver project in timely manner with high quality
• Coordinate with our Functional PMs to communicate project status, risks and issues to clients, Confidential account teams, and Marketing Services leadership as appropriate
• Coordinate Testing/SIT/UAT, depending on project scope and team structure

Confidential

ETL Technical Analyst

Hardware/Software: Informatica Power Center 9.5.1(Repository Manager, Designer, Workflow Manager, Workflow Monitor, Repository Administration Console), Netezza, Teradata, Oracle Exadata and Python scheduling

Responsibilities:

• Involved directly with Business in Requirement gathering, participated in design process
• Developed numerous Informatica mappings involving complex logics to pull data from various source systems
• Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM
• Experience working on Informatica IDQ as part for data quality process initiative and got involved from POC stage
• Implemented code using various Informatica Transformations like Aggregator, Expression, Filter, Sequence Generator, Update Strategy, Source qualifier, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations
• Worked on various source sytems like flat file, Netezza, Teradata and Oracle
• Implemented Informatica Partitioning and Push down optimizations to improve the performance of the code
• Created view over data mart layers for downstream usage
• Developed mapplets and reusable transformations to reduce the redundancy of transformation usage
• For the migration project, identified the list of codes to be moved from Informatica 8.6 to 9.1 and list of tables to be moved from Netezza to Oracle Exadata. Developed codes and there were many compatibility issues because of difference in version and database which all has been resolved and successfully migrated
• Involved in major performance tuning the Sources, Targets, Transformations and Mapping to remove bottlenecks for better performance

Confidential

ETL Technical Analyst

Hardware/Software: SSIS 2010/2012, Informatica Power Center 9.1(Repository Manager, Designer, Workflow Manager, Workflow Monitor, Repository Administration Console, MDM), MS SQL Server and Autosys Scheduling

Responsibilities:

• Involved in requirement gathering from business analyst, to understand the Business Requirements and Business Rules Subjected to Business
• Experience working on Informatica MDM to do data lineage, design, develop, test and review & optimize Informatica MDM (Siperian)
• Worked on development and enhancements of Informatica mapping and SSIS package for Data warehousing projects using snowflake models
• Worked on conversion from SSIS package to Informatica
• Worked with SSIS tool in developing packages to extract and load the data from flat files, MS SQL server into MS SQL Server database
• Developed packages using control task, data flow task, recursive for loop function, lookups and Joins
• Involved in Performance Tuning of SQL Queries, Sources, Targets and packages by identifying and rectifying performance bottlenecks.
• Created pre-session and post session procedures, cursors to make complex updates on database
• Tuned the Sources, Targets, Transformations and Packages to remove bottlenecks for better performance.
• Migrated Packages, autosys components from development to testing and then to Production environments
• Created deployment groups, migrated the code into different environments.
• Worked closely with reporting team to generate various reports

Confidential

ETL / Informatica Onshore Lead

Hardware/Software: Informatica Power Center 9.1(Repository Manager, Designer, Workflow Manager, Workflow Monitor, Repository Administration Console), Netezza, Toad 10.6, UNIX, Autosys scheduling

Responsibilities:

• Involved from initial stage of requirement gathering, to understand the Business Requirements and Business Rules Subjected to Business.
• Prepared ETL Specifications to help develop mapping.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files, Oracle into Oracle database.
• Implemented code using various Informatica Transformations like Aggregator, Expression, Filter, Sequence Generator, Update Strategy, Source qualifier, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed SQL overrides in Source Qualifier/Lookup according to business requirements.
• Developedmappings/Reusable Objects/mappletsby using mapping designer, transformation developer and mapplet designer, since different datatype conversions have to be dealt multiple times which are similar and also most of the lookups have been similar
• Worked with different caches in optimizing the transformations suchas Index cache, Data cache and Lookup cache (Static, Dynamic, Persistence and Shared).
• UsedInformatica Power Center Workflow managerto create sessions, batches to run the mappings.
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Created pre-session and post session scripts using UNIX/PL-SQL.
• Tuned the Sources, Targets, Transformations and Mapping to remove bottlenecks for better performance.
• Migrated mappings, sessions, and workflows from development to testing and then to Production environments
• Created deployment groups, migrated the code into different environments.
• Worked closely with reporting team to generate various reports

Confidential

ETL / Informatica Developer

Hardware/Software: Informatica Power Center 8.6(Repository Manager, Designer, Workflow Manager, Workflow Monitor, Repository Administration Console), Oracle 10g, Teradata, Toad 9.5, Delimited Flat Files, UNIX Shell Programming

Responsibilities:

• Interacted with Business Analysts to understand the requirements.
• Prepared HighLevel Design documents according to the Functional Specification document to help in development.
• Maintained Technical specification documents according to the Source to Target mapping documents.
• Prepared ETL Specifications to help in developing mappings.
• Used InformaticaPowerCenter 9.1 forextraction, loading and transformation(ETL) of data into the target systems.
• Worked on Informatica Power Center tools like Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.
• Created mappings in PowerCenter Designer usingAggregator, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, Source Qualifier and Stored procedure transformations.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
• Tuned the Sources, Targets, Transformations and Mapping to remove bottlenecks for better performance.
• Have monitored the jobs in QA environment for shakeout purpose.
• Migrated mappings, sessions, and workflows from development to testing then to Prod environments
• Documented the process for further maintenance and support
• Worked on a module for integrating informatica with SalesForce
• Developed Reusable components in Informatica which helps for other projects to use the reusable components for with overriding properties
• Automated the process to monitor the source and target count difference on daily basis

Confidential

Informatica Developer

Hardware/Software: Informatica Power Center 8.1, oracle 9i, Unix Shell scripts

Responsibilities:

• Data Analyzing and Data Profiling of the source data.
• Interacted with business analysts, data architects, application developers to develop a data model.
• Upgrade of Data warehouse tools Informatica
• ETL development and automation of complete process.
• Understanding Business needs and implementing the same into a functional database design.
• Optimizing the mappings by changing the logic to reduce run time.
• Designing and Implementing the Data mart access methods on different tools and Data mart.
• Documented the process for further maintenance and support.
• Migrated mappings, sessions, and workflows from development to testing then to Production environments
• Contributed to development effort and served as key technical resource.
• Worked closely with reporting team to generate various reports.