Associate Staff Engineer

Must have Skills

SQL Server Integration Services, Azure Synapse,

Job Description

• Expert in Database development (SQL queries, Stored procedures,views,indexes etc)
• Expert in building data pipelines using Azure Synapse , Azure Data factory and Azure Data Bricks.
• Good Exposure in creating Notebooks in Azure synapse for ingesting , analyzing and building data pipelines.
• Expert in data integration (ETL) best practices and techniques.
• Sound knowledge of Data Warehousing (Star/Snowflake schema) and solution designing concepts
• Good understanding of relational structures, dimensional data modelling
• Understanding of common ETL tools preferably SSIS Ability to design ETL unit test cases and debug ETL Mappings
• Familiarity with Data Governance concepts and tools (e.g. Data Quality tools, Master Data Management Tools)
• Experience in creating documentation for general and custom purposes
• Exposure to Agile (Scrum) development practices
• Should have good analytical ability
• Good written & verbal communication skills