DataStage Developer Resume Bentonville, AR - Hire IT People

SUMMARY:

Detailed oriented Programmer/Analyst with excellent skills in application development, support and customer business needs.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE

Confidential, Bentonville, AR

DataStage Developer

Responsibilities:

Designing, Developing, Documenting, Testing of ETL jobs and mappings in Parallel jobs using DataStage to populate tables in Data Warehouse.
Developing strategies for Extraction, Transformation, and Loading (ETL) mechanism.
Designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XML.
Integrate various data sources (DB2-UDB, SQL Server, PL/SQL, Oracle, Teradata, XML and MS-Access) into data staging area.
Using Unix commands to change file permissions, copy files, archive files, create shell scripts to sftp files, using Sed command to modify files, and using Regular Expressions.
Using Linux shell scripting to scheduled DataStage jobs and set up the necessary environments
Troubleshooting of Data Stage jobs and addressing production issues like performance tuning and enhancement.
Loading data from Oracle system to Greenplum and Hadoop data warehouse environment.
Design DataStage jobs from the business requirements
Perform unit testing, validated the result of the DataStage jobs against the result of SQL query in the database, also make sure the results are according to the business requirements.
Monitoring and debugging jobs using director.
Create CA7 Scheduling jobs on the mainframe which triggers the DataStage jobs on the Unix box.

Environment: Unix, .Net, Java, Javascript, and AngularJS

Develops and Supports Information System Division (ISD) applications by:
Conducting application analysis and design for end users by reviewing business processes
Coding instructions into programming languages and test and debug programs to get intended results
Researching potential solutions and make recommendations to meet business partners objectives
Design and code menu screens and questioners screen which let the user response to legal questions, also, make sure that the user interface (UI) is compatible with the standard user experience (UX) of the company.
Documenting program specifications and detailed checklists for change control implementations

Confidential, Greenville, SC

Programmer/Analyst

Responsibilities:

Upgraded Confidential package to be Y2K compliance on the HP3000 using Cobol
Maintain the package on the HP3000 using Cobol as needed
Design, code, test and debug existing systems using Speedware development tools on the HP9000 and windows/NT
Supported migration to Visual Speedware and Visual Basic
Converted PowerHouse application to be Y2K compliance
Modified the dictionary using PDL to account for the four digits year
Modified reports using Quiz to display the four digits year