OBIA DeveloperAtlanta, GA – 100 % OnsiteCore ResponsibilitiesETL Development (ODI)Develop & customize SDE, SIL, PLP mappingsModify existing ETL to accommodate new business requirementsCreate new interfaces/packagesHandle incremental & full load strategiesDebug and fix load failuresData Warehouse DevelopmentDesign & extend Fact and Dimension tablesImplement Slowly Changing Dimensions (SCD Type 1/2/3)Create indexes & partitions for performanceMaintain data integrity & referential constraintsWrite complex SQL for transformationsOBIEE / Reporting DevelopmentModify RPD (Physical, BMM, Presentation layers)Create new Subject AreasDevelop dashboards & reportsImplement KPIs and calculated measuresApply row-level & object-level securityPerformance TuningOptimize slow-running ETL jobsImprove query performanceAnalyze execution plansTune repository & BI serverProduction SupportMonitor daily ETL loadsResolve data discrepanciesHandle incident tickets (L2/L3 support)Perform root cause analysis (RCA)Coordinate with DBA & infrastructure teamsDocumentation & DeploymentPrepare technical design documents (TDD)Maintain mapping documentsMigrate code across DEV ? TEST ? PRODFollow release management processesAdditional Responsibilities (Senior Level)Architecture design discussionsEffort estimationClient interaction & requirement gatheringCode review & mentoring junior developersData model enhancementsSkills ExpectedStrong SQL & PL/SQLODI developmentOBIEE RPD modelingData warehousing conceptsUnix & shell scripting basicsPerformance tuning knowledge