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.
• Experience in Health Care, Pharma, Banking, Insurance domains
• 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 Informatica.
• Experience in resolving on - going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERWIN and ER-Studio.
• 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.
• Experience in using scheduling toolAutoSysto automate running of Informatica Workflows on a daily Batch Jobs.
• 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.
• Experience with coordinating and leading onsite-offshore development.

TECHNICAL SKILLS

ETL: Informatica Power Center 9.6.1

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

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

Operating Systems: Windows 7,XP and UNIX

Data Model: Erwin and ER-Studio

Scheduling Tools: Control-M, AutoSys

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

PROFESSIONAL EXPERIENCE

Confidential, Franklin, WI

Sr. Informatica Developer

Responsibilities:

• Involved in business requirement analysis and prepared functional requirement document.
• Involved in the ETL technical design discussions and prepared ETL high level technical design document.
• Involved in the analysis of source to target mapping provided by data analysts and prepared function and technical design documents.
• Designed and developed ETL Informatica mappings. Scheduled and Managed Informatica sessions.
• Extracted large volumes of data form Mainframes systems to target DB2 database.
• Extensively worked on Performance tuning of queries. Complex SQL queries are used for data retrieval.
• 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.
• Created various UNIXShell Scriptsfor pre/post session commands for automation of loads usingAutosys.
• 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,DB2, MSSQL 2012, MS Excel, UNIX, AutoSys.

Confidential, Durham, NC

Sr. Informatica Developer

Responsibilities:

• Development of mappings, mapplet, reusable transformations, sessions and workflows in Informatica 9X.
• Development of address cleansing/standardisationMapplet and mapping using Firstlogic plug-in.
• Worked extensively with Extraction, Transformation and Loading of data from Multiple Sources (oracle, fixed width and delimited flat files) to Oracle using Informatica.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator and joiner.
• Worked on Scheduling workflows and sessions using AutuSys and have implemented decision task and email task for tracking the successful completion.
• Worked with parameter and variables in various mappings and sessions.
• Handled the creation of tables, views, triggers, stored procedures, functions, sequences) in the database using SQL and PL/SQL scripts.
• Actively involved in creation of entity relationship diagram using data modelling techniques by interacting with the code development team.
• Good understanding of session logs and handled the rejected load with reject files.
• Have worked with Debugger tool of Informatica in the mapping when the desired result is not achieved( in case of errors in the output)
• Performing unit test, functional test and integration test depending upon the environments along with testing team.
• Handling of Support Central and SPR requests (Data fixes when change is reported).
• Performed the Database management activities for each new release.
• Preparing technical documents for the Informatica scheduled jobs and data mappings.

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

Confidential, NY

Sr. Informatica 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.
• Involved in creation of Low Level Design (LLD) document for Informatica mappings.
• Worked extensively with extraction, transformation and loading of data from different sources to the database.
• Developed and tested all the Informatica mappings, mapplets involving transformation such as lookup, router, filter, update strategy, sequence generator, joiner, stored procedure.
• Worked on creation of tables, views, triggers, stored procedures, functions, sequences in the database using SQL and PL/SQL scripts.
• Created pre-session and post-session SQLs to drop/create indexes for fast loading of the data.
• Implemented the Snowflake Schema Methodology during our Data Modelling.
• Knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions.
• Knowledge of the session logs and handled the rejected load with reject files.
• Performing unit test, functional test and integration test depending upon the environments along with testing team.

Environment: Informatica 8X, Oracle 10g, DB2, MSSQL,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.
• Worked closely withFacets 4.48, 4.51and differentEDI transaction filelike837,834, 835, 270, 271 to understand the source structure and the source data pattern.
• 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, AutoSys, Erwin, TOAD, UNIX and Windows XP

Confidential, Santa Clara, CA

Informatica 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 Wells Fargo 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, MS SQL 2008, SQL, PL/SQL, UNIX.

Confidential, San Jose, CA

Informatica Developer

Responsibilities:

• Extensively involved in System Study & Business Requirement Analysis.
• 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