SSIS Engineer

Infinites Hr Services Pune; Dadri; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Infinites Hr Services Pune in Noida is seeking a Senior Associate SSIS Engineer to design and optimize SQL queries, ETL pipelines, and data warehouse structures.

You will work with SSIS, SnapLogic, and cloud platforms (Azure/AWS/GCP) to deliver scalable analytics-ready data, support AI workflows, and ensure data quality and governance.

Qualifications

• Strong hands-on expertise with SQL Server, SSIS, and Data Warehousing concepts.

Responsibilities

• Develop and optimize SQL queries, stored procedures, and ETL pipelines.
• Build robust data warehouse structures and maintain/create high-quality ETL workflows using SSIS and Snaplogic.
• Implement data quality, validation, and auditing frameworks.
• Data Modeling: Design conceptual, logical, and physical models optimized for analytics, AI consumption, and enterprise data platforms.
• Implement best practices in dimensional modeling (Star/Snowflake schema).
• Align data structures with business needs and AI-driven workflows.

Skills

SSIS

SQL

ETL

Data modelling

Cloud platforms

CI/CD

AI/ML

SSAS

Data warehousing

Education

BE/B.Tech

MBA

MCA

Tools

SnapLogic

Azure

AWS

GCP

Job description

Job Description & Summary

Develop and optimize SQL queries, stored procedures, and ETL pipelines.

Build robust data warehouse structures and maintain/create high-quality ETL workflows using SSIS and Snaplogic.

Implement data quality, validation, and auditing frameworks.

Data Modeling Design conceptual, logical, and physical models optimized for analytics, AI consumption, and enterprise data platforms.

Implement best practices in dimensional modeling (Star/Snowflake schema).

Align data structures with business needs and AI-driven workflows.

Strong hands-on expertise with SQL Server, SSIS, and Data Warehousing concepts.

Proven experience designing ETL/ELT solutions and optimizing large-scale datasets.

Solid understanding of data modeling techniques and semantic layer design.

Experience with cloud data tools and services (Azure, AWS, GCP etc.) is good to have.

Experience with AI/ML is good to have Comfort with version control, CICD, and modern engineering practices.

Exposure to SSAS Understanding of data security, compliance, and governance frameworks.

Exposure on cloud migration project

Level: Senior Associate

Location: Noida

Skill: SSIS, Sql, ETL, Data modelling, Cloud Technology

Job Position Title: SSIS Engineer

Responsibilities

Data Engineering & Development

Develop and optimize SQL queries, stored procedures, and ETL pipelines.

Build robust data warehouse structures and maintain/create high-quality ETL workflows using SSIS and Snaplogic.

Implement data quality, validation, and auditing frameworks.

Data Modeling

Design conceptual, logical, and physical models optimized for analytics, AI consumption, and enterprise data platforms.

Implement best practices in dimensional modeling (Star/Snowflake schema).

Align data structures with business needs and AI-driven workflows.

Required Skills & Experience

Strong hands-on expertise with SQL Server, SSIS, and Data Warehousing concepts.

Proven experience designing ETL/ELT solutions and optimizing large-scale datasets.

Solid understanding of data modeling techniques and semantic layer design.

Experience with cloud data tools and services (Azure, AWS, GCP etc.) is good to have.

Experience with AI/ML is good to have

Comfort with version control, CICD, and modern engineering practices.

Preferred Qualifications

Exposure to SSAS

Understanding of data security, compliance, and governance frameworks.

Exposure on cloud migration project

Mandatory skill sets: SSIS, Sql, ETL, Data modelling

Good To Have skill sets: Cloud Technology (Azure,AWS,GCP), Spark, Databricks

Years of experience required: 7-10 years

Education qualification: BE/B.Tech/MBA/MCA