Major Job Description:
· Data warehouse specialist with finance ERP and ETL knowledge.
· Oracle Data warehouse , star schema, ETL knowledge
· Design, develop and implement enterprise data warehouse and datamart models, logical data model, and physical data model.
· Database skills - hands on Oracle SQL , PL/SQL, performance tuning skills
· BI Tools - Develop OBIEE reports & dashboards, free form SQLs, complex prompts and customizations ( OBIEE 11g/12c)
· Analyze requirements, program and configure warehouses of database information, and provide support to warehouse users. Review data mart/warehouse deliverables, and suggest and co-create standards and guidelines
· Understand star/snowflake schema model, Hierarchies, prompts, attributes, schema, application objects
· Perform data quality , develop mappings, define workflows and tasks, monitor sessions, export and import mappings and workflows and perform backup and recovery.
Major Job Requirements:
· Oracle Data warehouse, SQL, PL/SQL ( 5 to 7 years)
· OBIEE 11g/12c ( 3-4 years )
· Ability to work with customers and good communication skills.
Job Type: Full-time
Legacy to the Cloud Founded in 2004 by visionaries from leading technology organizations, MLOGICA’s leaders envisioned a faster, more efficient way of modernizing IT infrastructures to eliminate the skyrocketing costs of legacy systems that had stymied innovation and eaten away at enterprise profitability for years. They also realized modernization offered their customers the opportunity to harness the power of globally dispersed data to build revenue. mission is to assist its customers in driving enterprise profitability through advanced analytics and Cloud modernization. Helping customers unravel the complexities of migrating mission-critical, enterprise applications, databases, infrastructure, and data—while saving them time, money and business disruption is how we do it.