P99Soft - Senior ETL/Data Engineer - Synapse Analytics

7 days ago


Anywhere in IndiaMultiple Locations P99SOFT PRIVATE LIMITED Full time ₹ 6,00,000 - ₹ 18,00,000 per year

Description :

About the Role

We are seeking a highly skilled Senior ETL/Data Engineer with strong expertise in the Microsoft Data Platform to design, build, and optimize data pipelines and integration solutions.

The ideal candidate will have deep technical knowledge of SQL Server, SSIS, Azure Data Factory (ADF), Synapse, and Power BI integration, along with a solid understanding of data modeling, data governance, and performance tuning.

You will work closely with business analysts, data scientists, and application developers to ensure robust, secure, and scalable data solutions that support advanced analytics and reporting initiatives.

Key Responsibilities :

1.ETL Development & Data Integration :

- Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS) and/or Azure Data Factory (ADF).

- Build data ingestion and transformation pipelines for structured and unstructured data from multiple sources (databases, APIs, flat files, etc.

- Implement data extraction, cleansing, validation, and transformation logic to ensure high data quality.

- Develop incremental load and delta processing solutions for efficient data refreshes.

Data Modeling & Architecture :

- Design and maintain data warehouse/data lake architectures following best practices (Kimball, Inmon, or Data Vault methodologies).

- Create and optimize star/snowflake schemas, fact/dimension tables, and metadata-driven architectures.

- Work with data architects to define data standards, governance, and documentation.

Azure Data Engineering (Cloud-Focused) :

- Develop and manage cloud-based data pipelines using Azure Synapse Analytics, ADF, Databricks, and Azure SQL Database.

- Utilize Azure Data Lake Storage (ADLS) for scalable and secure data storage.

- Implement CI/CD pipelines for data integration workflows using Azure DevOps.

- Ensure performance, scalability, and cost optimization in cloud environments.

Performance Optimization & Monitoring :

- Conduct performance tuning of SQL queries, ETL jobs, and data models.

- Monitor ETL processes for efficiency and reliability, implementing proactive alerting and logging.

- Troubleshoot and resolve data issues, ensuring data integrity and consistency across systems.

Collaboration & Stakeholder Management :

- Partner with business teams to understand data requirements and translate them into technical solutions.

- Collaborate with data analysts and Power BI developers to provide clean, curated data models for reporting.

- Document data flows, mappings, and operational procedures.

- Mentor junior data engineers and contribute to process improvement initiatives.

Required Technical Skills :

- SSIS, Azure Data Factory (ADF)

- Microsoft SQL Server, Azure SQL Database, Azure Synapse Analytics

- Advanced SQL, T-SQL, and basic Python (for automation or data transformation)

- Star/Snowflake schemas, Kimball or Inmon methodologies

- Azure Data Lake, Synapse, ADF, Databricks, Azure Functions

- Azure DevOps, Git

- SQL Server Agent, ADF triggers, or equivalent tools


  • Senior Data Engineer

    2 weeks ago


    Anywhere in India/Multiple Locations Talent Socio Full time ₹ 8,00,000 - ₹ 12,00,000 per year

    Description : We are looking for a highly skilled Senior Data Engineer to join our data engineering team. The ideal candidate will design, build, and optimize robust and scalable data pipelines and platforms to support our data analytics, reporting, and machine learning initiatives. You will work closely with data scientists, analysts, and software...


  • Multiple Locations, India Digihelic Solutions Private Limited Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Description : We are seeking a highly experienced and technically adept Senior Data Engineer to join our TAVS team in Pune. The ideal candidate will have a minimum of 12 years of relevant experience and a strong background in designing, developing, and optimizing large-scale data pipelines and data warehouse solutions. This role requires deep expertise...

  • Data Engineer

    4 days ago


    Anywhere in India/Multiple Locations Jaipur Rugs Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    Description : Organization Description : Jaipur Rugs is a social enterprise that connects rural craftsmanship with global markets through its luxurious handmade carpets. It is a family-run business that offers an exclusive range of hand-knotted and hand-woven rugs made using 2500 years old traditional art forms. The founder, Mr. Nand Kishore Chaudhary...


  • Anywhere in India/Multiple Locations Talent Socio Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Description : About the Role : We are looking for a dynamic Data Analytics Manager with strong expertise in Power BI to lead our data analytics team. You will be responsible for driving data-driven decision-making across the organization by designing, developing, and managing interactive dashboards and reports that provide actionable insights. ...

  • Azure Data Engineer

    5 days ago


    Anywhere in India/Multiple Locations AATRAL HR CONSULTING LLP Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Description : We are looking for a skilled Azure Data Engineer to design, build, and maintain scalable data pipelines and architectures in Microsoft Azure. You will play a crucial role in enabling data-driven decision-making by transforming raw data into accessible, clean, and reliable datasets. If you have hands-on experience with Azure data...


  • Anywhere in India/Multiple Locations TESTQ Technologies Limited Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    About the Opportunity : We are looking for a skilled Azure Data Engineer / Data Engineer with hands-on experience in Azure Data Factory, Snowflake, Databricks, and DBT to architect and implement large-scale data integration and transformation pipelines. The ideal candidate will bring deep technical expertise in ETL/ELT design, data modeling, and big...


  • Anywhere in India/Multiple Locations ACA Global Full time ₹ 8,00,000 - ₹ 12,00,000 per year

    About the Role : We are seeking an experienced Enterprise Data Manager with deep expertise in Azure Data Factory (ADF) and cloud-based data management solutions. The ideal candidate will lead enterprise-wide data initiatives, oversee ETL/ELT pipelines, and drive data strategy across business units. This role requires a strong combination of...

  • Data Engineer

    5 days ago


    Anywhere in India/Multiple Locations Incanus Technologies Private Limited Full time ₹ 16,000 - ₹ 48,000 per year

    Description : About the Role : We are looking for a skilled Data Engineer to design, build, and maintain scalable data pipelines and architectures that support advanced analytics, machine learning, and reporting solutions. The ideal candidate will have a strong background in data modeling, ETL processes, and cloud-based data platforms such as Azure,...

  • Senior Data Engineer

    2 weeks ago


    Anywhere in India/Multiple Locations Techno Wise Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    The Senior Data Engineer will be responsible for building new segments in a Customer Data Platform (CDP), maintaining the segments, understanding the data requirements for use cases, data integrity, data quality and data sources involved to build the specific use cases. The resource should also have an understanding of ETL processes. This position will...


  • Multiple Locations, India Sky Systems, Inc. Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Description : - Role : Senior Analytics Support Engineer - Position Type : Full-Time Contract (40hrs/week) - Contract Duration : Long Term - Work Schedule : 8 hours/day (Mon-Fri) - Location : Hybrid (2x days onsite) in Bangalore, India Were looking for a skilled Analytics Support Engineer experienced in GA4, GTM, Looker,...