Sr Applications Developer

Date: Aug 23, 2024

Location:

Bangalore, India, 560064

Company: Teva Pharmaceuticals

Job Id: 46975

Who are we?

Teva is a global pharmaceutical leader and the world's largest generic medicines producer, committed to improving health and increasing access to quality health solutions worldwide. Our employees are at the core of our success, with colleagues in over 80 countries delivering the world's largest medicine cabinet to 200 million people every day. We offer a uniquely diverse portfolio of products and solutions for patients and we've built a promising pipeline centered around our core therapeutic areas. We are continually developing patient-centric solutions and significantly growing both our generic and specialty medicines business through investment in research and development, marketing, business development and innovation. This is how we improve health and enable people to live better, healthier lives. Join us on our journey of growth!

Opportunities

We are seeking a highly skilled and experienced SQL Server Database Developer with a minimum of five years of hands-on expertise in Microsoft SQL Server SSIS and SSRS. As a Database Developer, you will play a pivotal role in designing, implementing, and optimizing ETL (Extract, Transform, Load) processes and database architecture for our organization

Job Description

• Collaborate with cross-functional teams to gather requirements, understand business needs, and translate them into technical specifications for ETL processes and reports.

• Develop and maintain ETL processes using Microsoft SQL Server Integration Services (SSIS) to extract data from various sources, transform it into the desired format, and load it into target databases.

• Design, create, and manage Microsoft SQL Server Reporting Services (SSRS) reports.

• Optimize database performance and ensure data integrity by fine-tuning queries, creating indexes, and monitoring database health.

• Troubleshoot and resolve data-related issues, identifying root causes and implementing effective solutions.

• Continuously enhance and maintain existing ETL workflows, reports, and data models to meet evolving business requirements.

• Contribute to the development of data governance and data quality initiatives to ensure data accuracy and consistency.

• Troubleshoot and provide production support of existing processes.

• Provide regular project updates to business analysts and management.

• Develop and maintain system documentation.

• Stay up-to-date with the latest industry trends, best practices, and technologies related to ETL, data warehousing, and reporting.

Qualifications

• Bachelor’s degree in Computer Science or 7+ years relevant development experience.

• Minimum of five years of professional experience as a SQL Server Database Developer, specializing in ETL processes and database architecture using Microsoft SQL Server SSIS and SSRS.

• Proficiency in SQL scripting and experience with complex queries, stored procedures, and performance optimization techniques.

• Solid understanding of data warehousing concepts, data modeling, and database design principles.

• Proven ability to work with large datasets and handle data integration challenges effectively.

• Strong analytical and problem-solving skills, with a keen eye for detail and accuracy.

Skills and Capabilities

• Demonstrated experience of project estimation and planning.

• Excellent written and verbal communication skills ability to work effectively with both technical and non-technical stakeholders.

• Self-motivated and proactive, with the ability to work independently and as part of a team.

• Good organizational and time management skills, ability to be flexible, set priorities and meet deadlines in a changing environment.

• Commercial pharmaceuticals industry experience and knowledge a plus.

• Proficiency with MS Office tools and applications.

• SQL Development skills (Required).

• Vertica database skills (Preferred).

• Informatica Power Center and MDM (Preferred).

• Tableau Desktop and Tableau Server experience (Optional).

• RPA Automation (Optional).

• Familiarity or experience with SalesForce or Veeva CRM (Optional).

• Use of Pragmatic Works Task Factory (Optional).

• Fluent English – reading, writing, speaking

Function

Information Technology

Sub Function

Application Development

Reports To

Sr. Manager, Business Applications

Teva’s Equal Employment Opportunity Commitment

Teva Pharmaceuticals is committed to equal opportunity in employment. It is Teva's global policy that equal employment opportunity be provided without regard to age, race, creed, color, religion, sex, disability, pregnancy, medical condition, sexual orientation, gender identity or expression, ancestry, veteran status, national or ethnic origin or any other legally recognized status entitled to protection under applicable laws.

EOE including disability/veteran