OBIA Developer
Georgia Tek Systems
Atlanta, GA, United States
2 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.careerbuilder.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Job source
Tech stack
Query Performance
Unix
Code Review
Databases
Extract Transform Load (ETL)
Data Warehousing
Software Debugging
Oracle Business Intelligence Enterprise Edition
Performance Tuning
Release Management
Standard Sql
Shell Script
+2 more
PL-SQL
SQL Databases
Job description
- Modify existing ETL to accommodate new business requirements
- Create new interfaces/packages
- Handle incremental & full load strategies
- Debug and fix load failures
Data Warehouse Development
- Design & extend Fact and Dimension tables
- Implement Slowly Changing Dimensions (SCD Type 1/2/3)
- Create indexes & partitions for performance
- Maintain data integrity & referential constraints
- Write complex SQL for transformations
OBIEE / Reporting Development
- Modify RPD (Physical, BMM, Presentation layers)
- Create new Subject Areas
- Develop dashboards & reports
- Implement KPIs and calculated measures
- Apply row-level & object-level security
Performance Tuning
- Optimize slow-running ETL jobs
- Improve query performance
- Analyze execution plans
- Tune repository & BI server
Production Support
- Monitor daily ETL loads
- Resolve data discrepancies
- Handle incident tickets (L2/L3 support)
- Perform root cause analysis (RCA)
- Coordinate with DBA & infrastructure teams
Documentation & Deployment
- Prepare technical design documents (TDD)
- Maintain mapping documents
- Migrate code across DEV * TEST * PROD
- Follow release management processes
Additional Responsibilities (Senior Level)
- Architecture design discussions
- Effort estimation
- Client interaction & requirement gathering
- Code review & mentoring junior developers
- Data model enhancements
Skills Expected
- Strong SQL & PL/SQL
- ODI development
- OBIEE RPD modeling
- Data warehousing concepts
- Unix & shell scripting basics
- Performance tuning knowledge
Requirements
Database Extract Transform and Load (ETL), Debugging Skills, Data Warehousing, Data Quality, SQL (Structured Query Language), Oracle Business Intelligence Enterprise Edition (OBIEE), Reporting Dashboards, Performance Metrics, Performance Management, Analysis Skills
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.careerbuilder.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦