Job Title : Data Modeler - Wholesale Lending Data Domain

Location : Chennai / Mumbai

Year of Experience- 6 to 12 years

Key Responsibilities :

1. Data Modeling & Design

- Develop conceptual, logical, and physical data models for the Wholesale Lending domain/ applications/ platforms (e.g., Loans, Credit Facilities, Collateral, Exposure, Covenants, Customers, and Accounts).

2. Business Alignment & Data Domain Enablement

- Translate complex business requirements into data model structures that align with domain-driven design principles.

3. Technical Implementation Support

- Work with Data Engineers to ensure models are implemented accurately in data warehouses / data lakes / data mesh environments (e.g., Snowflake, Databricks, Teradata).

4. Data Governance & Quality

- Contribute to the data catalog, metadata management, and lineage documentation (e.g., using Collibra, Alation, Atlan, or Informatica EDC).

5. Continuous Improvement & Innovation

- Recommend opportunities for model optimization, standardization, and reusability across domains (Retail, Treasury, Risk).

Required Skills & Qualifications :

Technical Skills :

- Strong expertise in data modeling tools (e.g., ER/Studio, ERwin, PowerDesigner).

- Deep understanding of relational, dimensional, and data vault modeling.

- Experience with cloud data platforms (Snowflake, Azure Synapse, GCP BigQuery, AWS Redshift, Databricks).

- Strong knowledge of SQL, PL/SQL, proficiency and ability to review data mappings.

- Familiarity with data governance tools (Collibra, Alation, Informatica, Atlan).

- Understanding of metadata management, lineage, and cataloging principles.