Informatica Developer
Resume:
Informatica Developer Email:
*******@*****.***
Professional Summary:
. 7+ years of experience in analysis, design, development and
maintenance in IT industry.
. Strong expertise in designing and developing Business Intelligence
solutions in staging, populating Operational Data Store (ODS),
Enterprise Data Warehouse(EDW), Data Marts / Decision Support Systems
using Informatica Power Center 9.x/8.x/7.x ETL tool.
. Excellent interpersonal and communication skills, technically
competent and result-oriented with problem solving skills and ability
to work independently and use sound judgment.
. Experienced in integration and transforming of various data sources
from Databases like MS Access, Oracle, DB2, SQL Server and formats
like flat-files, XML, etc.
. Expertise in scheduling Informatica jobs using Informatica, Windows
scheduler
. Experienced in working for the post development cycle and applications
in Production Support.
. Expertise in Data Modeling using Star Schema/Snowflake Schema,
OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical
data modeling using ERWIN 4.x/3.x
. Experienced in Performance tuning of Informatica (sources, mappings,
targets and sessions) and tuning the SQL queries.
. Developed tactical and strategic plans to implement technology
solutions and effectively manage client expectations.
. Developed effective working relationships with client team to
understand support requirements.
. Knowledge of Installation, Configuration, and Administration of
Informatica Power Center 8.x/7.x/6.x
. Experienced in using ETL tools like Informatica (Power Center)
Designer, Repository Manager, Administration console and Workflow
Manager
Technical Skills:
ETL Tools Informatica Power Center 9.x/8.x/7.x
Data Modeling Erwin 4.0/3.5, Toad, SQL Station, MS
Visio, SQL Developer, Gretl, Stata,
Eviews
DBMS Oracle 11g/10g/9i/8i, IBM DB2, MS SQL
Server 2005/2000, Microsoft Access,
Excel, ODBC
Programming Languages SQL, PL/SQL,T-SQL, Unix Shell scripting
Operating Systems Windows XP/2008/2003/2000/NT/98/95,
MacOS
PROFESSIONAL EXPERIENCE:
Client: A to Z Financial Services, CA Jul'13 to
Present
Informatica Developer
A to Z Financial Services, was established and incorporated in California.
A to Z financial provides Home loans, Auto loans and a variety of short
term loans. Financial engages in business through its subsidiaries that
provide a wide range of financial planning, products and services designed
to be utilized as solutions for its clients. The objective of Data
Warehouse is to represent a financial reporting infrastructure that
centralizes access to data, applications, reporting and analytical systems
for the required financial content.
Responsibilities:
. Involved in gathering and analyzing the requirements and preparing
business rules.
. Worked with Informatica power center Designer, Workflow Manager,
Workflow Monitor and Repository Manager.
. Developed and maintained ETL (Extract, Transformation and Loading)
mappings to extract the data from multiple source systems like Oracle
and Flat files and loaded into Oracle.
. Involved in creating new table structures and modifying existing
tables and fit into the existing Data Model.
. Extracted data from different databases like Oracle and external
source systems like flat files using ETL tool.
. Generated queries using SQL to check for consistency of the data in
the tables and to update the tables as per the Business requirements.
. Designed and developed complex mappings by using Lookup, Expression,
Update, Sequence generator, Aggregator, Router, Stored Procedure,
etc., transformations to implement complex logics while coding a
mapping.
. Good understanding of source to target data mapping and Business rules
associated with the ETL processes.
. Involved in Performance Tuning of mappings in Informatica.
Environment: Informatica 9.1.0, Oracle 10g, SQL server 2005, SQL, T-SQL,
PL/SQL
Client: PNC Bank, Chicago, IL
Aug'12-Jul'13
Jr. Informatica Developer
PNC Financial Services Group, Inc is the fifth largest bank holding company
in the United States with its head quarters located in Pittsburgh,
Pennsylvania. PNC Bank operates in 19 states, with more than 2,700
branches. This project is developed for maintaining a catalog of all the
products that are offered online to the customers. It involved extraction
of data from multiple Source systems and loading them through an ETL
process in to staging tables and then in to Target tables.
Responsibilities:
. Prepared technical design/specifications for data Extraction,
Transformation and Loading.
. Worked on Informatica Utilities Source Analyzer, warehouse Designer,
Mapping Designer, Mapplet Designer and Transformation Developer.
. Analyzing the sources, transforming data, mapping the data and loading
the data into targets using Informatica Power Center Designer.
. Created reusable transformations to load data from operational data
source to Data Warehouse and involved in capacity planning and storage
of data.
. Developed complex mappings such as Slowly Changing Dimensions Type II-
Time stamping in the Mapping Designer.
. Used various transformations like Stored Procedure, Connected and
Unconnected lookups, Update Strategy, Filter transformation, Joiner
transformations to implement complex business logic.
. Used Informatica Workflow Manager to create workflows, database
connections, sessions and batches to run the mappings.
. Used Variables and Parameters in the mappings to pass the values
between mappings and sessions.
. Created Stored Procedures, Functions, Packages and Triggers using
PL/SQL.
. Implemented restart strategy and error handling techniques to recover
failed sessions.
. Used Unix Shell Scripts to automate pre-session and post-session
processes.
. Did performance tuning to improve Data Extraction, Data process and
Load time.
. Wrote complex SQL Queries involving multiple tables with joins.
. Implemented best practices as per the standards while designing
technical documents and developing Informatica ETL process.
Environment: Informatica Power center 8.6.1, Oracle 10g, Windows XP, Unix
Shell Scripts, SQL, PL/SQL, Flat files.
Client: Client: Fedex, SFO, CA
May'10-Jul'12
Jr. Informatica Developer
Fedex is one of the world's leading shipment companies for overnight
packages with its headquarters located in Memphis, TN. It is one of the
global companies, present in 220 countries and about 75,000 cities across
the world. The main aim of the project is to have the details of all the
orders and transactions of Fedex. This project is developed for Executive
business management, financial and profitability analysis, Sales force
management, Marketing Campaign and product analysis.
Responsibilities:
. Involved in creating Detail design documentation to describe program
development, logic, coding, testing, changes and corrections.
. Extensively involved in writing ETL Specifications for Development and
conversion projects.
. Created shortcuts for reusable source/target definitions, Reusable
Transformations, mapplets in Shared folder.
. Involved in requirement definition and analysis in support of Data
Warehouse.
. Worked extensively on different types of transformations like Source
qualifier, expression, Aggregator, Router, filter, update strategy,
lookup, sorter, Normalizer, sequence generator, etc.
. Worked with XSD and XML files generation through ETL process.
. Defined and worked with mapping parameters and variables.
. Designed and developed transformation rules (business rules) to
generate consolidated (fact/summary) data using Informatica ETL tool.
. Performed the performance evaluation of the ETLs for full load cycle.
. Checked Sessions and error logs to troubleshoot problems and also used
debugger for complex.
. Worked on Parameterize of all variables, connections at all levels in
UNIX.
. Created test cases for unit testing and functional testing.
. Coordinated with testing team to make testing team understand Business
and transformation rules being used throughout ETL process.
Environment: Informatica Power Center 9, Workflow Manager, Workflow
Monitor, Erwin, TOAD 8.6.1.0, PL/SQL, Flat files, XML, Oracle 10g/9i/.
Project Coordinator (Internship), Vpype, Fremont, CA
Dec'09-Apr'10
Vpype was an online interactive video broadcast application made for
Facebook. Allowing anyone with a webcam and microphone create a show and
chat with their audience in real time. Found in 2009, the company is
committed to create social video tools enabling people, businesses, brands,
and studios to broadcast their live video content.
Responsibilities:
. Work with all personnel and professional contacts to satisfy clients
and achieve company goals.
. Contacted leads via phone & email to provide information
. Organized monthly board meetings and provided follow ups on daily
activities
. Exceeded monthly sales goal by 100%, with 10 content writing solutions
per month
. Performed post-sales follow-up and logged feedback on services &
responded to inquiries
. Worked independently on projects under strict deadlines
. Worked with development team to ensure testing issues with Vpype
callings are resolved on the basis of using defect reports
. Initiate process improvement to elevate the operations efficiency
(reduced a man shift operation through process automation)
Environment: MS Office Suite, Peach Tree, Windows XP, Windows7, OSX
Contact this candidate