SSIS Engineer

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