SUMMARY

• 8 years of experience in IT in the areas of analysis, design, development and testing in client server environment with focus on Data warehousing applications using ETL/OLAP tools like Informatica, Teradata, Business Objects with Oracle, SQL Server databases, etc.
• Involved in complete software development life cycle (SDLC) of project with experience in domains like Retail, Confidential Insurance and Confidential .
• Strong experience in Informatica administration and was involved in maintaining Informatica Repository and Server processes, performing code migration from DEV to TEST/ PROD, backup and restoring of Informatica Repository and upgrades.
• Experience in business requirements gathering, define and capture metadata for business rules, system analysis, design, development, production support, testing, user, and strategic decision making, problem solving associated with the ETL processes by working closely with BI team.
• Experience in Informatica mapping specification documentation, tuning mappings to increase performance, proficient in creating and scheduling workflows and expertise in Automation of ETL processes with scheduling tools such as Autosys.
• Experience in developing Enterprise level Data warehouse, Data marts and Operational databases.
• Experience in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica 9.1.6/9.1.0/8.6/7. x/6.x/5.x.
• Experience in source systems analysis and data extraction from various sources like Flat files, Confidential 11g/10g/9i/8i, DB2 UDB.
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ ).
• Extensive experience using tools and technologies such as Confidential 11g/10g/9i/8i, SQL Server 2000/2005/2008 , DB2 UDB, Sybase, Confidential 13/12/ V2R5/V2R4, Netezza MS Access, SQL, PL/SQL, SQL*Plus, Sun Solaris 2.x, Erwin 4.0/3.5, SQL* Loader, TOAD, Stored procedures, triggers.
• Experience in Performance Tuning. Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Experience in using Teradata Utilities such as Tpump, Fast Load and Mload. Created BTEQ scripts.
• Experienced in the development, modification of UNIX SHELL SCRIPT.
• Strong data modelingexperienceusing Star/Snowflakeschema,Re - engineering, Dimensional Data modeling , Fact & Dimension tables, Physical &logical data modeling .
• Experience in writing complex sub queries, PL/SQL programs (functions, procedures, packages), stored procedures, and shell scripting to run pre-session and post session commands.
• Worked with heterogeneous data sources like Oracle, SQL Server 2008/2005, flat files, XML files, DB2 UDB, Main Frames and COBOL files.
• Perform error handling as part of production support on Informatica as well as Unix.
• Experience in performance tuning of sources, transformations, targets, mapplet, mappings, worklets, workflows, sessions and batches.
• Expertise in using GUI tolls like Erwin, Toad, SQL Developer, SQL Navigator and SQL *Loader.
• Excellent communication skills, team player, ability to work individually and meet tight deadlines.
• Experience in Installation, Configuration, and Administration of Informatica Power Center 9.x/8.x/7.x/6.x, power exchange8.1 and Power Mart 5.x/6.x Client, Server.
• Experience in Validating ETL Tools like Informatica Power Center.
• Extensive knowledge in System Testing / Integration Testing and Regression testing
• Extensive experience in writing SQL scripts to validate the database systems and for backend database testing.
• Expertise in defining Test Strategies, writing detailed Test Plan and Test Cases, Defect Tracking and Defect Reporting using Mercury Quality Center.
• Adaptable and proficient in the design and programming of systems in a wide variety of areas including Real Time Systems.
• Strong Team Player with communication and relationship management skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.1/9.5/8.6/8.1/7.1 , Metadata Manager, Power-Exchange,DataStage etc.

Reporting Tools: Business Objects XIR2/6.1/5.0, Confidential Analytics.

Databases: Confidential V15/V14/V13, Confidential 11g/10g, MS SQL Server 2008/2005/2000 , MS Access, Confidential, DB2

Data Modeling: Data Vault Modelling, Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

DB Tools: TOAD, SQL Developer, SQL Assistant, Visio, ERWIN

Languages: C, Java, SQL, PL/SQL, Unix Shell Scripting

OS: UNIX, Windows 7/Vista/Server 2003/XP/2000/9x/NT/DOS

PROFESSIONAL EXPERIENCE

Confidential, Birmingham, AL

Sr. Informatica Developer

Responsibilities:

• Involved in gathering and analysis business requirement and writing requirement specification documents and identified data sources and targets.
• Understanding of Business Requirement Documents, Data models & Architecture of project.
• Communicated with business customers to discuss the issues and requirements.
• Developed ETL programs using Informatica to implement the business requirements.
• Involved in test data set up and data quality testing and Unit testing and Integration Testing.
• Responsible for developing PL/SQL Stored Procedures, Functions, Packages, triggers and other database objects.
• Extensive use of SQL Query, Joining tables, SQL functions in Queries, PL/SQL with the use of Cursors, REF Cursors and loops .
• Configure deployment groups using Informatica Repository Tool to integrate all the ETL objects like Source definitions, Target definitions, Transformations, Mappings, Sessions, Workflows, etc. to be migrated to Production environment.
• Structure the parameters to be used in a file to manage the relational connections, schema names used in different environments to ensure smoother migration process.
• Designed and developed complex Informatica mappings using different transformations like Aggregators, Connected & Unconnected Lookups, Update Strategy, Filter and Sequence Generator .
• Created flexible mappings / sessions using parameters, variables and heavily using parameter files.
• Analyzed the session logs, bad files and error tables for troubleshooting mappings and sessions.
• Performance tuning of the mapping where goal was to insert millions of rows to target by identifying bottleneck at target, source, mapping and session level.
• Extensively worked on Labeler, Parser, Key Generator, Match, Merge, Consolidation transformations to identify the duplicate records.
• Created mappings using the Transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy, Transaction control, Sorter etc.
• Performed tuning of queries, targets, sources, mappings, and sessions.
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, and Aggregator Transformation.
• Tuning of Confidential SQL statements using Explain analyzing the data distribution among AMPs and index usage, collect statistics, definition of indexes.
• Wrote UNIX Shell Scripts for Informatica Pre-Session, Post-Session and Autosys scripts for scheduling the jobs (work flows).
• Worked with Confidential utilities such as M-load, F-load, export etc. to load or extract tables.
• Understand the current application issues, challenges, technology bottleneck if any
• Supported the current requirements from IT team for their support processes, SLA and ticket escalation processes, response, and resolution time.

ENVIRONMENT: Informatica 10.0.1

Skills: Designer, Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor, Transformation techniques.

Data Bases: Confidential 10g/11g/12g, PL/SQL, Toad, Teradata, UNIX, LINUX, Putty.

Confidential, Houston, TX

Informatica Developer

Responsibilities:

• Developed various Mappings with the collection of all Sources, Targets, and Transformations using Designer
• Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle in accordance with requirements and specifications
• Designed and developed mapplets and re-usable transformations, and used them in different mappings
• Experience in Data Warehouse development working with Data migration,Data conversion and Extraction/transformation/Loading using Informatica power center with Oracle , SQL server and DB2 .
• Applied slowly changing dimensions like type 1 and type 2 effectively to handle the delta loads.
• Developed mapping parameters and variables as per the requirement
• Used Debugger to test the data flow and fix the mappings.
• Developed the ETL mechanisms to load the data incrementally from the source database into the staging area and from there to feed the satellite applications in the form of flat files , XML files and relational tables . Most of the extract process was incremental, while others were full loads and snapshots.
• Extensively worked with XML files as the Source and Target, used transformations like XML Generator and XML Parser to transform XML files, used Confidential XML TYPE data type to store XML files.
• Frequently used TeradataUtilities such as BTEQ and Mload for loading small amounts of data and Fload for loading huge amounts of the data into the tables.
• Scheduling the Informatica workflows using Control-M scheduling tool& trouble shooting the Informatica workflows.
• Performed unit testing and integration testing from source to target.
• Worked on multiple projects using Informatica developer tool and loaded the data into Confidential database.
• Involved in performance tuning of the Informatica mapping and identifying the bottlenecks.
• Migrated the workflows and scripts from development environment to test and production environment.
• Actively involved in production support and also transferred the knowledge to the other team members .

ENVIRONMENT: Informatica Power Center 9.1, PL/SQL developer, Teradata, XML, Confidential 11g, Flat files, UNIX, Control-M.

Confidential, Columbus, OH

Sr. Informatica Developer

RESPONSIBILITIES:

• Prepared Conceptual Solutions and Approach documents and gave Ballpark estimates.
• Extraction, Transformation and Loading of the data using Informatica .
• Designed the target load process based on the requirements documents.
• Enhancing the existing mappings where changes are made to the existing mappings using Informatica Power center .
• Develop Mappings and Workflows to load the data into Confidential tables.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions for loading the data into target table.
• Prepared Business Requirement Documents, Software Requirement Analysis and Design Documents (SRD) and Requirement Traceability Matrix for each project workflow based on the information gathered from Solution Business Proposal document.
• Created Workflows, Tasks, database connections using Workflow Manager
• Developed complex Informatica mappings and tuned them for better performance
• Migration of objects across various environments
• Creation of Unit Test Cases.
• Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level. Developing, Testing and debugging the mappings in Informatica .
• Actively involved in Migration of objects across various environments
• Responsible for analyzing and comparing complex data from multiple sources (Teradata, Oracle, flat files).
• Data modeling and design of data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Worked with various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Stored procedure, Router and Normalizer etc.
• Worked with Connected and Unconnected Stored Procedure for pre-& post load sessions
• Designed and Developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Used PMCMD command to start, stop and ping server from UNIX and created Shell scripts to automate the process.
• Worked on production tickets to resolve the issues in a timely manner.
• Prepared Test Strategy and Test Plans for Unit, SIT, UAT and Performance testing.

ENVIRONMENT: Informatica Power Center 9.5, Informatica IDQ, Confidential 10g, Teradata, SQL Server 2008, Toad, PL/SQL, SQL Developer, MS Access, Windows NT, Shell Scripting, Control-M Scheduler , Windows Azure.

Confidential, Wilmington, DE

ETL Developer

RESPONSIBILITIES:

• Involved in all the phases of SDLC.
• Worked closely with business analysts and data analysts to understand and analyze the requirement to come up with robust design and solutions.
• Involved in standardization of Data like of changing a data set to a new standard.
• Data if validated from third party before providing to the internal transformations should be checked for its accuracy (DQ).
• Involved in massive data profiling prior to data staging.
• Created profiles and score cards for the users.
• Used IDQ address validation transformation to generate various reports.
• Created Technical Specification Documents and Solution Design Documents to outline the implementation plans for the requirements.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Designed and developed Mappings for loading MDM HUB.
• Involved in massive data cleansing prior to data staging from flat files.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.5 by using various transformations like Expression, Source Qualifier, Filter, Router, Sorter, Aggregator, Update Strategy, Connected and unconnected look up etc.
• Implemented slowly changing dimensions Type 2 using ETL Informatica tool.
• Created Informatica components required to operate Data Quality (Power Center required)
• Designed best practices on Process Sequence, Dictionaries, Data Quality Lifecycles, Naming Convention, and Version Control.
• Created Use-Case Documents to explain and outline data behavior.
• Developed scripts for creating tables, views, synonyms and materialized views in the datamart.
• Involved in designing and developing logical and physical data models to best suit the requirements.
• Created PL/SQL programs like procedures, function, packages, and cursors to extract data from Target System.
• Utilized dimensional and star-schema modeling to come up with new structures to support drill down.
• Converted business requirements into highly efficient, reusable and scalable Informatica ETL processes.
• Created mapping documents to outline source-to-target mappings and explain business-driven transformation rules.
• Data if sourced from database that has valid not null columns should not undergo DQ check for completeness.
• Designed mappings to read data from various relational and file source systems such as Teradata, Oracle, flat files and XML files.

ENVIRONMENT: Informatica Power Center 9.1, IDQ, Oracle11g, Teradata, SAP HANA, UNIX Shell Scripts.