Datamart Developer

**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.
- Write, debug, and optimize SQL and stored procedures.
- 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.