DataWarehouse Architect OLTP

Hi There,

Greetings from Sightspectrum LLC..!!

I hope you doing well, Please find the below job description if you're comfortable share me your updated resume and contact details asap.

Title: DataWarehouse Architect OLTP Data Modelling

Location: St. Louis, MO(Onsite)

Duration: Long Term.

Note In person Interview must for this role

Primary Skills: Erwin Data Modeler, Oracle, PL/SQL, Python, OLTP Data Modeling, Telecom/Wireless Domain

Position Overview

• We are seeking an experienced Solution Architect with deep expertise in OLTP Data Modeling and Data Architecture within the Telecom/Wireless industry.
• This role requires a hands-on architect capable of designing and governing highly normalized transactional databases that support customer-facing mobile applications, subscriber management systems, product catalogs, and activation workflows.
• The ideal candidate will have strong experience with Erwin Data Modeler, Oracle Database, PL/SQL, and Python, along with a proven track record of architecting scalable, high-volume transactional systems

Note: This is an OLTP-focused role. Candidates with primary experience in Data Warehousing, BI, Analytics Engineering, Reporting, or ETL/ELT development will not be considered.

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:
• Tables and columns
• Primary and foreign keys
• Indexing strategies
• Constraints and sequences
• Partitioning structures

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:
• Model validation
• Metadata extraction
• Schema compliance checks
• Data profiling
• 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:

• Erwin Data Modeler
• Oracle Database
• Advanced PL/SQL Development
• Python

• Expert understanding of:
• 3NF data modeling and normalization
• Logical and physical data modeling
• Database performance tuning
• Data governance practices

Must-Have Skills

• OLTP Data Modeling
• Data Architecture
• Erwin Data Modeler
• Oracle Database
• Advanced PL/SQL
• Database Performance Tuning
• Python Automation
• Telecom/Wireless Domain Experience
• Data Governance & Standards

Nice-to-Have Skills

• TM Forum SID
• Oracle Exadata
• Oracle GoldenGate
• Amdocs/Netcracker / Ericsson / CSG

Schema Automation & Version Control

Shawn