Azure Data Solutions Architect

TCS Hiring for Azure Data Solutions Architect\n\nExperience Range: - 08 To 10 Years (Mandatory)\n(Note: Candidates below 8 years of IT experience shall not be considered)\nJOB LOCATION: Pan India\n\nJOB DESCRIPTION\n\nResponsibilities:\n\nArchitect Data patterns like batch or real time data in the Azure lake and ensure requirements are well designed\nWork with business stakeholders and create data marts to be used for reporting\nCreate and maintain data pipelines to transform and load data from data lake into Datawarehouse models\nCreate and maintain data marts, data catalogue, data lineage, etc.\nEnable data quality checks and scheduling for timely delivery of data\nResponsible for end-to-end building of requisite data models - Conceptual, Logical, Physical, work with partner teams - business users, DMO, etc. to ensure seamless implementation of the Entity Relationship from business / operational to logical, and to physical\nWork with data owners, producers, and DMO to define criteria for authoritative data sources, ownership, and governance process; identify and determine the authoritative data sources (ADS) / Source System of Record (SSOR) from existing sources\nResponsible for the tooling landscape for data modeling including the analysis / assessment, evaluation, and finalization of the tool platform\nDesign and coordinate the data model maintenance and update workflow including the frequency, scope, and review processes, etc.\nResponsible for ensuring the data models are kept updated with implemented changes communicated with relevant stakeholders\n\nFunctional or Technical Competencies:\n\nMust have knowledge of data warehouse concept (Star or snowflake) methodology and experience in designing data warehouse dimensional modelling\nMust have hands-on experience in Azure Data Factory, Azure Databricks , Datawarehouse, Spark programming in Scala or python (for batch and real time) and Python\nMust have experience in Data architecture and in designing in Azure Stack\nExperience and knowledge in Financial Regulatory Reporting & Standards such as BCBS 239\nExperience in building effective and robust data models - Conceptual, Logical, Physical coupled with a strong ability to conceptualize Entity-Relationships, apply normalization / denormalization for redundancy management, standardize naming conventions, etc.\nExperience with data modeling tools and/or ER Diagramming tools such as ER Studio and/or Erwin is a plus\n\nGood to have aspects:\n\nPreferably with relevant certifications from Microsoft including Azure Data Engineer Associate, Databricks\nExperience in Data Management & Governance and associated platforms such as Collibra, Unity Catalog\n\nMinimum Qualification:\n15 years of Full Time Education\n\nInterested candidates kindly share your updated resume to immediately with the details below (Mandatory)\n\nName:\nContact No.\nEmail id:\nSkillset:\nTotal exp:\nRelevant Exp:\nFulltime highest qualification (Year of completion with percentage scored):\nCurrent organization details (Payroll company):\nCurrent CTC:\nExpected CTC:\nNotice period:\nCurrent location:\nPreferred Location:\nAny gaps between your education or career (If yes pls specify the duration):\nWill you be able to join within 30/45 days? (Yes/NO)