SUMMARY

• Around 8 plus years of Professional experience in Information Technology with extensive experience in Design, Development, Analysis, Implementation, Testing and Support of Data warehousing and Data integration solutions.
• Over 7 years of Data Warehousing experience using Informatica Power Center as Workflow Manager, Mapping Designer, Workflow Monitor and Repository Manager.
• Over 4 experience in Teradata RDBMS using FASTLOAD, MULTILOAD, TPUMP, FASTEXPORT, MULTILOAD EXPORT, Teradata SQL and BTEQ Teradata utilities.
• Over 3 years of experience of leading multiple ETL projectsof team members between 3 - 7 members.
• Designed, Installed, Configured core Informatica MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter & Data Modeling.
• Expertise in Extraction Transformation Loading (ETL) process, Dimensional Data Modeling experience using Data modeling, Star schema/ Snowflake modeling, Fact and Dimensions tables, Dimensional, Multidimensional modeling and De-normalization techniques
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1 and type2.
• Highly motivated and goal-oriented individual with a strong background inSDLC ProjectManagement and Resource Planning using AGILE methodologies
• Experience working in an Agile/Scrum environment.
• Worked on various types of transformations like Lookup, Update Strategy, Stored Procedure, Joiner, Filter, Aggregator, Rank, Router, Normalizer, Sorter, External Procedure, Sequence Generator, and Source qualifier and SCD Type-2 etc.
• Expertise monitoring workflows, pipeline partitioning, configuring email.
• Strong back end experience in writing PL/SQL stored procedures, functions, packages and triggers.
• Involved in Performance Tuning of the Data Warehouses including the creation of materialized views, bitmapped indexes and partitions.
• Expertise in Business Model development withDimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Expertise in implementing Power center Mappings, Mapplets and Workflows for the different stages of ETL.
• Experienced inUNIX shell scriptsto run Informatica workflows and controlling the ETL flow.
• Excellent experience in implementing Web Service, WCF, REST service which communicate data in a advanced XML.
• Excellent Programming experience in Teradata SQL, Stored Procedures and Macros.
• Expertise in Query Analyzing and Performance tuning.
• Experienced in Requirement gathering, designing (Technical Design) ETL interfaces, reviewing mapping design by team members as well as leading the team in coding, testing, performance tuning in developing Informatica mappings and workflows, production migration and providing stabilization support.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• 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.
• Analyze DB2 UDB Event Monitor information, physical design, performance characteristics of table spaces, physical I/O rates, and table access activities.Proactively monitor performance, diagnose problems and tune queries and database
• Experience with IBM DB2 on AIX in E-commerce is essential.
• Experience on design, development & administration of DB2 UDB databases.
• Experience in install, administer, troubleshoot and tune multiple production and non-production DB2 environments running on Linux.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Experience in resolving on-going maintenance issues and bug fixes monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience using SAS ETL tool, Talend ETL tool and SAS Enterprise Data Integration Server highly preferred.
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Experienced in working with tools like TOAD,SQL Server Management studio and SQL plus for development and customization

TECHNICAL SKILLS

Teradata Utilities: BTEQ, MultiLoad, FastLoad, FastExport, Multiloadexport,Tpump, TPT,Teradata SQL Assistant

ETL Tools: Informatica Power Center 9.1/8.x/7.x/6.x. Informatica Power exchange

Tools: Erwin 4.1, Toad, Rational Rose, MS Project, Test Director, MS Visio, Autosys,DB2 Connect, DB2 Data Joiner, Quest Tools, BMC Tools,Power Designer, DB Artisan, TSM.

Data Modeling/Tools: Erwin, Star Schema, Snowflakes Modeling

Databases: MS SQL Server 2005/2008, Oracle 8i/9i /10g, Teradata, IBM DB2, Sybase,DB2 UDB V.7.X, 8.1, 8.2Operating Systems UNIX, Windows XP/NT 4.0, Windows 2000 Server, Windows Vista, LINUX and Mainframe,AIX 5.2,5.3/4.3.x, Solaris 2.6/2.7/8

Methodologies: Data Warehousing Design, Data Modeling, Logical and Physical Database Design.

PROFESSIONAL EXPERIENCE

Confidential, Naperville, IL

Sr. Informatica Developer

Responsibilities:

• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
• Prepared the required application design documents based on functionality required
• Installed and configured Informatica9.1
• Migrated repository and mapping from Informatica8.6 to 9.1
• Designed the ETL processes using Informatica to load data from SAP R/3, Oracle, Flat Files (Fixed Width), and Excel files to staging database and from staging to the target Teradata Warehouse database.
• Wrote the Algorithm for ETL (Extract, Transform and Load) team for Data Validation.
• Built the BTEQ scripts to validate the Edge Model and to generate Surrogate Key.
• Performed various transformation logics by utilizing the Source Qualifier, expression, filter, joiner, lookup, router, Update Strategy and rank
• Mostly worked on Dimensional Data Modeling using Data modeling, Erwin Modeling (ERwin 4.1/4.0) Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling.
• Moving the data from source systems to different schemas based on the dimensions and fact tables by using the slowly changing dimensions type two and type one.
• Developed and executed UNIX scripts to schedule loads, through wrapper shell scripts for calling Informatica workflows using PMCMD command.
• Implemented DBMOVER configuration file, dbmover.cfg, to configure the operation of various PowerExchange tasks as well as their communication with other PowerExchange tasks.
• Used load, import and export utilities for moving data to files and from files. Used db2advis, db2batch, db2expln, and db2exfmt for tuning queries.
• Extensive DB2 DBA and DB2 Connect experience with activities involving design, installation, configuration, requirements gathering, data modeling, tuning, security, backup, recovery and integration of database applications
• Worked on PowerExchange bulk data movement processes by using PowerExchange Change Data Capture (CDC) method.
• PowerExchange CDC can retrieve updates at user-defined intervals or in near real time.
• Having brief practical knowledge on POWER EXCHANGE NAVIGATOIR,POWER EXCHANGE BULCK DATA MOVEMENT,POWER EXCHANE CHANGE DATA CAPTURE.
• Applied different types of monitoring for Power exchange processes like dtlcacon monitoring, dtllst monitoring, oracle scn monitoring, lag monitoring scripts, Heartbeat table to monitor.
• Created and managed different Power exchange directories like condense files directory, check point directory etc.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Imported sources and targets from Web services Definition Language (WSDL).
• Implemented the Web Service, XML Service for data interaction between Device app and the SQL server database.
• Implementedparallelismin loads bypartitioningworkflows usingPipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
• Implementeddaily and weekly audit processfor theeachsubject area to ensure Data warehouse is matching with the source systems for critical reporting metrics.
• Migrated repository objects, services and scriptsfrom development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Created Data Marts and did System Testing of the Application.
• Built the Informatica workflows to load Siebel EIM table as part of data load.
• Automated Test Scenarios using BTEQ scripts to validate Source System Data against the Data Mart Views generated.
• Wrote Queries, Procedures and functions that are used as part of different application modules
• Optimized Teradata SQL and TSQL queries for better performance.
• Extract and Load data using different tools in Teradata like Multiload, FastExport, Fastload, OLE Load, BTEQ.
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
• Created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.

Environment: Windows XP/NT, Informatica Powercenter 9.1/8.6, UNIX,Linux, Teradata 13.10, Oracle 11g, Oracle Data Integrator, SQL, PL/SQL,SQL Developer,Siebel, Erwin, MS VISIO, Autosys, Korn Shell, Quality Center 10.,Power Exchange 9.2.1/8.6.1 , DB2 UDB V.7.X, 8.1, 8.2

Confidential, Chicago, IL

Sr. Informatica Developer

Responsibilities:

• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database
• Prepared the DDL’s for the staging/work tables and coordinated with DBA for creating the development environment and data models.
• Involved in analyzing the source data coming from different Data sources such as XML, DB2, flat files and identifying data anomalies in operational data.
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Union, and Stored procedure, and XML transformations.
• Worked on Informatica Power Center tools - Source Analyzer, Warehouse Designer, Mapping &Mapplet Designer, and Transformation Developer.
• Converted existing PL/SQL Packages to ETL Mappings using Informatica Power Center.
• Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
• I was given Informatica Lead role by the client, which includes, involving in Business requirement discussion, understanding the requirements from Business team, pass on the requirements to offshore dev team and lead the project from Design, Dev, Unit testing and Deployment.
• Team leader who was responsible for the assignment of tasks for the team members, creation of Metrics reports, weekly status reports, preparation of project plan and quality related documents & migration documents etc. Used share point to maintain documents and tracking.
• Written Web Services to serve the business to divide the business sales territories.
• Handled all XML data integration challenges, including integration complexity, visibility into hierarchical data, high-performance requirements, and maintenance related to frequent changes
• Implementedparallelismin loads bypartitioningworkflows usingPipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
• Worked on Exchange Management Console(EMC) or theExchange Management Shell(EMS) related topics.
• Installed PWX 9.2.1/8.6.1 on Linux. Have good knowledge of configuring different PWX files like dbmover.cfg, dtlca.cfg, dtlcagrp.cfg for PWX version 8.6.1 and PWX files like dbmover.cfg,pwxccl.cfg and pwxorad.cfg for PWX version 9.2.1.
• Extensively involved in performance tuning, recommending SQL queries for better performance using snapshot monitor, visual explain, index advisor, db2expln, db2exfmt.
• Developed automated scripts using Unix Shell and Perl for performing runstats, reorg, rebind, backup, load, export and other related to database activities.
• Generated reports of database statistics using DB2LOOK Utility
• Performed admin related activities related to Power exchange like starting and stopping power exchange, starting and stopping dtlcacon/pwxccl process using screen utility or manually, registering different tables in Power exchange through PWX GUI tool.
• Automated the process of starting and stopping dtlcacon/pwxccl process by creating a shell script.
• Developed in SCRUM iterations using Agile Methodology, Iterative development and Sprint Burn down with Story Boards.
• Estimates and planning of development work using Agile Software Development.
• Used Change Data Capture (CDC) to simplify ETL in data warehouse applications
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Used Mapping variables for Incremental Extraction of operational data.
• Wrote Unix Shell scripts to automate workflows.
• Schedule and Run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor.
• Used Workflow Manager for creating workflows, work lets, email and command tasks.
• Used Informatica features to implement Type I, II changes in slowly changing dimension tables.
• Used FTP services to retrieve Flat Files from the external sources.
• Worked on Teradata RDBMS using FASTLOAD, MULTILOAD, TPUMP, FASTEXPORT, MULTILOAD EXPORT, Teradata SQL and BTEQ Teradata utilities.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Worked on Migration Strategies between Development, Test and Production Repositories.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.
• Did unit testing and development testing at ETL level in my mappings.

Environment: Informatica Power Center 8.5, Oracle 10g, SQL Server 2005, Linux, DB2, SQL*Plus, SQL Loader, SQL Developer, Autosys, Flat files, UNIX, Windows 2000,Teradata V-14., DB2 UDB EE/8.1, AIX 4.3, Solaris

Confidential, Sanfrancisco, CA

Sr. Informatica Developer

Responsibilities:

• Involved in analysis of different source systems and prepared technical specifications for the ETL.
• Involved in enhancing the data model for new additions of dimension and tables.
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Created mappings and Mapplets using the transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Sequence Generator and Update Strategy.
• Used Informatica Power Exchange to handle the change data capture (CDC) data from the source and load into Data Mart by following slowlychanging dimensions (SCD) type II process.
• Used Power Center Workflow Manager to create workflows, sessions, and also used various tasks like command, event wait, event raise, email to run with the logic embedded in the mappings.
• Restructured the Data stage jobs to enhance the performance and clarity of the job and also sent the exact data to the downstream systems.
• Developed Error/Exception handling mechanism to enhance the data quality loaded to EDW.
• Having experience in leading team and possess excellent communication and interpersonal skills, ability to quickly grasp new concepts, both technical and business related and utilize as needed.
• Extensively worked on performance tuning of Informatica Mappings and Sessions by implementing parallelism, partitioning and caching.
• Created BTEQ scripts to in corporate the transformation rules.
• Used Toad to write queries and interact with Oracle database.
• Developed several PL/SQL procedures, functions to provide data consistency.
• Developed Unix scripts to automate different tasks involved as part of loading process.
• Performed Unit Testing and Integration Testing on the mappings.
• Did Informatica mapping specification documents for the mappings developed and did documentation according to Business standards.

Environment: Informatica Power Center 8.5,7.X, Erwin, Oracle 11g, SQL, Power Connect, PL/SQL, UNIX, Linux,C#, Windows XP, TOAD, Teradata.

Confidential, Houston, TX

Informatica Developer

Responsibilities:

• Involved in Systems Study and Analysis and understand the business needs and implement the same into a functional database design.
• Defined the ETL strategy for Data Warehouse population.
• Involved in Data Quality Analysis to determine cleansing requirements.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Assisted in creating queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
• 24*7 job monitoring & fixing the production failures.
• Performed extensive analysis of metadata to test the integrity, consistency and appropriateness of the data to be brought into the centralized Data from various sources.
• Installed, Maintained and Documented the Informatica Power Center setup on multiple environments.
• Designed the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Worked on Informatica Power Center 6.2 and created Informatica mappings with PL/SQL procedures/functions to build business rules to load data. Most of the transformations used were like the Source qualifier, Aggregators, lookups, Filters & Sequence generators.
• Created sessions and batches to move data at specific intervals & on demand using Workflow Manager and Developed the Teradata Load Scripts (BTEQ/MLOAD/FLOAD)
• Extensively worked on the Database Triggers, Stored Procedures, Functions and Database Constraints. Written complex stored procedures and triggers and optimized for maximum performance.
• Created UNIX shell scripts (Scheduler utilities) for automating the backup of Database/ Transaction log.
• Identifying the major entities in the databases and preparing the E-R diagrams depicting major attributes and the relationship between these entities.
• Preparing a high-level logical dataflow diagram for THE BANK as a whole in addition to business unit wise data flow diagrams.
• Collecting the Business Metadata (confined to data elements relevant for EDW) and deliver the same in the form of a database (MS Excel).

Environment: Informatica PowerCenter 6.x/7.x, Power Exchange, Teradata, SSRS, Erwin, Oracle, SQL, BTEQ, Power Connect, PL/SQL, Linux,UNIX, TOAD.

Confidential, Memphis, TN

Informatica Developer

Responsibilities:

• Involved in the creation of the Technical design document on the basis of the Functional design document.
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle as per business requirements using Erwin 4.0.
• Wrote stored procedures in PL/SQL and UNIX Shell Scripts for automated execution of jobs.
• Done extensive bulk loading into the target using Oracle SQL Loader.
• Extracted, Transformed and Loaded OLTP data into the Staging area and Data Warehouse using Informatica mapping and complex transformations (Aggregator, Joiner, Lookup, Normalizer, Filter).
• Worked with clients to demonstrate Agile techniques for software development, explained and implemented unit testing, created coding standards.
• Wrote UNIX Shell Scripting for Informatica Pre-Session, Post-Session Scripts.
• Analyzed and created Facts and Dimension tables.
• Involved in Performance Tuning of the mappings.
• Implemented Slowly Changing Dimension (SCD- Type II) dimension mappings.
• Wrote validations using PL/SQL Stored Procedures before transferring data from temporary table to Interface tables.
• Used Repository Manager to create Repository, User groups, Users and managed users by setting up their privileges and profile.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to Target systems using Informatica Power Center.
• Created the Informatica mappings to extract the data from Oracle and load into Target database.
• Involved in Performance testing of all the workflows/Mapping, which helped in analyzing its performance before moving into production.

Environment: Informatica PowerCenter 6.0, Power Exchange, Teradata, Erwin, Oracle, SQL, BTEQ, Power Connect, PL/SQL, UNIX, TOAD.