SUMMARY

• 1.5 years of experience in Data Architecture, Data Integration, Data Warehousing using ETL tool INFORMATICA Power Center 10.1/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 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 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, java, 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, F-Export & TPT.
• Experience in doing fine tuning of Teradata scripts and writing Teradata scripts using BTEQ.
• Experience with Teradata Admin related work while supporting also using Explain plan effectively for performance related query tuning.
• Good experience on Teradata Data Recovery Options and Releasing different utility failures M-Load, F-Load & T-Pump).
• Good Experience with Teradata Index options, PPIs & Join Index.
• Worked with Different tables in Teradata - Multi Set, Set, Volatile, & Global tables.
• 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.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules for adhoc data.
• Strong knowledge on IDQ Mapping Designer, Mapplet Designer, Transformation developer Designer, Workflow Manager and Repository.
• Responsible for Unit testing of mappings and workflows.
• Experience in working with Unit testing & QA team for system testing.
• Good experience in working with several scheduling tools Maestro, Cron Tab, Autosys, Control M & Informatica Scheduler.
• Extensively worked on Code Migration from Development, UAT, and Production.
• Involved in Code Deployment, Release Management & Change Management process and documentation.
• Heavily Involved in On Call Production Support for monitoring & supporting ETL Production jobs also involved in solving trouble tickets raised by End Users/Customers.
• Experience in Both Waterfall & Agile Methodology in implementing DWH projects and good experience with scrum process.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.2/9.6.1/9.5.1/9.1.1

Databases: Oracle, MS Sql Server, Teradata SQL assistant, My Sql, DB2, Sybase, Flat File, XML.

Programming Languages/ Scripting: Sql, PL/SQL, Unix Shell, C, Java

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

Reporting Tools: Business Objects, Dash Board Reporting

Operating Systems: Windows, Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential, Racine, WI

Informatica/Teradata Developer

Responsibilities:

• Expertise in Informatica - Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extracted data from various heterogeneous sources like Oracle and SAP, MS SQL.
• Developed complex mapping using Informatica Power Center tool 10.2 .
• Bug fixing and re-testing .
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Good knowledge with the relational DB Teradata, experience with views creation and semantic layer built in Teradata using SQL Teradata assistant .
• Created views, AVFs, sematic layer built in Teradata and using Teradata in the mappings for loading the data.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Resolving design/development issues and interacting with infrastructure support partners (DBA, Sys Admins)
• Plan and execute deployments across all environments in DEV, QA and Prod .
• Designed end to end process solution for Informatica.
• Responsible for developing code according to the technical design of the solution when ETL is required.
• Design and Dynamic Access Control (DAC).
• Involved in loading of data into Teradata from legacy systems and flat files.
• Created Technical Design Document and detail designed documents.
• Extracting data from Oracle and SAP, MS SQL and performed Delta mechanism using Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Created Sessions, Tasks, Work flows and Worklets using Work flow manager.
• Involved in developing the Deployment groups for deploying the code between various environment (Dev, QA, and Prod) .
• Unit Test case preparation and unit testing.
• Experience developing and supporting complex DW transformations
• Excellent understanding of Star Schema Data Models; Type 1 and Type 2 Dimensions .
• Created pre SQL and post SQL scripts which need to be run at Informatica level.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Used Debugger to fix the defects/ errors and data issues.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Develop, test and maintain all ETL maps /scripts and physical data models.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD .
• Monitored and improved query performance by creating views, indexes, hints and sub queries.

Confidential, Cumberland, RI

Informatica Developer

Responsibilities:

• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformations
• Developed Informatica mappings & tuning them for better performance.
• Worked on loading Flat Files into Data warehouse.
• 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 solution 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 centre as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources .
• Scheduled and monitored automated daily, weekly, monthly jobs.
• Developed mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Worked on all phases of SDLC from requirement gathering, design, development, testing and support for production environment.
• Involved in unit testing, Integration testing and User acceptance testing of the mappings.
• Involved in Migrating the Informatica objects using Unix SVN from Dev to QA Repository.
• Worked on developing workflows and sessions and monitoring them to ensure data is properly loaded on to the target tables.
• Responsible for scheduling workflows, error checking, production support, maintenance and testing of ETL procedures using Informatica session logs.
• Performance tuning on sources, targets mappings and SQL (Optimization) tuning.
• Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• 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 at 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 Production with ETL Admins.

Environment: Informatica Power Center 10.2/9.6.1/9.5.1, Oracle, My Sql, Flat File, Cognos, Rally, Putty, Informatica Scheduler, UNIX, Windows.