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
Submit CV To All Data Science Job Consultants Across Bharat For Free

