ETL Lead

People's Growth HR Solutions; Hyderabad; On-site; INR 2,500,000 - 4,500,000; Full time

Job summary

People's Growth HR Solutions in Hyderabad seeks a senior SQL expert with 10+ years of experience to build and optimize large data platforms for multi-client SaaS environments.

You will model databases, run ETL with SSIS, and ensure scalable data warehousing. Communicate complex concepts to non-technical stakeholders, enforce coding standards, and manage Git/Bitbucket workflows.

Qualifications

• 10+ years of SQL coding experience.
• 5+ years large data with 5-10M records.
• Expert in performance tuning and transactions.
• Experience modelling enterprise-grade databases.
• 5+ years in data warehousing.
• ETL transformations with SSIS.
• Experience with AWS QuickSight for analytics.
• 4+ years in high-volume multi-client SAAS.
• Ability to communicate technical issues to non-business users.
• Experience with source control (Git/Bitbucket).
• Code reviews experience.
• Experience in utility domain.
• DB/DW certifications desired.

Responsibilities

• Write SQL with deep expertise and maintain efficiency.
• Handle very large data volumes and multi-tenant requirements.
• Tune performance, manage transactions and deadlocks.
• Model enterprise-grade databases and ER diagrams.
• Design schemas for tera/petabyte data stores.
• Work with data warehouses and ETL (SSIS).
• Translate data streams into usable schemas.
• Leverage AWS QuickSight for analytics and reporting.
• Enforce coding standards and perform code reviews.
• Collaborate with teams in a high-volume SaaS environment.
• Communicate technical concepts to non-technical stakeholders.
• Maintain robust source control (Git/Bitbucket).
• Apply domain knowledge in utilities.

Skills

SQL

Performance tuning

Deadlock management

Transactions

Data modeling

ER modeling

Data warehousing

ETL transformations

Coding standards

Git/Bitbucket

Code reviews

Communication to non-technical users

Education

DB/DW certifications (Microsoft or equivalent)

Tools

AWS QuickSight

SSIS

Git

Bitbucket

Job description

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.
• 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.