ETL Developer
Resume:
[login or register]
* search jobs
* tech interviews
* job seekers
* employers
ETL Developer Resume
Title
ETL Developer
Primary Skills
ETL, Informatica
Location
US-CA-San Francisco (will consider relocating)
Posted
Jun-28-12
RESUME DETAILS
Professional Summary
8 years of total IT experience in the business requirements analysis, application
design, dimensional data modeling, data modeling, designing, coding, development, testing
and implementation of business applications with RDBMS, Data Warehouse/Data marts, ETL,
and client/server environment applications for insurance, pharmaceutical, financial and
hospitability.
6 years of experience working on End-To-End implementation of Data warehouse
6six years of strong experience in Data Warehousing and ETL using
InformaticaPowerCenter9.1/8.6/8.1/7.1.3/7.0/6.2/5.1, InformaticaPowerMart6.2/5.1/4.7.
Strong experience in designing the Design Documents for loading data into Data
Warehouse and Data Mart tables.
Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data
modeling experience using Normalization, Business Process Analysis, Reengineering,
Dimensional Data modeling, FACT& dimensions tables, physical & logical data modeling.
Good programming experience in Transact SQL, SQL, PL/SQL, Complex Stored Procedures,
Triggers.
Three years of hands on experience working with scheduling tools like Auto sys, Control
M.
Experience in working with multiple RDBMS including Oracle 11i/9i/8i, SQL Server,
Teradata and MS Access.
Strong expertise on the various data design models like Star Schema and Snowflake
models.
Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and
Triggers.
Exceptional analytical and problem solving skills. Team Player with the ability to
communicate effectively at all levels of the development process
Technical Skills:
ETL: Informatica Power center 7.1.2/6.x/5.x
Databases: Oracle 11.i/9.i/8.x/7.i, Teradata, SQL Server, DB2, MS Access.
Packages: SQL* PLUS, Toad 7.x, SQL Navigator 4.
Languages: C, C++, Visual Basic, SQL, UNIX Shell (Ksh/Csh), PL/SQL.
Operating system: Windows (95/98/00/XP, vista), WinNT, UNIX.
Data Modeling Tools: ERWIN 4.5/4.0/3.5/3.2.,ER Studio.
GUI: Visual Basic 6.0/5.0.
Web technologies: HTML, DHTML, XML.
Education:
Bachelor's in Computer Engineering JNTU, Hyderabad.
Professional Experience:
Client:
HISNA ( Hyundai Information Services North America) Jan 2011 -- Present
Project Name: Hyundai Sales portal ( HSP)
Role: Informatica Developer
Project Description: Hyundai is one of the large Automobile company in United states, The
project main goal is take care of all Dealer sales across HMA ( Hyundai motor America )
and HMC ( Hyundai motors Canada ) and KMA ( Kia motors America), KMC (Kia motors Canada )
Responsibilities:
Working with different source systems like SAP (R3), AS400, flat files, Oracle
Contacting the Business Analysts/Users to develop, document and to evolve process and
data models based upon their input and feedback
Experience in Agile methodology
Experience translating business requirements into Conceptual and Logical Process and
Data Models.
Experience in preparing Logical data models as well as Physical data models and
document the same
Created reusable transformations for converting varchar into upper case and string to
date
Created Mapplet for history management dates,ETL Process status
Created mapping for error handling sessions
Participated in Data modeling meetings, helped to identify the relationship between
tables according to the requirements
Prepared ETL design document which consists of the database structure, change data
capture, Error handling, restart and refresh strategies
Created mapping for creating a parameter file
Worked with DBA's to design and build the Staging/Target databases
Assisted business users for data cleansing and user acceptance testing
Worked in Informatica for the Extraction, Transformation and Loading from various
sources to the enterprise data warehouse
Developed and tested extraction, transformation, and load (ETL) processes
Involved in change data capture (CDC) ETL process
Created sessions and workflows for the source to staging data flow and staging to
Target loading
Implemented Type II changes for different Dimensions
Developed functions and stored procedures to aid complex mappings
Environment: InformaticaPower Center 9.1,8.6, Oracle 9i, SQL developer, TOAD, Windows
NT/XP,HP Quality center 10.0.
Client:
PHILIPS, Andover, MA May 2010 - Jan 2011
Role: Informatica Developer
PHILIPS is one of the largest electronics companies in the world .Philips organized in
a number of sectors like Philips consumer lifestyle (Consumer electronics and Domestic
appliances,personal care) and Philips lighting and Philips Healthcare(Philips Medical
systems). The objective of the project APEX(Availability and performance in excellence) is
to give the Materials, Equipments and Customer, Contract etc details to Philips customer
service system Clarify for customer support. Objective of Consumer Objects project is to
extract the data from BW systems to comops server for Reports generation for business
users by incremental loading and full load.
Responsibilities:
Interacted with Business analyst, SAP developers, Clarify(Customer service team)
developers and SAP Functional consultants to identify the business requirements and data
realties.
Worked with Functional consultant and SAP developers to design the function modules for
extract the data from SAP R3 systems.
Imported Source/Target tables from the respective SAP R3 and BW systems and created
reusable transformations (Joiner, Routers, Lookups, Rank, Filter, Expression and
Aggregator) inside a mapplet and created new mappings using Designer module of Informatica
Power Center to implement the business logic and to load the customer healthcare data
incrementally and full.
Created Complex mappings using Unconnected Lookup, and Aggregate and Router
transformations for populating target table in efficient manner.
Used Shortcuts (Global/Local) to reuse objects without creating multiple objects in the
repository and inherit changes made to the source automatically.
Extensively used Experience in working with SAP Developers to create Function modules
or transparent(Z Table in SAP) tables for Migration /Loading of Data from SAP R3,SAP BW to
Oracle and then loading to external targets like SQL Server and Flat files.
Worked on SQL tools like PLSQL Developer/SQL Plus/MS SQL Visual studio to run SQL
queries and validate the data.
Worked along with SAP Functional team on SAP Solution manager and service manager tool
for transferring or Transporting programs from one level to another level in SAP(Landscape
like Development, UAT, Regression testing and Production).
Extensively work on the performance tuning of Informatica PowerCenter Mappings as well
as the tuning of the sessions by creating multiple sessions on primary key values by using
partition query.
Optimized the mappings using various optimization techniques and also debugged some
existing mappings using the Debugger to test and fix the mappings.
Migrated mappings, sessions, and workflows from Development to Testing and then to
Production environments.
Performed unit, integration and system level performance testing. Associated with
production support team in various performance related issues. Created testing documents
for the migration of SAP programs to next level for the approval of SAP functional team.
Provided production support by monitoring the processes running daily.
Scheduled the Jobs by using Informatica scheduler.
Environment: Informatica PowerCenter 9.0.1/8.6.1/7.1.4, IDQ 9.0.1/8.6.1, Power Mart, IDE,
Power center (Repository Manger, Designer, OLAP, Service Manager, Workflow Monitor,
Workflow Manager),Business Objects XI/6.0,Cognos 7, Erwin 4.5,Oracle 11.5/10g, SQL, PL/SQL
Developer, WINSQL, MS SQL Server 2005/2000,SSIS,Database Systems, Flat Files, Siebel, SAP
ABAP, Windows XP, UNIX Shell Scripting, Perl, Autosys, SQL*Loader, Microsoft visual
studio, HTML 4,DT and DX, Syncsort for UNIX/Windows.
Client:
Sankyo Pharma Inc., Parsippany NJ Apr 2009 - May 2010
Role: ETL Developer
Sankyo PharmaInc. is subsidiary of Sankyo Co. Ltd. Of Tokyo, established its U.S.
headquarters in Parsippany, New Jersey. It mainly develops drugs like Benicar, HCT, and
Welchol. The name of the project is SSR (Stock Status Report) and the project is to build
the SSRDM which is used for report generation to analyze and to take decisions about the
stock of their products.
Responsibilities:
Attend meetings and gathered business requirements.
Design, develop and implemented of the SSRDM.
Use debugger to test the mapping and fixed the bugs.
Working with unix shell scripting.
Develop Mapplets using corresponding Source, Targets and Transformations.
Tune Informatica Mappings and Sessions for optimum performance.
Solely responsible for IMS Data and converting those to require structure using
Informatica.
Working on TIBCO for data integration.
Develop and tune all the Affiliations received from IMS and other data sources using
Informatica and tested with high volume of data.
name containing duplicate rows which are deleted using aggregator.
In a map I had to load department table and employee table .Under constraint based
loading first it loads employee table and then department table as it contains the foreign
key.
I have validated the address of pharmacists and hospitals using trillium.
In sales table if we find more employees selling the same product and I used rank
transformation to find the first 10 employee who is selling more products.
Use power exchange CDC which captures changes in the sources and loads those changes
into the customer dimension.
Working with control-M scheduler.
Create database triggers for Data Security.
Using DataFlux in data management software and business consulting services.
Assist in writing project documentation used Microsoft Visio for different diagrams.
Used Autosys for scheduling the jobs.
Environment: Informatica Power Center 8.6, Informatica PowerConnect, (Repository Manger,
Designer, Server Manager, Workflow Monitor, Workflow Manager), PowerExchange, Superglue,
ETL, Flat files, Oracle 11g/10g, MS SQL Server 2008, PL/SQL, Autosys, Shell Programming,TIBCO,SQL * Loader, Toad, Excel and Unix scripting, Sun Solaris, Windows 2002.
Client:
Bank of New York, NYC, NY Nov 2008-Apr 2009
Role: DW Informatica Developer
Bank of NY has a long and unrivaled history as a provider of financial services
throughout the world. Bank of NY offers their customers personal service and the
advantages of a local bank, while their global platform allows them to introduce a
continuous stream of new and innovative products quickly and more cost-effectively than
their competitors. This project is developed for Sales & Marketing and Finance Departments
to assist them in their business Analysis.
Responsibilities:
Attend meetings and got the business requirements.
Update maps, sessions and workflows as a part of ETL change.
Develop and documented Data Mappings/Transformations, and Informatica sessions as per
the businessrequirement.
Wrote UNIX shell scripts for various purposes.
Create maps, sessions, tasks and workflows as a part of starcom and aero plan project.
Schedule the workflows in the workflow manager.
Call stored procedures in oracle as pre sql session.
Create reusable failure and success email tasks.
Did production support for all starcom and aeroplan jobs.
Cached up all informatics jobs along with my team.
Use trillium software to remove duplicates from the data.
I had to used change data capture to get only new and updated records from ODS and load
the shadow table.
Working with slowly changing dimensions type 1,2,3.
Create job status report in excel sheet during weekends.
Work on SQL tools like TOAD to run SQL Queries to validate the data.
Design and develop Oracle PL/SQL Procedures and wrote SQL, PL/SQL scripts code for
extracting data to system.
ETL Job daily verification.
Good knowledge on Informatica administration work.
Modifications to existing ETL Code and document the changes.
Download Informatica power center 8.6 client.
Downloadoracle10g client and toad 9.0.
Upgrade from Informatica power center 8.1 to Informatica power center 8.6.
Create repositories in development, QA and production environment.
Environment: Informatica Power Center 8.6, Informatica Power Connect, (Repository
Manager, Designer, Server Manager, Workflow Monitor, Workflow Manager), Power Exchange,
Power Analyzer, ETL, Oracle 11g/10g,Teradata V2R5, PL/SQL,ODI, Unix commands, Trillium 11,
Excel and shell scripting, MS Windows XP professional 2002,UNIX.
Client:
Starwood Hotels, White PlainsNYOct 2006 -Nov 2008
Role: DW Informatica Developer
Starwood is one of the world's largest hotel and leisure companies. It conducts hotel and
leisure business both directly and through its subsidiaries. Its brand names include the
following: St.Regis, The luxury Collection, Westin, Le Meridian, Sheraton, Four Points,
Aloft, Element. Through its brands, we are well representing in most major markets in the
world. Our operations are grouped into two business segments, hotels and vacation
ownership and residential operations.
Responsibilities:
Analyze the functional specs provided by the data architect and created technical specs
documents for all the mappings.
Develop logical and Physical data models that capture current state/future state data
elements and data flows using Erwin.
Tune Informatica mappings for optimum performance.
Provide Knowledge Transfer to the end users and created extensive documentation on the
design, development, implementation, daily loads and process flow of the mapping.
Extensively used Power Center/Mart to design multiple mappings with embedded business
logic. Created Mapplet and used them in different Mappings.
Create events and tasks in the work flows using workflow manager.
Use shell scripts for automating the execution of maps.
Design and developed Oracle PL/SQL Scripts for Data Import/Export, Data Conversions and
Data cleansing.
Did data cleansing using trillium such as converting male into M and female into F.
Generate reports using Cognos Impromptu tools querying database.
Design and deployed in Perl.
Environment: InformaticaPowerCenter 5.1/6.2, Server Manager, Power Connect, Erwin 3.5,
Control M, Siebel 2000, PL/SQL, Oracle 8i, SQL Server 2000, DB2 7.0, HP-UX 10.20, Windows
NT 4.0.
Requital Solutions, Hyderabad, India July 2005 - Aug 2006ETL Developer
Responsibilities:
Creating Database objects and managing the resources.
Exporting and importing data using Export/Import utilities.
Using Explain Plan and oracle optimizer hints to enhance performance of SQL statements.
Implementation of a backup strategy.
Generate completion messages and status reports using Informatica.
Tune ETL procedures and STAR schemas to optimize load and query Performance.
Design and tested the dimensional tables, ODS tables.
Built interface with existing Legacy system.
Carried out weekly reviews, technical reviews, made weekly progress reports.
Act as primary point of contact between customer and core development team.
Acting as configuration controller.
Configuring TNSNAMES.ORA and LISTENER.ORA for Client Server Connections.
Environment: Win NT/00, Oracle 8.1, Informatica, Oracle Developer 2000 Forms and Reports.
Client:
GE Energy BDMD, INDIA May 2004-July 2005ETL Developer
Project Description
GE Energy - Enterprise Data Warehouse, formally known as GE Power Systems (GEPS) -
Enterprise Data Warehouse, is one of the largest Enterprise data warehousing engagements
in the world. The engagement comprises of building and maintaining Enterprise wide Data
warehouse Solution for GEPS, which consists of Project planning, Designing, Development,
Coding, Testing, Integration, Deployment and Maintenance of the Data Marts and also to
coordinate their various sources of information for better decision-making. The sources
include Databases, OLTP Systems, Legacy Systems, Flat files etc.
Responsibilities:
Analysis of the specifications.
Maintain Meta data in the repository.
Document all Meta data dictionary.
Designer Mapping Designer and Mapplet, and Transformations.
Preparing mapping documents.
Extracting Data from source to target using Informatica
Testing - unit testing & integration testing.
UNIX and Perl scripts for Screen Door Programs.
Environment: Flat files, MS SQL Server 2000, PL/SQL, Reporting Services 2000, Autosys,
DOS commands, Excel and batch scripting, DOS, MS Windows 2000.
Certifications
See above
CONTACT DETAILS
You must be logged in and have a current resume access subscription. Login or Register "
Related:
Programmer / Developer Resumes IT Resumes in San Francisco, CA IT Resumes in
California
c2003-2012 Dev Bistro . About Us
Contact this candidate