ETL Lead

Job Title : ETL Talend Lead

Location : Bangalore, Hyderabad, Chennai, Pune

Work Mode : Hybrid

Job Type : Full-Time

Shift Timings : 2 : 00 - 11 : 00 PM

Years Of Experience : 8 - 15 years

ETL Development Lead :

• 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, AppFlow, Step Functions

Preferred Qualifications :