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 multiclient SAAS solutions.
- Must be expert at communicating technical issues to nonbusiness users.
- Must have a businessoriented 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.