• Address: Waukegan, IL 60079 (map)
• Date Posted: 10/31/09
• Job Type: Full-time

Company Teksystems
Position TitleSr. Datastage Developer
Job Code1994315
Job Location Waukegan, Illinois
DescriptionSr. Datastage Developer Job Description:

Role Needed / Job Description (Please provide sufficient detail as what this consultant is to produce from a work product or Service expectation from a response time if appropriate)




DataStage ETL Developer




Please ensure that candidate has DataStage 8.x experience, and working knowledge of Oracle database (SQL, PL/SQL).


Ability to read and write effective, modular, dynamic and robust code, establish and follow already established code standards, experience with Change Data Capture, Slowly Changing Dimension Type 2, Surrogate Key Generator, Aggregator, Merge, Sort, Join, Lookup, Transformer, Filter, Shared Container Stages, utilization of Datasets, Parameter files and Parameter sets.


Excellent troubleshooting & optimization skills: interpreting DataStage log files, SQL / Data validation, dissecting DataStage code at the UNIX OS level, understanding the benefits of parallelism, drawbacks and appropriateness of using the multi-node vs. single node processing; ability to understand and optimize the surrogate key generator behavior, date range and inconsistent data types handling.


Understanding of DataStage abilities and limitations from a scheduling perspective: DataStage jobs vs. sequences, UNIX Cron and UNIX Shell scripting and ability to select the most optimal scheduling solution; ability to call DataStage jobs from the command line


Ability to design jobs that can be easily promoted from one (Dev) environment to another (Test or Prod) seamlessly, without rewriting jobs.


Clear understanding of DataStage and ETL best practices within an Oracle environment


DataStage error handling, error propagation and email notification



Required Skills for Sr. Datastage Developer Job:

*DATASTAGE 8.X
* PARALLEL EXT
* PX
* PL/SQL
* ORACLE 10G


About TEKsystems:

Join TEKsystems® and get your career on the fast track. As the leading technology staffing and services firm, we are passionate about deploying high-caliber IT and communications expertise. To satisfy our constant need for expertise, we actively seek talented Technical Professionals with all levels of information technology and communications skills. TEKsystems knows that every professional has different needs, so we'll work together to determine a suitable benefits package. We offer options to our Technical Professionals that could include: a health plan, 401k, provisions for vacation and holiday pay, and technical and professional training. With a foundation as the nation's largest IT staffing firm, we've become a billion-dollar services company by blending superior client service with an unrivaled ability to source and manage talent to precise specifications, resulting in successful technology executions. Allegis Group and its subsidiaries are equal opportunity employers. M/F/D/V


Contact Information

Erik Jason Fisher Apply Now! Begin by filling out the "Apply Online for this Job" section at the top of the page Need Directions? Get office driving directions with Google Maps efisher@teksystems.com TEKsystems - Schaumburg, IL 1933 N. Meacham Road

Suite 100

Schaumburg, IL 60173 TEL: (847) 221-1444