edw designer

erp technical and development consultant Jobs in Saudi Arabia

erp technical and development consultant

mobile application developer Jobs in Saudi Arabia

mobile application developer

onsite applications engineer Jobs in Saudi Arabia

onsite applications engineer

open text engineer

edw developer

Master Works

<div>
 
 Enterprise Data Warehouse ETL Developer (Ab Initio Specialist)
 
 
 
 
 Position Overview
 
 
 
 We are seeking an experienced ETL Developer with specialized expertise in Ab Initio for developing complex data integration solutions for Teradata EDW. The candidate must have strong telecommunications domain knowledge and ability to translate technical specifications into high-performance ETL solutions.
 
 
 
 Experience Required:
 
 Minimum 5+ years in ETL development with Ab Initio
 
 
 
 Core Responsibilities
 
 
 
 
 Ab Initio Development
 
 
 
 <ul>
 <li>
 Design and develop complex ETL workflows using Ab Initio GDE for Teradata EDW
 </li>
 <li>
 Build scalable data pipelines using Ab Initio components (Reformat, Join, Rollup, Dedup, Partition, Sort, Lookup)
 </li>
 <li>
 Develop reusable components, sub-graphs, and implement error handling, checkpoints, and recovery mechanisms
 </li>
 <li>
 Optimize performance through parallelization, partitioning, and efficient component usage
 </li>
 <li>
 Work with Ab Initio EME, Control Center, Conduct&gt;It, and Co&gt;Operating System
 
 
 </li>
 </ul>
 
 Data Integration &amp; Loading
 
 
 
 <ul>
 <li>
 Integrate data from Oracle, flat files, XML, JSON into Teradata using Ab Initio
 </li>
 <li>
 Implement Ab Initio to Teradata connectivity using BTEQ, FastLoad, MultiLoad, TPump
 </li>
 <li>
 Develop incremental/full load strategies, CDC logic, and SCD Types 1, 2, 3 implementations
 </li>
 <li>
 Create data quality checks, validation rules, and reconciliation processes
 </li>
 <li>
 Work with Cloudera Data Platform (CDP) for big data integration (Plus)
 
 
 </li>
 </ul>
 
 Documentation &amp; Collaboration
 
 
 
 <ul>
 <li>
 Translate LLD and mapping documents into Ab Initio graphs
 </li>
 <li>
 Create technical documentation: design docs, graph specifications, deployment guides
 </li>
 <li>
 Collaborate with data modelers, architects, QA teams, and Teradata DBAs
 </li>
 <li>
 Develop Ab Initio scripts (.pset, .ksh, .plan files) and Unix shell scripts for automation
 
 
 </li>
 </ul>
 
 Production Support
 
 
 
 <ul>
 <li>
 Troubleshoot Ab Initio job failures, analyze logs, and implement performance tuning
 </li>
 <li>
 Manage version control (Git/SVN) and coordinate deployments
 </li>
 <li>
 Monitor jobs through Control Center and provide production support
 
 
 </li>
 </ul>
 
 Required Skills
 
 
 
 
 Ab Initio (Primary - Required)
 
 
 
 <ul>
 <li>
 5+ years hands-on experience with Ab Initio GDE, Co&gt;Operating System, Conduct&gt;It, Express&gt;It
 </li>
 <li>
 Advanced expertise in Ab Initio components, graph development, and performance tuning
 </li>
 <li>
 Ab Initio DML, parameter management, EME, and deployment procedures
 </li>
 <li>
 Unix/Linux shell scripting for Ab Initio automation
 
 
 </li>
 </ul>
 
 Teradata &amp; Database (Required)
 
 
 
 <ul>
 <li>
 Strong Teradata SQL, utilities (BTEQ, FastLoad, MultiLoad, TPump, TPT)
 </li>
 <li>
 Understanding of Teradata architecture (AMP, PE, partitioning, indexing: PI, SI, NUSI)
 </li>
 <li>
 Oracle SQL and PL/SQL for source data extraction
 
 
 </li>
 </ul>
 
 Big Data (Plus)
 
 
 
 <ul>
 <li>
 Cloudera Data Platform (CDP) experience; Hadoop ecosystem (Hive, HDFS, Sqoop)
 
 
 </li>
 </ul>
 
 Telecommunications Domain (Required)
 
 
 
 <ul>
 <li>
 Strong understanding of telecom processes, data flows, and industry standards
 </li>
 <li>
 OSS: Network inventory, provisioning, fault/performance management
 </li>
 <li>
 BSS: Billing, customer management, order management, revenue assurance
 </li>
 <li>
 Telecom KPIs: ARPU, churn rate, network utilization
 
 
 </li>
 </ul>
 
 Professional Skills
 
 
 
 <ul>
 <li>
 Full SDLC (Agile/Scrum, Waterfall); strong analytical and debugging skills
 </li>
 <li>
 Good communication for technical and business collaboration
 
 
 </li>
 </ul>
 
 Preferred Qualifications
 
 
 
 <ul>
 <li>
 Bachelor's degree in Computer Science or related field
 </li>
 <li>
 Ab Initio certification
 </li>
 <li>
 Experience with Ab Initio Express&gt;It for data quality
 
 
 </li>
 </ul>
 
 Key Deliverables
 
 
 
 <ul>
 <li>
 Functional Ab Initio ETL graphs with parameter files and scripts
 </li>
 <li>
 Technical documentation: design docs, graph specs, deployment guides
 </li>
 <li>
 Unit tested and optimized code ready for production
 </li>
 <li>
 Data reconciliation reports and performance tuning recommendations
 </li>
 </ul>
</div>

EDW Developer

MASTER-WORKS

<div><h3 class="jobSectionHeader">Enterprise Data Warehouse ETL Developer (Ab Initio Specialist)</h3><h3 class="jobSectionHeader">
Position Overview</h3>
We are seeking an experienced ETL Developer with specialized expertise in Ab Initio for developing complex data integration solutions for Teradata EDW. The candidate must have strong telecommunications domain knowledge and ability to translate technical specifications into high-performance ETL solutions.
Experience Required: Minimum 5+ years in ETL development with Ab Initio
<h3 class="jobSectionHeader">Core Responsibilities</h3>
Ab Initio Development<ul>
<li>
Design and develop complex ETL workflows using Ab Initio GDE for Teradata EDW</li>
<li>Build scalable data pipelines using Ab Initio components (Reformat, Join, Rollup, Dedup, Partition, Sort, Lookup)</li>
<li>Develop reusable components, sub-graphs, and implement error handling, checkpoints, and recovery mechanisms</li>
<li>Optimize performance through parallelization, partitioning, and efficient component usage</li>
<li>Work with Ab Initio EME, Control Center, Conduct&gt;It, and Co&gt;Operating System</li>
</ul>
Data Integration &amp; Loading<ul>
<li>
Integrate data from Oracle, flat files, XML, JSON into Teradata using Ab Initio</li>
<li>Implement Ab Initio to Teradata connectivity using BTEQ, FastLoad, MultiLoad, TPump</li>
<li>Develop incremental/full load strategies, CDC logic, and SCD Types 1, 2, 3 implementations</li>
<li>Create data quality checks, validation rules, and reconciliation processes</li>
<li>Work with Cloudera Data Platform (CDP) for big data integration (Plus)</li>
</ul>
Documentation &amp; Collaboration<ul>
<li>
Translate LLD and mapping documents into Ab Initio graphs</li>
<li>Create technical documentation: design docs, graph specifications, deployment guides</li>
<li>Collaborate with data modelers, architects, QA teams, and Teradata DBAs</li>
<li>Develop Ab Initio scripts (.pset, .ksh, .plan files) and Unix shell scripts for automation</li>
</ul>
Production Support<ul>
<li>
Troubleshoot Ab Initio job failures, analyze logs, and implement performance tuning</li>
<li>Manage version control (Git/SVN) and coordinate deployments</li>
<li>Monitor jobs through Control Center and provide production support</li>
</ul>
<h3 class="jobSectionHeader">Required Skills</h3>
Ab Initio (Primary - Required)<ul>
<li>
5+ years hands-on experience with Ab Initio GDE, Co&gt;Operating System, Conduct&gt;It, Express&gt;It</li>
<li>Advanced expertise in Ab Initio components, graph development, and performance tuning</li>
<li>Ab Initio DML, parameter management, EME, and deployment procedures</li>
<li>Unix/Linux shell scripting for Ab Initio automation</li>
</ul>
Teradata &amp; Database (Required)<ul>
<li>
Strong Teradata SQL, utilities (BTEQ, FastLoad, MultiLoad, TPump, TPT)</li>
<li>Understanding of Teradata architecture (AMP, PE, partitioning, indexing: PI, SI, NUSI)</li>
<li>Oracle SQL and PL/SQL for source data extraction</li>
</ul>
Big Data (Plus)<ul><li>
Cloudera Data Platform (CDP) experience; Hadoop ecosystem (Hive, HDFS, Sqoop)</li></ul>
Telecommunications Domain (Required)<ul>
<li>
Strong understanding of telecom processes, data flows, and industry standards</li>
<li>OSS: Network inventory, provisioning, fault/performance management</li>
<li>BSS: Billing, customer management, order management, revenue assurance</li>
<li>Telecom KPIs: ARPU, churn rate, network utilization</li>
</ul>
Professional Skills<ul>
<li>
Full SDLC (Agile/Scrum, Waterfall); strong analytical and debugging skills</li>
<li>Good communication for technical and business collaboration</li>
</ul>
<h3 class="jobSectionHeader">Preferred Qualifications</h3><ul>
<li>Bachelor's degree in Computer Science or related field</li>
<li>Ab Initio certification</li>
<li>Experience with Ab Initio Express&gt;It for data quality</li>
</ul>
<h3 class="jobSectionHeader">Key Deliverables</h3><ul>
<li>Functional Ab Initio ETL graphs with parameter files and scripts</li>
<li>Technical documentation: design docs, graph specs, deployment guides</li>
<li>Unit tested and optimized code ready for production</li>
<li>Data reconciliation reports and performance tuning recommendations</li></ul></div>

<div>We are seeking an experienced Datamart / Semantic Layer Developer to develop and implement business-oriented datamarts and semantic layers on Teradata EDW, CDP Hive, and Trino platforms. The candidate must possess strong SQL development skills, dimensional modeling knowledge, telecommunications domain expertise, and ability to translate technical specifications into optimized analytics solutions.
Experience Required: Minimum 5+ years in datamart development and semantic layer implementation<h3 class="jobSectionHeader">
Core Responsibilities</h3>
Datamart Development<ul>
<li>
Develop and implement star schema and snowflake schema dimensional models on Teradata EDW</li>
<li>Build subject-area datamarts (Customer, Revenue, Network, Product, Finance) based on design specifications</li>
<li>Create and optimize fact tables, dimension tables, bridge tables, and aggregate tables</li>
<li>Implement slowly changing dimensions (SCD Types 1, 2, 3) logic and dimensional hierarchies</li>
<li>Develop complex SQL queries, stored procedures, and views for datamart population</li>
<li>Implement data transformation and aggregation logic for business metrics and KPIs</li>
</ul>
Semantic Layer Development<ul>
<li>
Develop semantic layers using TIBCO Data Virtualization on Teradata and CDP platforms</li>
<li>Build semantic models using Trino for distributed query processing and data access</li>
<li>Create virtual views, materialized views, and business-friendly data abstractions</li>
<li>Implement business logic, calculated measures, KPIs, and derived metrics in semantic layer</li>
<li>Develop data access policies, row-level security, and governance rules</li>
<li>Optimize semantic layer performance through caching, indexing, and query optimization</li>
</ul>
Multi-Platform Development<ul>
<li>
Work across Teradata, CDP Hive, and Trino platforms for datamart and semantic layer implementation</li>
<li>Develop HiveQL queries and tables in CDP (Cloudera Data Platform) environment</li>
<li>Integrate data from Teradata EDW and CDP Hive through Trino for unified semantic access</li>
<li>Create cross-platform queries and federated views using Trino connectors</li>
<li>Implement partitioning, bucketing, and optimization strategies in Hive tables</li>
</ul>
Implementation &amp; Optimization<ul>
<li>
Translate design documents (HLD, LLD) and mapping specifications into SQL code</li>
<li>Develop ETL/ELT processes to populate datamarts from EDW sources</li>
<li>Optimize query performance using indexing (PI, SI, NUSI), statistics, partitioning, and aggregations</li>
<li>Conduct unit testing, data validation, and reconciliation between source and target</li>
<li>Debug and troubleshoot performance issues in datamarts and semantic layers</li>
</ul>
Collaboration &amp; Documentation<ul>
<li>
Work closely with datamart designers, EDW developers, BI teams, and business analysts</li>
<li>Implement business requirements and KPI calculations as per specifications</li>
<li>Create technical documentation: SQL scripts, deployment guides, data lineage</li>
<li>Support UAT activities and assist business users in validating data accuracy</li>
<li>Provide production support and resolve data or performance issues</li>
</ul>
Requirements<h3 class="jobSectionHeader">
Required Skills</h3>
SQL &amp; Development (Required - Strong)<ul>
<li>
Teradata (Must Have): Advanced SQL development, stored procedures, performance tuning, utilities (BTEQ, TPT)</li>
<li>Strong understanding of Teradata architecture, indexing (PI, SI, NUSI), partitioning, and statistics</li>
<li>CDP Hive: HiveQL development, table creation, partitioning, bucketing, optimization in Cloudera environment</li>
<li>Trino (PrestoSQL): SQL development using Trino, federated queries, connector configuration</li>
<li>Expert-level SQL across multiple platforms for complex queries and transformations</li>
<li>Oracle SQL and PL/SQL development experience</li>
</ul>
Semantic Layer &amp; Tools (Required)<ul>
<li>
TIBCO: Hands-on development experience with TIBCO Data Virtualization for semantic layer implementation</li>
<li>Experience creating virtual views, business views, and semantic models in TIBCO</li>
<li>Understanding of data virtualization concepts and query federation</li>
<li>Knowledge of BI tool integration with semantic layers</li>
</ul>
Dimensional Modeling Knowledge<ul>
<li>
Strong understanding of star schema and snowflake schema dimensional models</li>
<li>Knowledge of fact table design, dimension design, and SCD implementations</li>
<li>Ability to translate dimensional models into physical database objects</li>
<li>Understanding of dimensional modeling best practices (Kimball methodology)</li>
</ul>
Telecommunications Domain (Required)<ul>
<li>
Understanding of telecom business processes, KPIs, and data flows</li>
<li>OSS: Network performance, inventory, fault management metrics</li>
<li>BSS: Billing, customer analytics, revenue, churn, product performance</li>
<li>Telecom KPIs: ARPU, churn rate, CLTV, network utilization, revenue metrics</li>
</ul>
Professional Skills<ul>
<li>
Full SDLC experience (Agile/Scrum, Waterfall)</li>
<li>Strong analytical and debugging skills for performance troubleshooting</li>
<li>Good communication skills for technical collaboration</li>
<li>Unix/Linux scripting for automation (plus)</li>
<li>Version control: Git, SVN</li>
</ul>
<h3 class="jobSectionHeader">Preferred Qualifications</h3><ul>
<li>Bachelor's degree in Computer Science, Information Technology, or related field</li>
<li>Experience with data profiling and data quality tools</li>
<li>Knowledge of ETL tools (Ab Initio, Informatica)</li>
<li>Understanding of data governance and metadata management</li>
<li>Experience with BI tools: Tableau, Power BI, Qlik</li></ul><h3 class="jobSectionHeader"> 
Key Deliverables</h3><ul>
<li>Developed and deployed datamarts (star/snowflake schema) on Teradata</li>
<li>Semantic layer implementations using TIBCO and Trino with business views and virtual tables</li>
<li>Optimized SQL code, stored procedures, and views for datamarts</li>
<li>HiveQL scripts and tables in CDP environment</li>
<li>Technical documentation: SQL scripts, deployment guides, data lineage</li>
<li>Unit tested code with data validation and reconciliation reports</li>
</ul>
Performance tuning recommendations and optimization implementations</div>

Datamart Developer

<div><h3 class="jobSectionHeader">Position Overview</h3>
We are seeking an experienced Datamart / Semantic Layer Designer &amp; Modeler to design business-oriented data models and semantic layers on top of Teradata EDW. This is a business-focused role requiring strong dimensional modeling expertise, business acumen, deep understanding of KPIs, telecommunications domain knowledge, and product thinking to deliver analytics solutions that drive business value.
Experience Required: Minimum 5+ years in datamart design, dimensional modeling, and semantic layer development<h3 class="jobSectionHeader">
Core Responsibilities</h3>
Dimensional Modeling &amp; Datamart Design<ul>
<li>
Design and develop star schema and snowflake schema dimensional models on Teradata EDW</li>
<li>Create subject-area datamarts (Customer, Revenue, Network, Product, Finance) optimized for business analytics</li>
<li>Design fact tables (transaction, snapshot, accumulating) with appropriate grain and measures</li>
<li>Develop dimension tables, conformed dimensions, bridge tables, and hierarchies</li>
<li>Implement slowly changing dimensions (SCD Types 1, 2, 3) and aggregate tables for performance</li>
<li>Strong expertise in dimensional modeling best practices and design patterns</li>
</ul>
Semantic Layer Development<ul>
<li>
Design and implement semantic layers on Teradata using TIBCO and Trino
</li><li>Create business-friendly abstractions that hide technical complexity from end users</li>
<li>Define business entities, relationships, metrics, KPIs, and calculated measures in semantic layer</li>
<li>Implement business logic, calculations, and data access policies</li>
<li>Develop views, materialized views, and virtual tables for semantic consumption</li>
</ul>
Business Requirements &amp; KPI Definition<ul>
<li>
Collaborate with business stakeholders to understand analytics, reporting, and decision-making needs</li>
<li>Define and document business KPIs, metrics, and performance indicators with business context</li>
<li>Translate business requirements into dimensional models and semantic layer specifications</li>
<li>Apply product thinking to design analytics solutions that deliver measurable business outcomes</li>
<li>Create business glossary and maintain business metadata aligned with business terminology</li>
</ul>
Technical Implementation &amp; Optimization<ul>
<li>
Work with Teradata (Must Have) for datamart and semantic layer implementation</li>
<li>Develop semantic models using TIBCO Data Virtualization and Trino for distributed queries</li>
<li>Optimize query performance through indexing (PI, SI), partitioning, aggregations, and caching</li>
<li>Implement row-level security and data governance policies in semantic layer</li>
<li>Collaborate with EDW designers, ETL teams, BI developers, and business users</li>
</ul>
Requirements 
Dimensional Modeling (Required - Strong)<ul>
<li>
Strong expertise in star schema and snowflake schema design and modeling</li>
<li>Advanced dimensional modeling techniques (Kimball methodology)</li>
<li>Fact table design (additive, semi-additive, non-additive measures) and grain definition</li>
<li>Dimension design: conformed dimensions, role-playing dimensions, junk dimensions, slowly changing dimensions</li>
<li>Experience designing datamarts for multiple business domains</li>
</ul>
Database &amp; Tools (Required)<ul>
<li>
Teradata (Must Have): Advanced SQL, performance tuning, indexing strategies, architecture understanding</li>
<li>TIBCO: Experience with TIBCO Data Virtualization or TIBCO suite for semantic layer</li>
<li>Trino (PrestoSQL): Hands-on experience for distributed SQL and semantic layer implementation</li>
<li>Oracle SQL and database knowledge</li>
<li>Data modeling tools: Erwin, PowerDesigner</li>
</ul>
Business &amp; Domain Knowledge (Required)<ul>
<li>
Strong business acumen and understanding of business processes, KPIs, and decision-making</li>
<li>Product thinking: ability to design solutions focused on business value and user experience</li>
<li>Deep understanding of business metrics, analytics requirements, and reporting needs</li>
<li>Ability to translate business language into technical data models</li>
</ul>
Telecommunications Domain (Required - Must Have)<ul>
<li>
Deep telecom business knowledge including processes, operations, and analytics</li>
<li>OSS: Network performance, inventory, fault management, service quality metrics</li>
<li>BSS: Billing, customer analytics, revenue assurance, churn analysis, product performance</li>
<li>Telecom KPIs: ARPU, churn rate, CLTV, network utilization, service availability, revenue metrics, subscriber growth</li>
</ul>
Professional Skills<ul>
<li>
Excellent communication and stakeholder management skills</li>
<li>Strong analytical and problem-solving abilities with business-oriented thinking</li>
<li>Full SDLC experience (Agile/Scrum preferred)</li>
<li>Ability to conduct workshops and present to business audiences</li>
</ul>
<h3 class="jobSectionHeader">Preferred Qualifications</h3><ul>
<li>Bachelor's degree in Computer Science, Business Analytics, or related field</li>
<li>Experience with BI tools: Tableau, Power BI, Qlik, MicroStrategy</li>
<li>Knowledge of data virtualization, MDM, and data governance</li>
<li>Understanding of self-service analytics and data democratization</li>
</ul>
<h3 class="jobSectionHeader">Key Deliverables</h3><ul>
<li>Star/snowflake schema dimensional models for datamarts on Teradata</li>
<li>Semantic layer models with business entities, KPIs, and relationships using TIBCO and Trino</li>
<li>Business KPI definitions, calculations, and business glossary</li>
<li>Technical specifications and performance optimization recommendations</li>
<li>Documentation: dimensional models, semantic layer specs, user guides</li></ul></div>

Datamart Designer

<div>
 We are seeking an experienced Enterprise Data Warehouse Designer/Modeler with specialized expertise in Teradata environments. The ideal candidate will design robust data warehouse solutions, possess strong telecommunications domain knowledge, and translate complex business requirements into optimized data models.
 
 
 
 Experience Required:
 
 Minimum 5+ years in enterprise data warehousing and data modeling
 
 
 
 Core Responsibilities
 
 
 
 
 Data Modeling &amp; Architecture
 
 
 
 <ul>
 <li>
 Design conceptual, logical, and physical data models for enterprise data warehouses
 </li>
 <li>
 Specialize in Teradata modeling including partitioning, indexing (PI, SI, NUSI), join indexes, and statistics optimization
 </li>
 <li>
 Transform source data into target EDW models; design fact/dimension tables and implement SCD Types 1, 2, 3
 
 
 </li>
 </ul>
 
 Data Profiling &amp; Analysis
 
 
 
 <ul>
 <li>
 Conduct data profiling on source systems to identify quality issues, patterns, and anomalies
 </li>
 <li>
 Analyze source data structures, relationships, and dependencies; perform data lineage and impact analysis
 
 
 </li>
 </ul>
 
 Business Requirements &amp; Collaboration
 
 
 
 <ul>
 <li>
 Understand and analyze business requirements from business units, analysts, and tribes
 </li>
 <li>
 Collaborate with business tribes (product, marketing, finance, operations), development teams, ETL developers, and DBAs
 </li>
 <li>
 Conduct discussions with source system owners and subject matter experts
 
 
 </li>
 </ul>
 
 Data Validation &amp; Documentation
 
 
 
 <ul>
 <li>
 Perform source-to-target data validation and reconciliation; execute data quality checks
 </li>
 <li>
 Create mapping documents, High-Level Design (HLD), Low-Level Design (LLD), and technical specifications
 </li>
 <li>
 Maintain data dictionary, metadata repository, and operational documentation
 
 
 </li>
 </ul>
 
 Development &amp; Implementation
 
 
 
 <ul>
 <li>
 Design and optimize database objects; implement Teradata-specific optimizations (PI/SI selection, join indexes, statistics, workload management)
 </li>
 <li>
 Write complex SQL for data analysis and validation; support ETL teams with technical guidance
 
 
 </li>
 </ul>
 
 Required Skills
 
 
 
 
 Technical Expertise
 
 
 
 <ul>
 <li>
 Teradata (Required): Advanced knowledge of architecture, SQL, utilities (BTEQ, FastLoad, MultiLoad, TPT), optimization, partitioning, and indexing
 </li>
 <li>
 Oracle: Strong experience with PL/SQL and performance tuning
 </li>
 <li>
 SQL: Expert-level programming across multiple platforms (Teradata, Oracle, SQL Server)
 </li>
 <li>
 Data modeling tools (Erwin, PowerDesigner); ETL tools exposure (Ab Initio, Informatica)
 </li>
 <li>
 Data warehouse concepts: Star/snowflake schema, dimensional modeling (Kimball), normalized modeling (Inmon)
 
 
 </li>
 </ul>
 
 Domain Knowledge - Telecommunications
 
 
 
 <ul>
 <li>
 Strong understanding of telecom business processes and data domains
 </li>
 <li>
 OSS: Network inventory, provisioning, fault/performance management
 </li>
 <li>
 BSS: Billing, customer/order management, revenue assurance, product catalog
 </li>
 <li>
 Telecom KPIs: ARPU, churn rate, network utilization, service quality
 
 
 </li>
 </ul>
 
 Professional Skills
 
 
 
 <ul>
 <li>
 Full SDLC experience (Agile/Scrum, Waterfall methodologies)
 </li>
 <li>
 Product-oriented mindset with strategic thinking and business value focus
 </li>
 <li>
 Strong analytical, problem-solving skills with attention to detail
 </li>
 <li>
 Excellent communication skills; ability to explain technical concepts to non-technical stakeholders
 </li>
 <li>
 Cross-functional collaboration and stakeholder management
 
 
 </li>
 </ul>
 
 Preferred Qualifications
 
 
 
 <ul>
 <li>
 Bachelor's degree in Computer Science, Information Systems, or related field
 </li>
 <li>
 Teradata certification (Teradata Certified Professional)
 </li>
 <li>
 Cloud data platforms experience (AWS Redshift, Azure Synapse, Snowflake)
 </li>
 <li>
 Big data technologies (Hadoop, Spark); MDM and data governance knowledge
 
 
 </li>
 </ul>
 
 Key Deliverables
 
 
 
 <ul>
 <li>
 Comprehensive data models with Teradata-optimized physical designs
 </li>
 <li>
 Source-to-target mapping documents, HLD/LLD documents, and technical specifications
 </li>
 <li>
 Data profiling reports, quality assessments, and performance tuning recommendations
 </li>
 </ul>
</div>

EDW Designer

<div>We are seeking an experienced Enterprise Data Warehouse Designer/Modeler with specialized expertise in Teradata environments. The ideal candidate will design robust data warehouse solutions, possess strong telecommunications domain knowledge, and translate complex business requirements into optimized data models.
Experience Required: Minimum 5+ years in enterprise data warehousing and data modeling
Core Responsibilities
Data Modeling &amp; Architecture<ul>
<li>
Design conceptual, logical, and physical data models for enterprise data warehouses</li>
<li>Specialize in Teradata modeling including partitioning, indexing (PI, SI, NUSI), join indexes, and statistics optimization</li>
<li>Transform source data into target EDW models; design fact/dimension tables and implement SCD Types 1, 2, 3</li>
</ul>
Data Profiling &amp; Analysis<ul>
<li>
Conduct data profiling on source systems to identify quality issues, patterns, and anomalies</li>
<li>Analyze source data structures, relationships, and dependencies; perform data lineage and impact analysis</li>
</ul>
Business Requirements &amp; Collaboration<ul>
<li>
Understand and analyze business requirements from business units, analysts, and tribes</li>
<li>Collaborate with business tribes (product, marketing, finance, operations), development teams, ETL developers, and DBAs</li>
<li>Conduct discussions with source system owners and subject matter experts</li>
</ul>
Data Validation &amp; Documentation<ul>
<li>
Perform source-to-target data validation and reconciliation; execute data quality checks</li>
<li>Create mapping documents, High-Level Design (HLD), Low-Level Design (LLD), and technical specifications</li>
<li>Maintain data dictionary, metadata repository, and operational documentation</li>
</ul>
Development &amp; Implementation<ul>
<li>
Design and optimize database objects; implement Teradata-specific optimizations (PI/SI selection, join indexes, statistics, workload management)</li>
<li>Write complex SQL for data analysis and validation; support ETL teams with technical guidance</li>
</ul>
Required Skills
Technical Expertise<ul>
<li>
Teradata (Required): Advanced knowledge of architecture, SQL, utilities (BTEQ, FastLoad, MultiLoad, TPT), optimization, partitioning, and indexing</li>
<li>Oracle: Strong experience with PL/SQL and performance tuning</li>
<li>SQL: Expert-level programming across multiple platforms (Teradata, Oracle, SQL Server)</li>
<li>Data modeling tools (Erwin, PowerDesigner); ETL tools exposure (Ab Initio, Informatica)</li>
<li>Data warehouse concepts: Star/snowflake schema, dimensional modeling (Kimball), normalized modeling (Inmon)</li>
</ul>
Domain Knowledge - Telecommunications<ul>
<li>
Strong understanding of telecom business processes and data domains</li>
<li>OSS: Network inventory, provisioning, fault/performance management</li>
<li>BSS: Billing, customer/order management, revenue assurance, product catalog</li>
<li>Telecom KPIs: ARPU, churn rate, network utilization, service quality</li>
</ul>
Professional Skills<ul>
<li>
Full SDLC experience (Agile/Scrum, Waterfall methodologies)</li>
<li>Product-oriented mindset with strategic thinking and business value focus</li>
<li>Strong analytical, problem-solving skills with attention to detail</li>
<li>Excellent communication skills; ability to explain technical concepts to non-technical stakeholders</li>
<li>Cross-functional collaboration and stakeholder management</li>
</ul>
Preferred Qualifications<ul>
<li>
Bachelor's degree in Computer Science, Information Systems, or related field</li>
<li>Teradata certification (Teradata Certified Professional)</li>
<li>Cloud data platforms experience (AWS Redshift, Azure Synapse, Snowflake)</li>
<li>Big data technologies (Hadoop, Spark); MDM and data governance knowledge</li>
</ul>
Key Deliverables<ul>
<li>
Comprehensive data models with Teradata-optimized physical designs</li>
<li>Source-to-target mapping documents, HLD/LLD documents, and technical specifications</li>
<li>Data profiling reports, quality assessments, and performance tuning recommendations</li></ul></div>

Amco IT Systems

Job Title: Snowflake DeveloperLocation: Saudi ArabiaExperience: 3&ndash;5 yearsJob Summary:We&rsquo;re looking for a Snowflake Developer to build and optimize data pipelines and warehouse solutions. The ideal candidate should have hands-on experience with Snowflake architecture, strong SQL skills, and expertise in data modeling and workflow automation.Key Responsibilities:<ul><li>Design and optimize Snowflake-based data pipelines.</li><li>Implement Snowpipe, Streams, Tasks, and Virtual Warehouses.</li><li>Automate workflows using Airflow or Luigi.</li><li>Integrate Snowflake with GCP and other cloud platforms.</li></ul>Requirements:<ul><li>3&ndash;5 years&rsquo; experience in data engineering.</li><li>Strong SQL and data warehouse skills.</li><li>Proficiency in Snowflake and cloud integrations (preferably GCP).</li></ul>Job Type: Contract Contract length: 6 monthsAbility to commute/relocate:<ul><li>Riyadh: Reliably commute or planning to relocate before starting work (Required)</li></ul>Application Question(s):<ul><li>What is your Nationality?</li><li>What is your notice period in days?</li><li>What is your current monthly salary?</li><li>What is your expected monthly salary in SAR?</li><li>How many years of experience do you have as a Snowflake developer?</li><li>Are you comfortable with 6 months contract (extendable)</li></ul>Language:<ul><li>Arabic (Required)</li></ul>

Snowflake Developr

Explore 120+ Edw developer in Saudi Arabia this November. Find roles across top companies and apply now to boost your career.

120 edw developer jobs IN Saudi Arabia

EDW Developer

EDW Developer

Datamart Developer

Datamart Designer

EDW Designer

EDW Designer

Snowflake Developr