ETL Lead - SQL/SSAS (10-12 yrs)

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.