Job Description:

• Proven expert at writing SQL code with at least 7 years of experience. 
• Must have 5+ years of experience working with large data with transactions in the order of 5 – 10M records. 
• Expert at performance tuning, Transactions, DeadLock management, Triggers etc. 
• Proven expert in Modeling enterprise grade databases and architecture. Very strong at Entity Relationship. 
• 5+ years of experience modeling loosely coupled relational databases that can store tera or petabytes of data. 
• 3+ years of proven expertise in working with large Data Warehouses. 
• Must have ability to conceptualize ideas and data streams to schemas. 
• Expert at ETL transformations using SSIS. 
• Good knowledge of analytics tools like AWS QuickSight. 
• 4+ Years of proven experience working with high volume multi-client SAAS solutions. 
• Must be expert at communicating technical issues to non-business users. 
• Must have a business-oriented thought process. 
• Proven expert at setting up standards and coding process 
• Must have worked with Source Code Control tools like Bitbucket/GIT. 
• Must have done code reviews for the team. 

Tools used: MySQL, AWS – DW, Postgresql

Desirable 

• Prior experience working in the utility domain. 
• Any DB/DW certifications from Microsoft or equivalent. 
• Any knowledge of Data Science and Statistics is a plus.