Data Modeler - FSLDM

ITC Infotech is looking for Data Modeler - FSLDM to join our team in United States remotely. Job Summary: We are looking for a highly experienced Data Modeler with strong expertise in Teradata FSLDM to support a large-scale Financial Services Lakehouse program. The role involves designing and optimizing Lakehouse architecture (Bronze/Silver/Gold layers), developing ETL/ELT pipelines using Informatica (PowerCenter/IICS), and ensuring high-performance data processing within Teradata environments. Strong Banking/Financial Services domain knowledge and data governance experience are essential. Key Responsibilities • Data Modeling: Lead the implementation and customization of the Teradata FSLDM (Financial Services Logical Data Model) to ensure it meets the specific needs of the Lakehouse program. • Architecture Design: Design and maintain the Data Lakehouse layers (Bronze/Silver/Gold or Raw/Integrated/Access) to support massive scales of financial data. • ETL/ELT Development: Architect and develop robust data pipelines using Informatica (PowerCenter or IICS) to migrate data from disparate sources into Teradata and the Lakehouse environment. • Performance Tuning: Optimize Teradata SQL and Informatica mappings for high-volume data processing and complex financial calculations. • Data Governance: Ensure compliance with financial regulations by implementing data lineage, quality checks, and metadata management within the FSLDM framework. • Stakeholder Collaboration: Work closely with Business Analysts and Data Scientists to translate financial business requirements into scalable technical schemas. Technical Requirements • Core Model: Expert-level knowledge of FSLDM (Financial Services Logical Data Model) is mandatory. • Primary Database: Extensive experience with Teradata (Vantage, Architecture, Utilities like BTEQ, FastLoad, MultiLoad). • Integration Tools: Advanced proficiency in Informatica (PowerCenter/Informatica Intelligent Cloud Services). • Lakehouse Experience: Proven experience in building or maintaining Data Lakehouse architectures (combining the flexibility of data lakes with the performance of data warehouses). • Domain Knowledge: Strong understanding of Banking/Financial Services domains (Risk, Finance, Regulatory Reporting, or Retail Banking). ITC Infotech is an Equal Opportunity Employer. We believe that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion, or sexual orientation. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law. ITC infotech is committed to providing veteran employment opportunities to our service men and women.