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
Never miss an opportunity! Create an alert based on the job you applied for.
