SUMMARY

• Around 6 years of Technical and Functional experience in Decision Support Systems - Data warehousing implementing ETL (Extract, Transform and Load) using Informatica Power Center.
• Extensive experience on extracting data from different sources like Teradata, Oracle, DB2, SQL Server, Flat Files.
• Extensively worked on Power Center Mapping Designer, Mapplet Designer, Transformation developer Warehouse Designer, Workflow Manager, Repository Manager and Workflow Monitor.
• Solid understanding of ETL design principles and good practical knowledge of performing ETL design processes through Informatica.
• Sound Understanding of Data warehousing concepts and Dimensional modeling.
• Strong analytical and conceptual skills in database design and implementation of RDBMS concepts.
• Experienced in Oracle database development using Stored Procedures, Triggers, Functions and Packages.
• Resourceful, creative problem-solver with proven aptitude to analyze and translate complex customer requirements and business problems and design/implement innovative custom solutions.
• Exceptional problem solving and sound decision making capabilities, recognized by associates for quality of data, alternative solutions, and confident, accurate, decision making.
• Performed effectively both as an autonomous, self-motivated individual and as an active member of a decision making team.
• Communicate effectively and express complex technical concepts, both verbally and in writing.
• Strong Experience in the Business Requirements Analysis, design, conversion of business requirements into high level functional specifications.
• Ability to interact with various groups ranging from Business Users, Business IM teams, Analysts.
• Excellent Client Interaction, Communication, Documentation, Multitasking, Research, and Interpersonal skills, with proven ability to communicate effectively with customers; ability to analyze viable alternatives and provide innovative solutions

TECHNICAL SKILLS

DW/BI: Informatica PowerCenter 9.6, Business Objects XI R2

Databases: Oracle (Version 9 to 11g), Teradata, DB2 9.1, SQL Server 2008, MS-Access

Languages: SQL, PL/SQL, Shell Programming (Ksh, Bsh)

GUI Packages: MS Visio 2007, TOAD for Oracle

Operating Systems: Windows 9x/2K/NT/XP, UNIX, Linux

Other: Control M, Tableau

PROFESSIONAL EXPERIENCE

Confidential, Newark, CA

Informatica - ETL Developer

Responsibilities:

• Responsible for coordinating with the Business Analysts and users to understand business and functional requirements and implement the same into an ETL design document.
• Working closely with business users and technical teams in a customer facing role to bring requirements together into a cohesive design.
• Developed various Informatica Mappings & Mapplets to load data using different transformations like Source Qualifier, Joiner, Router, Sorter, Aggregator, Connected and Unconnected Lookup, Update Strategy, Expression, Stored Procedure, Java, Sequence Generator to load the data into the target tables.
• Extensively involved in Documentation of ETL Mapping Specification, and all other ETL Process documents.
• Implemented / Developed incremental ETL mappings.
• Adhered to the ETL best practices and the quality standards described by the client.
• Identifying the issues and working closely with Business Users and technical teams to resolve the issues.
• Enhancements to the existing data sources to meet the customer’s requirements.
• Analyze new data feeds.
• Performance tuning in Informatica Mappings by identifying the bottlenecks and Implemented effective transformation Logic.
• Provided 24 x 7 production support and maintenance for all the applications with the ETL process.

Environment: Informatica PowerCenter 9.6.1, Oracle 11g, Tableau, Linux

Confidential

ETL Developer - Programmer Analyst

Responsibilities:

• Provided business solutions for a leading banking firm in the U.S.A, in banking and financial services with data warehousing tools such as INFORMATICA and TERADATA.
• Design, Development, Implementation and Testing of ETL (Extract, Transform & Load) interfaces (Complex Mappings, Mapplets, Worklets, Workflows) with different sources and with different transformations using Informatica Power Center 9.1 for Data Warehousing.
• Actively involved in removing bottle necks and optimize the Mappings, Sessions, and Workflows to improve the load performance and to confirm they follow the coding standards and quality process.
• Issue Triaging and Verification using QC; Monitoring the Production jobs and solving the issues in case of production failures based on the priority basis.
• Closely worked and assisted the QA team during the test cycles to resolve the issues and bug fixing.
• Designed and developed ETL specifications for source to target mappings
• Wrote Data validity scripts that are created for the QA process to compare the target data against the source system.
• Worked with QA team on Full Load Testing, Attributes Testing, ETL Incremental Regression Testing, and Defect Tracking.

Environment: Informatica PowerCenter 9.1, Teradata, Control M, Unix

Confidential

ETL Developer - Analyst

Responsibilities:

• ETL Processes (Development/enhancements of ETL routines) were implemented using Informatica PowerCenter, Oracle, Windows and UNIX environment.
• Identified and implemented any transformations or conversions required to maximize consistency and usability of the data.
• Responsible for coordinating with the Business Analysts and users to understand business and functional requirements and implement the same into an ETL design document.
• Developed various Informatica Mappings & Mapplets to load data to ODS using different transformations like Source Qualifier, Joiner, Router, Sorter, Aggregator, Connected and Unconnected Lookup, Update Strategy, Expression, Stored Procedure, and Sequence Generator to load the data into the target tables.
• Performance tuning in Informatica Mappings by identifying the bottlenecks and Implemented effective transformation Logic.
• Created and Monitored Sessions and various other Tasks such as Decision, Email, Assignment, Command etc using Informatica Workflow Manager.
• Worked on Batch Processing or Scheduling and Shell Scripting.
• Ensuring right training programs for entry level trainees, urging team-members to take up domain trainings to enhance better requirement elicitation.
• Underwent extensive training in Data warehousing tools such as COGNOS(Reporting), BUSINESS OBJECTS(Reporting), Oracle and other basic concepts such as Unix and C++.
• Completed following certifications; Data warehousing Basics and testing concepts, Informatica Level 1 - Practitioner and Teradata Basics (TEO-121).

Environment: Informatica PowerCenter 9.1, Oracle 11g, Business Objects, Linux

Confidential

Junior Developer

Responsibilities:

• Involved in data gathering and system functionality requirements study.
• Createdtables, triggersandindexesfor enforcing business rules.
• Wrote Stored Proceduresas well as analyzed and debugged existing complex stored procedures.
• Worked closely with senior developers and DBA on the migration of the database.
• Created design documents based on the requirements.

Environment: MS SQL Server, Profiler, Windows, Unix