DataMart Developer (Teradata)

Master-Works is a company seeking a skilled DataMart Developer with expertise in Teradata to join their team.
Data
Mid-Level Software Engineer
In-Person
Enterprise SaaS

Description For DataMart Developer (Teradata)

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:

  1. Build Teradata stored procedures for data transfer and aggregation logic.
  2. Create or modify data models based on business requirements.
  3. Develop solutions using stored procedures, macros, and views.
  4. Apply relational and dimensional modeling techniques.
  5. Write, debug, and optimize SQL and stored procedures.
  6. Manage large datasets in Teradata and apply CLDM knowledge.
  7. Collaborate with Data Architects and Business Stakeholders.
  8. Document database designs and ensure best practices.
  9. Design fact and dimension tables for reporting.
  10. 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.

Last updated 5 days ago

Responsibilities For DataMart Developer (Teradata)

  • 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

Requirements For DataMart Developer (Teradata)

  • 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

Interested in this job?

Jobs Related To Master-Works DataMart Developer (Teradata)

Business Intelligence Engineer II, Amazon Privacy

Business Intelligence Engineer II for Amazon Privacy team, focusing on data analysis, metrics, and privacy compliance.

Data Engineer, Global Market

Join Airbnb as a Data Engineer in the Global Markets team, building scalable data pipelines and ensuring trustworthy data for innovation and global growth.

Data Engineer

Join MediaLab as a Data Engineer to build and maintain data platform solutions, working with streaming pipelines, BigQuery, and various data technologies.

Data Engineer

Join ResQ as a Data Engineer to build and maintain data pipelines, implement data models, and drive data-driven decision-making for a fast-growing restaurant tech startup.

Data Engineer, Amazon WW Promotions

Amazon WW Promotions seeks a Data Engineer to design and implement scalable data infrastructure solutions using AWS technologies.