SUMMARY

• I have 9 years of IT experience in Software Development Life Cycle (SDLC) which includes requirement gathering, designing, implementing, Maintenance and testing and Data Warehousing implementations across various domains.
• Proficient in Analyzing Business processes requirements and translating them into technical requirements.
• Implemented various ETL solutions as per the business requirement using Informatica 9.6.1.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle,, DB2 and SQL Server Databases.
• Designed, developed, implemented and maintained Informatica PowerCenter 9.6.1 and IDQ application for matching and merging process.
• Developed and maintained ETL (Data Extract, Transformation and Loading) mappings to extract the Data from multiple source systems like Oracle, and Flat Files and loaded into MS SQL Server using IDQ.
• Performed the data profiling and analysis making use ofInformatica Data Quality (IDQ).
• Experience in resolving on - going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Designed and developed complex mappings using different transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner Update Strategy and more.
• Developed Slowly Changing Dimension for Types 1 SCD, Type 2 SCD, Type 3 SCD.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Well acquainted with Performance Tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERWIN and ER-Studio.
• Experience in using Automation Scheduling tools like AutoSys and Control-M.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

ETL: Informatica Power Center 9.6.1 and IDQ 9X

Data Bases: Oracle 11g/10g, MS SQL Server 2008and DB2

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

Operating Systems: Windows 7,XP and UNIX

Data Model: Erwin

Scheduling Tools: Control-M, AutoSys

Database Connecting Tools: Toad, SQL Developer, Rapid SQL and Putty

PROFESSIONAL EXPERIENCE

Confidential, Franklin, WI

Sr. Informatica Developer

Responsibilities:

• Analysis of business requirements, design and development of ETL mappings involving complex business rules.
• Involved in Dimensional modeling of the data warehouse projects by using star schema
• Designed and developed ETL Informatica mappings. Scheduled and Managed Informatica sessions.
• Data Modeling (Physical and logical) using Erwin. Developed Data mapping and filtering procedures.
• Extracted large volumes of data form Mainframes systems to target Oracle database.
• Extensively worked on Performance tuning of queries. Complex SQL queries are used for data retrieval.
• PerformedData Analysisto summarize data with the intent to extract useful information and develop conclusion using theIDQtool.
• Utilized ofIDQ to complete initial dataprofiling and matching/removing duplicate data.
• Designed, Developed and Deployed UNIX shell scripts.
• Development & Implementation of a data warehousing project and also production support for enhancements and maintenance.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Coordinated and worked closely with architects, operations, and business units to build and deploy.
• Implementing data quality management solutions that manage millions of customer transactions.
• Configuration and Administration of Informatica Servers.
• Oversee the technical design of the data warehouse, optimizing for scale and performance.
• Performed systems, data quality assurance, system testing, ensuring that software and systems perform to specification
• Established test environments and test data and advocate the use of common re-usable functions, services and data
• Participated in quality assurance activities like reviews, walkthroughs etc.
• Performed extensive risk assessment prior to production implementations and carried out validations for post implementation to ensure successful execution monitoring performance.
• Assign work and responsible for providing technical expertise for the design and execution of ETL projects to onshore and offshore developers.

Environment: Informatica Power Center 9.6.1,IDQ 9X, DB2, MS Excel, UNIX, Control-M

Confidential, Durham, NC

Sr. Informatica Developer

Responsibilities:

• Involved in development of Logical and Physical data models that capture current state Developed and tested all the informatica Data mappings, sessions and workflows - involving several Tasks.
• Worked on source analyzer, Ware House Designer, Mapping and Mapplet Designer, Workflow manager and Workflow Monitor.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
• Identified and eliminated duplicates in datasets thorough IDQ components of Edit Distance, Jaro Distance and Mixed Field matcher, It enables the creation of a single view of customers, help control costs associated with mailing lists by preventing multiple pieces of mail.
• Created mappings for initial load in PowerCenter Designer using the transformations Expression, Router and Source Qualifier.
• Created complex mappings for full load into target in PowerCenter Designer using Sorter, Connected Lookup, Unconnected Lookup, Update Strategy, Router, and Union.
• Created Mapplets to reuse all the set of transformations for all mappings.
• Created work flows and sessions for each mapping that we are extracting from source systems to staging area; staging area to target.
• Responsibilities include creating the sessions and scheduling the sessions.
• Created various tasks to give various conditions in the workflows.
• Involving in extracting the data from Oracle and Flat files Developed and implemented various enhancements to the application in the form of Production and new production rollouts.
• Participated in the enterprise performance tuning of Informatica for sources, targets, mappings and sessions.
• Performed Unit testing on the Informatica code by running in the debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for the optimum performance.
• Involved in fixing invalid Mappings, Testing of Informatica Sessions, Worklets and Workflows.
• Created parameters and variables for the reusable sessions.
• Analyzed the various bottlenecks at source, target, mapping and session level.
• Tuning of the mappings and SQL Scripts for a better performance.
• Designed the ETL processes using Informatica to load data from DB2, SQL Server and Flat files to the Target Database.
• Experience in analyzing business specification documents, developing test plans defining test cases, developing and XML test scripts.
• Assign work and responsible for providing technical expertise for the design and execution of ETL projects to onshore and offshore developers.

Environment: Informatica Power Center 9X, IDQ 9X, Oracle 11g, PLSQL, DB2, MS SQL Server 2012/2008, MS Excel, UNIX, Autosys

Confidential, Oakland, CA

Sr. Informatica ETL Developer

Responsibilities:

• Involved in Requirement Analysis, ETL Design and Development for extracting the data which is stored in different sources like Oracle, SQL Server and DB2.
• Analyzed, designed and developed an environment that would facilitate the use of Informatica to transform data coming from IGRASP OLTP into ADIMdatamarts.
• Used BTEQ front-endtool to issue SQL commands matching the business requirements to TeradataRDBMS.
• DevelopedBTEQ scriptsto process the data in staging server.
• Developed complex Informatica Mappings with transformations like lookup, router, aggregator, expression, update strategy, joiner and etc.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Created sessions, worklets, workflows for the mapping to run daily, biweekly based on the business requirements.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Implemented Slowly Changing Dimension type2 methodology in Informatica.
• Worked on handling performance issues of Informatica Mappings, evaluating current logic for tuning possibilities.
• Tuned SQL, PL/SQL Queries in Source qualifier Transformation for better performance.
• Created and executed unit test cases for various scenarios for all the mappings, workflows and scripts.
• Involved in unit testing and fixing the bugs identified, provided data to the reporting team for their daily, weekly and monthly reports.
• Worked on modification of UNIX shell scripts.
• Involved in team weekly and by monthly status meetings.

Environment: Informatica 8X, Oracle 10g, BTEQ, Windows 7,UNIX

Confidential, Woodland Hills, CA

Informatica ETL Developer

Responsibilities:

• Analysis, requirements gathering, functional/technical specification, development, deploying and testing.
• Significant Multi-dimensional and Relational data modeling experience with modeling tool like ERWIN with a strong emphasis on data Warehouse/data Marts analysis, design, and implementation.
• Extensive use of Informatica Tools like Designer, Workflow Manger and Workflow Monitor.
• Extensively used Informatica client tools like Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer, and Informatica Server Manager.
• Extracted source data from Oracle, SQL Server, Flat files and XML using Informatica, and loaded into Oracle or flat file targets.
• Used transformations like Aggregators, Sorter, Dynamic lookups, Connected & unconnected lookups, Filters, Expression, Router, Joiner, Source Qualifier, Update Strategy, sequence Generator.
• Developed, tested stored procedures, functions in PL/SQL
• Created reusable transformations and mapplets to use in multiple mappings
• Used Workflow Manager/Monitor for creating and monitoring workflows and worklets.
• Improved the session performance by pipe line partitioning
• Extensively used mapping parameters, mapping variables and parameter files
• Analyzed the query performance and designed the loading process schedules
• Created sessions and batches for various mappings and automated using UNIX shell scripts.
• Wrote the shell scripts to process the PL/SQL procedures and wrote the PL/SQL program units for data extracting, transforming and loading.
• Involved in troubleshooting the loading failure cases, including database problems.

Environment: Informatica 8X, Oracle 10g, Erwin, TOAD, UNIX and Windows XP

Confidential, San Jose, CA

Informatica Developer

Responsibilities:

• Extensively involved in System Study & Business Requirement Analysis.
• Involved in the design and development of Star schema using dimensional modeling.
• Created and maintained the centralized repository using Informatica Power Center.
• Informatica Designer tools were used to design the source definition, target definition and transformations to build mappings.
• Maintained and improved integrity by identifying and creating relationships between tables
• Developed and implemented Error Handling Strategies
• Worked with mapping wizards for slowly changing dimensions and slowly growing dimensions by using Informatica mapping designer.
• Used Shell Script to execute post-session and pre-session commands
• Designed and developed complex aggregate, join, lookup transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica Power Center.
• Designed and developed mappings using Source qualifier, Aggregator, Joiner, Lookup, Sequence generator, stored procedure, Expression, Filter and Rank transformations.
• Created stored procedures to validate the data before loading data into data marts.

Environment: Informatica 8X, Oracle 9i, Flat Files, XML Files, PL/SQL, TOAD for Oracle

Confidential, Framingham, MA

ETL Developer

Responsibilities:

• Interacting with Business analyst and on-site coordinates for requirement analysis.
• Successfully solved Tracks assigned.
• Data Handling in Informatica and Oracle 9i.
• Created mappings and work flows to implement business requirements.
• Designing and developing mappings to extract data from diverse sources including flat files, and RDBMS tables.
• Development & support of client’s manufacturing and purchasing applications and end user reporting.
• Analyzed the Change requests (RFC) and Business Requirement Documents (BRD) as per requests
• Create, backup, restore for Informatica Repositories
• Involved in migration of objects in all phases (DEV, SIT and PRD) of project
• Involving Testing, Debugging, Validation and Performance Tuning of data warehouse, help develop optimum solutions for data warehouse deliverables.
• Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loading process.
• Interacted with Business Analyst and user for requirement gathering and created High Level and Low Level design documents.
• Suggested redesign of ETL processes and also re-architecture of existing ETL processes.
• Support defect resolution and perform change management by updating Technical system specification documentation, this will require analysis of existing software systems, and designing and implement testing for existing and new software systems.
• Gather Requirements, Perform Impact Analysis and Create the functional and Technical documentation for ETL process for Real time data process.
• Work closely with business users and involve in designing, developing high complexity mappings.
• Performed unit testing.

Environment: Informatica 8X, Oracle 9i, PL/SQL, SQL Developer, UNIX

Confidential, Durham, NC

ETL Developer

Responsibilities:

• Designing and reviewing the ETL solutions in Informatica Power Center 8X
• Based on the requirements, created Functional design documents and Technical Design specification documents for ETL Process.
• Worked as ETL Developer involved in the development of ETL process using Informatica to load data from source oracle database into the target oracle database and flat files.
• Designing and optimizing the Mapping to load the data in Slowly Changing Dimensions.
• Involved in Performance Tuning at various levels including Target, Source and Mapping.
• Used Debugger to gain troubleshooting information from the mappings.
• Worked on Migration from Dev environment to Test Environment.
• Assisted gathering business requirements and worked closely in various Applications with Business Analyst teams to develop Data Model, ETL procedures to design Data Warehouse.
• Designed and developed schema model for target database using Erwin Data modeling.
• Designed and developed Context for faster development, standardization and reusability purposes.
• Involved in pre and post session migration planning for optimizing data load performance.
• Understanding client process to work efficiently and deliver solutions in accordance with Confidential quality control standards and business practices and procedures.
• Have developed a level of competency, which helps to anticipate issues solve them in advance.
• Involved in analyzing, resolving and providing temporary fix for the Data issues Also he had to interact with the business users to intimate and do the recovery steps if there is any problem in the process
• Deployment to various servers & Migration activities.
• Done unit testing of the mappings.

Environment: Informatica 8X, Oracle 9i, SQL, PL/SQL, UNIX.

Confidential, Durham, NC

SQL Developer

Responsibilities:

• Involved in understanding requirements, analyze new and current systems to quickly identify required sources and targets
• Prepared technical documentation, design transformations that are consistent with the goals of the existing data warehouse, and worked with the development team to implement the solution
• Worked in legacy code to analyze problems, confirm requirements, and create designs, code and testing.
• Wrote complex SQL queries and demonstrated ability to collaborate with other developers during Design, Development, and Testing.
• Used design and development techniques that resulted in efficient, maintainable, and high quality ETL processes.
• Used problem solving skills and quickly understood relationships between data with little documentation or guidance.

Environment: Oracle 8i, Windows XP