Data Warehouse Analyst

Job Description:Hi,We have an urgent need for a Data Warehouse Analyst with one of our direct clients in NJ. Please reply back with your resume ASAP.Position: Data Warehouse AnalystLocation: Princeton, NJDuration: 6 M (Righ to Hire)Description:. Must have strong experience with installation and configuration of the IBM Data Stage ETL tool . Must have 3 -5 years working knowledge IBM Data Stage ETL tool . Full functional knowledge of Data Warehouse concepts, development, and design. Ability to develop and support data extracts, data transfers, and load jobs. Development and implementation of ETL solutions for legacy and new development. PL/SQL, Transact SQL a plus. Provides technical expertise to the development and implementation of solutions using basic dimensional modeling techniques. Make recommendations for improvements in these areas, if necessary.. 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 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 IS&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.Knowledge, Skills, and Abilities: . Must have extensive knowledge (3 -5 years working knowledge) with IBM Data Stage ETL experience.. Must strong experience with install and configuration of IBM Data Stage ETL tool . Must have extensive knowledge with IBM Data Quality experience. 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. Experience with Data Warehouse implementations and ETL skills. Autosys Job Scheduler. DMS Epress. MicroFocus 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. A plus to have broader IBM Quality Stage experience. A plus to have IBM WebSphere replication experience from DB2 to OracleThanks,Jatinder Singh |Technical Recruiting ManagerAjilon Consulting | Delaware Valley District Phone 412- 490- 7912Efax 610- 672- 9649 jatinder.chimni@ajilon.com www.ajilonconsulting.com You can view all of our jobs online at http://www.ajilonconsulting.com



Job Experience:Education: The candidate should have a Bachelor degree or Masters in Computer Science or 8 to 10 years of related experience in IT or a related field. The ideal candidate must have 5 years of applicable Data Warehouse experience.