ETL Lead

Custom Software Engineer

Project Role : Custom Software Engineer
Project Role Description : Design, build and configure applications to meet business process and application requirements.
Must have skills : Data Engineering
Good to have skills : NA
Minimum 7.5 year(s) of experience is required
Educational Qualification : 15 years full time education

Summary:
We are looking for a highly skilled and experienced ETL Lead with a strong background in Data Warehousing, ETL processes, and Big Data technologies. The ideal candidate should have hands-on experience with Cloudera tools, excellent SQL/PLSQL skills, and the ability to lead a team while working closely with clients in the Banking/Insurance domain.

Roles & Responsibilities:
Design, develop, and maintain end-to-end Data Warehouse and ETL solutions.
Work extensively with SQL, PLSQL, Oracle, Hadoop, and Cloudera Data Platform tools (Spark, Hive, Impala).
Lead a team of 4+ engineers, guiding both technical and operational tasks.
Manage daily operations and provide L1/L2/L3 support, ensuring no SLA breaches.
Collaborate with clients to understand requirements and provide scalable, reliable solutions.
Conduct team meetings, client discussions, and knowledge transfer (KT) sessions.
Utilize Shell scripting, Unix commands, and have working knowledge of Java/Python for task automation and integration.
Ensure the team follows best practices in coding, documentation, and support.
Stay up to date with new technologies and demonstrate a willingness to learn as per client needs.
Be available to work from client location and travel daily as required.
Proficient in analysing and rewriting legacy systems.
Solid team leadership skills with experience managing 4+ people.
Excellent communication and interpersonal skills.
Demonstrated ability to manage operations and support teams efficiently.
Willingness to work from the client location and travel as required.
Proactive and positive attitude toward learning and adopting new technologies.
Strong analytical skills and solution-oriented mindset.
Ability to work under minimal supervision in a fast-paced environment.


Professional & Technical Skills:
8+ years of experience in Data Warehousing and ETL Technologies.
Strong expertise in SQL, PLSQL, Oracle, and Hadoop ecosystem.
Hands-on experience with Spark, Hive, Impala on Cloudera Data Platform.
Strong understanding of the Banking/Insurance domain.
Understand legacy code and translate it effectively to modern technologies.

Additional Information:
- The candidate should have minimum 7.5 years of experience in Data Engineering.
- This position is based in Mumbai.
- A 15 years full time education is required.