SUMMARY:

• 8+ years of referable IT expertise in Data Warehouse development using ETL/Informatica PowerCenter across various industries such as Healthcare, Banking, Insurance and Retail.
• Extensive experience in developing ETL mappings, scripts and data integration using Informatica PowerCenter 9.x/8.x/7.x.
• Experience in all phases of Data warehouse life cycle such as Requirement Analysis, Design, Coding, Testing, and Deployment.
• Expert in working closely with business analysts to identify and understand requirements in order to create Technical Design Documents, also data profiling and data analysis.
• Expertise in understanding Business Model Identifying Dimensions and Facts.
• Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Experience in creating Reusable Transformations (Joiner, Sorter, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Aggregator, and Rank) for better usability.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Expertise in implementing Slowly Changing Dimensions- SCD Type 1 & SCD Type 2.
• Experience in integration of various data sources like Oracle, DB2, Sybase, MySQL, SQL Server and non-relational sources like flat files into staging area.
• Experience with Teradata utilities FastLoad, MultiLoad, BTEQ scripting, FastExport, SQL Assistant.
• Expertise in Tuning of Teradata Queries using Explain plan.
• Proficient in converting SSIS packages & Hadoop Hive QL to Informatica.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklets, Control).
• Excellent communication, interpersonal skills, enthusiastic, self-starter, eager to meet challenges and quickly assimilate latest technologies concepts and ideas.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.6.1/9.5.1 /9.1.1/8.6.1/8.1.1/7.1.2

Data Modeling: Dimensional Modeling, ER Modeling, Ralph Kimball Methodology, Bill Inman Methodology, Star, Snow-Flake, Fact Tables, Dimension Tables, Physical and Logical Modeling, Normalization and De Normalization

Databases: Teradata 14/12, Oracle 11g/10g/9i/8i/8.0/7.x, MS SQL Server 2012/2008, DB2, Sybase, MySQL

Others: Toad, SQL Navigator, FACETS 4.3/4.7, Shell Scripting, SQL Assistant, SQL, Java

Environment: Windows, Linux, UNIX

Job Scheduling: AutoSys, Control-M, Cronjobs, Maestro

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Sr. ETL Informatica Developer/ Teradata Developer

Responsibilities:

• I worked primarily Development, Enhancement and Supporting EDW which is on Teradata.
• Worked closely with Business Analyst & Data Modelers in understanding the BRD - Business Requirement Document, Mapping Document and Data Model.
• Extracted data from different source systems - Oracle, DB2, MySQL, Flat Files and XML Files.
• Developed ETL programs using Informatica Power center 9.6.1/9.5.1 to implement the business requirements.
• Involved in enhancements and maintenance activities of the Enterprise Data Warehouse.
• Used most of the Transformations available in Informatica - Source Qualifier, Filter, Router, Lookup (Connected & Un-Connected), Expression, Update Strategy, Transaction Control and Sequence Generator.
• Implemented Slowly Changing Dimensions - Type 1 & Type 2 to maintain the history in Dimension tables.
• Worked with Huge data sets to load Fact Tables.
• Implemented Change Data Capture (CDC) for handling delta loads.
• Involved in Informatica upgrade process and testing the whole existing Informatica flow in new upgrade environment.
• Handled performance Tuning of Informatica objects- Finding the bottle necks at source, Target and mapping level and eliminating the with tuning methods.
• Used Informatica file watch events to pole the FTP sites for the external files.
• Involved in Enhancing existing Production Informatica objects for change or additional requirements and pushing it back to production after successful QA testing.
• Used Teradata Utilities BTEQ, M-Load, F-Load, TPT and F-Export in combination with Informatica for better Load in to Teradata Ware House.
• Built several BTEQ to load data from Stage to Base after considering several performance techniques in Teradata SQL.
• Involved in Teradata upgrade process from TD 12/TD 14.
• Handled Production Support to resolve the ongoing issues and troubleshoot the problems.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks,
• Used Cronjobs to schedule jobs.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Worked with ETL Admin team for code migration activities and deployments.
• Worked with QA team for better understanding of code development.
• Implemented & followed organization level Informatica best Standards & Procedures.
• Involved in Solving Trouble tickets raised by Business users as part of application support team.

Environment: Informatica Power Center 9.6.1/9.1.1 , Oracle 11g,DB2, Teradata 14/12, Flat Files, XML, TOAD, SQL Assistant, Cronjobs, UNIX, Facets 4.7, Windows

Confidential, Walnut Creek, CA

Sr.ETL Informatica Developer / Teradata Developer

Responsibilities:

• Analyzed the Business Requirement Documents (BRD) and laid out the steps for the data extraction, business logic implementation & loading into targets.
• Responsible for Impact Analysis, upstream/downstream impacts.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Used Informatica as ETL tool to pull data from source systems/ files, cleanse, transform and load data into the Teradata using Teradata Utilities.
• Worked on Informatica Source Analyzer, Warehouse Designer, Mapping Designer & Mapplets, and Transformation Developer.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Developed mappings to load Fact, Dimension tables (SCD Type 1 and SCD Type 2 dimensions) and Incremental loading and unit tested the mappings.
• Successfully upgraded Informatica 9.1 and to 9.5 and responsible for validating objects in new version of Informatica.
• Involved in Initial loads, Incremental loads and Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner.
• Extensively worked in the performance tuning of Teradata SQL, ETL and other processes to optimize session performance.
• Loaded data in to the Teradata tables using Teradata Utilities BTEQ, Fast Load, Multi Load, and Fast Export, TPT.
• Worked extensively with different Caches such as Index cache, Data cache and Lookup cache (Static, Dynamic and Persistence) while developing the Mappings.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplets Designer and Worklets Designer.
• Integrated the data into centralized location. Used migration, redesign and Evaluation approaches.
• Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Worked extensively on Informatica Partitioning when dealing with huge volumes of data and also partitioned the tables in Teradata for optimal performance.
• Scheduling Informatica jobs and implementing dependencies if necessary using AutoSys.
• Managed postproduction issues and delivered all assignments/projects within specified time lines.

Environment: Informatica Power Center 9.5.1/9.1.1 , Oracle 11g, MySQL, Teradata, Flat Files, Erwin 4.1.2,Sql Assistant, Toad, WinSCP, Putty, AutoSys, UNIX

Confidential, IL

Sr. Informatica Developer

Responsibilities:

• The main objective of this project is to build Auto and Fire Data Marts.
• Extensive requirement gathering, analysis and writing of technical specifications, supporting for various projects involved with Auto, Fire Data marts and State farm Organization Profile (SFOP).
• Worked with Business Analysts to get the functional Specifications, create test plans and scenarios to translate them into technical designs for implementation and deployment.
• Involved as an ETL Developer by gathering business requirements, Preparing Design specification, Designing mappings and extensively used ETL to load data from flat files to Oracle Database.
• Worked extensively on transformations like Lookup, Filter, Expression, Aggregator, Router, Source Qualifier, Sorter, Sequence Generator, Rank, Lookup, Normalize etc.
• Designed and developed new mappings using Connected, Unconnected Lookups and Update strategy transformations.
• Implemented Slowly Changing dimension methodology for accessing the full history of accounts and transaction information.
• Error checking and Unit testing of the ETL procedures using Informatica session log and various tracing options.
• Developed joiner transformation for extracting data from multiple sources.
• Extensively used workflow manager for creating and scheduling various sessions.
• Fine-tuned the Informatica Mappings and Session to get better performance.
• Created scripts to verify that all the data has been moved successfully.

Environment: Informatica Power Center 8.1/8.6/9.1.1 , Oracle, UNIX AIX, Visio, Flat Files, Toad for Data Analyst, Control-M Scheduling Tool

Confidential, Atlanta, GA

Sr. Informatica Developer

Responsibilities:

• Extraction, Transformation and Loading of the data using Informatica.
• Designed the target load process based on the requirements.
• Enhancing the existing mappings where changes are made to the existing mappings using Informatica Power center.
• Testing and debugging the Enhanced mappings.
• Creating the ETL run book.
• Develop Mappings and Workflows to generate staging files.
• Develop Mappings and Workflows to load the data into Oracle tables.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created Workflows, Tasks, and database connections using Workflow Manager.
• Developed complex Informatica mappings and tuned them for better performance.
• Created sessions and batches to move data at specific intervals & on demand using Server Manager.
• Responsibilities include creating the sessions and scheduling the sessions.
• Recovering the failed Sessions and Batches.
• Involving in extracting the data from SQL Server, Sybase and Flat files.
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance Understanding the Functional Requirements.
• Responsible for identifying the missed records in different stages from source to target and resolving the issue.
• 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.
• Good experience in UNIX working environment.
• Preparing the documents for test data loading.

Environment: Informatica Power center 8.6, Sybase, SQL Server, Oracle, Flat File, UNIX shell scripts, Windows

Confidential, Los Angeles, CA

Informatica developer

Responsibilities:

• I worked for TRM (Transaction Risk Management) application system that provides intelligent profiling and analysis of transactional information, which will be utilized to identify unusual activity and potential money laundering.
• Involved in requirement gathering, data Analysis, and user meetings, discussing the issues to resolve and translated the user inputs into ETL design documents.
• Worked with Informatica PowerCenter 8.6 tools like Designer, Workflow Manager, Repository Manager, source analyzer, warehouse designer, mapping &mapplets designer and Transformation developer.
• Developed Informatica mappings using source qualifier, joiner, Lookups (connected and unconnected), expression, filter, router, and aggregator, sorter, update strategy and normalizer transformations.
• Involved in making the changes to the existing data models to accommodate the new requirements.
• Responsible for Optimizing the ETL loads and also redesigning ETL Interfaces which were not providing the accurate data for the business.
• Worked with mapping parameters and variables, session parameters, pmcmd commands, email tasks.
• Responsible for fixing PLSQL procedures for getting the accurate data.
• Worked with SQL override, Lookup override, Lookup caches, Index and Data caches while designing the mappings also Worked with TOAD SQL*Loader for loading the data from external files into RDBMS tables and Fine-tuned the SQL queries using Explain Plan and TKProf to speed up the session runs.
• Handled Informatica administration work like migrating the code, creation of users and creating folders
• Worked on Shortcuts across shared, non-shared folders and wrote AutoSys Jil Scripts for scheduling the workflows.
• Created and executed unit test plans based on system and validation requirements. Worked closely with Business during the testing phase and fixed bugs that were reported.
• Developed reports which used Conditional blocks/Variables and associated them with queries to show data only when the conditions were fulfilled.

Environment: Informatica PowerCenter 8.6, Oracle, UNIX, Windows, Toad, AutoSys

Confidential

Informatica Developer

Responsibilities:

• Successfully developed and maintained ETL maps to Load data from various data sources to the Enterprise Data warehouse. The projects aim to help make decisions for new product improvements, analysis of existing products.
• Imported various Sources, Targets, and Transformations using Informatica Power Center Server Manager, Repository Manager and Designer.
• Created and managed the global and local repositories and permissions using Repository Manager in Oracle Database.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Used heterogeneous files from Oracle, Flat files and SQL server as source and imported stored procedures from oracle for transformations.
• Designed and coded maps, which extracted data from existing, source systems into the data warehouse.
• Used Dimensional Modeling Techniques to create Dimensions, Cubes and Fact tables.
• Written PL/SQL procedures for processing business logic in the database. Tuned SQL queries for better performance.
• Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manager.
• Generated completion messages and status reports using Informatica Server manager.
• Tuned ETL procedures and STAR schemas to optimize load and query Performance.
• Starting Sessions and Batches and make Event based scheduling.
• Managed migration in a multi-vendor supported Server and Database environments.

Environment: Informatica Power Center 7.1.2, DB2 v8.0, SQL, Windows 2000, UNIX, SQL Server 2000, Oracle 8i, Flat files, SQL *Plus, Business Objects 5.1.6