Home  Post Resume Quick IT Job Search  Advanced IT Job Search 
Skip Navigation LinksHome » Job Details
Radiant Global Inc
  Company Profile

 
  Job Details 
Title: 

DataStage ETL Developer : UNIX cron, DataStage server, ETL : Round Lake, IL

Posted On:  11/24/2016 10:28:30 PM
Designation: 

DataStage ETL Developer

Qualifications:  BS in Computer Science
Essential Skills: 
SkillsSpecializationYears
UNIX-2
Linux-2
ETL-2
Data Warehouse-2
SQL-2
Job Tenure:  Full-time Only
Salary Offered:  DOE
Job Location:  Round Lake IL United States

  Job Description
Job Description:

* 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 and 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

Specific Qualifications Required:

* 5+ years experience implementing ETL for Data Warehouse and
Business intelligence solutions

* Deep familiarity with Oracle database technologies (9i and 10g)

* 3+ years with DataStage server / parallel addition (DataStage 8.x
required)

* 5 years experience with scheduling ETL jobs using DataStage
Scheduler, UNIX cron, and external scheduling tool

* UNIX (Korn) Shell scripting and Perl development skills strongly
preferred

Other qualifications

* Strong analytical and problem solving skills
* Effective communication skills
* Ability to work independently and as part of a team.

  Contact Information
Reference Name (If Any): 





 
Terms and Conditions | Privacy Policy | FAQ | Contact Us | Why?? | Link to us