INFORMATICA Developer Resume

OBJECTIVE:

Looking for a challenging and exciting passion that enable me to continually expand and enhance my current technical skill as well as my personal development and interpersonal skills.

PROFESSIONAL SUMMARY:

Five years of experience on ETL, Data Warehousing analysis, design and development of software applications using INFORMATICA Power Center 9.X, 10 and Pentaho BI tools (Kettle, Schema Workbench).
Good knowledge on data warehouse concepts like dimensional modeling, Star Schema and Snowflake.
Experience in development of mapping using needed Transformations using INFORMATICA tool.
Experience in the Data Warehousing using Data Extracting, Data Transformation and Data Loading.
Use ETL process to Extract, Transform and Load the data into stage area and data warehouse.
Preparing the documentation for the mappings that meet the business requirements.
Optimizing INFORMATICA Mappings and Sessions to improve the performance.
Extensively use of INFORMATICA client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, INFORMATICA Repository Manager and INFORMATICA Workflow Manager.
Possessing complete domain and development Life Cycle knowledge of Data Warehouse.
UNIX shell scripting.
Excellent problem-solving skills with strong technical background and good interpersonal skills.
Quick learner and excellent team player, ability to meet deadlines and work under pressure.

TECHNICAL SKILLS:

ETL Tools: INFORMATICA Power Center version 9.x and version 10, Pentaho Data Integration(PDI)

Database: Oracle 10g/11g, MySQL

Operating System: Linux, UNIX, Windows, OS X

Programming: SQL, PL/SQL, Shell Script

Applications Tools: SQL Developer, Toad, Putty, Notepad++

EXPERIENCE:

INFORMATICA Developer

Confidential

Responsibilities:

Developing ETL mappings, transformations using INFORMATICA Power Center.
Developing mappings using various transformations like Update Strategy, Lookup, Store Procedure, Router, Sequence Generator, Joiner, Aggregate transformation and Expression.
Involved into source code review and mappings created by other team members.
Preparing deployment document and assist to deployment team while migration.
Involved in creating test scripts.
Involved in performance tuning by optimizing the sources, targets, mappings and sessions.
Developing reusable transformations and mapplets that were used in other mappings.
Involved in scheduling the workflows to follow the order of loading data to target tables.

BI Engineer

Confidential, Claremont, California

Responsibilities:

Involved in implementing the end to end ETL life cycle.
Understanding the requirements from business user and translating the requirements into design.
Dimensional modelling (Star/Snowflake).
Preparing and implementing SQL DDL scripts for creating tables in data warehouse and Staging database.
Preparing the ETL source to target design documents.
Developing and maintain ETL workflow to import data from heterogeneous sources (Excel, CSV, flat files, and OLTP database) into data warehouse and data mart using INFORMATICA PowerCenter and Pentaho Data Integration(Kettle).
Design and unit testing all ETL components.
Building Cubes and Schemas for BI analysis using Pentaho Schema Workbench.
Wrote SQL and MDX queries to meet the requirements for reporting.
Monitoring and optimizing SQL and MDX queries for maximum efficiency.

Data Assistant / Database Administrator

Confidential

Responsibilities:

Installing and configuring Oracle database on test environment.
Installed Service Packs for Oracle database.
Creating and maintaining databases on production and development environments in Oracle.
Database performance tuning.
Involved in database backup and recovery.
Administered database user accounts; Created, modified, deactivated user accounts; assigned user roles.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship