Corteva Agriscience(Agriculture Division of Dow DuPont) is the world leader in the plantbiotechnology industry including the discovery, development and delivery ofelite crop genetics and crop protection solutions.
Our DataScience & Informatics (DSI) department in R&D is looking for creative individuals withcritical thinking skills to develop robust and innovative solutions to complexproblems. We solve research problems using custom software development, datascience, high performance computing, laboratory automation, electro-mechanicalengineering, and computational biology.
We are seeking a proven Data Warehouse Engineer to unleashthe value of data in ways that create value for our Research partners within the Data Science & Informatics group. We are looking for creative individualswho possess the knowledge to understand complex data and relationships andthe ability to work with large data sets and Big Data to build efficient dataintegration solutions in building and supporting our Data Warehouse platformfor reporting & analytics.
If you have demonstrated the ability to implementsolutions, adjusting to constraints while mitigating risks; if youbalance great technical depth with strong interpersonal skills and emphasizecommunication in your day to day work; if you are interested in applying yourskills in a challenging, dynamic, agriculture focused research environment -we'd love to talk to you.
We offer an inspiring, dynamic work environment with amazingcolleagues and countless opportunities to apply your talents and skills in newand innovative ways. At Corteva we recognize that there is life outside of workand support you in establishing a healthy work-life balance.
The successful candidate will helpintegrate data from a variety of data sources into Corteva's Research Data Warehouseto support reporting and analytical applications. The candidate will work withthe R&D partners within Data Science & Informatics group in Designingand Developing ETL/ELT processes as well as proper representations of theintegrated data and delivery methods for downstream applications.
Data Science & Informatics team
Design, develop, own and evolve the data anddata integration processes that power our data warehouse platform.
Design, Develop and implement on-premise & cloudDW infrastructure.
Develop and maintain complex Data Ingestion and
Transformations for data originating from multiple data sources.
Contribute to architecture of data integrationsolutions
Collaborate with teams across DSI to share andacquire development ideas and knowledge.
Create efficient SQL queries & ETL Mappingsusing Informatica & Python/SQL to analyze data from external applicationsand the data warehouse.
Evaluate and recommend products that enhance ourcloud BI / DW solution.
Analyze and resolve user issues reported to the
Bachelor's degree in Computer Science, Computer Engineeringor related field and 5+ years of experience developing data warehouse solutionsrequired; or equivalent levels of relevant education and experience.
The ideal candidate will have strong written and verbalcommunication skills and have the demonstrated ability to work collaborativelyin a multifunctional team.
This position requires proven experience in data warehousingpractices and concepts as well as proven experience in dimensional andrelational database modeling.
Highly desirable experience includes the following:
Lambda experience is preferred.
Strong working knowledge of NearRealtime Data Warehousing principles and implementations.
Working knowledge of key RDBMSdatabases like Oracle, Teradata, and other Cloud DW.
Strong practical experience with SQLand Database principles.
Experience in working with ETL toolsand technologies like Informatica and others.
Experience with the Linux operatingsystem is very beneficial.
Create Technical Designs and MappingSpecifications.
Hands-on experience in Query Optimizationand Performance improvement practices.
Experience in Relational and
Dimensional Data Modeling.
Experience with Agile developmentmethodologies.
Experience in Data VirtualizationPlatform using tools like Denodo and others is preferred.
Communicate well in both oral andwritten form.
We are excited to announcethat Corteva Agriscience is the name of the new Agriculture Divisionof DowDuPont. We are bringing together DuPont Crop Protection, DuPontPioneer and DowAgroSciences to create a market-shaping, standaloneagriculture company with leading positions in seed technologies, cropprotection and digital agriculture. We will work across the global agriculturevalue chain to create a more efficient food system.
At Corteva Agriscience,we seek to enrich the lives of those who produce and those who consume. Thismeans we will help rejuvenate the agricultural ecosystem to support people andthe planet and to ensure progress for generations to come.