Archer Daniels Midland

87489BR

Job Title:

Sr. MDM Developer - Erlanger, KY

Department/Function:

Information Technology

Job Description:

Sr. MDM Developer - Erlanger, KY

Informatica Data Quality Developer

Who's ready for an exciting, fast-paced career with a global impact? Our Master Data Management team is looking for an IDQ Developer focusing on data management, data quality and data governance as we continue our transformation to SAP. We are seeking a developer who understands the architecture and possibilities available with Data Quality and Data Analysis experience. Ideal candidates partner well with teammates in the execution of end to end, large-scale, sophisticated, data-focused technology projects.

We work closely with our business teams, so the ability to build connections is critical for responding to technical queries, working with both on-site and off-site teams, handling and resolving project issues, as well as coaching, guiding, and mentoring junior members in the team. We need problem solvers who will help us identify problems, develop ideas, and propose solutions.

Job Description

• Translate functional requirements into technical requirements and development those technical requirements into code and interfaces which are used by our Global Business Services Team.

• Profile source data and determine all source data and metadata characteristics

• Design and execute a Data Quality Audit/Assessment

• Design and execute the data quality mappings that will cleanse, de-duplicate, and otherwise prepare the project data

• Implement data quality processes including transliteration, parsing, analysis, standardization and enrichment at point of entry and batch modes; Deploy mappings that will run in a scheduled, batch, or real-time environment.

• Document all mappings, mapplets, and rules in detail and hand over documentation to the customer

• Collaborate with various business and technical teams to gather requirements around data quality rules and propose the optimization of these rules if applicable, then design and develop these rules with IDQ

• Utilize “Informatica Developer” and “Informatica Analyst” to design and develop custom objects and rules, reference data tables and create/import/export mappings

• As per business requirements perform thorough data profiling with multiple usage patterns, root cause analysis and data cleansing and develop scorecards utilizing Informatica, Excel and other data quality tools

• Develop "matching" plans, help determine best matching algorithm, configure identity matching and analyze duplicates

• Build complex profiles and scripts to execute and test mappings and workflows to implement data stewardship and exception processing

• Run data quality specific ETL jobs (address standardization and validation, email cleanups, name cleanup, parsing, etc.) utilizing IDQ

• Analyze and provide data metrics to management in order to help prioritize areas for data quality improvement

• Good knowledge on writing shell-scripts to invoke mappings or workflows

• Good at writing SQL queries and verifying the results

• Should be familiar in deploying and validating objects to different environments

• Good at perform Unit Test and verifying the end results with business requirements

• Perform both record-level and large-scale manual additions, adjustments and corrections to continuously ensure overall data quality and integrity

• Maintain excellent working relationship between internal (team and the whole organization) and external parties (vendors, customers)

• Assist with special projects or ad-hoc reviews as needed

Qualifications & Technical Proficiencies

• Bachelor’s degree in Business, Computer Science, Management Information Systems, Engineering or a related experience

• Minimum 5 years of hands-on experience with Informatica Data Quality (IDQ) toolset (Version 10.x preferred) and proficiency in IDQ development around data profiling, cleansing, parsing, standardization, verification, matching and data quality exception monitoring and handling

• Experience with Data Quality, ETL, and Data Integration and the needs for each in a mature data environment.

• Experience developing External calls, workflows .

• Experience on SQL development.

• Must have the ability to build or interpret detailed project specifications to develop program logic and code.

• Strong analytical, critical thinking, and problem-solving skills

• Must be able to facilitate discussions and foster communications

• Must be a team player and able to operate under direction when needed

• Prior experience in defect analysis and bug fixes.

• Be passionate and willing to think out of the box.

Excited about this role but don’t meet every requirement listed? Studies show that often applicants will self-select out if they don’t check every box. We encourage you to apply anyway. You may be just the right candidate for this role or another one of our openings.

ADM requires the successful completion of a background check.

REF:87489BR

Req/Job ID:

87489BR

City:

Erlanger

State:

KY - Kentucky

Ref ID:

#LI-AK1

:

About ADM

At ADM, we unlock the power of nature to provide access to nutrition worldwide. With industry-advancing innovations, a complete portfolio of ingredients and solutions to meet any taste, and a commitment to sustainability, we give customers an edge in solving the nutritional challenges of today and tomorrow. We’re a global leader in human and animal nutrition and the world’s premier agricultural origination and processing company. Our breadth, depth, insights, facilities and logistical expertise give us unparalleled capabilities to meet needs for food, beverages, health and wellness, and more. From the seed of the idea to the outcome of the solution, we enrich the quality of life the world over. Learn more at www.adm.com.

:

#LI-Onsite

\t:

#IncludingYou

Diversity, equity, inclusion and belonging are cornerstones of ADM’s efforts to continue innovating, driving growth, and delivering outstanding performance. We are committed to attracting and retaining a diverse workforce and create welcoming, truly inclusive work environments — environments that enable every ADM colleague to feel comfortable on the job, make meaningful contributions to our success, and grow their career. We respect and value the unique backgrounds and experiences that each person can bring to ADM because we know that diversity of perspectives makes us better, together.

We are committed to ensuring all qualified applicants receive consideration for employment regardless of race, color, ethnicity, disability, religion, national origin, gender, gender identity, gender expression, marital status, sexual orientation, age, protected veteran status, or any other characteristic protected by law.

We welcome everyone to apply, especially those individuals who are underrepresented in our industry, as we strive to ensure our workforce represents the world that we help to feed: people of color, women, gender non-conforming, LGBTQIA+, veterans and persons with disabilities. For more information regarding our efforts to advance Diversity, Equity, Inclusion & Belonging, please visit our website here: Diversity, Equity and Inclusion | ADM. (https://www.adm.com/en-us/culture-and-careers/diversity-equity-inclusion/)

:

Benefits and Perks

Enriching the quality of life for the world begins by taking care of our colleagues. In addition to competitive pay, we support your diverse needs with a comprehensive total rewards package to enhance your well-being, including:

• Physical wellness – medical/Rx, dental, vision and on-site wellness center access or gym reimbursement (as applicable).

• Financial wellness – flexible spending accounts, health savings account, 401(k) with matching contributions and cash balance plan, discounted employee stock purchasing program, life insurance, disability, workers’ compensation, legal assistance, identity theft protection.

• Mental and social wellness – Employee Assistance Program (EAP), Employee Resource Groups (ERGs) and Colleague Giving Programs (ADM Cares).

Additional benefits include:

• Paid time off including paid holidays.

• Adoption assistance and paid maternity and parental leave.

• Tuition assistance.

• Company-sponsored training and development resources, such as LinkedIn Learning, language training and mentoring programs.

*Benefits may vary for bargained locations, confirm benefit eligibility with your recruiter.