Data Architect/Modeler

Key Responsibilities
Data Architecture & Modeling
Translate business requirements into conceptual, logical, and physical data models.
Design and maintain highly normalized (3NF) enterprise data models.
Create conceptual Entity Relationship Diagrams (ERDs) and logical data models.
Establish and govern business data definitions, standards, and naming conventions.
Oracle Database Design
Design Oracle physical schemas, including:
o Tables and columns
o Primary and foreign keys
o Indexing strategies
o Constraints and sequences
o Partitioning structures
Ensure database scalability, integrity, and performance.
Erwin Data Modeling
Develop and maintain enterprise data models using Erwin Data Modeler.
Manage model versioning through Erwin Mart.
Perform forward and reverse engineering.
Utilize Complete Compare to identify and resolve schema differences.
Maintain naming standards, domains, and model governance.
PL/SQL Development & Performance Tuning
Develop and optimize complex PL/SQL code.
Analyze execution plans and identify performance bottlenecks.
Optimize indexing strategies and database queries.
Troubleshoot locking, contention, and concurrency issues in high-volume transactional environments.
Data Governance & Quality
Define data modeling standards, governance procedures, and review processes.
Develop data dictionaries and impact analysis documentation.
Establish controls for data quality, consistency, completeness, and integrity.
Ensure compliance with security and privacy requirements.
Python Automation
Develop automation tools for:
o Model validation
o Metadata extraction
o Schema compliance checks
o Data profiling
o Deployment support
________________________________________
Required Qualifications
10+ years of Data Architecture and Data Modeling experience.
Majority of experience focused on OLTP/transactional systems.
Strong hands-on expertise with:
o Erwin Data Modeler
o Oracle Database
o Advanced PL/SQL Development
o Python
Expert understanding of:
o 3NF data modeling and normalization
o Logical and physical data modeling
o Database performance tuning
o Data governance practices
Ability to work directly with business stakeholders and translate requirements into technical solutions.
________________________________________
Telecom/Wireless Domain Experience (Mandatory)
Candidates should possess hands-on experience in one or more of the following areas:
Subscriber and account lifecycle management
Multi-line and hierarchical account structures
Product catalogs, rate plans, and offers
Features, entitlements, compatibility, and eligibility rules
Order management, activation, and provisioning workflows
Device and equipment management
Device financing and installment plans
Mobile subscriber identifiers:
o MSISDN
o IMSI
o ICCID/SIM
o IMEI
Number portability (Port-In/Port-Out)
Telecom BSS/OSS ecosystems