Hello Associates,
If you have the right person, we can get him/her interviewed next week and placed. Location: Princeton, NJ Length: 6+ months Data warehouse Developer *Please see below for details, but our client is extracting data from a mainframe system to a data warehouse. Instead of using data warehouse tools (informatica, DataStage, Ab Initio, etc.) they are using PL/SQL to prepare the data for migration. So these are the skills they are looking for:* * ** *Very strong *PL/SQL skills (9.5/10*) *Data warehouse* development experience *UNIX Shell Scripting Linux COBOL/JCL* *Hiring manager is requesting advanced Oracle PL/SQL and UNIX Scripting. In addition they moving to LINUX scripting and are now requiring that potential candidates know both.* *6mo Senior Data Warehouse Analyst/Developer *The Data Management Services (DMS) group needs to fill a 6 month Senior Data Warehouse Analyst/Developer position. The candidate with the necessary knowledge, skills and abilities will need to start as soon as possible. *Work Summary* The candidate filling this Data Warehouse Analyst-Senior position will be responsible for the full functional knowledge of the Data Warehouse concepts, development, and design. The candidate will recommend solutions, test solutions, gain acceptance for solutions, and negotiate/coordinate across multiple organizations for timely and cost effective deployment of Business Intelligence applications. The candidate must possess technical skills, architecture/infrastructure skills, and project management/coordination skills. *Responsibilities:* The candidate filling this Data Warehouse Analyst/Developer-Senior position will: - Full functional knowledge of Data Warehouse concepts, development, and design - Development of ETL solutions for legacy and new development - Provide business expertise for the development of Business Intelligence solutions. - Provides technical expertise to the development and implementation of solutions using basic dimensional modeling techniques. Make recommendations for improvements in these areas, if necessary. - Provides technical support for existing Data Warehouse ETL processes. - Assures quality of design and implementation of projects. - Trouble-shoots application software/hardware problems as they apply to design, implementation, or installation activities. - Schedules and coordinates application maintenance activities. - Participates in on-call, overnight off-hour production problem resolution activities. - Follows DMS related standards and procedures, knows where they are located, and incorporates them. Follows ETS software development processes. - Researches, evaluates, and tests new software and DW related tools and facilities as they pertain to the existing DW environment and applications. - Monitors current DW applications and develops procedures, where necessary, to improve the DW environment as required. - Identifies and supports quality improvement initiatives. - Performs other assignments to comply with the SR&T corporate purpose and mission to add business value, increase revenue, decrease costs, improve productivity, and support the strategic initiative/directive. - Complies with all ETS security and audit standards. - Manages the work of ETS vendors to achieve quality results at a market based price using ETS SR&T policies and procedures. * Experience, Knowledge, Skills, and Abilities* *Experience:* The ideal candidate must have: - 8-10 years of experience in computer science or information technology - Minimum 5 years of applicable Data Warehouse experience - *Prefer 5 years advanced Oracle/SQL experience* - Full functional knowledge of Data Warehouse concepts, development, and design - Development of ETL solutions for legacy and new development - Full functional knowledge of Data Warehouse concepts, development, and design - Development of ETL solutions for legacy and new development - Good interpersonal skills in order to interact with clients, technical staff, and third parties. - Good oral and written communication skills with strong attention to detail. - Demonstrated ability to work independently and as a member of a team - Ability to document and resolve issues and risks with stakeholders *Knowledge, Skills, and Abilities: * - Must have extensive knowledge in *Oracle database programming* skills with *Oracle and PL/SQL.* - Must have extensive knowledge in advanced *Oracle PL/SQL* to maintain existing processes and create new ETL processes. - Must have extensive Oracle knowledge for performance tuning. - Must have extensive technical skills in Unix and Linux environment - *Strong knowledge of UNIX/LINUX shell scripting* - Strongly prefer *IBM Data Quality* experience - Prefer experience in *IBM Replication Server * - Experience with Data Warehouse implementations and ETL skills - *Autosys Job Scheduler * - Sync Sort for *UNIX/LINUX* - Micro Focus Cobol - IBM *Mainframe JCL/COBOL* - Follow Change Control concepts and policies - Ability to work with offsite Vendor Technical Support for problem resolution - Ability to express complex technical concepts effectively, both verbally and in writing - Ability to work well with people from many different disciplines with varying degrees of technical expertise *Education:* The candidate should have a Bachelor's degree or Masters in Computer Science, with coursework in the information processing or business-related curricula, or an equivalent combination of education and experience from which comparable knowledge and abilities can be acquired is necessary. Thanks & Regards, Fazal Mahmood I Technical Recruiter Kolansoft, INC (: 201-484-0340 Fax 7:201-656-6696 *: [email protected] Yahoo IMJ: fazal_kolansoft Website: http://www.kolansoft.net *************************************************************************************************************************************** If you are not interested in receiving our e-mails then please reply with a "REMOVE" 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. I am sorry for the inconvenience caused to you. ***************************************************************************************************************************************
