Senior Data Modeler

2 days ago


Hyderabad, Telangana, India iTheme Consulting Full time ₹ 12,00,000 - ₹ 36,00,000 per year

Job Description :

We are hiring a Senior Data Modeler to lead enterprise-wide schema design initiatives for a major U.S.-based global banking client undergoing large-scale modernization. This is a critical, hands-on role for someone experienced in designing and evolving normalized relational schemas while collaborating with cross-functional teams including architects, data engineers, and business analysts. Youll be responsible for unifying schemas across legacy systems and event-driven architectures, supporting governance, and ensuring models are scalable, optimized, and well-documented.

This role is ideal for someone with deep expertise in 3NF modeling, relational databases (Oracle/Postgres), ER modeling tools, and schema optimization. Exposure to NoSQL, Kafka, or cloud-native data platforms is a plus.

Model : Hybrid (3 Days Onsite)

Client : US-based Global Banking Institution

Notice Period : 21 Days

Key Responsibilities :

- Design and maintain logical and physical data models following third normal form (3NF), covering relationships (1 : M, M : N), surrogate vs. natural keys, and schema evolution strategies.

- Collaborate with stakeholders to unify schemas across transactional systems, data lakes, and event-based pipelines.

- Optimize relational schemas for performance on RDBMS platforms like Oracle and Postgres, including indexing, partitioning, and constraint enforcement.

- Support legacy modernization efforts by contributing to NoSQL-to-RDBMS data migrations, including mapping transformations and normalization strategies.

- Create and maintain entity-relationship diagrams using tools like Erwin or ER Studio, and manage DDL generation, versioning, and documentation.

- Lead schema walkthroughs and review sessions with cross-functional teams, resolving naming conflicts, duplication issues, and data ownership boundaries.

- Maintain detailed metadata documentation, including data dictionaries, field definitions, and transformation logic using tools like Confluence or Excel.

- Contribute to schema decisions with awareness of event-driven design patterns, including event sourcing, snapshotting, and downstream consumption.

- Engage with DevOps or data engineering teams on model lifecycle management, schema versioning, and deployment practices.

Skills & Expertise

Required Skills :

- Strong hands-on experience in 3NF relational modeling, including independent ownership of subsystem-level models and schema refactoring without data loss.

- Deep technical expertise in Oracle and/or Postgres, including performance tuning, referential integrity, indexing strategies (B-Tree, Bitmap), and DDL validation with DBAs.

- Working knowledge of NoSQL modeling (preferably MongoDB), including document structure design, indexing, and embedded vs. referenced data strategies.

- Proficiency with ER modeling tools such as Erwin or ER/Studio, including forward/reverse engineering and model versioning.

- Experience maintaining attribute-level metadata, data dictionaries, and supporting model rationale documentation.

- Effective stakeholder collaboration, including conducting schema walkthroughs and resolving architectural/data design conflicts.

- Awareness of event-driven design principles, such as event sourcing, schema evolution tied to domain events, and schema compatibility.

- Involvement in data migration from NoSQL to RDBMS, including mapping challenges, data quality impact, and normalization strategies.

Nice-to-Have Skills :


- Understanding of ETL tools like Informatica or Talend and how schemas impact transformation logic.

- Familiarity with cloud-native schema design using Redshift, BigQuery, or Azure SQL, and catalog integration (e.g., AWS Glue).

- Experience with version control for data models using Git or SVN.

- Exposure to data governance tools such as Collibra or Alation and concepts like metadata management and business glossary alignment.

- Knowledge of banking and financial services domains, including customer, account, transaction, or instrument data models.


  • Senior Data Modeler

    4 days ago


    Hyderabad, Telangana, India Info Services Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Senior Data ModelerFinancial District, Hyderabad or Navalur, ChennaiFull-time with Info ServicesSalary: Try to get under 35 LPA, but it is openRole OverviewWe are seeking an experiencedData Modelerto design, develop, document, and manage logical and physical data models supporting Oracle databases, data warehouse environments, and BI reporting tools such as...

  • Lead Data Modeler

    3 weeks ago


    Hyderabad, Telangana, India Unison Group Full time

    ob Overview:We are seeking a highly experienced Lead Data Modeler with deep expertise in Data Vault 2.0, VaultSpeed, and enterprise data modeling concepts. The ideal candidate will be responsible for designing scalable and maintainable data models, including Hubs, Satellites, Links, and Bridge tables. This role will act as a technical lead, managing offshore...


  • Hyderabad, Telangana, India INUMELLAS CONSULTANCY SERVICES PRIVATE LIMITED Full time

    Role - Data Architect/Data ModelerExp - 12 to 16 YrsLocations - Chennai, Hyderabad, Bengaluru, Delhi, PunePosition - PermanentCurious about the role? What your typical day would look like ?As a Senior Data Engineer, you will work to solve some of the organizational data management problems that would enable them as a data-driven organization; Seamlessly...

  • Data Modeler

    1 week ago


    Hyderabad, Telangana, India YO IT Group Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Experience:8 to 12 YearsRequired Qualifications8 to 12 years of experience as a Data Modeler or in a similar data architecture role.Strong domain expertise in Private Equity, Investment Management, or Asset Management (fund structures, portfolio data, investor reporting, valuations).Proven experience creating canonical models and developing logical &...

  • Data Modeler

    1 week ago


    Hyderabad, Telangana, India AALUCKS Talent Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Position : Data ModelerDepartment : Information Technology Role : Full-time Experience : 8 to 12 Years Number of Positions : 1 About the Role : We are seeking an experienced Data Modeler with strong expertise in the Private Equity and Investment domain. The ideal candidate will have a proven track record of designing and implementing...

  • Data Modeler

    2 days ago


    Hyderabad, Telangana, India Talent Worx Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    We are seeking a skilled Data Modeler to join our dynamic team. In this role, you will be responsible for designing and implementing data models that support our data strategy and business objectives. You will work closely with business stakeholders, data engineers, and analysts to ensure that our data is structured in a way that promotes accessibility,...

  • Data Modeler

    6 days ago


    Hyderabad, Telangana, India Prudent Globaltech Solutions Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    We are seeking an experienced Data Modeler with a strong background in real estate, investment management, and master data management. The ideal candidate will be responsible for designing, implementing, and maintaining data models that support our business objectives. This role requires a deep understanding of data architecture, data integration, and...

  • Data Modeler

    2 weeks ago


    Hyderabad, Telangana, India Two95 International Inc. Full time ₹ 1,20,000 - ₹ 3,00,000 per year

    Title: Data ModelerLocation: Hyderabad(Hybrid)Duration: Full time Salary: 20-22LPA(INR). Time : 1pm to 10PmRequirementsWhat you will be doing:Work as a team member to build a data warehouse on Snowflake This role will be responsible for creating, implementing, and maintaining data models for database platform and code table changes within the enterprise that...

  • Data Modeler

    4 weeks ago


    Hyderabad, Telangana, India Anblicks Full time

    Key Responsibilities:· Design and develop enterprise-grade data models (3NF, Dimensional, and Semantic) to support analytics and operational use cases· Collaborate with business and engineering teams to define data products aligned to business domains· Translate complex mortgage banking concepts into scalable and extensible models· Ensure alignment with...

  • Data Modeler

    2 days ago


    Hyderabad, Telangana, India Algoleap Technologies Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    SUMMARY Must have:   Experience with AWS, SQL, and Data Modeling toolsGood to have:  Exposure to data warehousing concepts and tools (e.g., Redshift, Snowflake)Minimum Experience:  5+ yearsRequirementsPosition SummaryPosition TitlePosition Brief SummaryNo. of RolesData ModelerThe Data Modeler in this role will collaborate with IDP's Data Engineering...