SUMMARY

• 8+ years of IT experience in Analysis, Design, Development and Implementation of Data warehouse systems and Expertise in Teradata, Informatica, Push down Optimization, Oracle and Unix/Linux.
• Worked on Teradata Client Utilities using BTEQ, Fast load, MultiLoad, TPT and Fast export.
• Extensively worked on UPI, NUPI, USI and NUSI.
• Design of Tables with Set and Multiset
• Extensively worked in Designing, Coding and Testing phases of software development life cycle process, which includes implementing and supporting Teradata & batch - processing jobs.
• Extensive experience in creating theMappings, Mapplets, Reusable transformations Workflows, Worklets,and scheduling theWorkflows and sessionsusingInformatica Power Center.
• Worked in Analysis & Migrating SAS Code to Informatica and Teradata.
• Identifying the bottleneck and involved in performance tuning and optimization of ETL loads both at the mapping and the session level and also at the database level.
• Documentation for the Informatica processes, naming conventions and best practices.
• Worked on queries for avoiding FTS in Teradata.
• Worked on Physical Data model and Logical Data model
• Involved in the design of Dimensional Data Modeling (Star, Snow Flake schema) using Erwin, MS-Visio.
• Sound knowledge in Relational and Dimensional modeling techniques of Data warehouse concepts and principles - Star, Snowflake schema, SCD, Surrogate keys, and Normalization/De normalization
• Designed and developed complex mappings using different transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner Update Strategy and more
• Excellent Knowledge of relational database management systems and extensively worked on Data extraction, transformation, loading with Oracle and Teradata using Informatica

TECHNICAL SKILLS

Operating System: Windows 95/98/2000, Unix /Linux

Languages: SQL,C,plsql

Databases: Teradata 12 and 13, Oracle

Tools: & Utilities: Informatica 9.1,Informatia 8.6,Informatica 8.5,Teradata 13,Teradata 12 & Utilities like BTEQ, Fast load, Multiload, Fast Export, Tpump, Erwin, Toad

Domain Knowledge: Life Sciences

PROFESSIONAL EXPERIENCE

Confidential

Informatica/Teradata Tech Lead

Responsibilities:

• Interacts with Functional teams to understand the requirements.
• Works as Tech Lead, performs requirements gathering, Analysis, Design development & documentation for any enhancements.
• Design, Development and Testing and coordination with Offshore Team for any enhancements.
• Worked on exporting data to flat files using Teradata FEXPORT.
• Query optimization (explain plans, collect statistics, Primary and Secondary indexes)
• Build tables, views, UPI, NUPI, USI and NUSI.
• Interpretation of long running Queries using Explain plan.
• Written several Teradata BTEQ scripts to implement the business logic.
• Worked with the Teradata SQL Assistant to interface with the Teradata.
• Extensively involved in Query Tuning to improve the performance by optimizing high volume tables in Teradata using Join Indexes, Secondary Indexes, Partition Primary Indexes, table compression, collecting stats etc.
• Extensively involved in Performance Tuning for ETL process at source, target, InformaticaMappings, Sessions and at database level for optimum performance.
• Coordinates the project tasks with the team and ensured that the projects are completed on time.
• Works on Informatica PDO at Source, PDO at Target and Full PDO for ETL code.
• Works on Teradata utilities TPT,Fload,Mload, for loading tables,bteq and Fast export exporting data from table.

Environment: Informatica 9.1, Oracle, Teradata 13.1, Linux

Confidential

Informatica Lead

Responsibilities:

• Interacts with Functional teams to understand the requirements.
• Works as Tech Lead, performs requirements gathering, Analysis, Design development & documentation for any enhancements.
• Interacts with Business Analyst in requirements gathering, business analysis and project co-ordination.
• Involved in creating Teradata tables, Views and Macros using feedbacks from the business users.
• Frequently used Teradata Utilities such as BTEQ and Mload for loading small amounts of data and Fload for loading huge amounts of the data into the tables.
• Used FastExport for creating the flat files from TD tables.
• Involved in modifying and Tuning of already existing code
• Design, Development and Testing and coordination with Offshore Team for any enhancements.
• Extensively involved in Performance Tuning for ETL process at source, target, InformaticaMappings, Sessions and at database level for optimum performance.
• Coordinated the project tasks with the team and ensured that the projects are completed on time.
• Works on Confidential Scheduling Tool for Scheduling and Monitoring of jobs.

Environment: Informatica, Oracle, Teradata, UNIX

Confidential

Informatica Lead

Responsibilities:

• Interacts with Functional teams to understand the requirements.
• Works as Tech Lead, performs requirements gathering, Analysis, Design development & documentation for any enhancements.
• Interacts with Business Analyst in requirements gathering, business analysis and project co-ordination.
• Design, Development and Testing and coordination with Offshore Team for any enhancements.
• Involved in writing SQL scripts for unit and functional testing.
• Extensively involved in Performance Tuning for ETL process at source, target, InformaticaMappings, Sessions and at database level for optimum performance.
• Coordinated the project tasks with the team and ensured that the projects are completed on time.
• Works on Confidential Scheduling Tool for Scheduling and Monitoring of jobs.
• Uses Teradata utilities Fload,Mload, for loading tables and Fast export exporting data from table

Environment: Informatica, Oracle, Teradata, UNIX

Confidential

Informatica Lead

Responsibilities:

• Interacted with Functional teams to understand the requirements.
• Data Profiling Activities.
• As a Sr. Informatica developer, performed requirements gathering, developed Analysis & Design document, developed Project time line.
• Involved with Business Analyst in requirements gathering, business analysis and project co-ordination
• Analyzed existing SAS codes for conversion into Informatica ETL code.
• Design, Development and Testing and coordination with Offshore Team.
• Data comparison with SAS files and ETL output Files.
• Extensively involved in Performance Tuning for ETL process at source, target, InformaticaMappings, Sessions and at database level for optimum performance.
• Coordinated the project tasks with the team and ensured that the projects are completed on time.
• Worked on Confidential Scheduling Tool for Scheduling and Monitoring of jobs.
• Used Teradata utilities Fload,Mload, for loading tables and Fast export exporting data from table
• Extensively involved in ETL testing,
• Documentation for the Informatica processes, naming conventions and best practices.

Environment: Informatica, Teradata, UNIX

Confidential

Informatica Lead

Responsibilities:

• Interacted with development & Functional teams to understand the load requirements.
• Performed Data profiling on the existing IDEA Sales Production data
• Developed business models confirming to functional mapping-defined logical and complex joins for the dimension tables.
• Responsible for History Load and Design, Interact with offshore for Development and Test and do Functional Testing.
• Involved in writing SQL scripts for unit and functional testing.
• Provided recommendations at query-level & also at Table-Level to improve the performance.
• Interacted with Business users on analyzing their requirements.

Environment: Informatica, Oracle, UNIX

Confidential

Teradata/Informatica Developer

Responsibilities:

• Interacted with development & Functional teams to understand the requirements.
• Worked in Data Profiling, Requirements gathering.
• Design of Product Subject Area for Confidential Products
• Worked in porting Oracle code in Teradata for ITRAK Reporting Tool as Part of Poc.
• Worked Extensively on Teradata utilities to load Data in Our project Using FLOAD, Fast Export, MLOAD, and BTEQ, had worked on some basics Teradata administrator tasks.
• Worked on Informatica tool for developing mappings.

Environment: Informatica, Teradata 12 & 13, Oracle 10g, UNIX

Confidential

Informatica Developer

Responsibilities:

• Gathered Requirements from functional team.
• Worked in Design of Mappings and Develop
• Reconcile with existing application
• Load BU Product master details in Table.
• Performed Unit testing and System integration testing
• Worked on Informatica tool for developing mappings.

Environment: Informatica, Oracle, UNIX

Confidential

Informatica Developer

Responsibilities:

• Design, Develop and Test the informatica code.
• Load file till data marts and do reconcile HFM with MIC data.
• Maintain cross reference Product information for MIC,Oracle and HFM and refresh whenever there are any changes in product maps
• Interact with Functional team for any issues on HFM adjustments due to wrong map of products in Product cross-reference file and fix them.

Environment: Informatica, oracle, UNIX

Confidential

Developer

Responsibilities:

• Had supported the application by fixing any data issue when job fails
• Reconcile data among data marts
• Used to handle reconcile issues on products by tracing back the load.
• Used to support client for data extraction, fixing issues and reloading data
• Handled CR’s in system.

Environment: Informatica, Oracle, UNIX