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