Cutshort logo

2+ ERwin Jobs in India

Apply to 2+ ERwin Jobs on CutShort.io. Find your next job, effortlessly. Browse ERwin Jobs and apply today!

icon
Bengaluru (Bangalore)
4 - 8 yrs
₹18L - ₹22L / yr
skill iconAmazon Web Services (AWS)
SQL
Datawarehousing
Data modeling
ERwin
+1 more

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 stackdata 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 warehousingRDBMS, and ETL tools like AWS GlueIBM 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 TableauPower BI, or AWS QuickSight.

·               Exposure to DevOps/CI-CD pipelinesAI/MLGen AINLP, and polyglot programming is a plus.

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

·               Domain knowledge in RetailManufacturingHR, 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., CDMPDatabricks, or TOGAF)

 

Mandatory Skills

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

Read more
PwC

at PwC

Agency job
via Randstad India by Shreya Chaudhary
Jaipur, Delhi, Gurugram, Noida, Ghaziabad, Faridabad
10 - 15 yrs
₹15L - ₹20L / yr
Project Management
TOGAF
PMP
PRINCE2
Oracle DBA
+9 more

Position Title: Enterprise Architect Expert

Grade/Level: Principal Consultant

LoS: Advisory

Sub LoS/SBU: Government & Public Sector

Location: New Delhi/Jaipur

Position Type: Full time

Subject Matter Expertise: Enterprise/Solution Architect


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.

 

Roles & Responsibilities:

  • Provide input to team for presenting assessment and analysis findings in EA framework to stakeholder on matters related to strategy, organizations, and governance.

  • Provide support and assistance in selecting the most appropriate EA approach for detailed development with focus on increasing its effectiveness.

  • Work with team members and provide inputs in developing architecture and standards with emphasis on various aspects of EA.

  • Work with other team members to develop the broad structure of EA framework with focus on governance decisions, structures and mechanisms to primarily elevate the role and impact of enterprise architecture within government departments, and to ensure that architecture thinking permeates in the ecosystem.

  • Coordination between selected agencies/SI and purchaser/Department for technical issues.

  • Share lessons learned and best practices across programs, building relationships with stakeholders and brokering relationships at all levels.

  • Coordination of project Governance arrangements, Post Project Reviews, Programme level workshops.

  • Issue tracking and resolution, status reporting and monitoring, service Level Agreement (SLA) monitoring.

 

Educational Qualifications

 

  • Post-Graduation: MCA/MSc/M.Tech (Computer Science, Information Technology, Electronics).

  • Graduation: BE/BTech (Computer Science, Information Technology, Electronics).

 

Certifications

Having one or more of the following certifications will be an added advantage:

  • TOGAF

  • PMP

  • Prince 2

 

Work Experience

  • Have 9 years+ of experience of working on ICT projects, with demonstrable experience on enterprise architecture and interoperability issues.

  • Have hands-on experience working with major architecture components: business process, information, and infrastructure.

  • Previous experience as a successful enterprise architect for government is highly desirable.

  • Demonstrated experience in inter-platform application design and implementation.

  • Experience and proficiency with data modelling and data architecture of highly scalable, multi-tenant environments.

  • Experience in the field of Software Development, software project implementation

  • Experience in prevalent project methodologies e.g. Agile and its estimation

  • Knowledge of new age technology like microservice, devops and API architecture.

  • Have good skills in strategic planning and policy level document development.

  • Experience of working with Government (Central, State, ULBs)/related agencies is preferred in India or internationally.

  • Extensive experience in designing systems and propose innovative solutions.

  • Experience in working in Government sector will be added advantage

  • Experience in Oracle suite like Oracle database, Exadata, WebLogic, Oracle SOA , Oracle IDM will be preferred.

 

Tools & Techniques

  • Candidate should have experience in various EA tools like IBM Rational rose , EA Modelling tool, Erwin, Bizzdesign, Software AG etc.

  • Thorough knowledge of MS Excel, Power Point and other project management tools.

 

Required Skill Sets

  • Conduct assessment and analysis not limited to working knowledge and experience with application process improvement techniques and best practices, software engineering concepts and project management methodologies.

  • Ability to review different software architecture document, technical design document etc.

  • Conduct consultation on application and software with related stakeholders

  • Work with team members and provide inputs in developing architecture and standards with emphasis on the ICT aspects of EA

  • Design, develop and implement interoperability framework .Provide inputs on EA related to data - storage, access, sharing and exchange and application – cross-cutting application capabilities

  • Contribute to various development of all reference models

  • Proven experience in providing service to internal stakeholders to achieve successful project outcomes. Hands-on approach to project management.

    Personality traits (desired)

    • Strong communications skills, both written and verbal. Communicating passion, energy, intensity, and excitement in a direct, apolitical, way.

    • Ability to handle complex assignment independently.

    • Ability to work with ambiguity. Taking a systematic, structured view of situations.

    • Team player - Work in a large team with people from diverse backgrounds.

    • Ability to interact with client (senior government officials).

    • Driving to root causes and able to identify trends, process improvement opportunities and broader business implications.

    • Demonstrating willingness to ‘get hands dirty’ and developing a problem-solving attitude.

    • Plans, manages and drives own efforts to successfully deliver client commitments.

    • Willingness and ability to handle multiple projects with competing deadlines, working with individuals who have different working styles, and managing challenging expectations.

    • Taking ownership of each project by doing what is needed at all phases of the process, anticipating next steps and not waiting to be told what to do.

    • Ability to prioritize in own workload to realign resources where/when needed.

    • Strong personal and professional presence and self-confidence, capable of working effectively with senior team as well as all other levels.

    • High drive, energy and work ethic; creative, flexible and adaptive in leading change.

    • Engaging interpersonal style and excellent relationship building skills, with the desire and ability to coach and mentor team members.

      The skills we look for in future employees:

       

      All our people need to demonstrate the skills and behaviours that support us in delivering our business strategy. This is important to the work we do for our business, and our clients. These skills and behaviours make up our global leadership framework, ‘The PwC Professional’. The PwC Professional focuses on five core attributes; whole leadership, business acumen, technical capabilities, global acumen and relationships. We use this framework to recruit, develop and assess our people, at all grades and all areas of our business, because we expect all of our people to be leaders

       

     

Read more
Get to hear about interesting companies hiring right now
Company logo
Company logo
Company logo
Company logo
Company logo
Linkedin iconFollow Cutshort
Why apply via Cutshort?
Connect with actual hiring teams and get their fast response. No spam.
Find more jobs
Get to hear about interesting companies hiring right now
Company logo
Company logo
Company logo
Company logo
Company logo
Linkedin iconFollow Cutshort