SSIS Developer

Job Description---

Roles and Responsibilities: • Design, build and deploy effective SSIS packages to validate, synthesize, transform customer data for integrated business planning and analytics • Understand data model (table structures, linkages, optimal designs) for designing various planning use cases • Review and analyse the data provided by customers along with its technical/functional intent and interdependencies • Participate in the technical design, data requirements gathering and making recommendations on best practices, in case of inaccurate or missing data • Design and automate the data loading and insights generation process with intelligent checks and balances for sustained value delivery • Create and execute test plans, document issues and track progress at resolving issues.

What You Should Possess : ▪ At least 5-7 years of experience with implementing ETL solutions for clients is a MUST ▪ Life Sciences and Healthcare Domain knowledge specially on Commercial Pharma is a big plus ▪ Proficiency in databases (SQL Server, MySQL) and skills in one or more languages like SQL with knowledge of DDL, DML, stored procedures, triggers and performance tuning is a MUST ▪ Knowledge on handling JSON files, Serializing the data, posting data to API is desirable.

Added Advantage: ▪ Good to have experience working with Snowflake ▪ Good to have experience working with AWS or Azure or GCP ▪ Knowledge of Python or Java is an added advantage . ▪ Proficient in the use of Microsoft Excel/PowerPoint for analysis and presentation ▪ Strong ability to lead by example and demonstrate proficiency in both product and domain. ▪ Strong familiarity with SQL Server Development and ETL Concepts ▪ Experienced in Designing, Developing & Implementing Data Integration solutions on SSIS (SQL Server Integration Services) ▪ Good exposure to building SSIS Packages using the package builder functionality Worked on the both the development and Maintenance projects and followed the Operational processes.

Minimum 4 years of experience in the Design, Development, Implementation and Support of SQL Server 2012/2014/2017 ▪ Minimum 2 years of ETL SSIS development experience ▪ Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) ▪ Skilled in error and event handling: Precedence Constraints, Break Points.