ETL Development Lead

Job Title: ETL Development Lead (7+ years)

Location : Bangalore, Hyderabad, Chennai, Pune, Vadodara

Work Mode: Hybrid
Job Type: Full-Time

Shift Timings: 2:00 - 11:00 PM

Budget: 18 to 25 LPA

Job Description :

• Experience with Leading and mentoring a team of Talend ETL developers.
• Providing technical direction and guidance on ETL/Data Integration development to the team.
• Designing complex data integration solutions using Talend & AWS.
• Collaborating with stakeholders to define project scope, timelines, and deliverables.
• Contributing to project planning, risk assessment, and mitigation strategies.
• Ensuring adherence to project timelines and quality standards.
• Strong understanding of ETL/ELT concepts, data warehousing principles, and database technologies.
• Design, develop, and implement ETL (Extract, Transform, Load) processes using Talend Studio and other Talend components.
• Build and maintain robust and scalable data integration solutions to move and transform data between various source and target systems (e.g., databases, data warehouses, cloud applications, APIs, flat files).
• Develop and optimize Talend jobs, workflows, and data mappings to ensure high performance and data quality.
• Troubleshoot and resolve issues related to Talend jobs, data pipelines, and integration processes.
• Collaborate with data analysts, data engineers, and other stakeholders to understand data requirements and translate them into technical solutions.
• Perform unit testing and participate in system integration testing of ETL processes.
• Monitor and maintain Talend environments, including job scheduling and performance tuning.
• Document technical specifications, data flow diagrams, and ETL processes.
• Stay up to date with the latest Talend features, best practices, and industry trends.
• Participate in code reviews and contribute to the establishment of development standards.
• Proficiency in using Talend Studio, Talend Administration Center/TMC, and other Talend components.
• Experience working with various data sources and targets, including relational databases (e.g., Oracle, SQL Server, MySQL, PostgreSQL), NoSQL databases, AWS cloud platform, APIs (REST, SOAP), and flat files (CSV, TXT).
• Strong SQL skills for data querying and manipulation.
• Experience with data profiling, data quality checks, and error handling within ETL processes.
• Familiarity with job scheduling tools and monitoring frameworks.
• Excellent problem-solving, analytical, and communication skills.
• Ability to work independently and collaboratively within a team environment.
• Basic Understanding of AWS Services i.e., EC2 , S3 , EFS, EBS, IAM , AWS Roles , CloudWatch Logs, VPC, Security Group , Route 53, Network ACLs, Amazon Redshift, Amazon RDS, Amazon Aurora, Amazon DynamoDB.
• Understanding of AWS Data integration Services i.e., Glue, Data Pipeline, Amazon Athena , AWS Lake Formation, App Flow, Step Functions

Preferred Qualifications:

• Experience with Leading and mentoring a team of 8+ Talend ETL developers.
• Experience working with US Healthcare customer..
• Bachelor’s degree in computer science, Information Technology, or a related field.
• Talend certifications (e.g., Talend Certified Developer), AWS Certified Cloud Practitioner/Data Engineer Associate.
• Experience with AWS Data & Infrastructure Services..
• Basic understanding and functionality for Terraform and Gitlab is required.
• Experience with scripting languages such as Python or Shell scripting.
• Experience with agile development methodologies.
• Understanding of big data technologies (e.g., Hadoop, Spark) and Talend Big Data platform.

Job Types: Full-time, Permanent

Pay: ₹1,800,000.00 - ₹2,500,000.00 per year

Schedule:

• Day shift
• Monday to Friday

Ability to commute/relocate:

• Bangalore, Karnataka: Reliably commute or planning to relocate before starting work (Required)

Education:

• Bachelor's (Required)

Experience:

• ETL: 7 years (Required)
• Talend: 7 years (Required)
• Python: 6 years (Required)

Work Location: In person