SSIS/SSAS Developer - ETL/Data Warehousing

3 years

0 Lacs

Posted:3 days ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Job Summary

We are seeking a skilled and experienced SSIS (SQL Server Integration Services) and SSAS (SQL Server Analysis Services) Developer to join our data engineering and business intelligence team. The ideal candidate will be responsible for developing, maintaining, and optimizing ETL packages and OLAP/Tabular models to support data warehousing and reporting Responsibilities :
  • Design, develop, deploy, and maintain SSIS packages for data extraction, transformation, and loading (ETL).
  • Develop and manage SSAS cubes (Multidimensional and/or Tabular Models) to support advanced analytics and reporting.
  • Collaborate with business analysts, data architects, and stakeholders to understand data requirements.
  • Optimize existing ETL processes for performance, scalability, and reliability.
  • Create and maintain technical documentation, including data flow diagrams and data dictionaries.
  • Monitor ETL workflows, troubleshoot issues, and implement data quality checks.
  • Perform data validation and unit testing to ensure accuracy of ETL and cube outputs.
  • Integrate SSIS/SSAS with Power BI, Excel, and other reporting tools.
  • Participate in code reviews, sprint planning, and agile development Qualifications :
  • Bachelors degree in Computer Science, Information Systems, or a related field.
  • 3+ years of hands-on experience with SSIS and SSAS.
  • Strong experience with SQL Server and T-SQL.
  • Experience building both Multidimensional and Tabular SSAS models.
  • Deep understanding of data warehousing concepts, star/snowflake schema, and ETL best practices.
  • Familiarity with performance tuning in SSIS and SSAS.
  • Proficient with data visualization tools like Power BI or Excel (PivotTables).
  • Knowledge of version control systems such as Git or Skills :
  • Experience with Azure Data Factory, Synapse, or other cloud-based data services.
  • Exposure to DevOps CI/CD pipelines for SSIS/SSAS deployments.
  • Familiarity with MDX and DAX query languages.
  • Certification in Microsoft SQL Server BI Stack is a Skills :
  • Strong analytical and problem-solving skills.
  • Effective communication and collaboration skills.
  • Ability to work independently and manage multiple tasks.
(ref:hirist.tech)

Mock Interview

Practice Video Interview with JobPe AI

Start DevOps Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You