Specialist Data Integration

Major Accountabilities

• 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.

Required Skills & Qualifications:

• 3–5 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.

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 diversityandincl.india@novartis.com and let us know the nature of your request and your contact information. Please include the job requisition number in your message

Why Novartis: Helping people with disease and their families takes more than innovative science. It takes a community of smart, passionate people like you. Collaborating, supporting and inspiring each other. Combining to achieve breakthroughs that change patients’ lives. Ready to create a brighter future together? https://www.novartis.com/about/strategy/people-and-culture

Join our Novartis Network: Not the right Novartis role for you? Sign up to our talent community to stay connected and learn about suitable career opportunities as soon as they come up: https://talentnetwork.novartis.com/network

Benefits and Rewards: Read our handbook to learn about all the ways we’ll help you thrive personally and professionally: https://www.novartis.com/careers/benefits-rewards