ETL Lead - SQL/SSAS

About the Role : ETL Lead- Contractual Job Monthly Pay : 1,80,000 Duration : 6 Month Location : Hyderabad Mode - Work From Office (5 Days) Time - India Time and U.S overlap. Timings : Full Time (As per company timings) Notice Period : within 15 days or immediate joiner Experience : 10 Years Job Description : - Proven expert at writing SQL code with at least 10 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. (ref:hirist.tech)

Location: hyderabad, IN

Posted Date: 12/28/2024