ITB-TH-00012
BO/BOBJ Developer with SQL Assistant, PL/SQL, SQL Performance Tuning, Unix Shell Scripting, Teradata utilities and Public Assistance Eligibility & Benefit Determination Experience
Location:-Lansing, Michigan
Duration: 1 Year
Positions: 1
Description:
The Department of Technology, Management and Budget (DTMB) is requesting one (1) Data Warehouse Senior Developer to work with State IT and contract staff to help enhance the DHS Data Warehouse that are critical to the Department of Human Services.
Required:
•Data warehouse developers perform application development tasks in support of building business intelligence applications and integrating data warehouse resources into other DHS applications. In addition they provide database expertise to other application developers in close collaboration with DBAs and other data management staff. This may include tasks such as:
•Creating data warehouse based applications including reporting, dashboards and other information analysis and delivery systems.
•Extract, transform and load systems to move data from the various operational systems in which it is collected to a cleansed, consolidated data warehouse.
•SQL development.
•Work with data warehouse developers and end user query developers to design and improve database queries.
•Train other data warehouse developers in how best to design queries for a specific database.
•Data warehouse developers are also expected to be able to work with agency requestors to define and develop new queries, and provide training and technical support to both DTMB developers and end user query developers. These tasks may include:
•Working with end user requestors to understand their data needs and create and implement solutions to those needs.
•Develop and present training classes for end user developers to help learn how to most effectively use the data warehouse platform and the BI tools available to users to support their own data needs where possible.
•Develop and present training classes for DTMB developers to better understand how to use the BI development tools to create and implement reporting solution using the data warehouse.
•Provide one on one support for developers and end users to assist them in accomplishing their data reporting needs.
Preferred:
•5 Years Teradata Utilities Experience
•3 Years SQL Assistant Experience
•3 Years Unix Shell Scripting Experience
•2 Years Teradata Version 12 or 13 Experience
•4 Years PL/SQL Experience
•3 Years SQL and Performance Tuning Training
•Business Objects Report Development Experience
•Business Analyst experience
•Public Assistance Eligibility & Benefit Determination knowledge
No comments:
Post a Comment