Data Engineer / Testing

POSITION SUMMARY
Summarize the primary purpose & key accountabilities of the position, including scope of responsibility in 5-7 concise sentences. (i.e. Global vs. Country/Region) It may be helpful to complete this section after you have finished the other sections of the document.

Zoetis, Inc. is the world's largest producer of medicine and vaccinations for pets and livestock. The Zoetis Tech & Digital (ZTD) Global ERP organization is as a key building block of ZTD comprising of enterprise applications and systems platforms.
Join us at Zoetis India Capability Center (ZICC) in Hyderabad, where innovation meets excellence. As part of the world's leading animal healthcare company, ZICC is at the forefront of driving transformative advancements and applying technology to solve the most complex problems. Our mission is to ensure sustainable growth and maintain a competitive edge for Zoetis globally by leveraging the exceptional talent in India.
At ZICC, you'll be part of a dynamic team that partners with colleagues worldwide, embodying the true spirit of One Zoetis. Together, we ensure seamless integration and collaboration, fostering an environment where your contributions can make a real impact. Be a part of our journey to pioneer innovation and drive the future of animal healthcare.
We are seeking a skilled Data Engineer to join our team. The ideal candidate will have experience with the Microsoft Azure technical stack and a passion for building robust data solutions. You will work closely with our data engineering team to design, develop, and maintain data pipelines and infrastructure, that serve our customers across our ZTD ecosystem.
Join us in shaping the future of data-driven applications and engineering within the DX Data team.

POSITION RESPONSIBILITIES
In order of importance, list the primary responsibilities critical to the performance of the position. It is recommended not to list actual tasks but focus on essential responsibilities that highlight accountability and level of judgment required.

Percent of Time (sum of responsibilities should equal to 100%)
Data Solution Design:
o Collaborate with cross-functional teams to deliver on data strategy, architecture, and governance.
o Design and deploy data solutions in the cloud, ensuring scalability, performance, and cost-effectiveness.
Data Pipelines and Integration:
o Create and maintain data pipelines using Azure Databricks, Azure Data Factory, and other Azure services.
o Extract, transform, and load (ETL) data from various sources into data warehouses or data lakes.
o Ensure efficient data cleaning, conversion, and loading processes.
Data Storage and Management:
o Work with various Azure data storage options, including:
 Azure SQL Database
 Azure Data Lake Storage
 Azure Cosmos DB
 Azure Blob Storage
o Design storage systems that meet organizational requirements.
o Support operational Azure SQL databases, including performance monitoring, query optimization, and DBA type tasks.
65%
Big Data and Analytics:
o Utilize big data technologies such as Azure Databricks and Apache Spark, Delta.
o Develop data processing workflows and pipelines to handle and analyze large volumes of data.
o Support data analytics, machine learning, and other data-driven applications. 25%
* Azure Functions Development:
o Proficiency in creating, deploying, and managing serverless functions using Azure Functions.
o Knowledge of triggers (e.g., HTTP, timer, queue, blob) and bindings (e.g., Cosmos DB, Azure Storage, Service Bus).
* Event-Driven Architecture:
o Understanding of event-driven design patterns and how to build scalable, event-triggered workflows.
o Ability to integrate Azure Functions with other Azure services (e.g., Logic Apps, Event Grid).
* Serverless Best Practices:
o Familiarity with best practices for optimizing performance, monitoring, and error handling in serverless applications. 10%

ORGANIZATIONAL RELATIONSHIPS
Provide the primary groups or key positions that this position will have interaction with as a regular part of the position responsibilities. Include any external interactions as appropriate.

Collaboration with product managers, product owners, scrum masters, development and testing teams.

EDUCATION AND EXPERIENCE
Indicate the formal education, certification or license required and/or preferred. Include the minimum number of years of relevant experience required for the position (where legally permissible).
* A bachelor's degree in computer science, information technology, or a related field is required.
* Minimum 8+ years of proven experience as a Data Engineer or in a similar role.

TECHNICAL SKILLS REQUIREMENTS
Indicate the technical skills required and/or preferred, as applicable.

Required:

* Azure Services: Strong hands-on experience with Azure Databricks, ADF, Azure SQL, CosmosDB, and Azure Synapse.
* Data Technologies: Proficiency with Data Lake, data warehouse, Big Data, and Spark.
* Programming Languages: Experience with Python, SQL, and Scala.
* Data Processes: Familiarity with data modeling, ETL processes, and data warehousing concepts.
* Analytical Skills: Excellent analytical and problem-solving skills with attention to detail.
* Data Verification: Strong experience in verifying, comparing, and troubleshooting data across environments.
* Version Control: Experience with applying version control systems for create and migration scripts.
* Database Optimization: Expertise in best practices for database performance optimization.
* Stored Procedures: Strong experience in creating complex functions and stored procedures.
* SQL Knowledge: In-depth knowledge of SQL and relational database management systems (RDBMS).
* Data Modeling: Experience in building and evolving data models (Conceptual, Logical, Physical).
* Database Standards: In-depth knowledge of database best practices and standards.
* Warehousing Concepts: Familiarity with data warehousing and business intelligence tools.
* Database Systems: Experience with a range of database systems, from traditional RDBMS/SQL to NoSQL and other scalable database technologies.
* Attention to Detail: Excellent attention to detail and a keen eye for usability issues.
* Testing Techniques: Experience with manual and exploratory testing techniques.
* Effectiveness: Proactive and collaborative team player with a strong commitment to meeting deadlines and delivering high-quality work. Efficient time management and prioritization skills

Desired:
* Passion for solving complex problems and making a difference.
* Experience with product development and collaborating in agile teams.
* Strong aptitude for learning new technologies, and continuous professional development.
* The ability to collaborate with a diverse group of people.
* Highly motivated and self-starting individual
* Familiarity with bug tracking and collaboration tools (e.g., Jira, Zephyr Scale, Confluence) is a plus.

PHYSICAL POSITION REQUIREMENTS
Note the physical conditions in which work will be performed, if applicable to the position. Examples: Lifting, sitting, standing, walking, ability to travel, drive, unusual attendance requirements, weekend work or travel requirements, etc.

Regular working hours are from 1:00 PM to 10:00 PM IST
Sometimes, more overlap with the EST Time zone is required during production go-live.
Some weekend work may be required to assist in data changes to systems during releases (estimated once every 2-3 months).

This description indicates the general nature and level of work expected. It is not designed to cover or contain a comprehensive listing of activities or responsibilities required of the incumbent. Incumbent may be asked to perform other duties as required. Additional position specific requirements/responsibilities are contained in approved training curricula.

About Zoetis

At Zoetis, our purpose is to nurture the world and humankind by advancing care for animals. As a Fortune 500 company and the world leader in animal health, we discover, develop, manufacture and commercialize vaccines, medicines, diagnostics and other technologies for companion animals and livestock. We know our people drive our success. Our award-winning culture, built around our Core Beliefs, focuses on our colleagues' careers, connection and support. We offer competitive healthcare and retirement savings benefits, along with an array of benefits, policies and programs to support employee well-being in every sense, from health and financial wellness to family and lifestyle resources.

Global Job Applicant Privacy Notice