What are the responsibilities and job description for the Data Warehouse Consultant position at DevCare Solutions?
Strong knowledge of database management systems, as well as data warehouse management and decision support tools
Extensive experience in the development, implementation and maintenance of data warehouses and data marts is desired
Experience in business objects and in building the data dictionary
Ability to use data base access tools for application delivery
Extremely high level of analytical ability where problems are very unusual and extremely difficult
Data Warehousing data population and data modeling techniques for target structures such as Star Schemas, Snowflake Schemas, and highly normalized data models
GUI based ETL tools such as Informatica, IBM WebSphere DataStage, or similar tools.
Implementation experience with enterprise class databases e.g. Teradata, Oracle, SQL Server, etc. or similar technologies.
Implementation experience with analytical and reporting tools e.g. Business Objects, Cognos, Hyperion, MicroStrategy or similar tools.
Experience with data warehouse implementation process, from business requirements through logical modeling, physical database design, data sourcing and data transformation, data loading, Structured Query Language (SQL), end-user tools, database and SQL.
Implementation experience with analytical and reporting tools e.g. Business Objects, Cognos, Hyperion, MicroStrategy or similar tools.
Excellent analytical; problem-solving; team playing; and oral and written communication skills.
Proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities.
Oracle Database experience
SSRS report creation
M204 database experience
Salary : $85 - $90