Software Engineer II (Bigdata / Spark / Apache / NIFI/ AirFlow / Unix / Oracle / Hadoop)

Our Purpose Mastercard powers economies and empowers people in 200+ countries and territories worldwide. Together with our customers, we’re helping build a sustainable economy where everyone can prosper. We support a wide range of digital payments choices, making transactions secure, simple, smart and accessible. Our technology and innovation, partnerships and networks combine to deliver a unique set of products and services that help people, businesses and governments realize their greatest potential. Title and Summary Software Engineer II (Bigdata / Spark / Apache / NIFI/ AirFlow / Unix / Oracle / Hadoop) Overview Mastercard is the global technology company behind the world’s fastest payments processing network. We are a vehicle for commerce, a connection to financial systems for the previously excluded, a technology innovation lab, and the home of Priceless®. We ensure every employee has the opportunity to be a part of something bigger and to change lives. We believe as our company grows, so should you. We believe in connecting everyone to endless, priceless possibilities. As a Test Engineer in Data Platform and Engineering Services, you will have the opportunity to build frameworks to perform testing on the ETL jobs as well as high performance data pipelines which loads data into Mastercard Data Warehouse. Our Data Warehouse provides analytical capabilities to number of business users who help different customer provide answer to business problems through data. You will play a vital role within a rapidly growing organization, while working closely with experienced and driven engineers to solve challenging problems. Role • Develop test frameworks to perform testing data stored in Unix/ Hadoop/ S3/ Oracle. • Write SQLs (Oracle, Hive, Impala, Spark) to perform data analysis and do root causes analysis of the issues identified • Good understanding of any of the programming language (Unix, PL SQL or SQL) would be addon. • Follow MasterCard Quality Assurance and Quality Control processes • Leverage new technologies and approaches to innovating with automating testing for large data sets • Work with project team to meet scheduled due dates, while identifying emerging issues and recommending solutions for problems • Perform assigned tasks and production incident independently • Contribute ideas to help ensure that required standards and processes are in place and actively look for opportunities to enhance standards and improve process efficiency All About You • 3 to 5 years of experience in Testing Data Warehouse related projects in product or service based organization. • Expertise in Data Engineering and implementing testing methodologies in multiple end-to-end data warehouse projects. • Experience of working with Databases like Oracle and have strong SQL knowledge • Experience of working on Nifi/Airflow and big data technologies will be an added advantage • Experience of any test automation tools would be a plus • Experience of working in Agile teams • Strong analytical skills required for debugging production issues, providing root cause and implementing mitigation plan • Strong communication skills - both verbal and written – and strong relationship, collaboration skills and organizational skills • Ability to be high-energy, detail-oriented, proactive and able to function under pressure in an independent environment along with a high degree of initiative and self-motivation to drive results • Ability to quickly learn and implement new technologies, and perform POC to explore the best solution for the problem statement • Flexibility to work as a member of a matrix based diverse and geographically distributed project teams 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.