Lead Data Engineer

2 days ago

Chennai, India Resourcetree Full time

Job Description :


We are seeking a highly skilled and motivated Lead/Senior Data Engineer to join our. Data Integration and Analytics team. The ideal candidate will bring deep expertise in AWS Redshift, with strong knowledge of Redshift architecture, query performance tuning, and workload optimization.


You will be responsible for leading the design, development, and optimization of scalable ETL/ELT pipelines that enable efficient data integration and power critical business intelligence and analytics initiatives. This role requires a proven ability to troubleshoot complex data challenges, drive performance improvements, and ensure our data ecosystem is both scalable and cost-efficient. A passion for continuous learning, problem-solving, and enabling data-driven decision-making is highly valued.


Primary Skills : AWS,ETL Concepts, Data Integration Tool (Any)


Secondary Skills : Python, Datastage, Informatica IICS, Informatica, SSIS


Role Description :


The Lead Data Engineer will be responsible for overseeing the design, development, and maintenance of our data infrastructure and pipelines. This role requires strong technical expertise, leadership skills, and the ability to work collaboratively with cross-functional teams to ensure efficient and reliable data processes.

Role Responsibility :


- Lead the design and architecture of scalable and robust data integration solutions on-premise and in the cloud.


- Ensure solutions meet business requirements and industry standards.

- Engage with executive leadership and key stakeholders to understand business needs and translate them into technical solutions.

- Define data models, schemas, and structures to optimize data storage, retrieval, and processing for analytical workloads.

- Work with data architects and solution architects to ensure alignment with overall data strategy and architecture principles.

- Lead a team of data engineers by providing technical guidance, mentorship, and support.

- Plan, prioritize, and manage data engineering projects, tasks, and timelines.

- Design, develop, and maintain data integration pipelines and ETL/ELT workflows.

- Lead more than one project or manage a larger team that might have sub-tracks.


Role Requirement :


- Proficient in basic and advanced SQL.

- Proficient in using Python for data integration and data engineering tasks.

- Proficiency in ETL/ELT tools such as Informatica, Talend, DataStage, SSIS, DBT, Databricks, or equivalent.

- Experience with relational databases (like SQL Server, Oracle, MySQL, PostgreSQL) and NoSQL databases (like MongoDB,

Cassandra), cloud databases (RedShift, Snowflake, Azure SQL).

- Familiarity with big data technologies like Hadoop, Spark, Kafka, and cloud platforms such as AWS, Azure, or Google Cloud.

- Solid understanding of data modeling, data warehousing concepts, and practices.

- Good Knowledge and Understanding of Data warehouse concepts (Dimensional Modeling, change data capture, slowly changing dimensions etc.).

- Knowledgeable in performance tuning and optimization

- Experience in Data Profiling and Data validation

- Experience in requirements gathering and documentation processes, and performing unit testing.

- Understanding and implementing QA and various testing processes in the project.

- Knowledge in any BI tools will be an added advantage.

- Sound aptitude, outstanding logical reasoning, and analytical skills.

- Willingness to learn and take initiative.

- Ability to adapt toa fast-paced Agile environment.

- Relevant certifications in data engineering or cloud platforms are a plus.


Additional Requirement :


- Overall 6+ years in ETL/ELT (preferably Informatica IICS/Powercenter) and 3+ years of hands-on experience with AWS RedShift.

- Strong proficiency in AWS Redshift and writing complex SQL queries.

- Solid programming experience in Python for scripting, data wrangling, and automation.

- Experience with version control tools like Git and CI/CD workflows.

- Knowledge of data modeling and data warehousing concepts.

- Prior experience with data lakes and big data technologies is a plus.


(ref:hirist.tech)

  • Lead Data Engineer

    6 days ago

    Chennai, Tamil Nadu, India AABM Cloud Data Solutions Full time ₹ 12,00,000 - ₹ 18,00,000 per year

    About the RoleWe are seeking a Lead Data Engineer to join our team. In this role, you will be crucial in designing, building, and maintaining our data infrastructure. This is a hands-on position requiring a strong foundation in data warehousing, ETL processes, and database management. The ideal candidate will have a keen eye for detail and the ability to...

  • Data Engineer

    2 weeks ago

    Chennai, India NTT DATA Full time

    Req ID: NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Data Engineer - Azure to join our team in Chennai, Tamil Nādu (IN-TN), India (IN). "Job Duties: Key Responsibilities: ...

  • Data Engineer

    3 days ago

    Chennai, Tamil Nadu, India NTT DATA Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Req ID: 336026NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Data Engineer - Azure to join our team in Chennai, Tamil Nādu (IN-TN), India (IN). "Job Duties: Key Responsibilities:...

  • Data Engineer

    2 weeks ago

    Chennai, India CX Data Labs Full time

    Hi Role - Azure Data engineer Location - Chennai, Gurugram (5days Onsite) Full time Immediate joiner Only (15days Notice period only) Technical Skills: o Proficiency in SQL for complex queries, database design, and optimization. o Strong experience with PySpark for data transformation and processing. o Hands-on experience with Databricks for building and...

  • Eucloid - Senior/Lead Data Engineer - Python

    9 hours ago

    Chennai, India Eucloid Data Solutions Pvt Ltd Full time

    Job Description : Eucloid is looking for a Lead Data Engineer to join our Data Platform team supporting various business applications. The ideal candidate will support development of data infrastructure for our clients by participating in activities which may include starting from up- stream and down-stream technology selection to designing and building of...

  • Lead Data Engineer

    1 day ago

    Chennai, Tamil Nadu, India ResourceTree Global Services Pvt Ltd Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Company DescriptionResourceTree Global Services Pvt Ltd. (ResourceTree) is a Talent Builder dedicated to offering careers to professionals across various industries, including Information & Technology, Manufacturing, Services, Banking, Agri-tech, and Edu-tech. ResourceTree has earned a reputation for helping industry leaders transform their talent needs into...

  • Data Engineer

    2 weeks ago

    Chennai, Tamil Nadu, India NTT DATA North America Full time ₹ 15,00,000 - ₹ 20,00,000 per year

    Req ID: NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Data Engineer - Azure to join our team in Chennai, Tamil Nādu (IN-TN), India (IN)."Job Duties: Key Responsibilities:•  ...

  • Lead Data Engineer

    2 weeks ago

    Chennai, India Ignitho Full time

    Position: Lead Data Engineer Location: Chennai Work Hours: 12:00 PM to 9:00 PM IST (US Business Hours) Availability: Immediate Experience: 6 + Years About the Company: Ignitho Inc. is a leading AI and data engineering company with a global presence, including offices in the US, UK, India, and Costa Rica. Visit our website to learn more about our work and...

  • Lead Data Engineer

    3 days ago

    Chennai, Tamil Nadu, India Ignitho Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Position: Lead Data EngineerLocation: ChennaiWork Hours: 12:00 PM to 9:00 PM IST (US Business Hours)Availability: ImmediateExperience: 6 + YearsAbout the Company:Ignitho Inc. is a leading AI and data engineering company with a global presence, including offices in the US, UK, India, and Costa Rica.Visit our website to learn more about our work and culture:...

  • Data Engineer

    2 weeks ago

    Chennai, India NTT DATA North America Full time

    Req ID: NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Data Engineer - Azure to join our team in Chennai, Tamil Nādu (IN-TN), India (IN). "Job Duties: Key Responsibilities: Design...