2 - 4 years

4 - 8 Lacs

Posted:4 months ago| Platform: Naukri logo

AI Match Score
Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

Job description

Responsibilities:

1. Data Warehouse Design and Development:

  • Design and develop data warehouses and data marts using Microsoft SQL Server and related technologies.
  • Implement efficient ETL processes for data extraction, transformation, and loading.

2. SSIS Development:

  • Create and maintain SQL Server Integration Services (SSIS) packages for data integration and workflow automation.
  • Optimize SSIS packages for performance and scalability.

3. SSAS Development:

  • Design and implement multidimensional and tabular models using SQL Server Analysis Services (SSAS).
  • Develop and maintain cubes for efficient data analysis and reporting.

4. SSRS Development:

  • Design and create reports using SQL Server Reporting Services (SSRS).
  • Customize and enhance reports to meet business requirements.

5. T SQL Development:

  • Write and optimize complex T SQL queries for data retrieval and manipulation.
  • Ensure database performance and integrity.

6. Collaboration:

  • Collaborate with business analysts, data scientists, and other stakeholders to understand reporting requirements.
  • Work closely with cross functional teams for end to end BI solutions.

7.Performance Tuning:

  • Identify and resolve performance bottlenecks in databases, queries, and ETL processes.
  • Optimize data storage and indexing strategies.

8. Security Implementation:

  • Implement and maintain security measures for databases and BI solutions.
  • Ensure compliance with data governance and privacy standards.

Experience:

2 4 Years

Qualifications:

1. Educational Background:

  • Bachelor s or higher degree in Computer Science, Information Technology, or a related field.

2. Technical Skills:

  • Proficiency in Microsoft SQL Server, including SSIS, SSAS, and SSRS.
  • Strong T SQL scripting skills.

3. Data Modeling:

  • Experience in data modeling and database design principles.

4. Collaboration Tools:

  • Familiarity with collaboration tools and version control systems.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific 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
Scatterpie Analytics

Data Analytics

San Francisco

RecommendedJobs for You

Chennai, Tamil Nadu, India

Bhubaneswar, Odisha, India

Pune, Maharashtra, India

pune, maharashtra