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.