SUMMARY

• 11 plus years of experience in solving business needs by modeling data warehouse for business intelligence environments using Star and Snow Flake Schema methodology for faster and TEMPeffective Querying and managing large volumes of data.
• Extensive experience in Informatica Power Center, Informatica MDM, Informatica DVO, Informatica Metadata Manager and Power Exchange.
• Having good understanding of Master Data Management (MDM) architectures and business processes
• Participated in the requirement gathering/ solution architecture for MDM initiatives.
• Experience wif MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, writing and customizing user exits, customizing/configuring Data Director.
• Experience in Design, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Have good experience in configuring MDM batch processes.
• Have good experience in Informatica MDM Data Manager and Merge Manager tools
• Have good experience in Informatica MDM/PowerCenter/PowerExchange migrator
• Implemented Power Exchange CDC Mechanism for Oracle DB and MS SQL Server 2008 r2 Sources.
• Have good experience in Data Integration by integrating data from different sources.
• Have good experience in Data Integration by integrating data from different locations.
• Have good experience in Data Integration by integrating data from across plants.
• Good understanding on WhereScape RED jobs and involved in migration project.
• Experience using Data modeling tools like ERWIN 7.x, Visio. Knowledge in designing and developing Data marts, Data warehouse using dimensional models such as Snow Flake Schema and Star Schema while implementing Decision Support Systems. Experience in Physical & logical data modeling.
• Worked on Data Cleansing tools like IDQ, PL/SQL coding and Unix/Perl shell scripting for address cleansing, profiling and segmentation of customer data.
• Have good noledge in Teradata MPP system
• Extensive experience as Informatica Administrator in 8.x and 9.x.
• Expertise in design and development of mappings to handle all types of slowly changing dimensions SCD type 1, type2, type3 and type6.
• Experience using Business Intelligence tools like Business Objects XI R2R1/6.5/6.0, and Brio.
• Experience in transforming data from various types of sources like flat files, Oracle, Teradata, SQL server and XML documents.
• Experience using APIs (Application programming interface) via Informatica Developer Platform (IDP) that allows third parties to build on and extend the PowerCenter platform to connect to new data sources (Like SAP, IBM web servers) and adds custom transformation and functions to the Power Center server.
• Good noledge in developing complex mappings, mapplets and reusable transformations.
• Experience in CDC techniques in oracle to extract the incremental changes from source systems.
• Working experience in Oracle 11g/10g/9i, PL/SQL Server 2008 R2 and Teradata V12/V13.
• Through noledge in Teradata architecture, extensively worked on BTEQ, MLOAD, FLOAD, FEXPORT, SQL Assistant to design and develop dataflow paths for loading transforming and maintaining data warehouse.
• Experience in Performance tuning of sources, targets, mappings, sessions and sql queries. Worked wif Oracle Stored Procedures and experienced in loading data into Data Warehouse/Data Marts using Informatica, SQL *Loader. Extensive Expertise wif error handling and Batch processing.
• Strong noledge of Software Development Life Cycle (SDLC) wif industry standard methodologies like Waterfall, Agile, and Scrum methodology including Requirement analysis, Design, Development, Testing, Support and Implementation. Provided End User Training and Support.
• Experience wif TOAD, SQL Developer and SQL Navigator, Teradata SQL Assistant, SQL Server Management to test, modify and analyze data, create indexes, and compare data from different schemas. Experienced in Shell scripting and PL/SQL procedures.
• Good experience in preparing Functional Specification Document (FSD) and Detail Design Document (DDD).
• Expertise in performing Unit and Integration testing (UTC).
• Good experience in JIRA tool on agile process.
• Experience in creating tasks, tickets and assign storey points in JIRA tool.
• Good awareness on UNIX Commands and DWH concepts.
• Have good noledge in Python scripting.
• Worked wif Autosys in scheduling daily loads, weekly loads, and monthly loads.
• Have good noledge in oracle DB schema creation
• Implemented Integration layer as Data Vault Technique.
• Expertise in performing Unit Testing, Integration Testing and Regression Testing.
• Mentors and assists lower level senior developers, business analysts and developers.
• Worked in 24/7 production support of ETL and BI applications for large insurance data warehouses for monitoring, troubleshooting, resolving issues, generating SLA reports. Also worked on administrative tasks of Business Objects XI R2 and Informatica.
• Excellent communication and interpersonal skills, very good team player and self-starter wif ability to work independently and as part of a team, strong effort, time management, good analytical reasoning and high adaptability to new technologies and tools.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter, Informatica PowerExchange, Inforamtica Metadata Manager, DVO, WhereScape Red, Kalido and Adaptive Warehouse.

MDM Tools: Informatica MDM.

Languages: PL/SQL, UNIX Shell Scripting, Perl Scripting

Database: Oracle, Teradata and SQL Server

Dev. Tools: PL/SQL Developer, Toad, Quality center/Test Director, Jira, WINSCP for Unix.

Operating Systems: UNIX (Aix 5.3), Linux, MS Windows (XP, 2000, NT, 98)

Data Modeling Tool: ERWIN, MS Visio

Scheduling Tools: Autosys, Informatica and DAC.

OLAP Tools: BO and Brio.

Version control: SVN, PVCS

PROFESSIONAL EXPERIENCE

Confidential, Ontario, California

Informatica Architect/Lead Informatica ETL/MDM Developer

Responsibilities:

• Installed Informatica PowerCenter/PowerExchange/Metadata Manager
• Working on Informatica MDM tool.
• Experience in Installing Informatica MDM HUB server/Cleanse Server.
• Experience wif MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, and Data Director.
• Participated in requirement gathering/solution architecture for MDM initiatives.
• Experience in Design, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Have good experience in configuring MDM batch processes.
• Have good experience in Informatica MDM Data Manager and Merge Manager tools
• Have good experience in Informatica MDM/PowerCenter/PowerExchange migrator
• Have good experience in logical and physical data modelling.
• Have good experience as solution architect as data warehouse standards.
• Have good experience in Data Integration by integrating data from different sources.
• Have good experience in Data Integration by integrating data from different locations.
• Have good experience in Data Integration by integrating data from across plants.
• Working on Informatica PowerExchange tool to capture real time transactions to ODS tables wif SQL server and Oracle databases.
• Working on 24*7 support for Informatica CDC jobs and PowerCenter jobs.
• Worked on Agile, and Scrum methodology for project execution.
• Strong working experience in Software Development Life Cycle (SDLC) wif industry standard methodologies like Waterfall, Agile, and Scrum methodology including Requirement analysis, Design, Development, Testing, Support and Implementation.
• Prepared Technical Specification documents (TSD).
• Developing a high level road map for the data quality improvement initiative, aligning data governance deliverables wif strategic objectives.
• Finding RCA for production failures and change requests.
• Established best practice and standard for ETL process documents.
• Developed Logical and Physical data models, created the (ER) Entity Relationship diagrams.
• Designed and developed ETL mappings using Informatica Power Center, designed to extract data from Flat files, Excel and transforming it according to the business transformation rule.
• Mentors and assists business analysts and developers.
• Coordinated wif the DBA Team, Source systems and offshore for Different data loads (System test Load, Integration System Test Load, UAT Load and Pre production deployment load) and in identified the bugs, new requirement changes and Data Quality Issue.
• Prepared Test preparation and execution plans for different entities and executed the testing wif team and Involved in Integration testing.
• Create Dimensional Model (Logical and Physical Model).
• Implemented Auditing and Logging Mechanism.
• Interact wif the Subject matter experts and Business users.
• Implemented Power Exchange CDC Mechanism for Oracle DB and MS SQL Server 2008 r2 Sources.
• Configured Listener and Logger and Created Change Registrations.
• Setting up Environment to pull data from various sources.
• Automated the Informatica real time workflows to overcome failures.
• Responsible for preparing ETL Design and Specification for developing Workflow.
• Responsible for Creating Users and Assigning roles.
• Responsible for Migrating code from one environment to other Environments.
• Created Inbound and Outbound Integration's between EBS and other source systems (Oracle EBS, Manhattan, ShotScope, E80 and Logility).

Environment: Informatica PowerCenter 9.x, Informatica PowerExchange 9.x, SQL Server, Oracle, Linux, SVN.

Confidential, Miami, FL

Informatica Architect/Senior Informatica ETL Developer/ Informatica MDM developer

Responsibilities:

• Gathered requirements from business analysts and designed and prepared Functional Specification (FSD) and Detail Design Documents (DDD).
• Worked on Agile, and Scrum methodology for project execution.
• Established best practice and standard for ETL process documents.
• Good understanding on WhereScape RED jobs and involved in migration project.
• Converted WhereScape RED jobs into Informatica PowerCenter mappings.
• Experience wif MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, and Data Director.
• Design, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Have good noledge in Teradata MPP system architecture and work experience.
• Have good experience in logical and physical data modelling.
• Have good experience as solution architect as data warehouse standards.
• Have good experience in Data Integration by integrating data from different sources.
• Have good experience in Data Integration by integrating data from different locations.
• Performance tuning and optimizing the existing mappings.
• Implemented Integration layer as Data Vault Technique.
• Expertise in Agile process by taking responsible for sprint planning, creating user stories, creating tasks and leading scrum meetings.
• Involved in Unit and Integration testing (UTC), System testing and User Acceptance Testing (UAT).
• Extensively utilized MLOAD, FASTLOAD in Informatica to load data to Teradata.
• Upgraded on informatica 9.0.1 to 9.5.1 version.
• Experience in creating Teradata SET and MULTISET tables, creating views, Indexes, collecting stats on the tables for improving query performances.
• Prepared technical specifications for the development of Informatica (ETL) process to load data into various target tables.
• Finding RCA for production failures and change requests.
• Good experience as Informatica Administrator in 9.x version.
• Developed Transformation logic and designed various complex mappings in the Designer for data load and data cleansing.
• Implemented SCD-Type 1/Type 2/Type 3 and Fact Tables.
• Generated different transformations for loading the data into target like Source Qualifier, Joiner, Update Strategy, Connected Lookup, Unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Built reusable transformations and mapplets to use in multiple mappings.
• Hands on experience using mapping variables, mapping parameters, workflow variables and session parameters.
• Designed the sessions, workflow to execute the mappings, monitored workflows using Workflow Manager and Workflow Monitor.
• Extensively used Workflow Manager for validating, testing and running the sequential and concurrent batches and sessions, and scheduled them to run at a specified time. Improved session run times by partitioning the sessions.
• Involved in data cleansing using IDQ and SQL.
• Participated in error handling and troubleshooting using various log files.
• Wide experience in SDLC and in handling large volume of data.
• Good experience in creating procedures, functions, triggers and cursors using PL/SQL.
• Good experience in SQL server and Teradata V12/V13.
• Improved performance by using Explain plan, creating appropriate indexes, queries optimization, utilizing table spaces and partitioning schemes.
• Handled production support for the monitoring of daily and monthly jobs.
• Used Automation Scheduling tools like AutoSys.
• Experience wif shell scripting and UNIX operating system architecture.
• Environment: Informatica 9.x, SQL Server, Teradata, Windows 2007, SVN.

Confidential, Simsbury, CT

Informatica Architect/Senior Informatica ETL Developer

Responsibilities:

• Gathered requirements from business analysts and designed and prepared Functional Specification (FSD) and Detail Design Documents (DDD).
• Have good experience in logical and physical data modelling.
• Have good experience as solution architect as data warehouse standards.
• Worked on Informatica tool including Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Developer.
• Extensively utilized MLOAD, FASTLOAD in Informatica to load data to Teradata.
• Involved in Unit and Integration testing (UTC), System testing and User Acceptance Testing (UAT).
• Experience in creating Teradata SET and MULTISET tables, creating views, Indexes, collecting stats on the tables for improving query performances.
• Experience in Oracle CDC Technique implementation to extract data from source systems.
• Developed Transformation logic and designed various complex mappings in the Designer for data load and data cleansing.
• Good experience as Informatica Administrator in 8.x version.
• Have good experience in Data Integration by integrating data from different sources.
• Implemented SCD-Type 1/Type 2/Type 3 and Fact Tables.
• Finding RCA for production failures and change requests.
• Created mappings using Mapping Designer to load the data from various sources.
• Built reusable transformations and mapplets to use in multiple mappings.
• Have good noledge in Teradata MPP system architecture and work experience.
• Hands on experience using mapping variables, mapping parameters, workflow variables and session parameters.
• Designed the sessions, workflow to execute the mappings, monitored workflows using Workflow Manager and Workflow Monitor.
• Extensively used Workflow Manager for validating, testing and running the sequential and concurrent batches and sessions, and scheduled them to run at a specified time. Improved session run times by partitioning the sessions.
• Participated in error handling and troubleshooting using various log files.
• Wide experience in SDLC and in handling large volume of data.
• Good experience in creating procedures, functions, triggers and packages using PL/SQL.
• Outstanding experience in Oracle 11g/10g/9i and Teradata V12.
• Improved performance by using Explain plan, creating appropriate indexes, queries optimization, utilizing table spaces and partitioning schemes.
• Handled production support for the monitoring of daily and monthly jobs.
• Used Automation Scheduling tools like AutoSys.
• Experience wif shell scripting and UNIX operating system architecture.

Environment: Informatica V8.x 9.x UNIX, Toad 9.0.1.8, Oracle 11g/10g, Teradata V12, CDC, XML, Flat Files, Autosys, SVN, Shell Scripting, Windows 2000 XP.

Confidential

Senior Informatica ETL Developer

Responsibilities:

• Performed business analysis and requirements gathering from high-end users and managers.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Parsing high-level design specifications to simple ETL coding and mapping standards. Designed mapping document, which is a guideline to ETL Coding.
• Analyzed and created Facts, Dimension tables. Modeled the data warehousing data marts in Star join schema.
• Handle slowly changing dimension (Types 1, 2, 3) based on the business requirements.
• Implemented best practices such as Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Created various mappings using the transformations, reusable transformations and mapplets.
• Used mapping parameters and variables.
• Worked broadly on fixing invalid mappings, testing of stored procedures and functions, unit and integration testing of Informatica sessions and target data.
• Good practical experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions..
• Experienced in scheduling tools like Autosys.
• Good experience in Oracle 11g/10g/9i.
• Responsible in doing data cleansing and data mining.
• Involved in Unit and Integration testing (UTC), System testing and User Acceptance Testing (UAT).
• Used PMCMD, PMREP and UNIX shell scripts for workflow automation and repository administration.
• PVCS used as version control tool.

Environment: Informatica Power Center 8.6.1, Workflow Manager, Workflow Monitor, TOAD PL/SQL, Flat files, XML, Oracle 11g/10g, UNIX, PVCS.

Confidential

Informatica ETL Developer

Responsibilities:

• Involved in all phases of project, including requirement gathering, design, Involved in Unit and Integration testing (UTC), System testing and User Acceptance Testing (UAT).
• Expert in designing ETL architecture, data warehouse builder development guidelines and database standards document.
• Used Informatica for extracting data from heterogeneous source systems.
• Extensively used the components of the Informatica PowerCenter(Source Analyzer, Datawarehouse Designer, Mapping Designer, Mapplet, Transformation, Repository Manager, Workflow Manager, Workflow Monitor)
• Created a repository using Repository Manager. Created folders and users and assigned proper privileges. Managing the repository.
• Formed mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Connected Lookup, Unconnected Lookup, Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
• Designed and developed complex mappings using various transformations in Designer to load data from Oracle DB.
• Developed mappings, mapplets using Informatica Designer to integrate data from various sources like Oracle, flat files and loaded into target including Teradata, Oracle.
• Created reusable mapplets, transformations and mappings using Informatica Designer.
• Focused on fixed and de-limited flat files, also worked wif direct and indirect flat files.
• Implemented sessions, workflows monitored the workflows.
• Identified and troubleshot bottlenecks at various levels like SQL logic, Mappings, and Sessions to enhance the performance.
• Design and development of SQL and stored procedures/functions in Oracle 10g.
• Tuned mappings to achieve faster data loads to the Datawarehouse.
• Used Informatica Debugger to debug the mapping and created breakpoints as needed in order to provide error free mapping.
• Experience in using Automation Scheduling third party tools like Autosys.
• Performed Unit Testing and Integration Testing of mappings and workflows.
• Analyzed performance measures to fit the reporting needs of the company.
• PVCS used as version control tool.

Environment: Informatica Power Center 7.x, Oracle 10g, Flat files, MS Access, PL/SQL, PVCS.