Mgr Application Development
Date:
Dec 15, 2024
Location:
Bangalore, India, 400706
Company:
Teva Pharmaceuticals
Job Id:
58385
Who we are
Together, we’re on a mission to make good health more affordable and accessible, to help millions around the world enjoy healthier lives. It’s a mission that bonds our people across nearly 60 countries and a rich, diverse variety of nationalities and backgrounds. Working here means working with the world’s leading manufacturer of generic medicines, and the proud producer of many of the products on the World Health Organization’s Essential Medicines List. Today, at least 200 million people around the world take one of our medicines every single day. An amazing number, but we’re always looking for new ways to continue making a difference, and new people to make a difference with.
The opportunity
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, he/she will play a pivotal role in designing, implementing, and optimizing ETL (Extract, Transform, Load) processes and database architecture for our organization
How you’ll spend your day
- 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.
Your experience and 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.
- Willing to work US hours on as needed basis for critical meetings
- Minimal travel (less than 10%)
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
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. We are committed to a diverse and inclusive workplace for all. If you are contacted for a job opportunity, please advise us of any accommodations needed to support you throughout the recruitment and selection process. All accommodation information provided will be treated as confidential and used only for the purpose of providing an accessible candidate experience.