Hi,
This is for my direct client opening for a *DataStage ETL Developer - Round Lake, IL*. This is a 2+ month’s contract position. The Hourly rate DOE. *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 *Specific Qualifications required (specialized skills, degrees, certification, etc.)* - 5+ years experience implementing ETL for Data Warehouse and Business intelligence solutions - Deep familiarity with Oracle database technologies (9i & 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 *Please complete the following skills-matrix and send back with your updated resume. ** * Full Name: Degree Major: Total exp as DataStage ETL Developer: Total exp in DataStage 8.x: Total exp in Oracle 9i: Total exp with Oracle 10g: Total exp with SQL: Total exp with PL/SQL: Total experience in DataStage Scheduler, UNIX Cron, and external scheduling tool: Total UNIX (Korn) Shell scripting experience: Total Perl development experience: Hourly Rate: Whether is it C2C/1099/W2? If 1099, specify the corporate name: Day Phone #: Evening Phone #: Cell Phone #: Availability: Current City/State: Work Status (US Citizen / Green Card / Others): Have you applied recently for this requirement earlier through anyone else? Y/N: Are you ready to relocate on your own expenses (Yes/No)? Yes Are you ready for Face to Face Interview on your own expenses?** *Note: If you have experience in all the skills than it should be show in projects as per skill matrix. Because I get feedback from the client, telling me the skill mentioned in the matrix is NOT FOUND in the resume..* * * *2 references required. These references should be US citizens and you reported directly or above their immediate management. All the references should have the details like: we will not contact your references before intimate you, but at the time of submission, we required 2 references with email id and contact number. * * * * * Name:** Title:** Email-id ** Tel#** Company name:** *Visa Status:* * * Name:** Title:** Email-id ** Tel#** Company name:** *Visa Status:* * * * * *Thanks & Regards……… * * * *Pramod Dubey* * * *BeyondTek IT - "Think Human. Think Technology. Think Beyond." * *Phone (*:* *714-857-2002* Extn: *801 *Fax* *7*: 714-364-9705 *E-mail ***: *[email protected] *Yahoo IM:* Pramod_Beyondtekit1 * * <http://www.beyondtekit.com/> <http://www.linkedin.com/in/pramodjohnmark> ** *Note:* We respect your Online Privacy. This is not an unsolicited mail.. This mail cannot be considered Spam as long as we include Contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with a "remove" to [email protected] <[email protected]>in the subject line and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SAP XApps Training/Jobs in Chennai/Bangalore -(0)9444359629" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sap-xapps -~----------~----~----~----~------~----~------~--~---
