Technology Lead - ETL Projects Resume LA - Hire IT People

SUMMARY:

Having around 6 years of experience in implementation of Datawarehousing projects with
ETL tool Informatica and around 2 years of experience in Datastage.
Having total IT experience of around 10 years.
Experience in leading ETL projects to design, develop and deliver.
Presented a paper on Decision Support System using DWH / OLAP during college days.

TECHNICAL SKILLS

ETL Tool: Informatica 9.5.1, Datastage 8.1

Databases: Oracle 11g, DB2 9.5, MS SQL Server

Operating system: Windows, Unix

PROFESSIONAL EXPERIENCE

Confidential, LA

Technology Lead - ETL Projects

Responsibilities:

Confidential

Technology Lead - ETL Development

Responsibilities:

Data analysis for the Inbound MDM database
Coordinate with different application teams to understand their master data requirement.
Build the MDM Outbound strategy and create mapping sheets.
Informatica mapping/workflow development and testing
Create the estimation and project plan
Perform reviews and testing
Defect Prevention and Root Cause Analysis for the project

Confidential

Technology Lead - ETL Development

Responsibilities:

Informatica development for minor and major enhancements
Offshore production support lead for ticket handling and data requests.
Job monitoring and status tracking
Basic Informatica administration
Involved in developing the ETL strategy to populate the Data Store from various source systems
Building the datastage jobs.
Preparation of technical design documents.
Developing the Informatica mappings\sessions for loading into DataMart.
Analyzing the data from various source systems
Performance tuning for the queries and mappings.

Analyst - Oracle Developer

Confidential

Environment: Oracle 8i

Responsibilities

As Oracle developer my responsibilities includes:
Impact analysis for the requirements.
Supporting and debugging production issues.
Modifying Oracle PL/SQL packages, procedures and functions as per the change in the business logic.
Won the ‘Extra Miler Award’ for outstanding performance in my project.
Involved in the Process and Quality management activities of our project.