- Analysis and gathering requirements for Development projects covering all parts of SDLC
- Creating tables and their relationships (Schemas) in the data warehouse.
- Creating SSIS packages to migrate large amounts of data. • Developed large number of standard and customized reports using SSRS for data feeds and for Reports on server.
- Create Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers, Functions and views, Performance tuning of queries.
- Solid SQL querying abilities necessary for database manipulation and analysis
- Familiarity with ETL Processes: Basic knowledge of ETL tools and principles, particularly related to data integration and workflow design.
- Knowledge of the fundamental concepts of data warehousing, including understanding of facts, dimensions, star schema.
- Experience with performance tuning of SSAS cubes and SQL databases
- Robust problem-solving and analytical abilities, with a keen attention to detail.
- Good communication and interpersonal skills, with the ability to interact effectively with stakeholders at all levels