Experienced Mid-level ODI/ETL Consultant with a strong background in Oracle Analytics Server (OAS) and Oracle Data Integrator (ODI) administration. Proficient in BI development, including report design and data visualization using Oracle Analytics Cloud (OAC) and BI Publisher. Skilled in user management, security configuration, performance tuning, and troubleshooting. Strong in SQL and PL/SQL for data analysis and query optimization, committed to delivering exceptional user support while maintaining data integrity and efficiency.
Essential Duties:
• Create, develop, document, and test BI software and models using OAS/OAC to meet user requirements.
• Utilize OAS Data Visualizer to create visual analytics and dashboards tailored to business needs.
• Design and maintain reports using BI Publisher for effective data presentation.
• Collaborate with data modelers and analytics developers to enhance BI solutions.
• Monitor, maintain, and optimize OAS and ODI systems for performance and security.
• Troubleshoot and resolve production issues to minimize downtime.
• Assist and train users on OAS and ODI functionalities for effective tool utilization.
• Oversee ETL processes for accurate data integration from various sources.
• Maintain documentation of system configurations, processes, and technical standards.
• Provide ongoing support for BI applications, addressing user needs and system issues.
• Ensure compliance with organizational and regulatory standards to maintain data integrity.
Skill Set:
• Proficient in SQL and PL/SQL for querying and data manipulation.
• Experienced with BI tools (e.g., Oracle BI, Power BI, Tableau, QlikView).
• Proficient in data warehousing and ETL processes (e.g., ODI).
• Familiar with database management systems (Oracle, SQL Server, MySQL).
• Skilled in data modeling (relational and dimensional).
• Understanding of OLAP and data visualization techniques.