Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS).
Develop and optimize complex SQL queries, stored procedures, views, and functions.
Create and maintain reports and dashboards using SQL Server Reporting Services (SSRS).
Develop multidimensional and tabular data models using SQL Server Analysis Services (SSAS).
Design and implement data warehouse solutions using Star and Snowflake schemas.
Perform data extraction, transformation, and loading activities from multiple source systems.
Monitor ETL jobs and troubleshoot data quality and performance issues.
Work closely with business stakeholders to gather reporting and analytics requirements.
Ensure data integrity, security, and compliance across BI solutions.
Optimize SQL Server databases and BI applications for performance and scalability.
Support production deployments, enhancements, and maintenance activities.
Required Skills
Strong experience in Microsoft SQL Server.
Hands-on experience with:
SSIS (SQL Server Integration Services)
SSRS (SQL Server Reporting Services)
SSAS (SQL Server Analysis Services)
Expertise in T-SQL, Stored Procedures, Triggers, Views, and Query Optimization.
Experience in Data Warehousing concepts and ETL development.
Knowledge of OLAP Cubes, Tabular Models, and Data Modeling.
Understanding of database performance tuning and indexing strategies.
Experience with SQL Server Agent jobs and deployment processes.
Strong analytical and problem-solving skills.
Source: Infosys careers — Read the original posting and apply
This role is listed by the employer on its own careers site. Kaam Ki Khoj does not process applications for it.
Infosys is an employer in the IT/Computers - Software, Software Services sector with operations in India. This is a directory listing maintained by Kaam Ki Khoj so that candidates can find the organisation; it is not an official company page and Kaam... Read More
Upload your CV once — we read it, build your profile and put you in front of every employer hiring on Kaam Ki Khoj. No forms, no fees.
