Data Engineering Sr. Associate

Synechron; Bengaluru; On-site; INR 1,400,000 - 1,900,000; Full time

Job summary

Synechron in Bengaluru is seeking a Data Engineer to design, build, and optimize scalable data pipelines and ETL/ELT processes. You will develop data models, warehouses, and governance mechanisms across cloud platforms and big data technologies, collaborating with architects, analysts, scientists, and BI teams.

The role emphasizes handling structured and unstructured data, ensuring data quality, and mentoring junior engineers while contributing to production deployments and incident resolution.

Qualifications

• Strong proficiency in Python, SQL and Spark.
• Hands-on experience with Azure Data Factory, Azure Databricks, Synapse Analytics, or equivalent cloud tech.
• Experience with ETL/ELT frameworks and data integration tools.

Responsibilities

• Design, develop, and maintain scalable data pipelines and ETL/ELT processes.
• Build and optimize data integration workflows from multiple source systems.
• Develop data models, data marts, and data warehouse solutions.
• Ensure data quality, integrity, security, and governance across platforms.
• Design solutions for structured and unstructured data processing.
• Develop and manage data solutions on cloud platforms such as Azure, AWS, or GCP.
• Work with big data technologies including Spark, Databricks, Hadoop, and Kafka.
• Implement scalable and high-performance data processing frameworks.
• Optimize cloud data storage and compute resources for cost and performance.
• Design and maintain SQL and NoSQL databases.
• Develop complex SQL queries, stored procedures, and performance tuning solutions.
• Work with enterprise data warehouses such as Snowflake, Redshift, Synapse, or BigQuery.
• Implement data partitioning, indexing, and optimization techniques.
• Establish and enforce data quality standards and validation processes.
• Implement monitoring, logging, and alert mechanisms for data pipelines.
• Ensure compliance with data security and governance policies.
• Collaborate with Data Architects, Business Analysts, Data Scientists, and BI teams.
• Gather requirements and translate business needs into technical solutions.
• Support production deployments, incident management, and root cause analysis.
• Provide technical guidance and mentoring to junior team members.

Skills

Python

SQL

Spark

Tools

Azure Data Factory

Azure Databricks

Synapse Analytics

ETL/ELT frameworks

Data integration tools

Git

Airflow

CI/CD pipelines

Snowflake

Redshift

BigQuery

Job description

Key Responsibilities

Data Engineering & Development

• Design, develop, and maintain scalable data pipelines and ETL/ELT processes.
• Build and optimize data integration workflows from multiple source systems.
• Develop data models, data marts, and data warehouse solutions.
• Ensure data quality, integrity, security, and governance across platforms.
• Design solutions for structured and unstructured data processing.

Cloud & Big Data Technologies

• Develop and manage data solutions on cloud platforms such as Azure, AWS, or GCP.
• Work with big data technologies including Spark, Databricks, Hadoop, and Kafka.
• Implement scalable and high-performance data processing frameworks.
• Optimize cloud data storage and compute resources for cost and performance.

Database & Data Warehousing

• Design and maintain SQL and NoSQL databases.
• Develop complex SQL queries, stored procedures, and performance tuning solutions.
• Work with enterprise data warehouses such as Snowflake, Redshift, Synapse, or BigQuery.
• Implement data partitioning, indexing, and optimization techniques.

Data Governance & Quality

• Establish and enforce data quality standards and validation processes.
• Implement monitoring, logging, and alert mechanisms for data pipelines.
• Ensure compliance with data security and governance policies.

Collaboration & Stakeholder Management

• Collaborate with Data Architects, Business Analysts, Data Scientists, and BI teams.
• Gather requirements and translate business needs into technical solutions.
• Support production deployments, incident management, and root cause analysis.
• Provide technical guidance and mentoring to junior team members.

Required Skills

• Strong proficiency in Python, SQL, and Spark.
• Hands‑on experience with Azure Data Factory, Azure Databricks, Synapse Analytics , or equivalent cloud technologies.
• Experience with ETL/ELT frameworks and data integration tools.
• Knowledge of Data Warehousing concepts and dimensional modeling.
• Experience with Snowflake, Azure Synapse, Redshift, BigQuery , or similar platforms.
• Strong understanding of Data Lake and Lakehouse architectures.
• Experience with version control tools such as Git and CI/CD pipelines.
• Familiarity with workflow orchestration tools such as Airflow or Azure Data Factory.
• Strong problem‑solving and analytical skills.

S YNECHRON’S DIVERSITY & INCLUSION STATEMENT

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply.

• We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.