<p>Key Responsibilities :<br/><br/>- Experience in data modelling and database design.<br/><br/>- Experience in MS SQL Server (i.e., tables, views, stored procedures, indexes, triggers, constraints, etc.)<br/><br/>- In-depth ETL development experience working with Microsoft SQL Integration Services (SSIS) or Azure data factory using all areas of the environment, including scripting.<br/><br/>- Hands on experience in writing complex SQL queries for KPI calculations<br/><br/>- Preferred experience in working on Azure Services like Azure Data Factory, Azure data lake storage (ADLS), Azure Blob Storage, Azure Synapse Analytics (Azure Data Warehouse), Azure Analysis Services<br/><br/>- Solid understanding of database design principles.<br/><br/>- Good to have experience in data migration between multiple environments, on premises to cloud, etc<br/><br/>- The candidate must also have had experience in data warehousing inclusive of dimensional modeling concepts and data lake concepts with practical knowledge of Data Modeling and implementation.<br/><br/>- Nice to have experience working with varied forms of data infrastructure inclusive of relational databases (MySQL, Oracle etc), column-oriented databases (Redshift, Teradata etc) & No SQL databases (Mongo DB, Cassandra etc) would be good to have.<br/><br/>- Demonstrate proficiency in at least one scripting languages, for example, Python, Scala, Power Shell etc.
This would be again good to have.
<br/><br/>- Experience in analysing very large real-world datasets and hands-on approach in data analytics will be a plus.<br/><br/>- Experience with Test Driven Development, Continuous Integration, Continuous Deployment etc.<br/><br/>- Strong analytical and technical skills.<br/><br/>- Good verbal and written :</p><p><br/></p><p>- Graduate(BE/B.Tech)/ Masters(ME/M.Tech/MS) in Computer Science or equivalent from a premier institute.</p> (ref:hirist.tech)