Job Description

𝗧𝗵𝗶𝘀 𝗿𝗼𝗹𝗲 𝗶𝘀 𝗳𝗼𝗿 𝗼𝗻𝗲 𝗼𝗳 𝘁𝗵𝗲 𝗪𝗲𝗲𝗸𝗱𝗮𝘆'𝘀 𝗰𝗹𝗶𝗲𝗻𝘁𝘀

𝗦𝗮𝗹𝗮𝗿𝘆 𝗿𝗮𝗻𝗴𝗲: 𝗥𝘀 𝟭𝟬𝟬𝟬𝟬𝟬𝟬 - 𝗥𝘀 𝟭𝟯𝟬𝟬𝟬𝟬𝟬 (𝗶𝗲 𝗜𝗡𝗥 𝟭𝟬-𝟭𝟯 𝗟𝗣𝗔)

Experience: 2+ yrs

Location: Pune, Maharashtra, India

Job Type: Full-time

We are seeking a skilled Fivetran Data Engineer to design, build, and maintain scalable data integration pipelines that support enterprise analytics and business intelligence initiatives. This role is ideal for professionals with hands-on experience in Fivetran, SQL, and PySpark, who are passionate about developing reliable data solutions that transform raw data into actionable insights.

As a Fivetran Data Engineer, you will be responsible for developing automated data ingestion workflows, optimizing ETL/ELT pipelines, and ensuring the quality, accuracy, and availability of enterprise data. You will collaborate closely with data analysts, business stakeholders, architects, and engineering teams to build efficient data platforms that enable reporting, analytics, and data-driven decision-making. This role offers the opportunity to work with modern cloud-based data technologies in a collaborative, fast-paced environment focused on continuous improvement and innovation.

Requirements

Key Responsibilities

• Design, develop, and maintain scalable data ingestion and integration pipelines using Fivetran
• Build and optimize ETL/ELT workflows to extract, transform, and load data from multiple source systems into enterprise data platforms.
• Develop high-performance data transformation logic using SQL and PySpark to support reporting, analytics, and downstream applications.
• Monitor, troubleshoot, and optimize data pipelines to ensure reliability, scalability, and data accuracy.
• Perform data validation, reconciliation, and quality checks to maintain the integrity of enterprise datasets.
• Collaborate with business stakeholders to understand data requirements and translate them into scalable technical solutions.
• Optimize SQL queries and PySpark jobs for improved performance, resource utilization, and processing efficiency.
• Support the implementation of data models, metadata management, and data governance best practices.
• Maintain technical documentation for data pipelines, workflows, transformations, and operational procedures.
• Identify opportunities to automate repetitive data engineering tasks and improve overall development efficiency.
• Work closely with cross-functional teams including data analysts, architects, and developers to deliver high-quality data solutions.
• Participate in production support activities by investigating issues, resolving pipeline failures, and ensuring timely delivery of business-critical data.

What Makes You a Great Fit

• 2+ years of hands-on experience as a Data Engineer with strong expertise in modern data integration technologies.
• Proven experience working with Fivetran for automated data ingestion and enterprise data integration.
• Strong proficiency in SQL with the ability to write, optimize, and troubleshoot complex queries.
• Hands-on experience with PySpark for large-scale data processing and transformation.
• Solid understanding of ETL/ELT concepts, data warehousing principles, and data modeling techniques.
• Experience working with structured and semi-structured data from multiple enterprise data sources.
• Strong analytical and problem-solving skills with the ability to diagnose and resolve complex data issues.
• Knowledge of cloud-based data platforms, distributed data processing, and modern analytics architectures is an advantage.
• Excellent communication and collaboration skills with the ability to work effectively across technical and business teams.
• Self-motivated, detail-oriented, and capable of managing multiple priorities in a dynamic, fast-paced environment.
• A continuous learning mindset with a passion for improving data engineering processes, automation, and scalable data solutions.