Description

You will design, build, and deploy SSIS packages to transform and validate customer data for integrated business planning and analytics.

Responsibilities

• Design and automate data loading and insights generation processes with intelligent checks and balances.
• Develop and implement data integration solutions using SSIS package builder functionality.
• Analyze data models, table structures, and linkages to support various planning use cases.
• Create and execute test plans, documenting issues and tracking progress through resolution.
• Perform data transformations between servers using BCP and SSIS, including error and event handling via precedence constraints and breakpoints.

Required Skills

• 5-7 years of experience implementing ETL solutions for clients.
• Minimum 4 years of experience in the design, development, implementation, and support of SQL Server 2012/2014/2017.
• At least 2 years of dedicated ETL SSIS development experience.
• Proficiency in SQL Server and MySQL, including DDL, DML, stored procedures, triggers, and performance tuning.
• Strong familiarity with SQL Server Development and ETL concepts.
• Experience with both development and maintenance projects following operational processes.
• Proficiency in Microsoft Excel and PowerPoint for analysis and presentation.

Preferred Skills

• Knowledge of Life Sciences and Healthcare domains, specifically Commercial Pharma.
• Experience with Snowflake, AWS, Azure, or GCP.

Key Skills

Education

Any Graduate