Integration Engineer, MuleSoft/SQL

Do you want to be part of an inclusive team that works to develop innovative therapies for patients? Every day, we are driven to develop and deliver innovative and effective new medicines to patients and physicians. If you want to be part of this exciting work, you belong at Astellas

Astellas Pharma Inc. is a pharmaceutical company conducting business in more than 70 countries around the world. We are committed to turning innovative science into medical solutions that bring value and hope to patients and their families. Keeping our focus on addressing unmet medical needs and conducting our business with ethics and integrity enables us to improve the health of people throughout the world. For more information on Astellas, please visit our website at .

This position is based in Bengaluru and will require some on-site work.

Purpose and Scope:

As an Integration Engineer, you will play a crucial role in designing, building, and maintaining our data infrastructure. Your expertise in MuleSoft, Talend, Databricks, PySpark, SQL and other related technologies, will be instrumental in driving data-driven decision-making across the organization. You will play a pivotal role in building maintaining and enhancing our systems across the organization. This is a fantastic global opportunity to use your proven agile delivery skills across a diverse range of initiatives, utilize your development skills, and contribute to the continuous improvement/delivery of critical IT solutions.

This position is based in Bengaluru and will require some on-site work.

Essential Skills & Knowledge:

• Proficient in Data Warehouse (DWH) ETL (extract, transform, load) development using Talend, MuleSoft, Databricks, PySpark and SQL in a 'hands-on' capacity
• Deep knowledge of MuleSoft and Talend Architecture (TAC, Job Servers, etc)
• Provide best practice advice and guidance on Talend approaches for scalable and sustainable solutions
• expertise using Talend with Amazon Web Services (AWS) Redshift and S3 buckets for fast data loading and the extraction of data from various internal and external sources
• Subject Matter Expertise: possess a strong understanding of data architecture/ engineering/operations across diverse areas like Commercial, Manufacturing and Medical.
• Analytical Thinking: Demonstrated ability to lead ad hoc analyses, identify performance gaps, and foster a culture of continuous improvement.
• Technical Proficiency: Strong coding skills in SQL, PLSQL. Experience in AWS and Azure.
• Agile Champion: Adherence to DevOps principles and a proven track record with CI/CD pipelines for continuous delivery.
• Code and version control experience and best practices
• reviews and maintain technical documentation
• Provide performance advise and tuning to ensure integrations run as quickly and optimally as possible

Desirable Skills and Knowledge:

• Knowledge and experience of working with Salesforce
• Knowledge and experience using Azure DevOps
• Knowledge of Python, R, Databricks and MuleSoft desirable

Qualifications:

Required

• Bachelor's degree in computer science, information technology, or related field (or equivalent experience.)
• 3 -5+ years of experience in building/operating data integrations
• Very strong SQL skills and a proven track record of delivering business value
  3 -5+ years of experience of cloud platforms (AWS, Azure, GCP). A deeper understanding/certification of AWS and Azure is considered a plus

Any relevant cloud-based integration certification at foundational level. For example:

• AWS certified DevOps engineer
• AWS Certified Developer
• MuleSoft Certified integration architect Level 1 (Essential),
• Microsoft Certified Azure Integration and Security.
• Proficient in RESTful APIs
• AWS, CDMP, MDM, DBA, SQL, SAP, TOGAF, API, CISSP, VCP (any relevant certification)

MuleSoft

• Understanding of MuleSoft's Anypoint Platform and its components
• Experience with designing and managing API-led connectivity solutions
• Knowledge of integration patterns and best practices
• Proficiency in network architecture and security concepts

AWS

• Experience provisioning, operating, and managing AWS environments
• Experience developing code in at least one high-level programming language
• Understanding of modern development and operations processes and methodologies
• Ability to automate the deployment and configuration of infrastructure using AWS services and tools
• Experience with continuous integration and continuous delivery (CI/CD) methodologies and tools

Microsoft Azure

• Fundamental understanding of Microsoft Azure and its services
• Experience with Azure services related to computing, networking, storage, and security
• Knowledge of general IT security principles and best practices
• Understanding of cloud integration patterns and Azure integration services such as Logic Apps, Service Bus, and API Management

Preferred

• Subject Matter Expertise: possess a strong understanding of data architecture/ engineering/operations/ reporting within Life Sciences/ Pharma industry across Commercial, Manufacturing and Medical domains.
• Other complex and highly regulated industry experience will be considered across diverse areas like Commercial, Manufacturing and Medical.
• Data Analysis and Automation Skills: Proficient in identifying, standardizing, and automating critical reporting metrics and modelling tools
• Analytical Thinking: Demonstrated ability to lead ad hoc analyses, identify performance gaps, and foster a culture of continuous improvement.
• Technical Proficiency: Strong coding skills in SQL, R, and/or Python, coupled with expertise in machine learning techniques, statistical analysis, and data visualization.
• Agile Champion: Adherence to DevOps principles and a proven track record with CI/CD pipelines for continuous delivery.

Working Environment

At Astellas we recognize the importance of work/life balance, and we are proud to offer a hybrid working solution allowing time to connect with colleagues at the office with the flexibility to also work from home. We believe this will optimize the most productive work environment for all employees to succeed and deliver. Hybrid work from certain locations may be permitted in accordance with Astellas' Responsible Flexibility Guidelines.