SUMMARY

• 8 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Telecom, Banking, Health care, Insurance and Financial.
• Experienced in Data Warehousing concepts, Dimensional modeling like Star Schema, Relational modeling, Snowflake Schema, 3NF and database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
• Involved in Full Life Cycle Development of building a Data Warehouse.
• Extensive experience in Data Extraction, Transformation and Loading Data using Informatica PowerCenter 9.x/8.x (Admin Console, Informatica Service, Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
• Worked on slowly changing dimensions like SCD type - 1, type-2 and type-3 to maintain the transactional data and historical data for the need of business process and change data capture (CDC) using Informatica applications.
• Extensively worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• Implemented Data Cleansing, Data Analysis, Data Profiling, Transformation Scripts and necessary Test plans to ensure the successful execution of the data loading processes.
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments.
• Experienced in debugging and performance tuning of sources, targets, mappings, and sessions in Informatica.
• Good Knowledge onapplying rules and policies using ILM (Information Life Cycle Management) workbench for Data Masking Transformationand loading into targets.
• Experience on ER Data Modeling tools likeErwin, ER-StudioandVisioin developing Fact & Dimensional tables, Logical and Physical models.
• Performed System Analysis, QA testing and involved in Production Support.
• Created the SQL Views, Table pairs and created the DVO jobs for validating the Source and Target Tables data as part of Automation Testing.
• Excellent communication and interpersonal skills. Ability to work effectively as a team member as well as an individual.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.x/8.x, Informatica Data Quality 9.x/8.x, Informatica Power Exchange 8.x

Operating Systems: Microsoft Windows 7/Vista/XP, UNIX, LINUX

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

Database: Oracle 11g/10g, SQL Server 2012/2008, DB2, Teradata, MySQL

Reporting Tools: Crystal Reports, Tableau

Tools: /Utilities: SQL Server Management Studio, MS SQL Server Analysis Services (SSAS), IBM Cognos, PLSQL Developer, TOAD, SQL Developer, Erwin, DRM 11g, Talend

Scheduler: Control-M, AutoSys, Active Batch 7, Tidal

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

Informatica ETL Developer

Responsibilities:

• Involved in understanding requirements, analyze new and current systems to quickly identify required sources and targets.
• Built the Mappings with Informatica 9.6 PowerCenter Designer using transformations like Source Qualifier, Expression, Filter, Router, Joiner, Sequence developer, Update Strategy, Lookup, Sorter, Aggregator, Normalizer, XML Source Qualifier, and Stored Procedure.
• Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads and Data Transformations.
• Experience in Informatica Power Exchange 9.5, 9.6 in pulling mainframe VSAM Files & Flat file and sequential files.
• Responsible for creating Workflows and sessions usingInformaticaworkflow manager and monitor the workflow run and statistic properties onInformatica Workflow Monitor.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Teradata, MS Access, and Flat files.
• Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle 11g in accordance with requirements and specifications.
• Used BTEQ andSQL Assistant(Query man) front-endtools to issue SQL commands matching the business requirements to TeradataRDBMS.
• Involved in cleansing, consolidating and re-structuring of the data as part of the data conversion and ongoing data integration processes.
• Built Shell Script which will FTP the data onto the server in .dat format, merge the file form different organizations and make it into a delimited source file.
• Developed Complex SQL queries using various Joins, Sub-Queries, Analytical and Group Functions and developed various dynamic SQL's thorough out the projects.
• Was involved in the performance tuning mappings, sessions, Source and Target.
• Used SQL to perform data analysis, data profiling and generating reports.
• Used PLSQL Developer for running SQL queries.
• Create various extracts from EDW based on business requirements using Teradata BTEQ and Fast Export.
• Modifying and remediate existing Teradata BTEQ scripts to reflect changing business data requirements.
• Performed Informatica Administrator functions like creating repository, Groups Users, Folders, giving permissions on the folders to the users etc.
• Was involved in unittestingby usingDebuggerand writing simple test scripts and eliminating thebottlenecksfor optimumperformance.
• TidalScheduler was implemented for scheduling of Informatica workflows.

Environment: Informatica PowerCenter 9.5/9.6, Oracle 11g, SQL Server 2012, Teradata, PL/SQL Developer, Informatica Power Exchange, SQL, PL/SQL, UNIX Shell Scripting, Tidal, Toad.

Confidential, St. Louis, Missouri

Informatica ETL Developer

Responsibilities:

• Extensively involved in almost all the phases of Project Life Cycle (SDLC) right from Requirements Gathering to Testing and Implementation etc.
• Developed various Informatica Mappings & Mapplets to load data to ODS using different transformations like Source Qualifier, Joiner, Router, Sorter, Aggregator, Connected and Unconnected Lookup, Update Strategy, Expression, Stored Procedure, Java, Normalizer, Xml and Sequence Generator to load the data into the target tables.
• Created and Monitored Sessions and various other Tasks such as Decision, Email, Assignment, Command etc using Informatica Workflow Manager.
• Developed and implemented Error Handling Strategies for Informatica ETL process.
• Utilized the Informatica Data Quality (IDQ 8.6) application and performs data profiling necessary to resolve issues uncovered and related to source data.
• Extracted the data from MS Access and SQL Server to SSIS for generating reports.
• Improving the performance of reports by tuning SQL Queries, Universes by using Aggregate Awareness, Short Cut Joins, tuning at Database level by creating Indexes, Views.
• Used SQL for querying and analysis purposes on various source tables and conditions applied and Wrote SQL joins, sub queries.
• Working on Extract, Transform & Load Process like Writing MS SQL, Procedures, Scheduling Jobs, using various Transformations using SQL Server Integration Service.
• Developed PL/SQL stored procedures and functions to handle various activities outside of Informatica ETL process. Created PL/SQL Functions & Procedures for the ETL process and for Data Validations between source and target tables.
• Develop and deliver dynamic reporting solutions using SQL Server 2008 Reporting Services (SSRS).
• Worked on Batch Processing or Scheduling and Shell Scripting.
• Closely worked and assisted the QA team during the test cycles to resolve the issues and bug fixing.
• Provided 24 x 7 production support and maintenance for all the applications with the ETL process.
• Responsible for catering day-to-day administration activities.
• Worked closely with reporting team to generate various reports.
• Worked on Virtual Tickets during production support and used AutoSys tool for scheduling.

Environment: Informatica PowerCenter 8.6, Informatica PowerCenter Data Profiling, SSIS, SSAS, SSRS, MS Access, Informatica Data Quality 8.6, SQL Server 2008, XML, Unix Shell Scripts, DB2, AutoSys.

Confidential, Albany, NY

Informatica ETL Developer

Responsibilities:

• Responsible for optimizing the ETL mappings and monitoring the load process in order to check the data.
• Wrote complex SQL queries, generated views for the administrative department.
• Written Unix Shell Scripts to schedule the Informatica jobs using PMCMD command.
• Created various active and passive transformations to support voluminous loading of data target table using Informatica PowerCenter.
• Built variety of prototypes to Extract, Transform and Load data from and to SAP using Informatica Power Connect
• Created SAP BW OHS source definitions in Informatica and configured work flow to run from SAP process chain
• Determine Extraction and Loading techniques from and to SAP, also from Non-SAP sources to SAP using Informatica Power Exchange for SAP Data Integration.
• Wrote queries involving multiple-joins to generate user reports.
• Worked on Teradata Multi-Load, Teradata Fast-Load utility to load data from Oracle and SQL Server to Teradata.
• Involved in identifying surrogate keys for the fact table.
• Defined data definitions, and created target tables in the database.
• Written PL/SQL Procedures, Function and Packages to perform database operations and pre & post session commands.
• Export/Import data from DRM using the DRM migration modules.
• Involved in Unit Testing,System Testing, User Acceptance Testingto check whether the dataloadinto target are accuratewhich was extracted from different source systems according to the user requirements by generating several SQL test scripts, validating against test casesbased on the pre-defined test plans.

Environment: Informatica PowerCenter 8.6, SQL, Oracle 10g, Teradata, MySQL, PL/SQL, SAP BO SQL, Toad, UNIX, SAP, HP Quality Control, Linux, SQL*PLUS, Control-M.

Confidential, Madison, WI

Informatica ETL Developer

Responsibilities:

• Worked on Informatica PowerCenter tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Developer.
• Developed complex mappings using Informatica PowerCenter Designer to transform and load data.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Aggregator, Filter, and Lookup.
• Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations.
• Data Warehouse Data modeling based on the client requirement using Erwin (Conceptual, Logical and Physical Data Modeling).
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Implemented complex mappings such as Slowly Changing Dimensions.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Built in mapping variable/parameters and created parameter files for imparting flexible runs of workflows based on changing variable values.
• Maintain Development, Test and Production mapping migration Using Repository Manager.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.

Environment: Informatica PowerCenter 8.1, DB2, Oracle10g, MySQL, SQL, Erwin, Linux, Control-M.

Confidential

Informatica ETL Developer

Responsibilities:

• Analyzed source database (Sybase), designed mapping (using various transformations like Update Strategy, Look Up, Stored Procedure, Router, Filter, Sequence Generator, Joiner, Aggregate and Expression) to transform and load data on target databases(SQL Server) using Informatica PowerCenter (ETL Tool).
• Analyzed and Resolved issues in Extraction, Transformation and Loading (ETL) Processes, especially in transformation and mapping development.
• Debugged invalid mappings using break points tested stored procedures, functions, Informatica sessions, batches and the target data.
• Wrote stored procedures in PL/SQL and UNIX Shell Scripts for automated execution of jobs.
• Identified performance bottlenecks and resolved those issues by Query optimization, dropping Indexes and Constraints, bulk loading.
• Created reusable transformations and mapplets to use in multiple mappings.
• Created complex/ad-hoc reports using Business Objects reporter and exported to the repository.
• Generated various reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Functions, Cross Tab, Master/Detail and Formulas as per client requirements.

Environment: Informatica PowerCenter 7.1, Sybase, SQL Server 2000, SQL/PLSQL, UNIX Shell Programming, and Windows 2000.