ETL Developer

• Design and develop data models ETL mappings and associated database objects for analytical solutions using ERWin ETL tools like Informatica ODI and AWS BI tools etc.
• Create/review technical documentation for all new and modified objects. Review solution design and ensure that the defined EDW standards and framework are followed.
• Review and validate logical and physical design to ensure alignment with the defined solution architecture.
• Ensure quality assurance plan and cases are comprehensive to validate the solution thoroughly.
• Extensive report development and enhancements using OBIEE & Oracle BI Applications or equivalent reporting platforms especially financial analytics using features like charts BI publisher Agents Prompts Actions and other Presentation Services elements to meet business requirements

• Experience in Installation of the OBIEE/OBIA platform or equivalent reporting platforms Configuring the OBIEE metadata repository (RPD) at the physical logical and presentation layers to meet business requirements
• Experience developing Packages Procedures and Functions with PL/SQL to support ETL processes.
• Experience in converting EBS Financials reports to OBIEE dashboards/reports or in equivalent reporting platforms
• Experience in performance analysis and optimization of OBIEE reports dashboards ETL and other components.
• OBIEE or equivalent reporting platforms Infrastructure experience including tuning performance issues monitoring applications analyzing logs and performing system operations
• Reporting layer security configuration experience including Single SignOn with EBS Financials R12 definitions of groups and roles restricting dashboard and Analysis access to specific groups performing data filtering based on user group and configuring LDAP integration

odi,obiee,pl/sql,aws bi,informatica,performance analysis,sql,reporting,erwin,dashboards,data modeling,etl,oracle bi applications