Technical Lead - Data Warehousing & Synapse Analytics

Azure Synapse Technical Lead (Sr. Hands-On Developer) Responsible for overseeing the entire lifecycle of a data mart, including data requirement analysis, design, and development of Azure Synapse pipelines, as well as setting up workflows and dependency - Design and develop pipelines from scratch based on existing requirements; analyze existing report queries and database procedures/functions in SQL Server. - Enhance and optimize existing Synapse pipelines for performance and high data quality. - Set up dependencies between external and internal job processes to ensure end-to-end system integrity. - Develop and customize Synapse pipelines according to end-user requirements. - Develop ETL/ELT load processes: - Analyze source system data structures and fields. - Extract data from source systems using big data technologies (Spark Pool). - Create data mapping documentation, including transformation rules, default values, and selection criteria. - Implement, program, and configure transformation rules, as well as structure/field/value mapping. - Evaluate the quality of data in the data warehouse/Data Mart. - Manage source code control, Pull Requests, and Code Qualifications - 8 to 12 years of experience in Data Warehouse development, including at least 3-5 years in Azure Synapse, SQL Data Warehouse, or Dedicated SQL Pool. - Hands-on ETL coding experience in at least 2 projects as a Team Member or Team Lead, focusing on ETL coding using Azure Synapse, SQL Data Warehouse, or Dedicated SQL Pool. - Experience in designing and developing Synapse Pipelines for STAR Schemas (Type 1, Type 2, Role-Playing Dimensions, Facts) in at least 2 projects. - Proficiency in working with relational and big data technologies such as SQL Server, Oracle, SQL Pool, and Spark Pool. - Strong ability to communicate with business teams using business language. - Knowledge of Project Management Methodologies and principles. - Experience with billing and revenue management. (ref:hirist.tech)

Location: noida, IN

Posted Date: 4/11/2025