DataMart Developer (Teradata)

Master-Works is a company seeking skilled professionals in data development and management.
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.
Last updated 2 months 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)

IDQ Developer

IDQ Developer position at Master-Works, focusing on data quality management using Informatica tools and requiring 2+ years of experience.

EDW Developer/Tester

EDW Developer/Tester position at Master-Works, focusing on Ab Initio and Teradata in the telecom domain.

DataMart Developer (Teradata)

Master-Works is hiring a DataMart Developer with Teradata expertise for data modeling, CLDM, and development of stored procedures, macros, and views.

EDW Developer/Tester

EDW Developer/Tester role at Master-Works, focusing on Ab Initio and Teradata in the telecom domain.

Data Engineer

Data Engineer role at Complex, building scalable data solutions and ML capabilities using Python, SQL, and AWS, with competitive benefits and salary.