382020-Lead Assistant Manager

Job Title: SSIS & SQL Server Developer Job Description: We are looking for a highly skilled SSIS & SQL Server Developer to join our team. The ideal candidate will have extensive experience in SQL Server Integration Services (SSIS), SQL Server development, and database management. This role involves designing, developing, and optimizing ETL processes, writing complex SQL queries, and ensuring data integrity and performance tuning. Key Responsibilities: Develop, implement, and maintain ETL solutions using SSIS. Design, develop, and optimize SQL Server databases, stored procedures, functions, and triggers. Perform data extraction, transformation, and loading (ETL) processes. Monitor and troubleshoot ETL jobs and database performance issues. Ensure data integrity and consistency across various data sources. Collaborate with business analysts, data analysts, and other stakeholders to gather and analyse requirements. Implement best practices for database design, development, and optimization. Develop and maintain technical documentation for SSIS packages and SQL Server processes. Support production environments and provide timely resolution for data-related issues. Required Skills and Qualifications: Bachelor's degree in Computer Science, Information Technology, or a related field. 4+ years of hands-on experience with SSIS and SQL Server. Strong expertise in T-SQL, stored procedures, functions, views, and triggers. Experience in performance tuning, query optimization, and indexing. Familiarity with data warehousing concepts and ETL best practices. Strong problem-solving skills and attention to detail. Excellent communication and teamwork abilities. Experience with job scheduling and automation tools is a plus. Knowledge of cloud-based SQL solutions (e.g., Azure SQL, AWS RDS) is an advantage. Preferred Qualifications: Experience with SSRS and SSAS. Exposure to big data technologies and data lake concepts. Understanding of Agile development methodologies. Experience in data governance and compliance requirements.EXL is the indispensable partner for leading businesses in data-led industries such as insurance, banking and financial services, healthcare, retail and logistics. We bring a unique combination of data, advanced analytics, digital technology and industry expertise to help our clients turn data into insights, streamline operations, improve customer experience, and transform their business. Our partnerships with clients are built on a foundation of collaboration - and we've been chosen as a partner by nine of the top ten leading US insurance companies, nine of the top 20 global banks, and six of the top ten US health care payers. We function as one team to make your goals our goals, whether that's unlocking the value of generative AI or embedding analytics into workflows that reduce risk or power your growth. Clients choose EXL as their transformation partner for many reasons. Our geographic diversity make talent all over the world instantly accessible. Digital accelerators enable unmatched speed-to-value, letting you realize results fast. It's our people that truly set us apart, though, including the 1,500 data scientists we have dedicated to our generative AI practice. And our more than twenty years of experience in delivering business services, garnering stellar client references, and maintaining a solid balance sheet are reassuring to our C-suite clients. Find out for yourself why clients, employees, and analysts think we're some of the best in the business. Contact us to see how we can help you achieve your goals.