SUMMARY

• Over 8+ years of extensive experience on Informatica Power Center with strong understanding and knowledge of Extraction, Transformation and Loading of Data from heterogeneous source system like Flat files, Excel, XML, Oracle, Teradata.
• Extensively involved in ETL Datawarehousing using Informatica PowerCenter 7.x/8.x/9 Designer tools like Source Analyzer, Target Designer, Mapping Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Extensively worked with Informatica Mapping Variables, Mapping Parameters and Parameter Files.
• Experienced in complete life cycle Implementation of data warehouse.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Data modeling tool ERWIN and Dimensional modeling techniques (Kimball and Inmon), Star and Snowflake schema addressing Slowly Changing Dimensions (SCDs).
• Good at Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Created Match Rule Sets for preventing duplicate data entry into the MDM tables.
• Worked on Data Modelling and MDM Architecture based on the requirements provided by the client.
• Hands on experience in Informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter in Windows.
• Experience in identifying and resolving the bottlenecks in Source, Target, Transformations, Mappings and Sessions for better performance
• Transformed data from one server to other servers using tools likeBulk Copy Program(BCP), andSQL Server Integration Services(SSIS).
• Involving in creating SSRS Operational Reports.
• Wrote SQL Queries to test data at various stages to generate data lineage, and to monitor and measure data quality as defined by business rules.
• Proficient inDataAnalysis on Oracle, MS SQL Server & MS Access, Teradata, Netezza with sound knowledge in extraction ofdatafrom various database sources like Oracle, Teradata, Netezza, MS SQL Server, DB2 and Flat files intoInformatica
• Design and develop PL/SQL Stored procedures to generate the outbound extract files for Third party vendors.
• Experience with Informatica B2B & IDQ Experience in an Oracle environment.
• Hands on experience in user interaction to gather and analyze the project requirements.
• Strong expertise in design, development and integration of complex ETL processes.
• Hands on experience in Informatica Data Quality (IDQ) processes.
• Extensive experience with PL/SQL in designing, developing functions, procedures, triggers and packages.
• Excellent analytical, problem solving, communication skills and a committed team player with ability to interact with individuals at all levels.

TECHNICAL SKILLS:

Business Tools: Informatica PowerCenter9.x/8.x, (Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, IDQ Experience Workflow Monitor, Work lets), Power Exchange Informatica MDM Multi - Domain. SQL Server Integration services (SSIS)

Project Management Tools: Microsoft Project, Microsoft Office, MS PowerPoint, MS Visio.

Operating Systems: Windows 7,8,10, Windows NT, Windows2000, UNIX, Linux, Z/OS

Languages: SQL Loader, PL/SQL, Shell Scripting, TOAD.

Databases: Oracle 10g, SQL Server 2005/2008/2012,Mainframes, Netezza, Teradata, MS Access

Data Modeling: Erwin

Reporting tools: Crystal Reports, SSRS, SSAS.

Scripting: Unix Shell Scripting.

Web Technology: HTML5, CSS

PROFESSIONAL EXPERIENCE

Informatica Developer

Confidential, Oklahoma City, OK

Responsibilities:

• Reviewed business, technical requirements, and large scale data models for an enterprise systems to ensure the data integration platform meets requirements.
• work closely with Lead systems analyst to identify system requirements and changes as and when they happen.
• Co-ordinate with Business users to understand the product and bring to table novel methods to implement business requirements.
• Interacted with various technical people and gathered the business requirements and translated them into technical specifications for Developers.
• Documented business requirements/ Functional requirements and discussed issues to be resolved and translated user input into ETL design documents.
• Work with data analysts to implement Informatica mappings and workflows to meet business requirements.
• Interacting with Business users for Gathering information on new requirements to develop and generate reports to meet business needs and provide reports on timely manner using Business Intelligence information.
• Extracted data from oracle database and spreadsheets and stages into a single place and applied business logic to load them in the central oracle database
• Used Informatica Power Center 9.0.1 for extraction, loading and transformation (ETL) of data in the data warehouse
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure.
• Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
• Design MDM architecture, which uniquely identifies Customers and their related information.
• Good knowledge for working with parameterized DB connections.
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
• Involve in writing SQL batch scripts.
• Designed Automation for executing Informatica MDM jobs using PowerCenter workflows and using Unixscripts.
• Create and automate batch jobs to load,match and merge data in MDM.
• Managing and debugging MDM hub log files
• Designed Automation for executing Informatica jobs using PowerCenter workflows and using Unixscripts.
• Extensively used Toad for SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL Procedures for Informatica mappings for truncating the data in target tables at run time.
• Worked on de-dup process to cleanse the data for Finance and controlling objects to help better cleanse data that can be loaded on SAP.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings
• Extraction and transformation from DB2 source files is done in AS400 environment to avoid complexity while loading target files.
• Written documentation to describe program development, logic, coding, testing, changes and corrections
• Followed Informatica recommendations, methodologies and best practices from velocity documentation
• Provided support during various phases of project and plan the E&T process.
• Was involved in production support to make sure all issues are fixed in the respective turn-around times.

Environment: Informatica MDM 9.x,Oracle 11g, MS-SQL server, TOW and other legacy systems, TOAD, HP Quality Center, Autosys, MS Office Suite

Informatica Developer

Confidential, CA

Responsibilities:

• Involved in implementation of Hyundai Protection Plan (HPP) project supporting Hyundai Capital Insurance (HCI) and parts promotion project supporting Hyundai Motors America (HMA)
• Prepared mapping documents, System Requirement Specification and High level Design Document as a part of project
• Extracted data from Flat files, AS400 sources and loaded in to Oracle staging and target tables applying business rules as per the requirement
• Designed and developed mapping using various transformations like Expression, Lookups, Joiner, Filter, Sorter, Aggregator, Router, Union, Update strategy, source qualifier transformation and Sequence generator
• Implemented SCD Type1 and SCD Type2 techniques to update slowly changing dimension tables.
• Configured different source systems of MDM tables in MDM Hub: Landing Tables, Base Objects, Staging Tables, and Relationships Base Objects.
• Created reusable components like reusable transformations, Maplets and Worklets
• Created different reusable tasks like email tasks to send email and command tasks to create, rename and delete files
• Scheduled and ran Workflows for Extraction, Loading processes and monitored the Workflows using Workflow Monitor
• Implemented error handling by routing invalid records to error tables, and reloading them to target tables
• Did Performance tuning and Optimization of mappings for better performance and efficiency
• Modified /Created parameter files in development, test and production environments using UNIX
• Wrote Oracle PL/SQL procedures and functions to call them in the informatica mappings
• Troubleshoot problems by checking Sessions and Error Logs. Also used Debugger for complex problem troubleshooting
• Developed unit test scripts and test cases for unit testing and system testing

Environment: Informatica Power Center 8.6.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Repository Administration Console), Informatica MDM, Oracle Developer, TOAD, Oracle 11g, TOAD, UNIX

Informatica Developer

Confidential, Boston, MA

Key Responsibilities:

• Worked with business analysts to identify appropriate sources for data warehouse and prepared the functional and technical designs, test cases, and user guides.
• Helped in developing Star Schema by following referential integrities among Facts and Dimensions.
• Implemented slowly changing and rapidly changing dimension methodologies; created aggregate fact tables for the creation of ad-hoc reports.
• Created and maintained surrogate keys on the master tables to handle SCD type 2 changes effectively.
• Mentored Informatica developers on project for development, implementation, performance tuning of mappings and code reviews.
• Developed Informatica jobs and automated data loads using UNIX shell scripts.
• Involved in debugging mappings, recovering sessions and developing error-handling methods.

Environment: Informatica Power Center 8.6, DB2, Oracle 10g, TOAD 9.x, Oracle Financials, Shell Scripting, Oracle SQL *Loader, OBIEE, PL/SQL, Sun Solaris UNIX, Windows-XP, Visio, Autosys.

Informatica Developer

Confidential, Malvern, PA

Key Responsibilities:

• Interacted with the business community and database administrators to identify the business requirements and data realties.
• Designed the process and developed a number of Mappings, Mapplets and Transformations to load data from relational and flat file sources into the data warehouse.
• Used UNIX shell scripting for Scheduling Informatica Workflows.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.

Informatica Developer

Confidential, Seattle, WA

Key Responsibilities:

• Developed ETL mappings by making use of various transformations in Informatica.
• Developed mappings to implement type 2 slowly changing dimensions
• Developed and implemented the UNIX shell script for the start and stop procedures of the sessions
• Used various Informatica Error handling technique to debug failed session.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality.

Environment: Power Center 6.2,Oracle9i, SQL Server 2000, SQL,PL/SQL, shell scripts, Mainframe DB2, MS Visio, Toad 8.0, Windows 2000,XML,UNIX.