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 & Architecture
- Design conceptual, logical, and physical data models for enterprise data warehouses
- Specialize in Teradata modeling including partitioning, indexing (PI, SI, NUSI), join indexes, and statistics optimization
- Transform source data into target EDW models; design fact / dimension tables and implement SCD Types 1, 2, 3
Data Profiling & Analysis
Conduct data profiling on source systems to identify quality issues, patterns, and anomaliesAnalyze source data structures, relationships, and dependencies; perform data lineage and impact analysisBusiness Requirements & Collaboration
Understand and analyze business requirements from business units, analysts, and tribesCollaborate with business tribes (product, marketing, finance, operations), development teams, ETL developers, and DBAsConduct discussions with source system owners and subject matter expertsData Validation & Documentation
Perform source-to-target data validation and reconciliation; execute data quality checksCreate mapping documents, High-Level Design (HLD), Low-Level Design (LLD), and technical specificationsMaintain data dictionary, metadata repository, and operational documentationDevelopment & Implementation
Design and optimize database objects; implement Teradata-specific optimizations (PI / SI selection, join indexes, statistics, workload management)Write complex SQL for data analysis and validation; support ETL teams with technical guidanceRequired Skills
Technical Expertise
Teradata (Required) : Advanced knowledge of architecture, SQL, utilities (BTEQ, FastLoad, MultiLoad, TPT), optimization, partitioning, and indexingOracle : Strong experience with PL / SQL and performance tuningSQL : Expert-level programming across multiple platforms (Teradata, Oracle, SQL Server)Data modeling tools (Erwin, PowerDesigner); ETL tools exposure (Ab Initio, Informatica)Data warehouse concepts : Star / snowflake schema, dimensional modeling (Kimball), normalized modeling (Inmon)Domain Knowledge - Telecommunications
Strong understanding of telecom business processes and data domainsOSS : Network inventory, provisioning, fault / performance managementBSS : Billing, customer / order management, revenue assurance, product catalogTelecom KPIs : ARPU, churn rate, network utilization, service qualityProfessional Skills
Full SDLC experience (Agile / Scrum, Waterfall methodologies)Product-oriented mindset with strategic thinking and business value focusStrong analytical, problem-solving skills with attention to detailExcellent communication skills; ability to explain technical concepts to non-technical stakeholdersCross-functional collaboration and stakeholder managementPreferred Qualifications
Bachelor's degree in Computer Science, Information Systems, or related fieldTeradata certification (Teradata Certified Professional)Cloud data platforms experience (AWS Redshift, Azure Synapse, Snowflake)Big data technologies (Hadoop, Spark); MDM and data governance knowledgeKey Deliverables
Comprehensive data models with Teradata-optimized physical designsSource-to-target mapping documents, HLD / LLD documents, and technical specificationsData profiling reports, quality assessments, and performance tuning recommendations#J-18808-Ljbffr