ETL Lead

Title: ETL Lead

Location: Hyderabad

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.