Circulant Software | Hiring | SSIS/ SQL Developer | Pune | BigDataKB.com | 2022-09-29

0

Job Location: Pune

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, Check points and Logging.

Experience in Requirements gathering, development and deployment of SSIS

Experience in conceptualizing and designing Data Migration projects

Expert in data validation, cleansing, analysis and Transforming

Experience in using SSIS Transformations like Lookup, Merge, Union ALL, Multicast Skilled in error

and event handling: precedence Constraints, Check Points and Logging

Have Experience in performance optimization and expert in writing SQL queries.

Experience with business intelligence tools mainly SQL Server Integration Services (SSIS)/DTS packages is must.

Experience with SQL Server performance tuning, SQL Server Replication, SQL Server mirroring is

required.

Patient listener with the ability clearly articulate your view point to manage and deliver to customer expectations, even under pressure

Ability to take complete ownership of the work and deliver with minimal oversight.

(Work Hours)

Flexible working hours/5 days working//Hybrid Role

Share your resume at hr@circulants.com or maneetk@circulants.com

Apply Here

Submit CV To All Data Science Job Consultants Across Bharat For Free

🔍 Explore All Related ITSM Jobs Below! 🚀 ✅ Select your preferred "Job Category" in the Job Category Filter 🎯 🔎 Hit "Search" to find matching jobs 🔥 ➕ Click the "+" icon that appears just before the company name to see the Job Detail & Apply Link 📝💼

LEAVE A REPLY

Please enter your comment!
Please enter your name here