Sr. DataStage Developer Resume Charlotte, NC - Hire IT People

SUMMARY

13 + years of experience in IT as an application developer.
With experience in the total life cycle of Software Development Applications involving Requirements, Analysis Design, Development, Testing
7 + years experience in Data warehousing, ETL Process, methodology and data mart design
7+ years experience in ETL using Ascential DataStage/IBM Infosphere Datastage and Production Support.

TECHNICAL SKILLS

ETL Tools: AscentialDataStage8.5/8.01/7.x/6.0/5.x,XE/390,Orchestrate

BI Tools (DSS): Microstrategy 7i, Business Objects 6.0, Cognos

Reports: Oracle Reports Builder 6i, PL/SQL

Data Modeling: ERWIN 3.5/4.0/4.1.4

Databases: Oracle 11g/10g/9i/8i /7.x, SQL Server 7.0 / 6.5, MS Access, Teradata, IBM DB2

Languages: C, SQL, PL/SQL, UNIX Shell scripts, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. DataStage Developer

Responsibilities:

Review functional requirements and technical specifications and document them as needed
Assist on support and enhancements modules
Develop ETL jobs for Daily and Monthly loads
Schedule the jobs in Autosys
Unit testing, integration testing and UAT

Environment: IBM Infosphere Datastage v8.1, 9.1, 11.3 (DataStage and QualityStage Designer, Director, Administrator), Oracle 11g/Teradata 15.0, Unix Solaris and Linux 2.6.18, Autosys, TortoiseS VN v1.7.10, Toad for Oracle 11.6

Confidential, Charlotte, NC

Sr. DataStage Developer

Responsibilities:

Participated in requirement gathering meetings to define high level business requirements for the project.
Involved in migration of jobs from Datastage 7.5.2 to 8.7

Environment: IBM Infosphere Datastage v8.7 (DataStage and QualityStage Designer, Director, Administrator), Ascential Datastage v7.5.2,Oracle 11g/Exadata, Red hat Linux 2.6.18, Control - M v7.0.0, TortoiseSVN v1.7.10, PVCS Version Manager v8.4, Rumba v8.1,Rumba FTP Client v4.2.4

Confidential, Blythewood, SC

Sr. DataStage Developer

Responsibilities:

Involved the Data Warehouse design, data mapping.
Participated in the new product installation of websphere datastage 8.1

Environment: Datastage8.1/8.5, Oracle9i, Oracle10g/11g, Flat files, ETL- DataStage(IBM Information Server) 8.1, Autosys, Unix Shell Script(Linux, AIX), Win XP, Lotus Notes, ClearCase, ERWIN 4.x, TOAD

Confidential

Responsibilities:

Designed and developed the datastage jobs with many stages to Extract, Transfom and load the data into target database
Extensive;y used Datastage Designer, Administrator and Director for creating jobs, export/imports and scheduling jobs

Environment: DB2 9X, FTP, Flat files, ETL- DataStage(IBM Information Server) 8.1, IBM AIX 5.X, Unix Shell Script, Win XP, Lotus Notes, Erwin 4.x, Serena dimensions, JIRA, Tivoli, Toad, and MS Office Products

Confidential, Wilmington DE

Datastage Developer

Responsibilities:

Installed, Configured Datastage on both UNIX and Windows environments.
Administered Dagtastage- created new projects, users, roles and responsibilities.
Administered and Configured datastage files,libraries fine tune datastage jobs.

Environment: IBM Web sphere DataStage Server Edition 7.5, Datastage Designer, Datastage Manager, Datastage Director, Datastage version control, UNIX SUN, LINUX,Oracle 10g, DB2,UDB, COGNOS,TOAD and ERWIN.

Confidential, McLean VA

Responsibilities:

Worked with Ascential DataStage Designer to develop jobs for Extracting, Transforming and Loading the data into Target database DB2
Unit testing the jobs designed and co-operate with UAT.

Environment: DataStage Parallel Extender 7.5, Datastage Designer, Datastage Manager, Datastage Director, Server 7.1, UNIX AIX 5.0, DB2 7.2, Rapid SQL 7.3.0, Exceed, Lotus Notes 6.5, Orchestrate IBM DB2 Command center ( db2cctr), Rational ClearCase, Rational ClearQuest 2002.05.20

Confidential, Newark, DE

Responsibilities:

Developed ETL jobs for loading data into Oracle Tables at each area
Developed data mappings between operational sources to Operational target tables
Extracted the data from several sources such as Oracle, HL7, sequential files
Designed ETL for hash file stages to load data into Oracle tables

Environment: Ascential DataStage 7.1, Oracle 9i,Erwin DataModeler 4.1.4, Windows NT 4.0,Sun Solari8 UNIX, Microstrategy 7.2/7i, WINRUNNER 6.0

Confidential, Denver, CO

Oracle Developer

Responsibilities:

Created detailed project outlines, application design specifications, and test plans
Involved in the Creating, Designing and Documentation of the Data Warehouse
Modified, maintained and developed the SQL codes to develop new enhancements
Develop and maintain the documentation to support the team and business

Environment: Oracle9i/8i,SQL Plus, Trillium Software Data Analyst, TOAD, DB2, Business objects, SQL * Loader, HP-Unix and Windows 2000.

Confidential, Indianapolis, Indiana

Oracle Developer

Responsibilities:

Developed Oracle forms and assigned the properties and coded SQL
Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN

Environment:, Oracle8.1.6, DB2, SQL Plus, SQL Server 7, SQL*Loader, TOAD, WinRunner, UNIX, Windows NT4.0.ERWIN

We provide IT Staff Augmentation Services!

Sr. Datastage Developer Resume

Charlotte, NC

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship