<p>Role - Data Warehouse Engineer</p> <p>Experience Required - 10+ Years</p> <p>Must Have Technical/Functional Skills</p> <p>10+ years of experience SSRS , Databricks, Data Lake Storage Gen2, Azure Analysis Services</p> <p>CI/CD, Git, Jenkins/GitHub/Azure DevOps pipelines</p> <p>Strong communication, stakeholder management, and problem-solving skills.</p> <p>Roles & Responsibilities</p> <p>Architecture & Strategy</p> <p>Designing and implementing cloud-based data warehouses using Azure Synapse Analytics (formerly SQL DW) to create a single source of truth.</p> <p>Building pipelines with Azure Data Factory (ADF) or Azure Databricks to ingest, transform, and load data from diverse sources into the warehouse.</p> <p>Developing dimensional models (fact and dimension tables) within the Gold layer of the Medallion architecture to enable efficient BI reporting.</p> <p>Tuning SQL queries, managing indexes, partitioning, and scaling Synapse compute resources to maintain high performance.</p> <p>Integrating structured relational data with unstructured data from Azure Data Lake</p> <p>Analyze COBOL programs, copybooks, JCL workflows, CICS/IMS transactions, DB2 schemas, and VSAM files.</p> <p>Base Salary Range : $100,000 to $125,000 Per Annum</p> <p>TCS Employee Benefits Summary:</p> <p>Discretionary Annual Incentive.</p> <p>Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.</p> <p>Family Support: Maternal & Parental Leaves.</p> <p>Insurance Options: Auto & Home Insurance, Identity Theft Protection.</p> <p>Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.</p> <p>Time Off: Vacation, Time Off, Sick Leave & Holidays.</p> <p>Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.</p>