Hello Associates,

If you have the right person, we can get him/her interviewed next week and
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

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


The candidate filling this Data Warehouse Analyst/Developer-Senior position

   - Full functional knowledge of Data Warehouse concepts, development, and
   - Development of ETL solutions for legacy and new development
   - Provide business expertise for the development of Business Intelligence
   - 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
   - Development of ETL solutions for legacy and new development
   - Full functional knowledge of Data Warehouse concepts, development, and
   - 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
   - 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
   - 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


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

*: fa...@kolansoftinc.com

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.


You received this message because you are subscribed to the Google Groups 
"zilliontechnologies" group.
To post to this group, send email to zilliontechnologies@googlegroups.com
To unsubscribe from this group, send email to 
For more options, visit this group at 

Reply via email to