Company: Inteliment is a niche business analytics company with almost 2 decades proven track record of partnering with hundreds of fortunes 500 global companies. Inteliment operates its ISO certified development centre in Pune, India and has business operations in multiple countries through subsidiaries in Singapore, Europe and headquarter in India.
Location: Baner - Pune
Role Focus
We are seeking an experienced Technical Data Skilled with 5-8 years of hands-on expertise in designing and implementing dimensional data models using Erwin or any dimensional model tool and building SQL-based solutions adhering to Data Vault 2.0 and Information Mart standards. The ideal candidate will have strong data analysis capabilities, exceptional SQL skills, and a deep understanding of data relationships, metrics, and granularity of the data structures.
Work Experience
5+ years of experience in Technology areas like Database, Data Warehousing, SQL etc.
Key Responsibilities
1. Dimensional Data Modeling:
o Design and develop dimensional data models using Erwin with a focus on Star Schema and BUS architecture (Fact and Dimension tables).
o Ensure models align with business requirements and provide scalability, performance, and maintainability.
2. SQL Development:
o Implement data models in SQL using best practices for view creation, ensuring high performance.
o Write, optimize, and refactor complex SQL queries for efficiency and performance in large-scale databases.
o Develop solutions adhering to Information Mart and Data Vault 2.0 standards. (Dimensional model that is built using Raw Data vault tables Hubs, Links, satellites, Effectivity satellites , Bridge and PIT tables from Data Vault.)
3. Data Analysis & Relationship Metrics:
o Perform in-depth data analysis to identify patterns, relationships, and metrics at different levels of granularity.
o Ensure data integrity and quality by validating data models against business expectations.
4. Performance Optimizat
📌 Data Engineer (Pimpri-Chinchwad)
🏢 Inteliment Technologies
📍 Pimpri-Chinchwad
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.