- esponsible for the development of the Dimension Modelling conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (Snowflake DB).
- Experience with 3rd Normal Form/Transaction database modelling ( Basic Idea or working experience)
- Should have working experience with Dimension Modelling/Kimbal Modelling tools like Erwin/ER Studio/oracle Data Modeller ( Mandatory experience).
- Should be an Expert in any relational Database ( MS SQL Server/Snowflake/Postgres/..) with a very good understanding of relational databases, Keys, indexes, Data Granularity and PK-FK Relations.
- Analyzing and translating business needs into long-term solution data models.
- Exposure to Data Vault implementation
- 6-12 years of DW/BI overall experience
- Should have 3-4 years of hands-on experience with any ETL and BI tools
- 4+ years of hands-on experience in data modelling.
Good to have SAP and Data Vault Knowledge/Experience.
Top Skills
What We Do
A trusted partner at nearly three million customer locations, Ecolab (ECL) is the global leader in water, hygiene and infection prevention solutions and services. With annual sales of $12 billion and more than 44,000 associates, Ecolab delivers comprehensive solutions, data-driven insights and personalized service to advance food safety, maintain clean and safe environments, optimize water and energy use, and improve operational efficiencies and sustainability for customers in the food, healthcare, hospitality and industrial markets in more than 170 countries around the world.
For more Ecolab news and information, visit www.ecolab.com, or follow us on twitter.com/ecolab, facebook.com/ecolab or instagram.com/ecolab_inc.
