Tata Consultancy Services - Data Modeler - Wholesale Lending Data Domain

Job Title : Data Modeler - Wholesale Lending Data Domain

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 & 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.

(ref : iimjobs.com)