Data Modeler / Pl/sql Senior Developer - Oracle Data Warehouse Job in Mindpool Technologies Limited

Job Description

• Convert business requirements to concept/ technical specification
  
• Develop PL/SQL based on technical specification
  
• Work along with source system experts in finalizing ETL and report design
  
• Work with other data modeler in preparing the data/ dimensional models
  
• Coordinate with central team to replicate tables from source system to data lake
  
• Support Oracle developer and Report designers in design and development
  
• Creation of activity plan as per the agreed concept with timelines
  
• Design, Develop and Deploy solution
  
• Unit & Integration testing
  
• Support customers during the stabilization phase
  

Qualifications

• Overall 8+ years of experience in IT Industry
  
• 4+ yearsexperience on Oracle Database programming in Data Warehousing systems
  
• 4+ yearsexperience on Dimensional Modelling in Data warehousing solutions
  
• Experience in working at least 2 end-to-end projects
  
• Rich Experience in with Database Packages, Stored procedure, Functions , procedures, Triggers and data transformation activities using SQL and PLSQL
  
• Strong expertise on RDBMS fundamentals
  
• Good knowledge in SQL loader, Data pump and Import/Export utilities
  
• Knowledge on Performance Tuning for Oracle RDBMS
  
• Good oral communication skill
  

Additional information

• Good to have experience in building applications with Data Vault 2.0
  
• Experience with any data visualization or BI tools such as Tableau, PowerBI
  
• Experience in any ETL tools like BODS, SSIS
  

Strong customer & result orientation