Lead ETL Developer
Job Description:
We are looking for a Lead ETL Developer to join our C3 Data team based in Bangalore. This role offers a unique opportunity to work on Clarivate Customer Cloud (C3) and make rich content available across the Clarivate platform to all customers. As the Lead ETL Developer, you will support the data team by loading new content to Clarivate Customer Cloud, and you will have the chance to work with modern, cutting-edge big data technologies. Our team has expertise in Python, Spark, Databricks, EMR, PySpark, Airflow, AWS, and we would love to speak with you if you have experience in Spark, Databricks, or PySpark.
About You:
• 5+ years of experience in building ETL pipelines and proficiency in PySpark.
• Strong SQL and non-SQL database skills.
• Proficient in Python3 and experience with Apache Spark and/or Databricks.
• Passionate about code and software architecture.
• Strong communication skills at all levels and excellent interpersonal skills.
• Self-motivated and confident in working on projects independently or as part of a team.
• Enthusiastic about expanding knowledge and learning new skills.
• Committed to quality work and attention to detail.
It would be a plus if you have experience in:
• Docker
• AWS services: EC2, ECS, RDS, EMR, S3
• ElasticSearch, Presto, Snowflake
• Oracle, PostgreSQL
• Trifacta
Key Responsibilities:
• Providing technical leadership and guidance, evaluating various technologies to balance business needs and cost-effectiveness.
• Collaborating with business and IT teams to design and implement a data lake platform.
• Maintaining the overall solution architecture for the data lake platform.
• Establishing technical best practices for big data management and solutions, from technology selection to architecture and implementation.
• Ensuring all components of the data lake platform meet SLAs.
• Leading technical investigations, POCs, and hands-on coding to make technical recommendations.
• Mentoring and coaching team members to enhance their technical and professional skills.