SUMMARY:

• 7 years of experience in IT Industry and worked on Data Warehousing projects, Data Integration Projects and Data migration projects with development/Enhancement Projects and also have Production Support Experience.
• Strong experience with Informatica Power Center ETL 9X ETL Tool and Informatica B2B MFT Tool.
• Extensively worked with various Relational and non - relational sources and target systems including Teradata, SQLServer, Oracle, Flat files, XML files, SalesForce.Com (SFDC) etc.
• Extensively worked with cloud salesforce.com (SFDC) system as Source and target systems, SFDC source and Target transformation, Lookup transformations and using UPSERT logic with SFDC target.
• Expertise in identifying performance bottlenecks and optimizing performance with in Informatica mappings, sessions and workflows.
• Expertise with using Pushdown Optimization (PDO) technique for performance optimization.
• Strong experience in Data Warehousing concepts such as DWH, DataMart’s, Star Schemas, Snowflake schemas, Facts, Fact less facts, various Dimensions, SCD techniques, Dimension modeling (SCD) etc.
• Worked on Unix/Linux operating systems and experienced in writing shell scripting.
• Experience with developing slowly changing dimensions (SCD) type -1, 2, 3 and 4 mappings and various Change Data Capture (CDC) requirements for incremental data load process.
• Expertise in troubleshooting and analyzing issues/errors and providing resolutions accordingly.
• Extensively worked with XML transformations like XML Generator and XML Parser to transform XML files.
• Experienced using Control-M, Autosys and Tivoli Workload Scheduler (TWS), Maestro scheduling tools.
• Expertise in developing complex mappings with various Power Center transformations, Lookup, Router, Sorter, Aggregator, Joiner, Union, Update Strategy, Expression, Normalization, Transaction Control transformations etc.
• Expertise in developing reusable transformations, Mapplets, Workflows, worklets and sessions/tasks in Power Center Tool.
• Expertise in all phases of Project/Software Development Life Cycle phases (SDLC) from Requirements gathering/Analysis/Development & Unit testing/QA Support to Production Deployment. Knowledge transition to Support teams in various projects implemented.
• Experience with data modeling tools such as ERWIN and Microsoft VISIO
• Expertise in working with Business Analysts, Architects/Project members from different areas including technical and non-technical resources.
• Team and Independent Player with good Organizational and interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center (9X, 8X), Informatica B2B MFT Tool.

SSIS (SQL SERVER Integration service) Relational Database / Various Source types: Oracle, SQL Server, Teradata, SQL, DB2, Web service Consumer, Salesforce.Com (SFDC), Flat files, CSV files, XML Files

Operating Systems: Windows, UNIX, Linux

Data Modeling Tools: ERWIN, Microsoft VISIO

PROFESSIONAL EXPERIENCE:

Confidential, Woburn, MA

Sr. ETL Developer

Major Technologies used: Informatica PowerCenter 9X, B2B MFT Tool, Oracle, Teradata, SQL Server, DB2, SalesForceDotCom (SFDC).

Roles and Responsibilities:

• Responsible for Interacting with Business Analyst/Project Architect for understanding of requirements and analyze the requirements.
• Responsible for preparing Design documents (High Level Design document and Low level design document) and security and other compliance standard documents and also Prepared Unit test Plan which needs to be executed in Development environment after the code changes completed.
• Used to handle the group of people (offshore team) and perform lead role to make sure reaching deadlines and get the work done as per the time lines/phases.
• Used Informatica Power Center ETL tool for developing mappings/Mapplets and create sessions/tasks, workflows for integrating the data.
• Used Informatica B2B Data Exchange tool MFT the files from external venders to internal servers.
• Used Teradata utilities such as FastLoad, MultiLoad, Tpump, FastExport and Teradata Parallel Transporter (TPT).
• Used Pushdown Optimization (PDO) technique for performance optimization.
• Developed mappings for loading the data into Dimensional tables and fact tables.
• Developed mappings using various transformations Ex: Source, Target, Lookup, Filter, Router, Sorter, Aggregator, Joiner, Union, Update Strategy, Expression transformation, etc.
• Identified bottlenecks and performance tuned at source, target, mapping and sessions where bottle neck occurs. Used Partitioning technique and pushdown optimization for improving the performance.
• Perform code reviews and execute the unit test cases as per the UTP.
• Knowledge Transition to QA team for code changes which are migrating to QA Environment.
• Migration of code changes to QA environment and providing support till QA sign off.
• Trouble Shooting the issues/defects which comes during QA testing and fixing defects.
• Migration of code changes to PreProd/UAT environments, trouble shooting and fixing issues.
• Knowledge Transition to Production Support team for code changes which are migrating to Prod Environment and resolution to issues.
• Providing extended support during the production warranty period after the implementation and fix if any issues occur.

Confidential, NY City, NY.

Sr. ETL Developer

Major Technologies used: Informatica PowerCenter 9X, SQL Server Database, Salesforce SFDC, WSDL.

Roles and Responsibilities:

• Responsible for Interacting with Business Analyst/Project Architect for understanding of requirements and analyze the requirements.
• Responsible for creating Data profiling on physical data objects and co-ordinate with Data stewards and Business Analyst about various data issues, data cleansing or data standardization tasks which meets the Business requirement.
• Responsible for preparing Design documents (High Level Design document and Low level design document) and security and other compliance standard documents.
• Prepared Unit test Plan which needs to be executed in Development environment after the code changes completed.
• Prepared Data Flow Diagrams and ER Diagram which explains the process/application execution flow.
• Performed Lead role to handle offshore team to meet the deadlines and perform code reviews.
• Prepared Mapping specification document which explains source, target and transformation rules/Business logics which need to be applied.
• Developed SCD type 1, 2, 3 mappings to load the data from source to target, Dimension tables, Facts, etc.
• Developed mappings for integrating the data from various sources systems to enterprise Dataware house tables.
• Designed mappings using various transformations Ex: Source, Target, Lookup, Filter, Router, Sorter, Aggregator, Joiner, Union, Update Strategy, Expression transformation, etc.
• Identified bottlenecks and performance tuned at source, target, mapping and sessions where bottle neck occurs.
• Perform code reviews and execute the unit test cases as per the UTP.
• Knowledge Transition to QA team for code changes which are migrating to QA Environment.
• Migration of code changes to QA environment and providing support till QA sign off.
• Trouble Shooting the issues/defects which comes during QA testing and fixing defects.
• Migration of code changes to PreProd/UAT environments, trouble shooting and fixing issues.
• Knowledge Transition to Production Support team for code changes which are migrating to Prod Environment and resolution to issues.

Confidential

Sr. ETL Developer & Technology Lead

Major Technologies used: Informatica PowerCenter 9X, SSIS, Teradata, SQL Server Database, WSDL.

Roles and Responsibilities:

• While working with Allstate I did work on multiple projects, like migrating the code from different ETL tools (such as SSIS, ABInitio) to Informatica PowerCenter ETL tool.
• While migrating the code we used to Understanding the existing code and develop same business rules in informatica PowerCenter ETL tool and automate the jobs using TWS scheduling tools.
• Worked as Senior ETL Developer, SME and Onsite Coordinator with AFT Integration and EPC-SI integration teams.
• Played Project lead role by handling offshore team and dispatching the work to offshore team, get the task done on time.
• Worked with Business Analyst, Project Architect and other teams SA, SMEs at Project Requirement Phase to gather requirements, analysis and understanding of requirements.
• Based on Requirements I have prepared Conceptual Design, Detailed Design documents, UTP plan documents and also security related (SOX complains) documents.
• Responsible for Interacting with Business Analyst for understanding of requirements and analyze the requirements.
• Responsible for preparing Design documents (High Level Design document and Low level design document) and security and other compliance standard documents.
• Preparing Unit test Plan which needs to be executed after the code changes completed.
• Preparing Data Flow Diagrams and ER Diagram.
• Design and develop Data profiling, Scorecards, Mapplets, Rule, Mappings, workflows, Data Cleansing, Data Standardization process using IDQ Developer.
• Writing BTEQ queries and used Teradata utilities such as FastLoad, MultiLoad, Tpump, FastExport and Teradata Parallel Transporter (TPT).
• Used Pushdown Optimization (PDO) technique for performance optimization.
• Preparing Mapping specification document which explains source, target and transformation rules/Business logics which need to be applied.
• Designing Source, Target, Mapping, Sessions and Workflows using Informatica PowerCenter.
• Designing the mappings using various transformations Ex: Source, Target, Lookup, Filter, Router, Sorter, Aggregator, Joiner, Union, Update Strategy, Expression transformation, etc.
• Identifying bottle necks and performing Performance tuning at source, target, mapping and sessions where bottle neck occurs.
• Knowledge Transition to QA team for code changes which are migrating to QA Environment.
• Migration of code changes to QA environment and providing support till QA sign off.
• Trouble Shooting the issues/defects which comes during QA testing and fixing defects.
• Responsible for migration of code to Prod Environment (Live Deployment) and providing support for initial days.
• Knowledge Transition to Production Support team for code changes which are migrating to Prod Environment, possible failures and resolution to issues.

Confidential

Informatica Developer

Major Technologies used: Informatica PowerCenter 8X, SQL Server Database, WSDL.

Roles and Responsibilities:

• Prepared Mapping specification document which explains source, target and transformation rules/Business logics which need to be applied.
• Developed SCD type 1, 2, 3 mappings to load the data from source to target, Dimension tables, Facts, etc.
• Developed mappings for integrating the data from various sources systems to enterprise Dataware house tables.
• Designed mappings using various transformations Ex: Source, Target, Lookup, Filter, Router, Sorter, Aggregator, Joiner, Union, Update Strategy, Expression transformation, etc.
• Identified bottlenecks and performance tuned at source, target, mapping and sessions where bottle neck occurs.
• Perform code reviews and execute the unit test cases as per the UTP.
• Knowledge Transition to QA team for code changes which are migrating to QA Environment.
• Migration of code changes to QA environment and providing support till QA sign off.
• Trouble Shooting the issues/defects which comes during QA testing and fixing defects.
• Migration of code changes to PreProd/UAT environments, trouble shooting and fixing issues.
• Knowledge Transition to Production Support team for code changes which are migrating to Prod Environment and resolution to issues.