OBIA Developer

Georgia Tek Systems
Atlanta, GA, United States
2 days ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours

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

Good distractions

Loading talks and stories from around this role…