Data Warehouse Consultant | Online Jobs | Optimhire

Data Warehouse Consultant

We are looking for an ELT/Data Integration Consultant. The consultant will join a Professional Services Team who are responsible for developing Data Warehouse Automation solutions & supporting various customers to provide technical expertise on an ELT Automation tool. The role is focused on automation tools WhereScape RED and 3D integrated with various traditional & cloud platforms like Oracle, Teradata, Snowflake, Azure SQL, Hive, Amazon, Google Bigquery etc. applied in the areas of Dimensional as well as Data Vault modeling techniques. 

Principal Accountabilities: 


Requirement gathering & understanding of client Data Warehouse needs 

Provide Data Warehouse Automation solutions  

Develop, schedule & productionize the ELT  

Migration of Data Warehouse systems from traditional RDBMS platforms to Cloud platforms  


Skills Required: 


Must have excellent command over communication (Written and Verbal) 

Knowledge of Data Warehousing modeling techniques - Dimensional Modeling or Data Vault Modeling 

Should have extensively worked in any of the ETL/ELT tools  

Good understanding of any Database Architectures 

Excellent SQL  

Good problem-solving capability and self-explore 

Work Location & Culture: 


Full-time position 

Remote Working - Anywhere from India 

Flexible working hours 

Job Type


Must have Skills

  • Data Warehousing

6 - 34 K/Year USD (Annual salary)

Longterm (Duration)

Fully Remote

Shweta M