SUMMARY:

• 8 Plus years of experience in Data Architecture, Data Integration, Data Warehousing using ETL tool INFORMATICA Power Center 9.6.1/9.5.1 /9.1.1/8.6/8.1/7.1 (Source Analyzer, Warehouse Designer, Mapping/Mapplet Designer, Sessions/tasks, Worklets/Workflow Manager).
• Worked with integrating most of teh databases such as Oracle, Teradata, My Sql, Sql server, DB2, Sybase and flat file, XML both at source & target.
• Excellent knowledge in data warehouse development life cycle including Software Development Life Cycle (SDLC) on various platforms like WINDOWS /XP/2000, UNIX.
• Extensive knowledge in dimensional data modeling, star schema, snowflake schema, fact and dimension tables and process mapping using teh top - down and bottom-up approach.
• Extensively worked in teh Performance tuning of teh SQL and ETL processes.
• Experience in Designing and developing mappings from various transformation logics like, Source Qualifier, Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Union, Joiner, Transaction Control and Update Strategy.
• Proficient in implementing Complex business rules by creating re-usable transformations, workflows/worklets and Mappings/Mapplets.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, transformations and sessions
• Experienced in using Teradata Utilities like BTEQ, M-Load, F-Load, T-Pump & TPT.
• Experience in doing fine tuning of Teradata scripts and writing Teradata scripts using BTEQ.
• Developed slowly changing dimension (SCD) mappings of Type1, Type2 and Type3 (version, flag and time stamp).
• Implemented Change Data Capture (CDC) for extracting Delta data.
• Worked with Informatica Mapping Variables, Mapping Parameters and Parameter Files
• Scheduling teh sessions to extract, transform and load data into warehouse database depending on teh business requirements.
• Worked on Weblogic as part of informatica requirement and performed performance tuning.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules for adhoc data.
• Responsible for Unit testing of mappings and workflows.
• Experienced working with QA team.
• Good experience in working with several scheduling tools Maestro, Cron Tab, Autosys, Control M & Informatica Schedular.
• Extensively worked on Code Migration from Development, UAT, and Production.
• Experience in Both Waterfall & Agile Methodology in implementing DWH projects and good experience with scrum process.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6.1/9.5.1 /9.1.1/8.6.1/8.1.1/7.1.1

Databases: Oracle 11g/10G, MS Sql Server 2005, 2008, Teradata 14/13/12, My Sql, DB2, Sybase, Flat File, XML.

Programming Languages/ Scripting: Oracle, PL/SQL, VC++, HTML. Java webservices, Object Oriented Programming, Python 2 and Python 3

Tools: Toad, MS Office, SQL*PLUS, Sql Assistant, SQL Developer

Reporting Tools: Business Objects BO XI R2/R3, Oracle EBS 12.1, Cognos

Operating Systems: Windows, Unix(Solaris), Linux

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee, WI

Lead Informatica developer / Teradata developer

Responsibilities:

• Worked on teh requirements with Business Analyst and business users also involved in working with data modellers.
• Worked closely with data population developers, multiple business units and a data solutions engineer to identify key information for implementing teh Data warehouses.
• Analyzed logical and physical data models for Business users to determine common data definitions and establish referential integrity of teh system.
• Parsed high-level design spec to simple ETL coding and mapping standards.
• Used Informatica power center as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Written Teradata BTEQs & as well Informatica mappings using TPT to load data from Staging to base.
• Fine-tuned Teradata BTEQs as necessary using explain plan and collecting statistics
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements into ETL procedures.
• Developed and tested all teh backend programs, Informatica mappings and update processes
• Populated teh Staging tables with various Sources like Flat files (Fixed Width and Delimited), Oracle, My Sql, Informix.
• Created mappings using various Transformations such as Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Look up, Sequence Generator, java and Update Strategy.
• Created and used teh Normalizer Transformation to normalize teh flat files in teh source data.
• Extensively built mappings with SCD1, SCD2 implementations as per requirement of teh project to load Dimension and Fact tables.
• Used Evaluate expression options to validate and fix teh code using Debugger tool while testing Informatica code.
• Handled initial (i.e. history) and incremental loads in to target database using mapping variables.
• Used Debugger to debug mappings and created breakpoints for better analysis of mappings.
• Worked with Workflow Manager for maintaining Sessions by performing tasks such as monitoring, editing, scheduling, copying, aborting, and deleting.
• Worked on performance tuning at both teh Informatica level and Database as well by finding teh bottlenecks.
• Worked on Maestro job scheduling and Unix Scripting.
• Developed UNIX shell scripts to run teh pmcmd functionality to start and stop sessions, batches and scheduling workflows.
• Involved in migrating teh ETL Code to different environments from Dev to UAT and tan to Produciton with ETL Admins.
• Performed Unit testing and created unit test plan of teh code developed and involved in System testing and Integration testing as well. Coordinated with teh testers and helped in teh process of integration testing.
• Heavily involved in Production support on rotational basis and supported DWH system using teh ticketing tool for teh issues raised by Business users.
• Experience in working with reporting team in building collection layer for reporting purpose.

Environment: Informatica Power Center 9.6.1/9.5.1, Oracle, My Sql, Informix, Teradata 14/13/12, Flat File, Cognos, Rally, Putty, Maestro/Informatica Scheduler, UNIX, Windows.

Confidential, Middleton, NJ

Senior Informatica Developer

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Creating teh design and technical specifications for teh ETL process of teh project.
• Managed offshore team with 4 resources for development/Support in Informatica.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Developer.
• Developed complex mappings using Informatica Power Center 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.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Implemented complex mappings such as Slowly Changing Dimensions.
• Implemented Change data capture (CDC).
• Extracted data from heterogeneous sources like Oracle, My Sql, Sybase and loaded in Teradata.
• Involved in ETL performance tuning for jobs running in Production
• Heavily involved in supporting AT&T ECDW.
• Written and did performance tuning of Teradata scripts for stage to base loads.
• Used Teradata utilities extensively - BTEQ, M-LOAD, F-LOAD & T-PUMP.
• Involved in code migration & deployment activities for both newly developed, enhanced code also production fixes.
• Extensively worked with Cron tab scheduler for scheduling Informatica jobs.

Environment: Informatica Power Center 9.5.1/9.1.1, Oracle, My Sql, Flat File, Sybase, Teradata 14, AOTS, Cron Tab, Unix, Windows.

Confidential, Boston, MA

ETL Informatica Developer

Responsibilities:

• Extensively used ETL to load data from Oracle database, Flat files to Data Warehouse.
• Involved in production support for teh Data Warehouse Informatica jobs.
• Modified teh existing mappings and workflows as per requirement changes and migrated them back to production environment.
• Created robust and complex workflow and Worklets using Informatica Workflow Manager and troubleshot data load problems
• Wrote SQL Queries, Triggers and Shell Scripts to apply and maintain teh Business Rules.
• Translated business requirements into Informatica mappings/workflows
• Used Source Analyzer and Warehouse designer to import teh source and target database schemas, and teh Mapping Designer to map teh sources to teh target.
• Used Informatica Designer to create complex mappings using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Filter and Router transformations to pipeline data to Data Warehouse/Data Marts.
• Developed Mappings to extract data from ODS to Data Mart, and monitored Daily, Weekly and Monthly Loads.
• Created and monitored Sessions/Batches using Informatica Server Manager/Workflow Monitor to load data into target Oracle database
• Worked with mapping variables, Mapping parameters and variable functions like Set variable, Count variable, Set invariable and Setmaxvariable.

Environment: Informatica Power Center 8.6.1, Sql Server 2005, oracle 12.1, PL/SQL, Business ObjectsXI R2, Oracle EBS, Toad, Unix Shell Scripts.

Confidential

Senior Informatica Developer

Responsibilities:

• Involved in Business Analysis and requirement gathering.
• Used Power Center for data Extraction from various sources such as databases and flat files.
• Extensively used transformations Expression, Aggragator, Joiner, Filter, lookup.
• Created mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and normalizer, update strategy etc
• Develop/Migrate/Customize ETLs for Data Extraction, Transformation and Loading using Informatica Power Center 9.1.1.

Environment: Informatica Power Center 9x, Sybase, UNIX, Oracle 9i

Confidential

Senior Informatica Developer

Responsibilities:

• Understanding database design schemas for different sources.
• Understanding end user requirements.
• Designed teh ETL processes using Informatica tool to load data from File system and Oracle into teh target.
• Created aggregate tables, Materialized views to improve query performance.
• Created Mapplets and reusable transformations.
• Done teh error validation of teh data moving from source system to teh target.
• Used Informatica as an ETL Tool to extract data from source systems to Target systems. Have good experience in understanding & creating source and target definitions, Mappings, Transformations and working with workflows.
• Used teh Informatica Workflow Manager create and run teh sessions for loading teh data using teh earlier created mappings.
• Involved in extracting data from different data sources, flat files, excel sheets and loaded into Oracle 9i and target flat files using Informatica.
• Test teh mappings and check teh quality of teh deliverables.
• Used Informatica Workflow Manager & Monitor to create, schedule, Monitor Workflows.
• Performed teh Tasks of Validating, Executing and scheduling teh workflows.

Environment: Informatica Power Center 8x, Oracle 9i, Windows XP.

Confidential

Informatica Developer

Responsibilities:

• Imported data from various Sources transformed and loaded into Data Warehouse Targets using Informatica Power Center 7x/8x
• Was involved in Identifying slowly changing dimensions (SCD) and creating mapping using wizards in Designer.
• Transformation is done using Informatica tool from MS-Access, Oracle database To Oracle database.
• Sophisticated transformations rules are implemented using Informatica features like Filter, Aggregation, Joiner, Expression, Lookup, Update Strategy, Stored Procedure and Source Qualifier. Wrote PL/SQL packages, Stored Procedures to invoke several ETL functionalities for aggregation and summation.
• Developed several Mappings and Mapplets using corresponding Source, Targets and Transformations.
• Responsible for documenting teh entire process.
• Prepared teh design specifications, detailed design document for technical specifications.

Environment: Informatica 8x, ORACLE 9i, Windows XP.