MResult - SSIS Developer - Solution Design & Implementation (6-10 yrs)

MResult is a leading Data & Analytics intelligence technology solutions provider to companies that value insights from information as a competitive advantage. We are the partner of choice for enterprises on their digital transformation journey. Our teams offer solutions and services at the intersection of Advanced-Data, Analytics, and AI. These include Data and Analytics CoE roadmap and buildout, Realtime Data Insights, and Advisory services. We help companies monetize their data assets and generate real-time actionable insights that drive growth and optimize business operations.

MResult was founded in 2004 and is headquartered in Connecticut with offices worldwide located in the USA, India, Australia, and the UAE. We are trusted by several Fortune 500 companies and start-ups to design, architect, build, and manage solutions that enable critical decision-making. We bring together rich domain expertise, and best in class analytics, and innovative AI capabilities to deliver world-class solutions meeting organizational needs.

Role : BI Lead (SSIS Developer)

Job Summary :

We are looking for an experienced SSIS Developer to join our dynamic team. The ideal candidate will be responsible for designing, developing, and implementing solutions using SQL Server Integration Services (SSIS) to support ETL processes, data integration, and data transformation. You will work closely with the data management team to ensure data flows smoothly between systems and meets business needs.

Key Responsibilities :

- Design, develop, and maintain SSIS packages to support ETL (Extract, Transform, Load) processes.

- Integrate data from various sources such as databases, flat files, XML, and other external data sources.

- Collaborate with business analysts and stakeholders to understand data requirements and provide effective ETL solutions.

- Optimize SSIS packages for performance and scalability, ensuring efficient processing of large volumes of data.

- Monitor, troubleshoot, and resolve issues with SSIS packages and ensure data integrity and reliability.

- Develop complex SQL queries, stored procedures, and functions to support ETL processes.

- Create and maintain documentation for SSIS packages, workflows, and procedures.

- Participate in data warehouse design and architecture discussions.

- Implement data validation and quality assurance processes to ensure data accuracy.

- Work with cross-functional teams to support data integration and reporting initiatives.

Required Skills and Qualifications :

- Bachelor's degree in computer science, Information Technology, or a related field.

- Proven experience as an SSIS Developer with a minimum of [X] years of hands-on experience.

- Proficiency in SQL Server and T-SQL (stored procedures, triggers, views).

- Strong experience with SSIS for ETL development, data migration, and data integration.

- Familiarity with relational databases, data warehousing, and data modelling concepts.

- Experience with SQL Server Data Tools (SSDT) for designing, testing, and deploying SSIS packages.

- Ability to troubleshoot and optimize SSIS packages for performance.

- Strong problem-solving skills and attention to detail.

- Experience with version control systems like Git is a plus.

- Knowledge of other ETL tools (e.g., Informatica, Talend) is a plus.

Location : Bangalore/Remote