Job Title: Lead Data Warehouse Programmer/Analyst
Duration: 6 month Right to Hire
Max Pay Rate: $65/hr (W2)
Location: Princeton, NJ
Job ID: 716
The Lead Data Warehouse Programmer/Analyst provides technical expertise to the development and implementation of solutions using basic dimensional modeling techniques. The incumbent provides business expertise of the development of Business Intelligence solutions, technical support for existing Data warehouse ETL processes and makes recommendations for improvements in these areas, if necessary. Responsibilities The ideal candidates will be responsible for: - Develop home grown ETL applications using Oracle PL/SQL for new project contract.
- Full functional knowledge of Data Warehouse concepts, development, and design
- Provides technical expertise to the development and implementation of solutions using basic dimensional modeling techniques. Make recommendations for improvements in these areas, if necessary.
- Ability to develop and support data extracts, data transfers, and load jobs
- Development of ETL solutions for legacy and new development
- Provide business expertise for the development of Business Intelligence solutions.
- 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 when required.
- Follows DMS related standards and procedures, knows where they are located, and incorporates them. Follows Corporate 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 IT corporate purpose and mission to add business value, increase revenue, decrease costs, improve productivity, and support the strategic initiative/directive.
- Complies with all Corporate security and audit standards.
- Manages the work of Corporate vendors to achieve quality results at a market based price using IT policies and procedures.
- Transact SQL a plus
Experience, Knowledge, Skills, and Abilities Experience:The ideal candidate must have knowledge in Oracle database programming skills with Oracle and PL/SQL with 8 – 10 years of experience in IT or a related field. The candidate must have 5+ years of applicable Data Warehouse experience and Oracle programming tools. Knowledge, Skills, and Abilities: - Must have extensive knowledge in Oracle database programming skills with Oracle and PL/SQL
- Must have extensive technical skills in Linux environment
- Strong knowledge of Linux shell scripting
- Must have experience with Data Warehouse implementations and ETL skills
- Autosys Job Scheduler
- Linux Sync sort
- MicroFocus Cobol preferred
- 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
- Microsoft SSIS knowledge a plus
Education A Bachelors degree with extensive coursework in Computer Science or an equivalent combination of education and experience from which comparable knowledge and abilities can be acquired is necessary.
Sincerely,
Autumn Ortenzi
Advanced Technology Solutions, Inc. 802 W. Park Ave. Suite 223 Ocean, NJ 07712
P: 732.918.4664 x18
F: 732.918.4666
MIS Ntwk Assoc Mtg Dates:
Jan 31 Tues Dinner Mtg - Totowa - Managing The First Impression - Linda Trignano
Feb 7 No Mtg - Tech expo Giants Stadium
Feb 14th - Tues Reg Mtg - 6 pm - Berman Larson Kane Offices, Paramus - DO NOT use GPS for directions - Get dir from BLK site - Bring 15 copies of your resume |
No comments:
Post a Comment