SSIS and Azure Specialist

SSIS and Azure Specialist

Take your next career step at ABB with a global team that is energizing the transformation of society and industry to achieve a more productive, sustainable future. At ABB, we have the clear goal of driving diversity and inclusion across all dimensions: gender, LGBTQ+, abilities, ethnicity and generations. Together, we are embarking on a journey where each and every one of us, individually and collectively, welcomes and celebrates individual differences.

You will be working as SSIS and Azure Specialist at Grade 13 and will be part of Finance Services business area, Financial Planning & Analysis Services division based in Bangalore, India and will be reporting to Financial Planning & Analysis Manager and In this role you will be primarily responsible for collaborating with key stakeholders to develop, implement and facilitating successful onboarding digital solutions and the adoption of digital platform and solutions into the customer business environment along with their subsequent operations and maintenance.

Your responsibilities

Planning, coordinating, developing and supporting ETL solutions using Microsoft SQL integration services platform

Developing data links and data loading scripts, including data transformations, reconciliations and accuracies. Designing the ssis packages, testing and deployment of packages in various environments

Maintenance and administration of SSIS by creating jobs, alerts, SQL mail agent and schedule SSIS Packages. Designing and automates complex data quality and data validation or verification functions as part of the overall solution

Understanding and translate business needs into data models for supporting long term solutions and reviewing modifications of existing systems to improve efficiency and performance

Having strong experience in performance tuning of packages and sql scripts and expert in error handling, precedence constraints and logging

Managing package configurations to efficiently deploy ETL packages from development

environment to production environment and extensive Knowledge on SQL Server and T-SQL concepts

Designing, developing and maintaining BI reporting and analytic dashboards using Power BI

Your background

Degree in computer engineering, computer Science or related fields

At least 5 year of experience in SSIS package and one years in azure

Experience in designing, implementing, azure cloud solution for migrating data from on premises to azure cloud

Good understanding of finance processes and data structure. Required working knowledge in data modelling concepts and agile experience will be added as advantage

Working experience in snowflake is an added advantage

Good knowledge on data lifecycle management on azure cloud and experience in building an ETL solution using pipeline in azure

More about us

ABB's shared services organization which delivers operational and expert services in Finance, Human Resources, Information Systems, Legal, Global Travel Services and external Customer Contact Centers. With employees based in five main hubs and front offices, GBS provides mainly Business services to ABB teams across the globe as well as supports with external customer inquiries We look forward to receiving your application (documents submitted in English are appreciated). If you want to discover more about ABB, take another look at our website Work model: on site #LI-onsite

Full time