Senior ODI Developer

Astrosoft Technologies LLC has openings for the position Senior ODI Developer with bachelor’s degree in Computer Science, Engineering any, Technology or related and 5 yrs of exp for building and testing the Business Intelligence application which involves developing the ETL jobs, Replicating the data, OBIEE RPD, Report and Dashboards. Enhancement of OBIEE repository layers which enables business users to prepare their own ad-hoc reports. Creating analytical reports and dashboards in OBIEE which helps business executives to take their decision. Identifying the bottleneck SQL queries from Oracle BI Publisher and tuning queries using optimized SQL writing methods. Responsible for performance tuning ETL objects to complete the Batch Schedules on time and performance tuning of BI dashboards & ETL jobs to meet the SLA which is critical for Business Users. Responsible for administration activities like RPD Merging, RPD & Web catalog migrations, and support of BI Application tools (OBIEE, and ODI). Perform testing sessions for reports and dashboards and resolve process issues. Design and develop data transformation using Oracle Integration cloud on real-time streaming and persistent ETL into different databases.