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 Business Intel Technical Lead II -134854 Create date: 17-Sep-2024 Bid Limit Per Vendor : 2 Start date : 10/14/2024 End Date : 06/30/2025 Submission deadline : 9/23/2024 at 4:00PM CST. Client Info : DOT Note : * Interview Process: Teams interview with Camera On * Duration: 6/30/25 with possible extensions * Remote or On-site? Candida.... (This job is for - ETL Jobs in WI Madison TechLead - (in Madison, WI)) NCDPI - SQL/Snowflake - Tableau Developer - Expert (746387) Create date: 09-Sep-2024 No of Submissions : 1 Start date : 09/23/2024 End Date : 03/21/2025 Submission deadline : 09/13/2024 Client Info : Note: * Agency Interview Type : In Person Only * Onsite Description : ***This is an onsite position in Raleigh, NC. Current.... (This job is for - ETL Jobs in NC Raleigh Developer - (in Raleigh, NC)) Data Warehouse Developer III -134848 Create date: 09-Sep-2024 Bid Limit Per Vendor : 1 Start date : 09/23/2024 End Date : 06/30/2025 Submission deadline : 9/11/2024 at 4:00PM CST. Client Info : ETF Note : * Interview Process: 1 round via Microsoft Teams. * Duration: 6/30/2025, likely to extend. * Onsite or Remote? No WI reside.... (This job is for - ETL Implementation Testing Jobs in WI Madison Developer - (in Madison, WI)) Data Warehouse Developer III -134705 Create date: 04-Sep-2024 Bid Limit Per Vendor : 1 Start date : 09/23/2024 End Date : 06/30/2025 Submission deadline : 9/6/2024 at 4:00PM CST. Client Info : ETF Note : * Interview Process: 1 round via Microsoft Teams. * Duration: 6/30/2025, likely to extend. * Onsite or Remote? Candidate MU.... (This job is for - ETLDataloader Jobs in WI Madison Developer - (in Madison, WI)) RHAPSODY DEVELOPER-Consultant - 11216-1 Create date: 28-May-2024 No of submissions : 2 Start date : 6/17/2024 Submission deadline : 6/4/2024 Client info : Health & Environmental Control Department (DHEC) Note : * INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? - An interview panel will conduct one initial.... (This job is for - T SQL ETL Sql Server 2000 Jobs in SC COLUMBIA Developer - (in Columbia, SC))    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)

Featured Jobs Troubleshooting Engineer (Jobs in Des Moines, Iowa) Application Developer (Jobs in Richmond, Virginia) Business Analyst Business Analyst (Jobs in Richmond, Virginia) Consultant (Jobs in Murfreesboro, Tennessee) TFS Automation Analyst (Jobs in Dimondale, Michigan) Cloud Architect (Jobs in Lansing, Michigan) GitHub Consultant (Jobs in Lansing, Michigan) IT Developer (Jobs in Atlanta, Georgia) Microsoft Consultant (Jobs in ANDERSON, South Carolina) Business Analyst JAD SQL Analyst (Jobs in Lansing, Michigan)