SUMMARY

• 8+ years of experience in implementing Extraction, Transformation and Loading (ETL) using Informatica Power Center 9.x/8.x/7.x/6.x(Source Analyzer, Data Warehousing Designer, Mapping Designer, Maple Designer, Transformation developer).
• Extensively worked on Relational Databases Systems like Oracle11g/10g/9i/8i, MS SQL Server and Source files like flat files, XML files and COBOL files.
• Experience in all phases of software Development Life Cycle (SDLC) Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Expertise in Data warehousing concepts like OLTP/OLAP System Study, Analysis and E - R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.
• Involved in Troubleshooting data warehouse bottlenecks, Performance tuning - session and mapping tuning, session partitioning & implementing Pushdown optimization.
• Extensive experience in designing and developing complex mapping using transformations like Source Qualifier, Sorter, Aggregator, Expression, Connected and Unconnected Lookup, Filter, Joiner, Sequence Generator, Router, Normalizer and Update Strategy.
• Working experience in Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Experience in integration of various data sources like Oracle, DB2, Sybase, SQL server and MS access and non-relational sources like flat files into staging area.
• Proficiency in data warehousing techniques for Slowly Changing Dimension (type1, type2, type3), surrogate key assignment, Normalization & De-normalization, Cleansing, Performance Optimization along with the CDC (Change Data Capture).
• Worked on Tpump, Mload, Fload, TPT and BTEQ scripts to load the data into tables.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Experience in creating pre-session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs.
• Well in doing Error Handling using various log files.
• Involved in Full Cycle Development (Water, Scrum/Agile) of building a Data Warehouse on windows and Unix Platforms.
• Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per business requirements along with the experience in web services and application protocol interface.
• Enthusiastic and goal-oriented team player, possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5/9.1/8.6/8 , Informatica power Exchange

Databases: Oracle 11g, 10g &9i, SQL Server 2012, Teradata

Database Tools: Toad 10.1.1, SQL, SQL plus, Power Designer, SQL Assistant

Data Cleansing Tool: IDQ

Application server: WebSphere Application Server 6.0/6.1/7.0.

Program Languages: SQL, PL/SQL, UNIX, C, Java

Operating systems: Windows 95/98/NT/2000, UNIX, Linux

Testing Tools: HP Quality Center (QC)

Project Management & Data Modeling Tools: MS-Project, Microsoft Visio

Methodologies: Agile/Scrum, Waterfall.

PROFESSIONAL EXPERIENCE

Confidential, Billerica, MA

Informatica Developer

Responsibilities:

• Analyze the requirements and accordingly plan, develop, design, test and implement the functionality and procedure.
• Designing, Implement and delivering data warehouse ETL power center 9.5.1 and reporting applications.
• Worked with project managers, design lead and solution architect to achieve business and functional requirements.
• Establish controls to ensure the accuracy and consistency of data.
• Review existing systems to determine compatibility with projected and select appropriate systems, including ensuring forward compatibility of existing systems.
• Review existing systems to determine compatibility with projected and select appropriate systems, including ensuring forward compatibility of existing systems
• Involved in loading of data into Oracle from legacy systems and flat files using complex Scripts, also worked in Hyperion EssBase integration.
• Loaded the data into the Oracle database from teradata using Load utilities like Multi Load, Tpump, and Fast Load to load data into oracle data warehouse.
• Used Oracle as a Source and a Target for few mappings. Worked with Teradata loaders within Workflow manager to configure Fast Load and Multi Load sessions.
• Database development and ETL process in Oracle l0g using PSQL, SQL, PERL and UNIX scripting.
• Experience in Installing, Configuring and Administering Web Servers like IBM Http Server (IHS), Apache 2.2, Web server and configuration of Web Server Plug-ins.
• Design/implement queries to extract specific data from legacy system to new data warehouse.
• Designed and created complex source to target mapping using various transformations inclusive of but not limited to Sorter, Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
• Preparation of the various technical and functional documents consisting of Detailed Design Documentation, function test specification with use cases.
• Analysis of source systems and work with business analysts to identify study and understand requirements and translate them into ETL code.
• Supporting, correcting and following up trouble reports Skills.
• Scheduled jobs using Autosys.
• Involved in performance tuning and optimization of Informatica mappings and session using features like Partitions and data/index cache.
• Development, Maintenance, Production Support for scheduled ETL jobs that run on Windows scheduler.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements.
• Worked in debugging using Log messages, Server Messages.
• Perform analysis on quality and source of data to determine accuracy of information being reported.
• Involved in Unit Testing, User Acceptance Testing (UAT) to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.

Environment: Informatica 9.5.1, Oracle 10g, UNIX, PL/SQL Developer, SQL Data Modeler, Teradata, Autosys.

Confidential, Los Angeles, CA

ETL Developer

Responsibilities:

• Involved with requirement gathering and analysis for the data marts focusing on data analysis, data quality, data mapping between ODS, staging tables and data warehouses/data marts.
• Designed and developed processes to support data quality issues and detection and resolutions of error conditions.
• Working with the Business Analysts andthe QA team for validation and verification of the development.
• Analyzed the session logs, bad files and error tables for troubleshooting mappings and sessions.
• Implemented various scenarios related to slowly growing targets and slowly changing dimensions(Type1, Type2, Type3)
• Implemented various business rules of data transformations using various Informatica transformations like Normalizer, Source Qualifier,Update Strategy, Look up(connected/unconnected/static cached/dynamic cached), Sequence Generator, expression, Aggregator, XML(source and generator), Stored Procedures.
• Worked with newer Informatica transformations like Java transformation, Transaction Control.
• Used Teradata as a Source and a Target for few mappings. Worked with Teradata loaders within Workflow manager to configure FastLoad and MultiLoad sessions.
• Provided administrative functions like creating repositories, backing up repositories, setting up users, assigning permissions and setting up folders in Repository manager.
• Worked on Oracle Warehouse Builder for already existing workflows to get the final source files for use.
• Worked on the Integration tier and was responsible in writing the services to communicate with external resources using messaging systems likeusing JMS.
• Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2, COBOL files & XML Files.
• Involved in the Creation, modification and maintainance of Relational database likeOracle and MS sql serverdatabaseobjects and storage structures including table spaces, tables, users, roles, profiles, directories and indexes.
• Wrote shell script utilities to detect error conditions in production loads and take corrective actions, wrote scripts to backup/restore repositories, backup/restore log files.
• Heavily involved with performance tuning of Oracle database - using TKPr of utility, working with partitioned tables, implementing layer of materialized views to speed up lookup queries, working with Bitmap indexes for dimension tables, DBMS Stats package to update statistics, using SQL hints.

Environment: InformaticaPower Center 9.0.1, Autosys, Oracle 10g/9i, Erwin 4.5, CMS, MS PowerPoint, MS Visio, TOAD, PL/SQL, UNIX, SQL Loader*, JMS, SQL server 2005, IDQ 9.1.0 and 9.5.1.

Confidential, Yardley, PA

Informatica/IDQ Developer

Responsibilities:

• Worked with Data Modeler to understand the business requirements and business rules
• Prepared ETL Specifications to help develop mapping.
• Extracted data from various sources (Flat files, SQL Server, DB2 Databases).
• Designed and developed Informatica power center 8.1 Mappings and sessions based on business user requirements and business rules.
• Worked extensively on Source Analyzer, Mapping Designer, and Warehouse Designer Developed several Mappings using corresponding Sources, Targets and Transformations, Web Services.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Created mappings to read from Flat files, RDBMS and to load into RDBMS tables.
• Based on business Rules Debugged code, tested and validated data after processes are run in development..
• Prepared and maintained mapping specification documentation.
• Modified the existing mappings for the updated logic and better performance.
• Developed Logical Data Flow Diagrams in Visio for every mapping that is developed. Assisted QA Team to fix and find solutions for the production issues.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets
• Developed rules and mapplets that are commonly used in different mappings
• Used various transformations like Address validator, parser, joiner, filter, matching to develop the maps
• 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.
• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
• Worked on multiple projects using Informatica developer tool (IDQ) of latest versions 9.1.0 and 9.5.1.
• Implemented Slowly Changing Dimension mappings of SCD's- Type 1, Type 2, and Type3.
• Expertise in configuring Cells, Nodes, clustering, JDBC Providers, Data Sources, Virtual Hosts, session management.
• Experienced in applying patches for WebSphere Application Server.
• Involved in migration of the mapps from IDQ to power center
• Applied the rules and profiled the source and target table's data using IDQ.
• Developed the mappings, applied rules and transformation logics as per the source and target system requirements.
• Worked on different environments with different source and target databases like Teradata, DB2, and SQL server.
• Developed the mapping to process multiple flat file as source and staged the data into teradata and DB2 databases.
• Resposible for migration of the work from dev environment to testing environment
• Responsible for solving the testing issues.

Environment: Informatica Power center 8.6-HotFix 4, IDQ 9.1/9.5.1 Hotfix 2.0, SQL Server 2007, IBM Mainframes, UNIX, Windows NT, SQL Assistant 6.2.1. WebSphere Application Server 6.0/6.1/7.0.

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Involved in creating the technical architecture and design documents for small project change requests.
• Work with business users directly in gathering requirement and implementing them and working close with offshore developers.
• Worked on Informatica Power Center - Used Source Analyzer and Warehouse designer to import the source and target database schemas and the Mapping Designer, Mapplets and Transformation Developer to map the sources to the target.
• Developed complex mappings to implement the business rules and logic using Expression, Lookup, Filter, Joiner, Rank, Router, Sequence Generator, Normalizer and Update Strategy transformations and tuned for better performance.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level.
• Involved in Data Extraction from Oracle and Flat Files, XML Files using SQL Loader, Freehand SQL.
• Created mappings to extract, transform & load data from different sources using various Transformations.
• Prepared user requirement documentation for mapping and additional functionality.
• Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system.
• Analyzed the requirements and framed the business logic for the ETL process.
• Involved in cleansing and extraction of data and defined quality process for the warehouse.
• Developed slowly changing dimension mappings (Type 1 and Type 2).
• Worked on populating the EDW / Data Marts, multiple fact and dimension tables with star methodology.
• Designed and developed reusable mapplets and used mapping variable and mapping parameters in the ETL mapping.
• Involved in writing various UNIX shell scripts for writing automated scripts for scheduled queue process.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Identified the different bottlenecks.

Environment: Informatica Power Center 8.1.1 (Source Analyzer, Data warehouse designer, Mapping Designer, Mapplets, Transformations, Workflow Manager, Workflow Monitor), Oracle 10g, SQL/PLSQL, Windows and SQL server.

Confidential

Informatica Developer

Responsibilities:

• Designed Parameter driven Informatica mappings and sessions for extracting, cleansing, transforming and loading the data from the Complex Flat Files into the data warehouse
• Used various transformations like Unconnected /Connected Lookup, Aggregator, Expression
• Joiner, Sequence Generator, Router for creating complex business logic in ETL
• Developed logic using sequence generator transformation to replace missing keys and create unique keys
• Created Worklets and workflows in the workflow manager to synchronize OLAP system with OLTP system with the logic to run set of tasks at the scheduled times
• Used Repository Manager to migrate Informatica mappings across the development, test and production environments
• Involved in extensive performance tuning by determining bottlenecks at targets, sources, mappings, sessions.
• Extensively used PL/SQL for creating views, stored procedure, and indexes on the tables.
• Involved in error checking and testing of ETL procedures and programs in Informatica session log.
• Developed Component documentation for every product designed.

Environment: Informatica 7.1, SQL Server 2005, SQL Navigator, Visio, Windows XP, SunOS 5.6.