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

Data Modeler / Pl/sql Senior Developer - Oracle Data Warehouse

Apply Now
Job Summary

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



Experience Required :

4 to 7 Years

Vacancy :

2 - 4 Hires