SUMMARY

• 8+ years of extensive experience in design, development, Implementation & maintenance of Informatica ETL processes, OLTP & Data Warehouse systems, Business Intelligence and Enterprise Application Integration.
• Solid expertise in Data Extraction, Data Migration, Data Transformation and Data Loading using ETL process in Informatica Power Center 10.x/9.x/8.x/7.x.
• Experience in all the phases of life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Proficient in data modeling for OLTP relational databases and Data warehouse applications using Ralph Kimball and Bill Inman design principles including Facts and dimensions tables, Slowly Changing Dimensions (SCD) and Dimensional Modeling - Star and Snow Flake Schema.
• Proficient in designing and developing Data Marts in a data warehouse for business subject areas.
• Expertise in developing Master Data Management solutions using Informatica MDM. Proficient in configuring and creating Landing, Staging and Base tables in Informatica MDM Hub.
• Expertise working with Informatica MDM components Hub Console, Hub Store, Hub Server and Cleanse Match Server used in building and administering MDM solution.
• Experience working with Informatica Data Director (IDD) for implementing data governance solution for MDM applications.
• Experience in integration of various data sources like Oracle, Teradata, DB2, Sybase, SQL server, MS Access and non-relational sources like Flat files and XML files into staging area.
• Worked on Data Profiling using IDE-Informatica Data Explorer and IDQ-Informatica Data Quality to examine different patterns of source data. Proficient in developing Informatica IDQ transformations like Parser, Classifier, Standardizer and Decision.
• Experience in identifying bottlenecks in ETL Processes and Performance tuning of applications using Database Tuning, Partitioning, Index Usage, and Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning.
• Solid experience with Informatica PowerCenter Data Validation client for Unit testing ETL mappings and transformations.
• Expertise in implementing Change Data Capture (CDC), Operational Data Store for real-time data (ODS), Incremental extracts and slowly growing target for data warehouses.
• Strong SQL, PL/SQL, T-SQL programming skills in Oracle 12c/11g/10g, SQL Server 2012/2008/2000 , Teradata 14/13/12 and DB2 databases. Proficient in writing Packages, Stored Procedures, Triggers, Views, Indexes and query optimization.
• Expertise in deploying and maintaining Informatica ETL code in Production environment.
• Experience in designing and developing B2B transformations for EDI and other formats using Informatica B2B Data Exchange.
• Extensive experience with Teradata SQL Assistant and Teradata Load/Unload utilities like TPUMP, Fast Export, Fast Load, MultiLoad and BTEQ.
• Experience with issue and project management tool JIRA to track defects. Solid experience in project documentation including Technical specifications and Technical Design Documents (TDD). Extensively involved in Quality Assurance, bug fixing and testing. Prepared user manuals, presentations and trained users and operators.
• Strong trouble-shooting, problem solving, analytical and design skills combined with effective communication, professional attitude, strong work ethic and interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 10.x/9.x/8.x/7.x/6.x/5.x / Power Mart / Power Connect, Workflow Manager, Workflow Monitor, Designer, Server Manager, Repository Manager.

Data Quality/MDM Tools: Informatica MDM Hub, IDE, Informatica Data Quality IDQ, Informatica Data Director IDD

Databases: Oracle 12c/11g/10g/9i/8i/7.3, MS-SQL Server 2012/2008/2000 , DB2, Teradata 14/13/12, MS Access 2000/97.

Operating Systems: Windows Server 2008/2003, Windows 7/XP/98/95, UNIX, OS/390, AS/400.

Languages: C, C++, UNIX Shell Scripts, SQL, T-SQL, PL/SQL, and Visual Basic 6.0/. Net, XML, Java Script and VB Script

Web Tech: HTML/CSS

GUI and Other: Toad 12/10/9/8/7/6, SQL Loader, SQL Plus, Erwin, Teradata SQL Assistant, JIRA

Reporting Tools: Tableau 9/8, OBIEE 11g, Crystal Reports

PROFESSIONAL EXPERIENCE

Senior Informatica ETL/MDM Developer

Confidential, Grand Rapids, MI

Responsibilities:

• Worked closely with business teams to understand and analyze data integration requirements for 7 source systems in an Agile Sprint development environment.
• Partnered with integration architects to document the detailed technical design and specifications for ETL transformations, mappings & MDM Base Objects.
• Designed and developed complex ETL mappings in Informatica PowerCenter 10.1 using PowerCenter Designer, Workflow Manager, Repository Manager and Workflow Monitor.
• Extensively used transformations like Source Qualifier, Joiner, Update Strategy, Rank, Expression, Connected /Un-connected Lookup, Router, Filter, Aggregator and Sequence Generator.
• Designed and developed MDM Base Objects and hierarchies using Informatica MDM Hub Console 10.1.
• Worked on Stage, Load and Match/Merge Jobs in MDM Hub Console. Implemented Match/Merge rules for creating golden records in Base Objects.
• Used MDM Hub Services Integration Framework (SIF) for integrating MDM Hub data with external systems.
• Worked on configuration for data stewards in Informatica Data Director (IDD).
• Developed SQL, PL/SQL in Oracle 12c database to extract data from multiple source systems.
• Responsible for analyzing bottle necks and performance tuning in ETL mappings.
• Involved in Admin activities to migrate the code to higher environments in both Informatica Power Center and MDM Hub.
• Responsible to migrate mappings, sessions and MDM objects to Integration and UAT environments. Developed detailed Change Implementation documents for Production deployments at the end of each Sprint.
• Responsible to work on the SOAP API’S to clean and unmerge the data in MDM base and staging tables.
• Extensively used Jira for tracking User Stories, Tasks, and Issues. Worked closely with business and QA to resolve issues identified in testing phase.
• Responsible for Production Support and maintenance of ETL and MDM applications.

Environment: Informatica MDM Hub Console 10.1, Informatica PowerCenter 10.1, Informatica Data Director, Oracle 12c, Toad 12, SQL, PL/SQL, Unix.

Senior ETL/DW Consultant

Confidential, Peapack, NJ

Responsibilities:

• Analyzed country specific requirements and performed impact analysis in GRW Oracle data warehouse to identify interfaces and reports that needs to be modified as part of ERP R14/R18 projects.
• Responsible to update/maintain GRW data warehouse in Oracle and integrate new SAP financial system data from PeopleSoft into the data warehouse.
• Worked on Informatica PowerCenter 9.5.x designer tools Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator.
• Extensively worked in Informatica MDM Hub Console, Hub Store, Hub Server and Cleanse Match Server to implement MDM solution. Responsible for creating/updating Landing, Staging and Base tables.
• Created complex SCD Type 1, Type 2 and Type 3 mappings using Dynamic Lookup, Joiner, Router, Union, Expression transformations.
• Involved in migration of mappings and sessions from development repository to Integration and Production environments.
• Responsible for Unit testing and Integration testing of mappings and workflows. Extensively used Informatica PowerCenter Data Validation tool to unit test the ETL mappings.
• Responsible to cleanse and standardize source data using Informatica Data Quality tool.
• Developed Packages, Stored Procedures, and Cursors & Views in Oracle PL/SQL to in corporate country specific requirements for SAP downstream applications.
• Validate ASL security data integrated from PeopleSoft to GRW derived tables for HR employee organizational hierarchy.
• Maintain UC4 jobs to refresh GRW processing & delivery layer with PeopleSoft HR data.
• Responsible to lead off-shore team for development & prepare integration test scripts.
• Responsible in Informtica admin activities for both Power center and MDM Hub while moving the code to higher environments.
• Worked with business teams to investigate and resolve issues in GRW interfaces for downstream applications.

Environment: Oracle 11g, Toad, Informatica Master Data Management MDM, Informatica Power Center 9.5, UC4, UNIX, SQL, PL/SQL.

Informatica Developer

Confidential

Responsibilities:

• Translated business requirements into functional specifications. Designed and developed process flows for ETL to load data to the data warehouse.
• Designed and maintained logical and physical enterprise data warehouse schemas using Erwin.
• Worked with Enterprise Architects to do dimensional modeling for the data warehouse. Developed Fact and Dimension tables implementing Star Schema in the data warehouse
• Extracted Erwin physical models into repository manager using Informatica Power Plug.
• Integrated different systems using Informatica server configuration. Extracted data from Flat files, Oracle 10g, SQL Server 2005, MS-Access and loaded data into Oracle using Informatica PowerCenter.
• Created Source definitions, Target definitions, Mappings, Transformations, Reusable Transformations, Mapplets using Informatica Designer tool.
• Worked with Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Worked extensively on different types of transformations like Source Qualifier, Expression, Filter, Aggregator, Rank, Update Strategy, Lookup, Stored procedure, Sequence generator and Joiner transformations.
• Created sessions, database connections and batches. Scheduled and monitored transformation processes using Informatica Server Manager.
• Used Informatica Repository Manager to backup and migrate metadata in development, test and production systems.
• Developed custom business intelligence reports in Cognos Impromptu.

Environment: Informatica Power Center 8.6, Cognos Impromptu 6.0, Impromptu web reports (IWR 6.0), UNIX, IIS 4.0, PL/SQL, Oracle 10g, SQL Server 2005, T-SQL and Win NT.