Datastage Developer Resume

Summary:

Over 5 years of professional Information technology experience encompassing a wide range of skill sets, roles and industry verticals.
Over 5 years of knowledge and hands on experience with Data Warehousing, ETL using different versions of Datastage, Linux, MS Visio, UNIX, software testing techniques, software metrics, Dimensional modeling (Snow Flake and Star Schema) and master data management.
Proficient with UNIX shell scripting, SQL and data investigation.
Strong knowledge of parallel processing concepts and techniques and best practices.

Technical Skills:

Language/Technology:
Data Warehousing, Master Data Management, SQL, Service Oriented Architecture (SOA), Agile methodology, Waterfall methodology

App Dev Tools:
IBM Information Server 8.1, Websphere Datastage Enterprise Edition (Parallel Extender) v 7.5.1, Toad

CASE/Modeling Tools:
MS Project 2003, U.M.L., Microsoft Visio

Databases:
Oracle 10g/9.x/8.x, UDB DB2, MS Access, SQL Server

Operating Systems/File Systems:
Linux RHEL 3/4, UNIX, Windows, PVFS, MPFSI, NFS, HP-UX

Experience:

Confidential,Phoenix, AZ
Datastage Developer Nov 2008 - Current

This project is to support enterprise marketing of Wells Fargo Financials, Home Equity, Home Mortgage and consumer credit card products and services. The main goal to pull data from Wells Fargo’s current ODSs and outside data vendors and transform and transfer it to vendor for loading into data warehouse.

Recommend, plan and execute strategies to provide solution to meet business requirements.
In conjunction with Information System managers establish policies, procedures, tools and infrastructure for a scalable and highly available solution.
Working as Liaison between software sales and services group, enterprise architect, business enablement team, ETL development, production support team and outside vendors.
Created ETL development standards and best practices.
Developed parallel jobs to implement solutions to meet requirements
Created documentation and training support team once the data warehouse went live.
Participated in code reviews and peer review sessions.

Environment
HP - UX, Datastage 8.1, Oracle, DB2, e-room (for documentation), Toad, Cronacle (Scheduling tool), Syncsort utilities, MS Visio, Rapid SQL.

Confidential,Chicago, IL May 2006 – Nov 2008
ETL Developer

This was a master data management project to support consumer goods marketing and Research Company’s data warehouse. Vendor, item and time dimensions were used to create data warehouse using daily feeds from legacy system and retailer chains i.e. Walgreens, Albertons, CVS, Caremark, Safeway etc.

· Involved in requirement gathering and legacy system analysis.
· Load analysis of the system to acquire optimal software licenses and hardware.
· Performing IBM information server 8.0 administration to manage user privileges, session management.

Worked with different stages Transformer, Aggregator, Pivot, Remove Duplicate, Data Set, Sort, Lookup, Merge etc. to do extract, transform and load.
Worked with Oracle and flat files as the sources.
Applied debugging techniques using Peak, Row generators, Column Generator operators.
Extensive work on datastage jobs’ performance tuning using combination of business and datastage knowledge to achieve optimal performance.
Created the technical specifications/unit test cases/ source-to-target mappings for each job. Involved in the creation of jobs using DataStage Designer.
Worked on code migration from Datastage v 7.5 to version 8.0.

Environment:
IBM Information Server Websphere Datastage v.7.5, 8.0, Linux, Oracle, SQL, MS Visio2003,

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship