ETL Development (ODI): Develop and customize SDE, SIL, and PLP mappings; modify existing ETL for new business requirements; create interfaces/packages; implement incremental and full load strategies; debug and resolve load failures.
Data Warehouse Development: Design and extend Fact and Dimension tables; implement SCD Type 1/2/3; create indexes and partitions for performance; ensure data integrity and referential constraints; write complex SQL transformations.
OBIEE / Reporting Development: Modify RPD (Physical, BMM, Presentation layers); create new Subject Areas; develop dashboards and reports; implement KPIs, calculated measures, row-level, and object-level security.
Performance Tuning: Optimize slow-running ETL jobs; improve query performance; analyze execution plans; tune repository and BI server.
Production Support: Monitor daily ETL loads; resolve data discrepancies; handle L2/L3 incident tickets; perform root cause analysis (RCA); coordinate with DBA and infrastructure teams.
Documentation & Deployment: Prepare technical design documents (TDD) and mapping documents; migrate code from DEV → TEST → PROD; follow release management processes.
Participate in architecture design discussions.
Provide effort estimation and client interaction for requirement gathering.
Conduct code reviews and mentor junior developers.
Drive data model enhancements.
Strong proficiency in SQL and PL/SQL.
Expertise in ODI development (SDE, SIL, PLP mappings).
Advanced OBIEE skills, including RPD modeling (Physical, BMM, Presentation layers).
Solid understanding of data warehousing concepts (Fact/Dimension modeling, SCDs).
Basics of Unix and shell scripting.
Proven experience in performance tuning (ETL, queries, execution plans).
4+ years in OBIA/ODI/OBIEE environments; Bachelor''''s in Computer Science or related field preferred.
Never miss an opportunity! Create an alert based on the job you applied for.
