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 the databases such as Oracle, Teradata, My Sql, Sql server, DB2, Sybase and flat file, XML both Confidential 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 the top - down and bottom-up approach.
• Extensively worked in the Performance tuning of the 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 the sessions to extract, transform and load data into warehouse database depending on the 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 the 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 the Data warehouses.
• Analyzed logical and physical data models for Business users to determine common data definitions and establish referential integrity of the 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 the backend programs, Informatica mappings and update processes
• Populated the 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 the Normalizer Transformation to normalize the flat files in the source data.
• Extensively built mappings with SCD1, SCD2 implementations as per requirement of the project to load Dimension and Fact tables.
• Used Evaluate expression options to validate and fix the 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 Confidential both the Informatica level and Database as well by finding the bottlenecks.
• Worked on Maestro job scheduling and Unix Scripting.
• Developed UNIX shell scripts to run the pmcmd functionality to start and stop sessions, batches and scheduling workflows.
• Involved in migrating the ETL Code to different environments from Dev to UAT and then to Produciton with ETL Admins.
• Performed Unit testing and created unit test plan of the code developed and involved in System testing and Integration testing as well. Coordinated with the testers and helped in the process of integration testing.
• Heavily involved in Production support on rotational basis and supported DWH system using the ticketing tool for the 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 the design and technical specifications for the ETL process of the 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 Confidential &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, MA

ETL Informatica Developer

Responsibilities:

• Extensively used ETL to load data from Oracle database, Flat files to Data Warehouse.
• Involved in production support for the Data Warehouse Informatica jobs.
• Modified the 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 the Business Rules.
• Translated business requirements into Informatica mappings/workflows
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the 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 the ETL processes using Informatica tool to load data from File system and Oracle into the target.
• Created aggregate tables, Materialized views to improve query performance.
• Created Mapplets and reusable transformations.
• Done the error validation of the data moving from source system to the target.
• Used Informatica as an ETL Tool to extract data from source systems to Target systems. Has good experience in understanding & creating source and target definitions, Mappings, Transformations and working with workflows.
• Used the Informatica Workflow Manager create and run the sessions for loading the data using the 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 the mappings and check the quality of the deliverables.
• Used Informatica Workflow Manager & Monitor to create, schedule, Monitor Workflows.
• Performed the Tasks of Validating, Executing and scheduling the workflows.

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

Confidential, Orange County, CA

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 the entire process.
• Prepared the design specifications, detailed design document for technical specifications.

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