Data Engineer II - Informatica & PL/SQL

Our Purpose

We work to connect and power an inclusive, digital economy that benefits everyone, everywhere by making transactions safe, simple, smart and accessible. Using secure data and networks, partnerships and passion, our innovations and solutions help individuals, financial institutions, governments and businesses realize their greatest potential. Our decency quotient, or DQ, drives our culture and everything we do inside and outside of our company. We cultivate a culture of inclusion for all employees that respects their individual strengths, views, and experiences. We believe that our differences enable us to be a better team – one that makes better decisions, drives innovation and delivers better business results.

Title and Summary

Data Engineer II - Informatica & PL/SQL

Overview
We are looking for a Data Engineer to join the Data Engineer team. This is a pivotal role, responsible for supporting multiple Data Analysts and Data Scientists day-to-day and assisting various data-driven requests across the company. The position involves a wide variety of technical skills, from coding to infrastructure, from data analysis to database management. The ideal candidate will have experience working with large-scale data and building automated data ETL processes for large-scale data analysis. ODS or data warehousing experience would be ideal.

Key responsibilities include:
• Build and maintain database technologies, environments, and applications, seeking opportunities for improvements and efficiencies
• Writes SQL statement procedures to optimize SQL execution and query development
• Effectively utilizes various tools such as Informatica for data ETL
• Manages the deployment of data solutions that are optimally standardized and database updates to meet project deliverables
• Leads database security posture, which includes proactively identifying security risks and implementing both risk mitigation plans and control functions
• Supports process improvement efforts to identify and test opportunities for automation and/or reduction in time to deployment
• Participating in the entire solution development cycle from requirement gathering to solution deployment.
• Working with multiple stakeholders across teams to fulfill ad-hoc investigations, including large-scale data extraction, transformation, and analyses.
• Supporting production code to produce comprehensive and accurate data artifacts.
• Promoting strategies to improve our data modeling, quality, and architecture.

All About You:
Highly skilled in SQL knowledge and relational databases.
3-5 years of overall career experience
Experienced with developing and maintaining data pipelines for the extraction, transformation, and/or loading of large-scale data.
Experienced with working with large data sets. You’ve implemented parallel processing and have dealt with the limitations and challenges of working with terabytes of data.
Strong analytics skills related to working with unstructured datasets.
Experienced with performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
Experienced with database administration and query optimization with different databases.
Experienced with at least one of the programming languages like Python
Capable of effectively communicating requirements and solutions to audiences with different skill sets.
Familiarity with the core requirements of data analysis and/or presentation.
Focused, innovative, and self-sufficient problem solver who is willing to independently and creatively deep-dive into an issue, cut to the heart of a problem, and solve it.
Bonus Points if:
You have any prior experience with any of the following:
• AWS; specifically Redshift, Kinesis, EMR, S3, Cloud Formation, Data Pipeline, Athena, SageMaker, Glue
• Python, PHP, Javascript, PSQL, regex, Tableau,
• Jenkins, Datadog, Splunk

Corporate Security Responsibility

All activities involving access to Mastercard assets, information, and networks comes with an inherent risk to the organization and, therefore, it is expected that every person working for, or on behalf of, Mastercard is responsible for information security and must:

• Abide by Mastercard’s security policies and practices;

• Ensure the confidentiality and integrity of the information being accessed;

• Report any suspected information security violation or breach, and

• Complete all periodic mandatory security trainings in accordance with Mastercard’s guidelines.