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
