Teradata Architect
Lansing, MI
Contract
Required Skills
· Teradata physical modeling and indexing
· Teradata ETL development
· Teradata security
· Teradata SQL
Highly desired
· UNIX / Linux shell scripting
· Unix / Linux operating system
Nice to have
· ETL tools – Datastage
· BI inquiry tools including Business Objects, BI-Query
Designs, implements and supports data warehousing in a Teradata database environment. The position has responsibility for data base planning, development, administration and maintenance/ETL of the MDARD data warehouse.
Years of Experience:
5 or more years of Teradata physical modeling and indexing techniques.
Job Description:
· Relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, a wide degree of creativity and latitude is expected.
· 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 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, performance tuning. Demonstrated problem resolution skills with team of persons, and strong leadership with 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 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 section 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.
You received this message because you are subscribed to the Google Groups " c2c jobs usa" group.
To unsubscribe from this group and stop receiving emails from it, send an email to c2cjobsusa+unsubscribe@googlegroups.com.
To post to this group, send email to c2cjobsusa@googlegroups.com.
Visit this group at https://groups.google.com/group/c2cjobsusa.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment