Lead SQL/ETL Developer - Data Warehousing (10-13 yrs)

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