Job Description :
Job Description:
· In-depth SQL programming knowledge - partitioning, indexing, tuning knowledge, stored procedure, views
· Good acquaintance with DW concepts – start, snowflake schema, facts, dimensions, KPI, load strategies, surrogate keys, business keys, slowly changing dimensions, staging layer, information layer, analytic layer, data loading concepts
· Data model – Understanding of data model, OLTP, OLAP, Normalized and de-normalized schema, users
· Deep ETL concepts – Tool can be anything but should have deep knowledge in that. Should handle complex transactions like folder traversing, transaction handling, logging, auditing, error handling, data versioning with the tool, deployment concepts
· Azure Knowledge – Knowledge in various Azure PAAS offerings e.g. ADLS, Azure BLOB, Batch Service, Azure Data factory V1, Key Vaults etc.
· Code repository and versioning concepts
· Good understanding on Microsoft offerings such as SSIS, SSRS and Azure Analysis Service.
· Knowledge on CloverDX preferred, knowledge on Informatica acceptable.
· Lead the offshore developers