Senior Data Engineer

About the job

Role Overview Seeking an experienced Technical Data Professional with: o Dimensional Data Modelling expertise o Strong SQL development skills o Knowledge of Data Vault 2.0 and Information Mart standards o Hands-on experience with Informatica PowerCenter / IICS O Ability to analyze data relationships, metrics, and granularity Key Responsibilities Data Modelling & ETL Design and implement dimensional data models Build IICS mappings and Information Mart Views Develop solutions using Data Vault 2.0 (Hubs, Links, Satellites, PIT, Bridge tables) SQL Development Write, optimize, and refactor complex SQL queries Implement high-performance views and adhere to best practices Data Analysis Perform in-depth analysis of patterns, relationships, and metrics Validate models against business expectations Performance Optimization Tune queries, ETL processes, and data structures Apply indexing, partitioning, and optimization techniques Collaboration Work with business stakeholders, data engineers, and analysts Ensure integration and delivery of data solutions Qualifications & Skills Technical Expertise • ETL using Informatica IICS • Advanced SQL for large-scale databases • Hands-on with Data Vault 2.0 and Information Mart • Knowledge of Star Schema, Facts & Dimensions, BU architecture Analytical Skills • Strong data analysis and troubleshooting Soft Skills • Problem-solving, decision-making, and communication • Stakeholder management and attention to detail Experience • 6-10 years in data modeling, SQL development, and performance tuning • Prior enterprise-level data environment experience preferred.

Requirements

• Dimensional Data Modelling
• SQL development
• Data Vault 2.0
• Informatica PowerCenter
• Data Analysis
• Performance Optimization

Preferred Technologies

• Dimensional Data Modelling
• SQL development
• Data Vault 2.0
• Informatica PowerCenter
• Data Analysis
• Performance Optimization