Informatica Developer Resume

PROFESSIONAL SUMMARY:

Informatica Powercenter client tools - Mapping Designer, Repository Manager, Workflow
Manager/Monitor and Server tools - Informatica Server, Repository Server Manager Designed
ETL process using Informatica Tool to load from Sources to Targets into OLAP/data warehouse using data Transformations
Tuned Informatica mappings and sessions for optimum performances
Parsing high level design specification to simple ETL coding along with mappings standards
Experience in Dimensional Modeling using Star and Snow Flake Schema, identifying Facts and
Dimensions, Physical and logical data modeling using Erwin and ER-Studio
Experience in Agile/Scrum based system development methodologies *Worked intensively on
SQL, PL/SQL procedures and functions and packages within mappings
Created Post UNIX scripts to perform operations like remove, touch and gunzip files
Hands on experience with SDLC, Java, HTML & CSS and Python.
Strong Communication and Interpersonal skills with ability to work in fast paced team environment and quickly learn new software technologies

SKILL:

ETL Tools: Informatica Powercenter / 9.6.1 /9.5/8.6.1

Operating systems: Microsoft Windows, UNIX

OLAP Tools: Cognos 8.4

Languages: SQL, PL/SQL, UNIX, Shell scripts, Java Script, HTML &CSS Fast learner

WORK HISTORY:

Informatica Developer

Confidential

Responsibilities:

Worked with Business analysts and DBA for requirements gathering, business analysis and designing of the data warehouse.
Performance Tuning for Informatica session with large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
Created Mapplet, Reusable sessions and used them in Mappings and workflows.
Working with database connections, SQL joins, views, aggregate conditions, parsing of objects and hierarchies.
Developed Shell scripts for running batch jobs and scheduling them.
Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
Studied the existing OLTP system(s) and created facts, dimensions and star schema representation for the data mart.

Environment: Informatica Power center 9.6.1/8.6.1 Workflow Manager/Monitor, Erwin 4.0, Oracle 11g/10g, SQL, PL/SQL, UNIX, Shell scripting, TOAD.

Confidential, Ohio

Informatica Developer

Responsibilities:

Inventory and generating Reports Using MS Office.
Offered feedback on the quality of segments and coached other staff members on how to improve segments
Coordinated with supervisor and Team members