DataStage Developer Resume Atlanta, GA - Hire IT People

SUMMARY

Over 6 Years of ETL experience in development with Strong skills in Data Integration, Data Warehousing, and multiple Relational Database systems. Highly motivated, productive, and customer focused team player. Excellent communication, analytical, and problem solving skills.
Ability to grasp and apply new skills quickly and adapt readily to new challenges. I have demonstrated excellent leadership skills in handling offshore and delivered all requirements on time.
Experience with multiple ETL tools - DataStage with different versions like 11.3,11.5
Experience in converting Cobol code to data stage migration
Experience in C, C++, and SQL programming languages
Hands on experience on IBM DB2/Oracle/SQL Server
Experience in Control-M, Autosys and Robert scheduling tools
Experience working with Windows, UNIX, and Linux operating systems
Strong PC hardware assembly and troubleshooting skills, as well as computer network design, installation, and support, including Cisco router implementation
Working knowledge UNIX Shell scripting
Experience in working and creating incidents by using JIRA,CISM,HO Quality center
Expertise in Master data management and BPM.

TECHNICAL SKILLS

Data Warehouse (ETL) Tools: IBM Info sphere DataStage 11.3, 11.5 (Parallel Extender), COBOL

Languages: C, C++, SQL, Java

RDBMS: DB2, Oracle 10g/11g, Teradata, MS SQL Server, DB2

Scheduling Tools: Robot Scheduler, AutoSys, Control-M

Operating Systems: Windows, UNIX, Linux

Bug Tracking Tool: JIRA, CISM, HP Quality center

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

DataStage Developer

Responsibilities:

Build DataStage jobs to read files from multiple sources using Complex Flat File and Sequential File stages and different operational DB's.
Developed and maintained accurate project documentation and worked with DA’s to get data model from Erwin tool.
Analyze users’ needs and then design, develop test and develop software to meet those needs
Prepared technical data flow proposals for enhancements and integration of existing code in production.
Create a variety of models and diagrams (such as flowcharts) to Understand overview and flow of the project code needed for an application.
Worked with ITSME’s to understand requirement and prepared the Designed mapping document
Converted code from COBOL to Data Stage.
Coordinating the offshore team through the project to create accurate project.
Created ETL DataStage parallel jobs to extract and reformat and loaded in DWH.
Worked in an environment with many other application dependencies like sending FTP flag files to trigger the jobs like cognos cubes, mainframe dependent jobs.
Analyzing and fixing the code as part of SIT and UAT.
Written UNIX shell scripts to retrieve data from various databases and file move scripts.
Used different types of DB connector stages like DB2, ODBC.
Used different File stages like XML, Sequential files, Data sets and unstructured stages.
Developed complex SQL’s in Data studio to retrieve the data from DWH.
Design and development of common jobs to update Batch Status, Control, File Info, App Parameter tables.
Developed Scheduling jobs in CTRL-M scheduler, which invoked from Data stage jobs.
Ensure that a program continues to function normally through software maintenance and testing.
Document every aspect of an application or system as a reference for future maintenance and upgrades.

Environment: IBM DataStage 11.5, Cobol (Designer, Manager, Director) Windows, Linux, Oracle11g/10g, DB2, Teradata, SQL, CTRL-M, Data studio, Jira, CISM

Confidential, Eagan, MN

DataStage Developer

Responsibilities:

Build DataStage jobs to read files from multiple vendors using Complex Flat File and Sequential File stages and different operational DB's
Perform reconciliation of the data by matching Row counts and Hash Totals
Cleanse and transform the data as per business logic
Design Unit Test Cases
Migrated data from DB2 to Teradata
Write Unix shell scripts to retrieve data from various databases
Work with various stages of parallel extender like sequential file and merge stage and Aggregator, Row Generator, Datasets, Lookup, Transformer and many more to design the job and load data into fact and dimension tables.
Load data into DB2 tables using DB2 connector stage
Create parallel and server Routines functions
Analyzing and fixing the code as part of SIT and UAT
Creating the data Stage parallel job to extract data from various sources and operation mainframe database, UDB database like ODBC, SQLserver and load it into target data warehouse like DB2, Oracle
Design and development of common jobs to update Batch Status, Control, File Info, App Parameter tables
Involved in moving DataStage code from development to Test and Production environment through TSV Subversion tool
Developed Scheduling jobs in Robert schedular which invoked from Data stage jobs and ini files

Environment: DataStage 11.3 (Designer, Manager, Director) Windows UNIX, Oracle11g/10g, DB2, Teradata, SQL, Robot Scheduler, C++ Subroutines, HP Quality center

We provide IT Staff Augmentation Services!

Datastage Developer Resume

Atlanta, GA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship