SUMMARY

• Around 7 years of extensive experience with Informatica Power Center in all phases of Analysis, Design, Development, Implementation and support of Data Warehousing applications using Informatica Power Center 10.x/9.x/8.x/7.x.
• Have clear understanding of Data warehousing concepts with emphasis on ETL and life cycle development including requirement analysis, design, development and implementation.
• Extensive working experience in design and development of data warehouse, marts and ODS.
• Handful working experience in Data warehousing development with data migration, data conversion and extraction/transformation/loading using Informatica Power Center to extract & load data into relational databases like SQL Server, Oracle, Teradata, DB2.
• Good work experience in Informatica Data Integration Tools - Such as Repository Manager, Designer, Workflow Manager, Workflow Monitor and Scheduled workflows using Workflow Manager.
• Experience in Informatica Power Center for Data integration between source & Target which includes development of Joiner, Aggregator, Lookup, Salesforce Lookup, Router and Sorter transformations.
• Extensively worked with informatica mapping variables, mapping parameters and parameter files.
• Experience in several facts of MDM implementations including Data Profiling, Data extraction, Data validation, Data Cleansing, Data Match, Data Load, Data Migration, Trust Score validation.
• Experience in working with business analysts to identify and understand requirements in order to create Technical Design Documents.
• Experience working with Informatica Data Quality (IDQ) for data cleansing, data matching and data conversion.
• Experienced in creating IDQ mappings using Consolidation, Key Generator, Match, Merge, Exceptional, Labeler, Standardizer, Address Validator transformations with Informatica Developer and migrated to Informatica Power Center.
• Extensively worked with Informatica MDM (Master Data Management) in order to manage the high-volume data.
• Excellent Hand full working experience in running projects by using scheduling tools like AutoSys.
• Extensive knowledge in optimizing techniques such as concurrent caching, Auto memory calculations, partitioning and using push down optimization.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle12c /Oracle11g, MS SQL Server, DB2, XML files and Flat Files into the staging area, Data Warehouse and Data Mart.
• Strong experience with star and snow flake schema, dimensional data modelling, facts, dimensional and slowly changing dimensions.
• Expertise in OLTP/OLAP System Study, E-R modeling, developing Database Schemas (Star schema and Snowflake schema) used in relational and dimensional modeling.
• Expertise in implementing Slowly Changing Dimensions (SCD) Type 1 and Type 2 for initial and history load using Informatica.
• Understanding & working knowledge of Informatica CDC (Change Data Capture) Implementation experience of CDC using stored procedures, triggers and using informatica power exchange.
• Experience in debugging mappings, Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Expertise in RDBMS, database Normalization and Denormalization concepts and principles.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Developed shell scripts for invoking Informatica workflows and for running batch process.
• Extensive experience in designing the architecture for extract, transformation, load environment and development of mapping and process using Informatica power center.
• Experienced in Performance Tuning at Mapping, Session and database level, tuning mappings, Pipeline Partitioning to speed up data processing.
• Strong understanding of operationaldatastaging environments,datamodelingprinciples, anddatawarehousing concepts
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experienced in using different scheduling tools - Control- Confidential, Auto Sys, Maestro/TWS & Cron Job.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Excellent analytical skills in understanding client’s organizational structure.
• Excellent problem-solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.x/9.x/8.x, Informatica Master Data Management (MDM), Data Quality Tool (IDQ), Informatica Cloud.

Database: Oracle 12c,Oracle 9i/10g/11g, SQL Server 2014/2008/2005 and Teradata 14.0

Data Modelling Tools: Erwin 4.1, TOAD, MS Visio, SQL *Loader, Star and Snow Fake Schema.

Scheduling Tools: TWS, Auto Sys, Maestro, Cron Tab, Control - Confidential, Informatica Scheduler

Languages: SQL, T-SQL, PL/SQL, C, C++

Scripting Languages: UNIX Shell Scripting, Korn Shell, Bash shell scripting

Operating Systems: Windows, MSDOS, Linux, Unix, Sun Solaris

PROFESSIONAL EXPERIENCE

Confidential, Orlando, FL

Sr. ETL Informatica Developer

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.
• Extensively used ETL to load data using Power Center from source systems like Flat Files into staging tables and load the data into the target database Oracle and Analyzed the existing systems and made a Feasibility Study.
• 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 InformaticaPowerCenter10/1.9.6.1 for extraction, transformation and load (ETL) of data in the data warehouse.
• Used Informatica Power Center ETL tool for developing mappings/Mapplets and create sessions/tasks, workflows for integrating the data to large Data warehouse like Oracle, Teradata.
• Worked on Informatica power center 10.2 for creating mappings, workflows, reusable mapplets, reusable transformations and different session tasks.
• Collaborate with Functional analysts for requirements gathering, analysis of functional requirements to help in designing the data warehouse.
• Successfully managed and implemented various ETL projects using Informatica Power Center that loaded data from DB2, flat files and other data sources to Oracle and other targets used for reporting.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Developed internal and external Interfaces to send the data in regular intervals to Data warehouse systems.
• Extracted Data from different flat files, MS Excel, MS Access and transformed the data based on user requirement using Informatica Power Center and loaded data into target, by scheduling the sessions.
• Creating IDQ Data profiling, ScoreCards, Mapplets, Rules, Mappings, workflows, Data Cleansing, Data Standardization process using IDQ Developer and Informatica Analyst tools.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Developed mappings for Change data Capture CDC with Power Exchange with Change data Capture.
• Involved in building robustETLsolution using Informatica Cloud to harness the best practices.
• Created detailed Technical specifications for Data Warehouse andETLprocesses.
• Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Used Informatica B2B Data Exchange tool MFT the files from external venders to internal servers.
• Involved in the error checking and testing ofETLProcedures using Informatica Session log and workflow logs.
• Extensively involved in performance tuning of the InformaticaETLmappings by using the caches and overriding the SQL queries and also by using Parameter files.
• Performed Unit Testing, prepared Test Cases for the same.
• Prepared Unit testing cases document and mapping design document.

Environment: InformaticaPowerCenter10.1/10.2,Oracle 12c/11g, Teradata 15/14,, IDQ 10.1, Informatica MDM 10.1, XML files, DB2, MS SQL Server 2016, Flat files SQL Server management studio, AutoSys, UNIX.

Confidential, Buffalo, NY

Sr. ETL Informatica Developer

Responsibilities:

• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Performed requirement gathering analysis design development testing implementation support and maintenance phases of both MDM and Data Integration Projects.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files and Oracle database.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Utilized Informatica Data Quality (IDQ V10.1) for data profiling and matching/removing duplicate data, fixing the bad data, fixing NULL values.
• Produceddatamodels to meet functionaldatarequirements.Datamodelingat the enterprise level through to ETL and application.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems (SQL server and flat files) by incorporating business requirement rules.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Involved in logical and physicaldatamodelingand analyzed and designed the ETL processes.
• Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into theTeradatausingTeradataUtilities.
• Performed match/merge and ran match rules to check the effectiveness ofIDQon data and fine-tuned the match rules.
• Developing Informatica Mappings and Workflows to extract data and to load intoTeradata staging area using Fast Load/Tpump utilities.
• Extensively used SQL Scripts and worked in Windows Environment.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Written complex SQL queries inOracle/ SQL server to test data in the data warehouse and to provide expected results to users.
• Expertise in Exporting IDQ mappings into Informatica designer and creating tasks in workflow manager and scheduling the mapping with scheduling tools to run these mappings.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Efficiently worked in all the phases of System development life Cycle (SDLC) using different methodologies like Agile and Waterfall.
• Wrote UNIX shell scripts to schedule Informatica workflows and oracle database scripts to populate data in to data warehouse and database.

Environment: Informatica Power Center 10.2, Informatica IDQ 10.1.1, Informatica MDM, Oracle 11g, SQLTeradata, UNIX Shell Scripting, Flat Files, Microsoft Office.

Confidential, Tampa, FL

Sr. ETL Informatica Developer

Responsibilities:

• Worked with Informatica power center tools like Designer, Workflow Manager, Repository Manager, source analyzer, warehouse designer, mapping & Mapplet designer.
• Worked on all phases of data warehouse development life-cycle,ETLdesign and implementation, and support of new and existing applications.
• Extensively used ETL processes to load data from flat files into the target database by applying business logic on transformation mapping for inserting and updating records when loaded.
• Defined and developed brand new standard design patterned, ETL frameworks,DataModel standards guidelines and ETL best practices
• Worked with Informatica Data Quality 9.6 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities ofIDQ9.6.
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Created, executed and managed ETL processes using Oracle Data Integration (ODI)&Customized ODI Knowledge modules like Loading Knowledge Modules and Integrated Knowledge Modules.
• Created queries, procedures and packages inMDMHub for displaying and updating the data.
• DevelopedIDQmappings using various transformations like Labeler, Standardization, Case Converter, Match & Address validation Transformation.
• Worked on improving data warehouse solutions by translating business requirements into robust, scalable, and supportable solutions that work well within the overall system architecture.
• Extracted data from various source systems like Oracle, SQL Server, XML and flat files and loaded into relational data warehouse and flat files.
• Used theTeradatafast load/Multiload utilities to load data into tables.
• Created Match Rule Sets for preventing duplicate data entry into theMDMtables.
• Involved in optimizing the existingdatamodels and load scripts to improve the performance.
• UsedIDQto cleanse and accuracy check the project data, check for duplicate or redundant records.
• Designed and DevelopingETLMappings and Workflows Using with Informatica Power Center.
• Worked on creating Mapping/Session/Workflow Variables and Parameters.
• Involved in tuningTeradataBTEQs for recurring production failures.
• Designed IDQ mappings which are used as Mapplets in Power center.
• Imported the IDQ address standardized mappings into Informatica Designer as a Mapplets.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Responsible for performance tuning at Mapping level, Session level, Source and Target level.

Environment: Informatica Power Center 9.6.5, Informatica Data Quality 9.6.1, Teradata, Oracle, SQLUnix, Autosys.

Confidential, Bethesda, MD

Informatica Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirement for database changes, ETL, Business Reports.
• Responsible for designing and developing of mappings, Mapplets, sessions and workflows to load data from source to target database using Informatica Power Center.
• Used Informatica to developETLprogram to extract data warehouse File extract to be created will follow the instructions specified in the data mapping and file layout documentation.
• Extracted Data from different source systems like Oracle, MySQL and Flat Files.
• Worked with various transformations in Informatica power centre like Filter, Aggregator, Joiner, Rank, Router, Sorter, Source qualifier, and Update Strategy transformations.
• Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join in the Joiner transformation.
• Translated Business Requirements into Informatica mappings to build Data Warehouse by using Informatica Designer, which populated the data into the target Star Schema.
• Involved in executing theETLTest Jobs from the Informatica power center workflow Manager to verify different test cases and validate the data.
• Work withDataModelers to performdataanalysis, define requirements anddataneeds.
• Replicated operational tables into staging tables, to transform and load data into the enterprise data warehouse using Informatica.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Have written complex SQL queries in the stored procedures for the expected business logic.
• Performed data validation testing writing SQL queries.
• Converted PL/SQL stored Procedures in to Informatica which resulted drastic change with better performance. Extensively worked with SQL Server andOracleto ensure data accuracy.
• Created (ETLProcess) for populating the data into the Data warehouse constantly from different source systems like ODS, flat files
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
• Involved in various meetings, seminars, presentations and group discussions.

Environment: Informatica Power Center 9.1, Oracle 11g, MySQL, SQL, Pl/SQL, TOAD, Erwin, SQL SERVERShell Scripts, Unix, AutoSys, Control - Confidential, Windows.

Confidential

Informatica Developer

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Developed mappings/Reusable Objects/Transformation/Mapplets by using mapping designer, transformation developer and Mapplet designer in Informatica Power Center.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Wrote Data loading stored procedures, functions using PL/SQL from Source systems into operational data storage.
• Extensively used ETL to load data from Flat files and Oracle.
• Extensively used Informatica Power Center for extracting, transforming and loading into different databases.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Prepared reusable transformations to load data from operational data source to Data Warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Involved in Unit Testing and Resolution of various Bottlenecks came across.

Environment: Informatica Power Center 8.1, SQL, PL/SQL, UNIX, Shell Scripting, SQL Server 2008,Oracle 11gDB2, Control- Confidential, AutoSys.

Confidential

Informatica Developer

Responsibilities:

• Worked extensively with various Passive transformations in Informatica Power Center like Expression Transformation, Sequence Generator, and Lookup Transformation.
• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica 7.X.
• Involved in enhancements and maintenance activities of the data warehouse.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Created stored procedures, Functions and Packages inOracle, used PL/SQL and SQL.
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.
• Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process

Environment: Informatica Power Center 7, Oracle 11g,SQL, UNIX, Control- Confidential .