Talent.com
This job offer is not available in your country.
Senior Data Modeler - ETL / Informatica

Senior Data Modeler - ETL / Informatica

iTheme Consulting Pvt LtdHyderabad
10 hours ago
Job description

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.

    • (ref : hirist.tech)

    Create a job alert for this search

    Data Modeler • Hyderabad