Sign upLog in

OBIA Developer

Georgia Tek Systems

GA, GA

Apply
JOB DETAILS
SKILLS
Analysis Skills, Architectural Design, Business Intelligence, Code Reviews, Customer Relations, Customer/Client Research, Data Modeling, Data Quality, Data Warehousing, Database Administration, Database Extract Transform and Load (ETL), Debugging Skills, Design Document, Mentoring, Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle PL-SQL, Performance Management, Performance Metrics, Performance Tuning/Optimization, Production Support, Release Management/Engineering, Reporting Dashboards, Root Cause Analysis, SQL (Structured Query Language), Technical Writing, Technical/Engineering Design, Test Driven Development (TDD), Unix Shell Programming
LOCATION
GA, GA
POSTED
30+ days ago
OBIA Developer
Atlanta, GA – 100 % Onsite

Core Responsibilities
ETL Development (ODI)
  • Develop & customize SDE, SIL, PLP mappings
  • 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

About the Company

G

Georgia Tek Systems