3+ ERwin Jobs in India

About the 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.

About the Role:

We are seeking an experienced Technical Data Professional with 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.

Qualifications:

• Bachelor’s degree in computer science, Information Technology, or a related field.
• Certifications with related field will be an added advantage.

Key Competencies:

1.Technical Expertise:

• Proficiency in Erwin for data modeling.
• Advanced SQL skills with experience in writing and optimizing performance driven queries.
• Hands-on experience with Data Vault 2.0 and Information Mart standards is highly preferred.
• Solid understanding of Star Schema, Facts & Dimensions, and Business Unit (BU) architecture.

2. Analytical Skills:

• Strong data analysis skills to evaluate data relationships, metrics, and granularities.
• Capability to troubleshoot and resolve complex data modeling and performance issues.

3.Soft Skills:

• Strong problem-solving and decision-making skills.
• Excellent communication and stakeholder management abilities.
• Proactive and detail-oriented with a focus on delivering high-quality results.

Key Responsibilities:

1. Dimensional Data Modeling:

• Design and develop dimensional data models using Erwin with a focus on Star Schema and BUS architecture (Fact and Dimension tables).
• Ensure models align with business requirements and provide scalability, performance, and maintainability.

2. SQL Development:

• Implement data models in SQL using best practices for view creation, ensuring high performance.
• Write, optimize, and refactor complex SQL queries for efficiency and performance in large-scale databases.
• 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:

• Perform in-depth data analysis to identify patterns, relationships, and metrics at different levels of granularity.
• Ensure data integrity and quality by validating data models against business expectations.

4. Performance Optimization:

• Conduct performance tuning of existing data structures, queries, and ETL processes.
• Provide guidance on database indexing, partitioning, and query optimization techniques.

5. Collaboration:

• Work closely with business stakeholders, data engineers, and analysts to understand and translate business needs into effective data solutions.
• Support cross-functional teams to ensure seamless integration and delivery of data solutions

Job Description :

We are seeking a highly experienced Sr Data Modeler / Solution Architect to join the Data Architecture team at Corporate Office in Bangalore. The ideal candidate will have 4 to 8 years of experience in data modeling and architecture with deep expertise in AWS cloud stack, data warehousing, and enterprise data modeling tools. This individual will be responsible for designing and creating enterprise-grade data models and driving the implementation of Layered Scalable Architecture or Medallion Architecture to support robust, scalable, and high-quality data marts across multiple business units.

This role will involve managing complex datasets from systems like PoS, ERP, CRM, and external sources, while optimizing performance and cost. You will also provide strategic leadership on data modeling standards, governance, and best practices, ensuring the foundation for analytics and reporting is solid and future-ready.

Key Responsibilities:

·               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.

Required Skills & Qualifications:

·               Bachelor’s or Master’s degree in Computer Science, IT, or related field (B.E./B.Tech/M.E./M.Tech/MCA).

·               Minimum 4 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.

·               Exposure to DevOps/CI-CD pipelines, AI/ML, Gen AI, NLP, and polyglot programming is a plus.

·               Familiarity with data governance tools (e.g., ORION/EIIG).

·               Domain knowledge in Retail, Manufacturing, HR, or Finance preferred.

·               Excellent written and verbal communication skills.

Certifications (Preferred):

·               AWS Certification (e.g., AWS Certified Solutions Architect or Data Analytics – Specialty)

·               Data Governance or Data Modeling Certifications (e.g., CDMP, Databricks, or TOGAF)

Mandatory Skills

aws, Technical Architecture, Aiml, SQL, Data Warehousing, Data Modelling

Job Summary

At PwC, our purpose is to build trust in society and solve important problems. We’re a network of firms in 157 countries with more than 208,000 people who are committed to delivering quality in Assurance, Advisory and Tax services.

Within Advisory, PwC has a large team that enables government organisations to transform and provide better service to citizens and optimize operations. The open position is for a candidate who desires to work with government clients and bring about a change in society. A successful candidate will be expected to work pro-actively and effectively on multiple client engagements over the period of time and take ownership of the entire project delivery he/she entrusted with.

Proposed role requires a candidate with relevant experience in Enterprise/Solution Architecture. He/She would have lead the process improvement and solution conceptualization and handled large integrations involving the latest technologies in the field of solution architecture. The architect should have a successful track record in managing and implementing e-government projects with particular focus on business components, and has contributed to the IT Strategy, maintenance of the information strategy and use architecture to support business and process change.

The candidate should strong interpersonal skills, who not only enjoys the challenge of working with other team members but externally with a diverse, senior-Government officials across varied Ministries and PSUs. Recent experience and understanding of the Indian business ecosystem and government initiatives is a must.

The candidate will be required to showcase excellent communication skills and will have demonstrated consistently the skill and capability in delivering impactful and insightful projects in the past. He/she will also be required to participate in client meetings and, during the course of a project, will be responsive to client enquiries, eventually leading the delivery engagement.

They will also be expected to contribute to Practice or Firm development. This may be adjudged in various ways such as serving as a mentor to other team members, by leading training/development initiatives, contributing to thought leadership papers, assisting other network firms etc.

Positions are with PwC’s Government and Public Service (G&PS) practice, which works

with Central & State Governments, PSUs, donor agencies etc. The position can be based in Delhi or Kolkata. However the ideal candidate should not have any constraints to travel for work related opportunities, whether domestic or internationally.