We are seeking a skilled DataMart Developer with expertise in Teradata to join our team. The ideal candidate will have a strong background in data modeling, CLDM, and Teradata development, including experience with stored procedures, macros, and views. You will play a crucial role in designing and developing data solutions that meet business needs.
Must-Have Qualifications:
- Proficiency in Teradata development (stored procedures, macros, views)
- Understanding of Communication Logical Data Model (CLDM)
- Expertise in relational and dimensional data modeling
- Strong SQL skills and debugging capabilities
- Familiarity with Singlestore, Hadoop, and TIBCO
Good-to-Have Qualifications:
- Basic knowledge of Ab Initio or other ETL tools
- Basic shell scripting skills
- Understanding of Apache Airflow
Responsibilities:
- Build Teradata stored procedures for data transfer and aggregation logic.
- Create or modify data models based on business requirements.
- Develop solutions using stored procedures, macros, and views.
- Apply relational and dimensional modeling techniques.
- Write, debug, and optimize SQL and stored procedures.
- Manage large datasets in Teradata and apply CLDM knowledge.
- Collaborate with Data Architects and Business Stakeholders.
- Document database designs and ensure best practices.
- Design fact and dimension tables for reporting.
- Maintain STTM documentation and update the Data Dictionary.
This role offers an exciting opportunity to work with cutting-edge data technologies and contribute to the development of crucial data solutions. The ideal candidate will have a strong foundation in Teradata and data modeling, with the ability to translate business requirements into effective technical solutions. Join our team to play a key role in managing and optimizing our data infrastructure.