Senior Data Modeler

Exponentia Team

8 - 13 years

5 - 9 Lacs

bengaluru

Posted:None| Platform:

Apply

Skills Required

performance tuning data modeling rdbms datastage agile stored procedures microsoft project delivery sql data architecture

Work Mode

Work from Office

Job Type

Full Time

Job Description

Design and deliver conceptual, logical, and physical data models using tools like ERWin .
Implement Layered Scalable Architecture / Medallion Architecture for building scalable, standardized data marts.
Optimize performance and cost of AWS-based data infrastructure (Redshift, S3, Glue, Lambda, etc.).
Collaborate with cross-functional teams (IT, business, analysts) to gather data requirements and ensure model alignment with KPIs and business logic.
Develop and optimize SQL code, materialized views, stored procedures in AWS Redshift .
Ensure data governance, lineage, and quality mechanisms are established across systems.
Lead and mentor technical teams in an Agile project delivery model.
Manage data layer creation and documentation: data dictionary, ER diagrams, purpose mapping.
Identify data gaps and availability issues with respect to source systems.

Ideal Candidate Profile :

Minimum 5 years of experience in data modeling and architecture.
Proficiency with data modeling tools such as ERWin , with strong knowledge of forward and reverse engineering .
Deep expertise in SQL (including advanced SQL, stored procedures, performance tuning).
Strong experience in data warehousing , RDBMS , and ETL tools like AWS Glue , IBM DataStage , or SAP Data Services .
Hands-on experience with AWS services : Redshift, S3, Glue, RDS, Lambda, Bedrock, and Q.
Good understanding of reporting tools such as Tableau , Power BI , or AWS QuickSight .

More Jobs at Exponentia Team

Account Manager

Mumbai

5 - 10 yrs

INR 8 - 12 Lacs

Senior Data Engineer

Mumbai

5 - 8 yrs

INR 25 - 30 Lacs

Qlik Developer

Mumbai

2 - 8 yrs

INR 5 - 9 Lacs

Full Stack Developer

Mumbai

3 - 8 yrs

INR 6 - 10 Lacs

Azure Data Engineer

Mumbai

2 - 8 yrs

INR 6 - 10 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.