Key Responsibilities:

• Design, develop, and maintain ETL workflows and data integration solutions using tools like Informatica or equivalent.
• Write and optimize R and Python scripts for data transformation, cleansing, and automation.
• Work with Oracle and SQL Server databases to extract, transform, and load data efficiently.
• Collaborate with cross-functional teams to gather requirements and deliver data solutions aligned with business needs.
• Ensure data quality, integrity, and consistency across systems.
• Participate in all phases of the SDLC, including requirements gathering, design, development, testing, deployment, and support.
• Apply Agile and Waterfall methodologies to manage and execute projects effectively.
• Document processes, workflows, and technical specifications.

Role Requirements

• Bachelor’s degree in Computer Science, Computer Engineering or related technical discipline or equivalent experience demonstrated experience
• 10+ years of experience in ETL and data integration roles.
• Proficiency in R scripting and Python scripting.
• Strong knowledge of Oracle and SQL Server databases.
• Hands-on experience with ETL tools such as Informatica, Talend, or similar.
• Solid understanding of SDLC principles and software engineering best practices.
• Exposure to Agile methodologies and traditional Waterfall project execution.
• Excellent problem-solving and communication skills.

Why Novartis:
Our purpose is to reimagine medicine to improve and extend people’s lives and our vision is to become the most valued and trusted medicines company in the world. How can we achieve this? With our people. It is our associates that drive us each day to reach our ambitions. Be a part of this mission and join us! Learn more here: http://www.novartis.com/about/strategy/people-and-culture

You’ll receive: You can find everything you need to know about our benefits and rewards in the Novartis Life Handbook. http://www.novartis.com/careers/benefits-rewards

Commitment to Diversity and Inclusion: 
Novartis is committed to building an outstanding, inclusive work environment and diverse teams' representative of the patients and communities we serve.

Accessibility and accommodation 
Novartis is committed to working with and providing reasonable accommodation to individuals with disabilities. If, because of a medical condition or disability, you need a reasonable accommodation for any part of the recruitment process, or in order to perform the essential functions of a position, please send an e-mail to [email protected] and let us know the nature of your request and your contact information. Please include the job requisition number in your message

Join our Novartis Network: If this role is not suitable to your experience or career goals but you wish to stay connected to hear more about Novartis and our career opportunities, join the Novartis Network here: 
http://talentnetwork.novartis.com/network

Job Description

In this role you will create the detailed Data Digital & IT (DDIT) solution/service design, based on functional specifications to meet quality and performance requirements and technical constraints. You will be responsible for detailed design, development, code review and delivery of system solutions