← Back to jobs

4A IT Services LLC Logo
Solution Architect MDM

4A IT Services LLC

 

Dallas, TX, USA

Posted On: 30+ days ago
Experience: 7+ years
Availability: Hybrid
Openings: 1
Category: Solution Architect
Tenure: Full-time Only
Related Jobs

No related jobs found

Description

You will own the architecture, build, and maintenance of the Enterprise Data Warehouse and end-to-end BI solutions.

Responsibilities

  • Architect and oversee ETL processes including data extraction, cleansing, mapping, transformation, and validation.
  • Translate stakeholder requirements into technical specifications and design documents.
  • Lead teams in model deployment across environments and manage version control via code repositories.
  • Optimize data read/write performance and apply star schema techniques for data integrity.
  • Evaluate, select, and implement Teradata-based solutions to support analytics and reporting.

Required Skills

  • 7+ years of experience in data warehousing and BI architecture.
  • Expertise in Standard SQL and SQL Server.
  • Hands-on experience with Teradata technologies and Informatica.
  • Deep understanding of dimensional modeling, relational modeling, and enterprise data design.
  • Proven ability to design ETL processes using SSIS and Informatica.
  • Experience architecting BI dashboards, KPIs, metrics, and reports.
  • Practical knowledge of designing data integrity and error handling techniques.
  • Experience working with both cloud and on-premise data sources and targets.
  • Ability to create technical diagrams, data mapping documents, and integration architectures.

Preferred Skills

  • In-depth knowledge of Teradata Utilities and Teradata QueryGrid.
  • Experience with Informatica Data Quality and Informatica Data Catalog.

Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs