SUMMARY

• 9 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.
• Expertise Informatica B2B Data Transformation, DT and DX, pre-built transformations for most versions of industry Confidential messages including the following EDI standards and derivatives.
• Experienced in executing complex queries using stored procedures, Triggers, Cursors, User Defined Functions using T-SQL.
• Experienced in Data Analysis, Data Modeling, Development, Testing and Documentation of projects.
• 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.
• Experienced in ETL process using PL/SQL to populate the tables in OLTP and OLAP Data Warehouse Environment.
• 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.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, T-SQL and Oracle PL/SQL.
• Experienced in using different scheduling tools - Control-M, Auto Sys, Maestro/TWS & Cron Job.
• 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 - M, 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, Mason, Oh

Sr. ETL Lead Developer

Responsibilities:

• Responsible for Developing, support and maintenance for the ETL (Extract, Transform and load) processes Using Oracle and Informatica Power Center.
• Worked extensively on Informatica Power Center tool - Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Developed Informatica mappings and also in tuning of mappings for better performance..
• Analyzing the source data and working with business users to develop the Model.
• Sharing Requirements and make them to Understand The requirement with Offshore. and setup the environments for brand new Projects and For the Informatica Team.
• Extracted data from flat files and Sql Server and Sybase and Orcale Database and applied business logic and loaded in to oracle and Sybase Warehouse.
• Developed mappings/Reusable Objects/Transformation by using mapping designer, transformation developer in Informatica power center.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented slowly changing dimensions to maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Worked on different data sources such as DB2, Oracle, Sybase, SQL Server, Flat files etc.
• Involved in Data Validating, Data integrity, Performance related to DB, Filed Size Validations, Check Constraints and Data Manipulation and Updates by using SQL Single Row Functions.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Stored Procedure.
• Created E-mail notifications tasks using post-session scripts.
• Created Triggers and Store procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Created deployment groups, migrated the code into different environments.
• Written documentation to describe program development, logic, coding, testing, changes and corrections. Demo Presentation with WEB UI results and Sit and Uat and Prod Deployments Done .
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Documented technical design documents based on the BRD and SRS.

Environment: Informatica Power Center 10.5, Oracle 11.5,putty.winscp, Unix, Terradata,Tidal, Toad, SybaseControl-m, MSSQL Server, Jira, Agile Methodology,BITBUCKET, jira,Ms sql, Oracle, Sybase, Unix, UISNOW.

Confidential, Seymour, IN

Sr. ETL Developer

Responsibilities:

• Responsible for Developing, support and maintenance for the ETL (Extract, Transform and load) processes Using Oracle and Informatica Power Center.
• Worked extensively on Informatica Power Center tool - Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Developed Informatica mappings and also in tuning of mappings for better performance.
• 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.
• Designed the ETL mappings between sources to operational staging targets, then to the data warehouse using Power center Designer.
• Used Informatica Power Center 10.1 to create mappings, sessions and workflows for populating the data into dimension, fact and lookup tables simultaneously from different source systems (SQL Server, Oracle, Flat files).
• Responsible for creating and maintaining Architecture document for PL/SQL ETL Framework.
• Worked as Data modeler and created Data model for warehouse and involved in ODS and Data Mart data models.
• Involved in design and development of data warehouse environment, liaison to business users and technical teams gathering requirement specification documents and presenting and identifying data sources, targets and report generation.
• Extensively used Oracle ETL process for address data cleansing.
• Used ETL tools Informatica 10.1 to extract data from source systems, cleanse Transform, and Load data into XML and Flat files.
• Created DDL scripts to create database schema and database objects like tables, stored procedures, views, functions, and triggers using T-SQL.
• Identified & documented data integration issues and other data quality issues like duplicate data, non-conformed data, and unclean data.
• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA.
• Designed and developed Confidential re-usable mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Created common reusable objects for the ETL team, overlook coding standards and reviewed high - level design specification, ETL coding and mapping standards.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables and established joins
• Developed Informatica mappings, reusable transformations and created PL/SQL Stored procedures/packages for extracting data from source systems to staging and processing and loading to the data warehouse.
• Performed Unit Testing, tuned it for better performance and created various documents such as Source - to - Target Data mapping document and unit Test cases Document.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Extensively used SQL Developer to check if data is properly loaded into target systems by writing SQL Queries.
• Wrote UNIX Shell Scripts for Informatica Pre-Session, Post-Session and Autosys scripts for scheduling the jobs (work flows).
• Create Sessions, reusable worklets and workflows in Workflow Manager and Schedule workflows and sessions at specified frequency.
• Created test scripts and Unit test plan documents.
• Created Deployment Document for Migration of code from Dev to Test and from Test to Production environment.
• Published the records to downstream applications with help of ETL power center with the help of message queue.

Environment: Informatica Power Center 10.1, Oracle 11g, SQL, PL/SQL, Oracle RDBMS 12g, Autosys.

Confidential, IL

Sr. ETL Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Used Informatica power center as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Involved in building the ETL architecture and Source to Target mapping to load into Data warehouse.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Created references tables, applications and workflows and deployed that to Data integration service for further execution of workflow.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Analyzing the source data coming from different sources and working with business users and developers to design the Data Integration Model/Patterns.
• Worked with Power Center Designer tools in developing mappings to extract and load the data from XML files into different Flat File formats.
• Using Informatica Power Center created mappings and mapplets to transform the data according to the business rules.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Lookup, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Responsible for creating scalable, multithreaded ETL PL/SQL framework to run batch jobs to move data from landing zone to Target tables.
• Write ETL design documents, establish ETL coding standards and perform mapping reviews.
• Involved in development and debugging of complex batch T-SQL Procedures and functions.
• Developed mapping parameters and variables to support SQL override.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Involved in data modeling to identify the gaps with respect to business requirements and transforming the business rules.
• 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 Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Developed Shell scripts using UNIX to drop and recreate indexes and key constraints.
• Used TOAD to develop oracle PL/SQL Stored Procedures.
• Working in the Agile (Scrum) software development process, for the better accurate signoff.
• Designed and developed complex procedures to handle errors and exceptions at both application and database level using PL/SQL and shell scripts.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 9x, SQL, PL/SQL, Data Warehouse, Oracle, Control-M.

Confidential, Dearborn, MI

Informatica Developer/Project Coordinator

Responsibilities:

• Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Extensively worked on Power Center 9.1 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Involved in gathering and analyzing the requirements and preparing business rules.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Experience in Designing ETL & Data Integration Solutions, Development and Support using Informatica PowerCenter.
• Extensively Worked with Data Modeler, Data Analysts and Business Users to gather, verify and validate various business requirements.
• Write Stored Procedures and T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
• Developed Database application to meet business need using Oracle PL/SQL features. Created Packages, Procedures, Functions and Triggers.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Worked on performance tuning of the ETL processes. Optimized/tuned mappings for better performance and efficiency.
• Written PLSQL code for the data integration between Informatica and other Source systems.
• Extensively used Informatica Power Center for extracting, transforming and loading into different databases.
• Defined Target Load Order Plan and to load data correctly into different Target Tables.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Involved in designing the ETL testing strategies for functional, integration & system testing for Data warehouse implementation.
• Recommended tweaks and changes to the data model design based on the challenges in implementing ETL code.
• Developed complex mappings using Informatica Power Center Designer to transform and load data from different sources and loaded in to Oracle using Informatica.
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed, Debugged mappings for failed sessions.
• Perform backend coding and testing using database SQL and PL/SQL queries.
• Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Created data models for information systems by applying formal data modeling techniques.
• Strong expertise in physical modeling with knowledge to use Primary, Secondary, PPI, and Join Indexes.
• Created Mappings and used transformations like Source Qualifier, Filter, Update Strategy, Lookup, Router, Joiner, Normalizer, Aggregator, Sequence Generator and Address validator.
• Involved in enhancements and maintenance activities of the data warehouse including performance tuning.
• Designed Fact tables and Dimension tables for star schemas and snowflake schemas using ERWIN tool and used them for building reports.
• Performed Unit testing and created Unix Shell Scripts and provided on call support.
• Created sessions and workflows to run with the logic embedded in the mappings.

Environment: Informatica Power Center 8x/9x, Workflow Manager, Workflow Monitor, Informatica Power Connect/ Power Exchange, Toad, Data Warehouse, SQL Developer, Oracle 11g, SQL loader, PL/SQL, ErwinLinux.

Confidential, Hartford, CT

Informatica Developer

Responsibilities:

• Analyze the business requirements and framing the Business Logic for the ETL Process and maintained the ETL process using Informatica Power Center.
• Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator.
• Responsible for definition, development and testing of processes/programs necessary to extract data from operational database and syndicated File System IMS and, SWIFT, HL 7 and EDI-X12 flat files.
• Responsible for the design of mapping and delivering the Business data for the data warehouse from existing data sources.
• Worked extensively with HL7 Data, EDI X12 Messages, HIPAA Transactions, ICD Codes.
• Worked with HIPAA Transactions and EDI transaction sets (834, 835, 837, 824, 820, 270, 276, 271, 278)
• Develop an ETL Informatica mapping in order to load data into staging area. Extracted from Mainframe files and databases and loaded into Oracle 11g target database.
• Create workflows and work lets for Informatica Mappings.
• Work on SQL coding for overriding for generated SQL query in Informatica.
• Involve in Unit testing for the validity of the data from different data sources.
• Extensively used Informatica to load data from various Data Sources like Flat files, Oracle, SQL Server, into the Enterprise Data Warehouse.
• Design and develop PL/SQL packages, stored procedure, tables, views, indexes and functions.
• Experience dealing with partitioned tables and automating the process of partition drop and create in oracle database.
• Involved in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Involve in migrating the ETL application from development environment to testing environment.
• Perform data validation in the target tables using complex SQLs to make sure all the modules are integrated correctly.
• Perform Data Conversion/Data migration using Informatica Power Center.
• Involve in performance tuning for better data migration process.
• Analyze Session log files to resolve error in mapping and identified bottlenecks and tuned them for optimal performance.
• Create UNIX shell scripts for Informatica pre/post session operations.
• Worked on Direct Connect process to transfer the files between servers.
• Document and present the production/support documents for the components developed, when handing-over the application to the production support team.
• Worked with XML targets for the data coming from SQL server source.
• Query tuning and SQL Query override used in Source Qualifier transformation to pull historical data from database not earlier than the given date i.e. the change data capture (CDC).
• Parameterized the whole process by using the parameter file for the variables.
• Imported xsd file to create the xml target and create the Hierarchical Relationship And normalized views.
• Scheduled the batch jobs in Autosys to automate the process.
• Created complex Shell scripts for various set of actions that would automate the process of executing the actions like validating the presence of indicator files.
• Pushing the compressed and encrypted xml files and flat files generated to the external vendor using MFT.
• Involved in Unit testing and system integration testing (SIT) of the projects.
• Assist the team members with the mappings developed as part of knowledge transfer.

Environment: Informatica Power Center 8x, Windows Server 2008, Data Warehouse, Oracle, MS-SQL Server 2005, Batch Scripting, Perl Scripting, XML Targets, Flat Files,), UNIX..

Confidential, NYC

Informatica Developer

Responsibilities:

• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created source-to-target mappings for loading data warehouse/data marts.
• Creating the mappings using transformations Filter, Expression, Aggregator, Sorter, Lookup, and Update Strategy.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning and storage of data.
• Formulating the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing.
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Wrote complex SQL Queries involving multiple tables with joins.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Perform Data Conversion/Data migration using Informatica Power Center.
• Performing database testing to verify backend database transactions.
• Implemented best practices as per the standards while designing technical documents and developing Informatica ETL process.
• Created Source-to-target (S2T) mapping document as part of Data Analysis.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Did performance tuning to improve Data Extraction, Data process and Load time.
• Involving in communication between UAT team members, business leaders, and IT.
• Working on conversion of manual tests into automated test scripts.
• Modifying and executing test scripts for web-based environment-using Quality Center.

Environment: Informatica Power Center 8x, Oracle, SQL Server, Windows, UNIX, UNIX Shell Script.