2 ERwin Jobs in Bangalore (Bengaluru) | ERwin Job openings in Bangalore (Bengaluru)

Hiring: Data Modeler

Experience: 6+ years

Location: Bangalore/Gurugram/Pune

Required Skills

• Hands-on experience in conceptual, logical, and physical data modeling.
• Strong knowledge of ER modeling, dimensional modeling, star/snowflake schemas, fact/dimension tables, and SCDs.
• Strong SQL skills for data profiling, validation, and quality checks.
• Experience with source-to-target mapping, data dictionaries, metadata, and data lineage.
• Proficiency in Erwin, ER/Studio, or similar modeling tools.
• Exposure to Snowflake, Databricks, Redshift, SQL Server, or other data platforms.
• Understanding of data governance, UAT, reconciliation, and Agile methodologies.
• Strong analytical, documentation, and stakeholder management skills.

Preferred Qualifications

• Experience in enterprise data warehousing or lakehouse modeling.
• Knowledge of data products, data contracts, quality SLAs, and reusable datasets.
• Exposure to dbt, data cataloging, metadata management, and governance tools.
• Ability to work independently in a fast-paced environment.

If interested please share your cv at : snigdhaattheratebeanhr.com

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