OBIA Developer - Onsite; Atlanta, GA

OBIA Developer

Atlanta, GA – 100 % Onsite

Pay Rate: DOE

1 ⃣ 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

2 ⃣ 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

3 ⃣ 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

4 ⃣ Performance Tuning

• Optimize slow-running ETL jobs
• Improve query performance
• Analyze execution plans
• Tune repository & BI server

5 ⃣ 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

6 ⃣ Documentation & Deployment

• Prepare technical design documents (TDD)
• Maintain mapping documents
• Migrate code across DEV → TEST → PROD
• Follow release management processes

• Architecture design discussions
• Effort estimation
• Client interaction & requirement gathering
• Code review & mentoring junior developers
• Data model enhancements

• Strong SQL & PL/SQL
• ODI development
• OBIEE RPD modeling
• Data warehousing concepts
• Unix & shell scripting basics
• Performance tuning knowledge