SSIS Developer

As an SSIS Developer at our client's global technology consulting and digital solutions company, you will play a crucial role in designing, developing, and optimizing complex SQL queries, stored procedures, functions, and views. Your primary responsibility will involve driving the design, development, and maintenance of data warehouse/ETL processes using Microsoft SQL databases and SSIS technology. Your expertise in Microsoft SQL Server 2019 and above, as well as experience in managing databases, will be essential in ensuring the smooth execution of ETL processes. Key Responsibilities: - Design, develop, and optimize complex SQL queries, stored procedures, functions, and views - Develop and maintain ETL packages using SQL Server Integration Services (SSIS) - Create and deploy SSIS packages for ETL processes - Write and troubleshoot T-SQL statements, create stored procedures, views, and SQL functions - Understand different data models like normalized, de-normalized, stars, and snowflake models - Optimize SQL coding for data query performance - Collaborate with team members to identify and resolve technical issues promptly - Analyze problems and communicate with end users to determine optimal solutions - Deep understanding of data warehousing concepts - Strong knowledge of data structures and formats such as JSON and XML and SSIS Scripting Qualifications Required: - 5+ years of experience with Microsoft SQL databases, SSIS/SSRS development - Demonstrated experience with Microsoft SQL Server 2019 and above - Experience in writing and troubleshooting T-SQL statements - Ability to thrive in a fast-paced, rapidly changing, and complex environment Join our dynamic team in Pune for a hybrid work mode and contribute your expertise to accelerate innovation and drive growth through digital technologies.,