Data Engineering Sr. Associate

Synechron; Bengaluru; On-site; INR 1,200,000 - 2,100,000; Full time

Job summary

Synechron in Bengaluru is seeking an experienced Data Engineer to design, build, and maintain scalable data pipelines and ETL/ELT processes across cloud platforms. You will collaborate with Data Architects and BI teams to deliver robust data models, data marts, and warehouse solutions that ensure data quality and governance.

The role requires strong Python/SQL/Spark skills, plus hands-on experience with Azure Data Factory, Azure Databricks, Synapse Analytics, and related tools.

Qualifications

• Strong proficiency in Python, SQL, and Spark.
• Hands-on experience with cloud data tools (Azure/AWS/GCP).
• 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.

Responsibilities

• Design 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.

Skills

Python

SQL

Spark

Azure Data Factory

Azure Databricks

Synapse Analytics

ETL/ELT tools

Data Warehousing

Dimensional modeling

Snowflake

Azure Synapse

Redshift

BigQuery

Data Lake

Lakehouse

Git

CI/CD

Airflow

Problem solving

Analytical skills

Tools

Azure Data Factory

Azure Databricks

Synapse Analytics

Snowflake

Redshift

BigQuery

Airflow

Job description

• 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.

Key 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.

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.