Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
ETL Datastage Developer
(Jobs in Round Lake, IL)
 
Requirement id 4741
Job title Developer
Job location in Round Lake, IL
Skills required ETL, Data Stage, PL/SQL,
Open Date 08-Jun-2011
Close Date
Job type Not specified
Duration 8 Months
Compensation DOE
Status requirement ---
Job interview type Phone Screen and Face to Face interview
   Email Recruiter: coolsoft
Job Description Developer: ETL, Data Stage, PL/SQL,

[Note : Duration: Through 02/2012]

Experience
• 5+ years experience implementing ETL for Data Warehouse and Business intelligence solutions
• 10 year experience in RDBMS design and development, and performance tuning
• Deep familiarity with Oracle database technologies (9i, 10g, 11g)
• 5+ years with DataStage server / parallel addition, 2 years experience with DataStage 8.x and Orchestrate 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

Qualifications
The Individual must demonstrate broad and deep knowledge of ETL development in a dimensional database environment while using the Datastage 8.x (parallel edition) toolset.
The following development skills are critical to ensure a successful engagement:
• Ability to read and write effective, modular, dynamic and robust code, establish and follow already established code standards, and ETL framework
• Ability to work with Change Data Capture, Slowly Changing Dimension Type 2, Surrogate Key Generator, Aggregator, Merge, Sort, Join, Lookup, Transformer, Filter, Shared Container and other 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.
• Ability to capture and research DataStage issues and bugs, build sample test jobs that recreate a bug, provide sample job and supplemental information to the vendor and work with IBM until successful resolution.
• Understanding of the 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 and from the Scheduling tool locally or remotely
• Ability to design jobs that can be easily promoted from one (Dev) environment to another (Test or Prod) seamlessly, without rewriting jobs.
• Ability to create unit, integration and system ETL test cases
• Clear understanding of Datastage and ETL best practices within an Oracle environment
• DataStage error handling, error propagation and email notification
• Ability to read, write and tune Oracle and ANSI SQL code
• Ability to read, write and tune Oracle PL/SQL code
• Ability to read, write and support custom UNIX shell scripts that supplement and enrich ETL toolset, and enable ETL and Scheduling tools integration
Other qualifications
• Strong analytical and problem solving skills
• Effective communication skills
• Ability to work independently and as part of a team
Responsibilities include, but not limited to:

• Design of DataStage jobs, job sequences, containers and re usable components to implement specified business requirements
• Creation of technical specifications documents and design process diagrams
• Develop functional specifications for data acquisition, transformation and load processes
• Develop UNIX shell scripts for data file processing and process integration tasks.
• Define job parameters, reference lookups, filter criteria
• Use Oracle, ODBC, SORT, JOIN, MERGE, FILTER, FUNNEL, MODIFY and other stages.
• Schedule jobs through UNIX shell scripts in UNIX CRON utility
• Conduct code reviews and participate in technical design
• Conduct performance analysis and optimize Data stage/Orchestrate jobs
• Conduct performance analysis and tuning
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 4741 while calling.
 
Other jobs in IL: Chicago (77), Deerfield (7), Des Plaines (2), Downers Grove (7), Downtown Chicago (5), DT Chicago (2), Elk Grove (3), Elk Grove Village (24), Elkgrove Village (1), Evanston (1), Lake Forest (1), Lincolnshire (4), Northbrook (3), Oak Brook (5), Oakbrook (1), Oakbrook Terrace (5), Round Lake (3), Schaumburg (4), South Barrington (1), Springfield (2), Vernon Hills (6), Warrenville (7),
 
 ETL job openings in other states
Jobs List

Data Warehouse Developer III -129720
Create date: 24-Apr-2024
No of Submissions : 2

Start date : 06/03/2024

End Date : 06/30/2024

Submission deadline : 5/1/2024 at 4:00PM CST.

Client Info : ETF

Note :

* Interview Process: 1-2 rounds via Microsoft Teams.

* Duration: 6/30/2024, likely to extend.

* Onsite or Remote? No.... (This job is for - ETL Jobs in WI Madison Developer - (in Madison, WI))

Data Warehouse Developer III - 128748
Create date: 28-Mar-2024
Start date : 05/20/2024

End date : 06/30/2024

Submission deadline : 4/4/2024 at 4:00PM CST.

Client info : ETF

Note :

* Interview Process: 1-2 rounds via Microsoft Teams.

* Duration: 6/30/2024, likely to extend.

* Onsite or Remote? No WI residency required. Open to n.... (This job is for - ETL CDC Jobs in WI Madison Developer - (in Madison, WI))

Data Warehouse Architect 3 - 128536
Create date: 27-Mar-2024
Start date : 04/22/2024

End Date : 09/30/2024

Submission deadline : 4/1/2024 at 10am EST.

Client Info : DHHS

Note :

* Interview Process: Virtual Interview via MS Teams video. Please use laptop and be prepared so share screen if asked. Use of headphones is strongly discouraged. A screensho.... (This job is for - ETL Jobs in MI Lansing Architect - (in Lansing, MI))

Data Warehouse Developer III -128359
Create date: 18-Mar-2024
Start date : 04/08/2024

End Date : 06/30/2024

Submission deadline : 3/20/2024 at 4:00PM CST.

Client Info : ETF

Note :

* Interview Process: 1-2 rounds via Microsoft Teams.
* Duration: 6/30/2024, likely to extend.
* Onsite or Remote? Candidates MUST be WI residents or willing to r.... (This job is for - ETL Alteryx Jobs in WI Madison Developer - (in Madison, WI))

Data Warehouse Developer III - 128031
Create date: 07-Mar-2024
Start date : 04/22/2024

End date : 06/30/2024

Submission deadline : 3/14/2024 at 4:00PM CST.

Client info : ETF

Note :

* Interview Process: 1-2 rounds via Microsoft Teams.

* Duration: 6/30/2024, likely to extend.

* Onsite or Remote? Candidates MUST be WI residents or .... (This job is for - ETL CDC Jobs in WI Madison Developer - (in Madison, WI))
 
 ETL job openings in IL
Jobs List

Data Engineer 2
Create date: 26-Mar-2021
Description:

Must have skills:

2 years experience in ETL and data manipulation

1-2 years experience using advanced SQL/Snowflake or other relational database design, data modeling, and structured query language.

1-2 years experience in using python.

Candidate Responsibilities:
.... (This job is for - ETLSnowflake Jobs in IL Chicago Engineer - (in Chicago, IL))

Pentaho ETL Developer - 70629
Create date: 06-Jan-2021
Candidate must be our W2 Employee.

Job Description:

Pentaho ETL Developer - Database Consultant

Long Term Contract

Enterprise Ecommerce Client

Chicago, IL Based -- WFH/Remote in 2021

Pentaho ETL Senior Developer. (60%) – Design and develop code in Pentaho ETL, performance & run t.... (This job is for - ETL GIT Jobs in IL Chicago Developer - (in Chicago, IL))

Software Engineer - 65616
Create date: 05-Aug-2020
Candidate must be our W2 Employee.

Job Description :

Responsible for analysis, design, and development within our Actimize Suite of applications including CDD, KYC, AIS, SAM, and UDM. This role requires experience in implementing Fraud and Actimize solutions. Must have strong Java, ETL, and SQL skills, and will be responsible .... (This job is for - Java ETL Jobs in IL Chicago Engineer - (in Chicago, IL))

Angular Developer - 60428
Create date: 02-Mar-2020
Job Description :


Technical Skills

*Required:

6+ years application development experience
4+ years application development utilizing Javascript experience using Ajax, Angular, Polymer and proficient in HTML/XHTML, XML, and CSS
Experience with NX
Experience with CDD
Exper.... (This job is for - ETLCSS Jobs in IL Peoria Developer - (in Peoria, IL))

HRIS Systems Analyst - 51149
Create date: 13-Aug-2019
Candidate must be our W2 Employee

Description:

Required

Experience with SAP, especially Success Factors
Experience with ETL and other integration patterns (i.e. file transfers, web services, batch jobs, etc
Basic IT skills like SQL, Office, Visio, etc…
This person will need to be able .... (This job is for - ETLMS Office Jobs in IL Deerfield Analyst - (in Deerfield, IL))
(Developer: ETL, Data Stage, PL/SQL, in Round Lake, IL)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us