Arete Technologies, Inc.
Data Warehouse Architect
Arete Technologies, Inc., Lansing, Michigan, United States, 48900
Arete Technologies, Inc. offers a set of innovative Consulting and Outsourcing services, bridging the gap between requirements and outputs of various dexterous and facile companies worldwide. The thrust of providing global deliverables with a focus on providing paramount and unsurpassed services combined with cost-saving solutions to the clients.
We understand the business requirements in the present-day corporate scenario and aspire to provide world-class services enabling the organization to burgeon and flourish while keeping the work-life balance intact. The Global delivery mechanism followed at Arete Technologies, Inc. saddles proficient schemas and unconventional channels to provide one-stop solutions for all your workforce needs.
Our team is an exquisite amalgamation of vast experiences of over 30 years in the IT Consulting and Staffing industry. Connoisseurs in the field of staff augmentation for IT, we operate on a 24 by 7 model with an aim of providing affordable and adept professionals with an assurance of satisfaction for both Consultants and Clients.
We are pre-eminent service providers in the field of staff augmentation, IT Consultancy, Software Development, and Web Development providing unexcelled services and focusing on both the employers and employees.Job Description
Description:
Designs, implements, and supports data warehousing in a Teradata database environment. The position has responsibility for database planning, development, administration, and maintenance/ETL of the MDARD data warehouse. Either
Webcam or In Person .Years of Experience:
5 or more years of Teradata physical modeling and indexing techniques.Responsibilities:Designs, implements, and supports data warehousing.Implements business rules via stored procedures, middleware, or other technologies.Defines user interfaces and functional specifications.Responsible for verifying the accuracy of data, and the maintenance and support of the data warehouse.Knowledge of data warehouse end-to-end implementation processes, from business requirement logical modeling, physical database design, ETL, end-user tools, database, SQL, and performance tuning.Demonstrated problem resolution skills with a team of persons, and strong leadership with the implementation team.Experience in data warehouse design and data modeling (both relational and dimensional) and development and maintenance of multi-dimensional data models.Development experience in the implementation of data warehousing utilizing RDBMS.Understanding of data warehouse Metadata concepts, tools, and different data warehouse methodologies.Expertise in SQL and proficiency in database tuning techniques.Responsible for the ongoing architecture and design of the data warehouse, data mart, and reporting environments.Develop strategies for flexibility and scalability, and define the future technical architecture direction for the business intelligence reporting physical environment.Responsible for proper selection of appropriate hardware, software, tools, and system lifecycle techniques for the different components of the end-to-end data warehouse architecture including ETL, metadata, data profiling software, database platform, performance monitoring, reporting, and analytic tools.Defining and documenting the technical architecture of the data warehouse, including the physical components and their functionality.Setting or enforcing standards and overall architecture for data warehouse systems.Monitoring the data warehousing industry and assisting in establishing the organization's data warehousing strategy and selection of strategic warehousing tools and techniques.Ensuring compatibility of the different components of the DW architecture and ensuring alignment with broader IT strategies and goals.Ability to educate the project teams on the standards and architecture of each component of the data warehouse architecture.Very strong written and oral communication skills, including some presentation skills.Skills Required:Teradata physical modeling and indexingETL tools - DatastageBI inquiry tools including Business Objects, BI-QueryAdditional Information
All your information will be kept confidential according to EEO guidelines.
#J-18808-Ljbffr
We understand the business requirements in the present-day corporate scenario and aspire to provide world-class services enabling the organization to burgeon and flourish while keeping the work-life balance intact. The Global delivery mechanism followed at Arete Technologies, Inc. saddles proficient schemas and unconventional channels to provide one-stop solutions for all your workforce needs.
Our team is an exquisite amalgamation of vast experiences of over 30 years in the IT Consulting and Staffing industry. Connoisseurs in the field of staff augmentation for IT, we operate on a 24 by 7 model with an aim of providing affordable and adept professionals with an assurance of satisfaction for both Consultants and Clients.
We are pre-eminent service providers in the field of staff augmentation, IT Consultancy, Software Development, and Web Development providing unexcelled services and focusing on both the employers and employees.Job Description
Description:
Designs, implements, and supports data warehousing in a Teradata database environment. The position has responsibility for database planning, development, administration, and maintenance/ETL of the MDARD data warehouse. Either
Webcam or In Person .Years of Experience:
5 or more years of Teradata physical modeling and indexing techniques.Responsibilities:Designs, implements, and supports data warehousing.Implements business rules via stored procedures, middleware, or other technologies.Defines user interfaces and functional specifications.Responsible for verifying the accuracy of data, and the maintenance and support of the data warehouse.Knowledge of data warehouse end-to-end implementation processes, from business requirement logical modeling, physical database design, ETL, end-user tools, database, SQL, and performance tuning.Demonstrated problem resolution skills with a team of persons, and strong leadership with the implementation team.Experience in data warehouse design and data modeling (both relational and dimensional) and development and maintenance of multi-dimensional data models.Development experience in the implementation of data warehousing utilizing RDBMS.Understanding of data warehouse Metadata concepts, tools, and different data warehouse methodologies.Expertise in SQL and proficiency in database tuning techniques.Responsible for the ongoing architecture and design of the data warehouse, data mart, and reporting environments.Develop strategies for flexibility and scalability, and define the future technical architecture direction for the business intelligence reporting physical environment.Responsible for proper selection of appropriate hardware, software, tools, and system lifecycle techniques for the different components of the end-to-end data warehouse architecture including ETL, metadata, data profiling software, database platform, performance monitoring, reporting, and analytic tools.Defining and documenting the technical architecture of the data warehouse, including the physical components and their functionality.Setting or enforcing standards and overall architecture for data warehouse systems.Monitoring the data warehousing industry and assisting in establishing the organization's data warehousing strategy and selection of strategic warehousing tools and techniques.Ensuring compatibility of the different components of the DW architecture and ensuring alignment with broader IT strategies and goals.Ability to educate the project teams on the standards and architecture of each component of the data warehouse architecture.Very strong written and oral communication skills, including some presentation skills.Skills Required:Teradata physical modeling and indexingETL tools - DatastageBI inquiry tools including Business Objects, BI-QueryAdditional Information
All your information will be kept confidential according to EEO guidelines.
#J-18808-Ljbffr