Senior Data Engineer – Data warehouse
Bengaluru, India
Visa
Das digitale und mobile Zahlungsnetzwerk von Visa steht an der Spitze der neuen Zahlungstechnologien für die neue Zahlung, elektronische und kontaktlose Zahlung, die die Welt des Geldes bildenCompany Description
Visa is a world leader in digital payments, facilitating more than 215 billion payments transactions between consumers, merchants, financial institutions and government entities across more than 200 countries and territories each year. Our mission is to connect the world through the most innovative, convenient, reliable and secure payments network, enabling individuals, businesses and economies to thrive.
When you join Visa, you join a culture of purpose and belonging – where your growth is priority, your identity is embraced, and the work you do matters. We believe that economies that include everyone everywhere, uplift everyone everywhere. Your work will have a direct impact on billions of people around the world – helping unlock financial access to enable the future of money movement.
Join Visa: A Network Working for Everyone.
Job Description
Verifi a Visa entity operates a network enabling data sharing among Acquirers, Merchants & Issuers for fraud prevention, dispute prevention and revenue recovery. Below are the key product solutions which are managed by this technology team
Card Holder Dispute Resolution Network (CDRN) - Resolve pre-dispute cases directed by participating CDRN issuers.
Intelligence Suite - Risk management platform that allows merchant to customize services to protect their business, gain greater customer insights and seamlessly keep pace with emerging fraud threats
The Verifi reporting and analytics team is responsible for all facets of architecture, software development and production support of data pipelines, ETL process, reporting and analytics system.
The reporting and analytics team support Visa's Business users in Billing, Client Services, Issuer Processing and Global Contact Center Teams in providing access to data and insights from multiple applications.
As a Sr. Data Engineer supporting reporting and analytics group, you will be responsible for designing, developing and implementing Data integration and Analytics solutions on relational databases (MS SQL Server) using Wherescape Red ETL tool to enable self-service reporting. Based on deep understanding and knowledge of ETL and data engineering techniques, you will develop and maintain data and tools to provide self-service to Business users. Your ability to work across functions and teams will allow you to drive results and foster the right culture and environment to achieve Engineering Excellence and Innovation.
Essential Functions:
- Support Data warehouse Engineering in the architecture, development, and employment of MS SQL Database on LUW in high SLA environments.
- Solid understanding on data model for facts and dimensions. Ability to provide logical and physical design for the given business requirements.
- Design scalable data warehouse solution using SQL Server and Hadoop.
- Engage in proof of concepts on new SQL Server features and advocate the business benefits to the leadership team.
- Provide data warehouse engineering for off the shelf and external merchant facing applications.
- Implementation of databases, storage structures, high-availability solutions, replication, encryption, and disaster recovery solutions.
- Follow the industry best practice in writing TSQL code and unit test cases.
- Proactive performance analysis, troubleshooting and resolution of database issues.
- Work very closely with the application team and DBA team to ensure delivery of database services within the SLA's and performance target set.
- Integrate the DWH code with the Redgate for the automated deployment.
- Support P1/P2 database issues which impacts the customer applications.
- Manage, support, and maintain database technology and infrastructure, adhering to the architectural guidelines and policies.
- Address vulnerabilities and TSR findings reported by the DBA team.
- Ability to work well as a team and as an individual with minimal supervision.
This is a hybrid position. Hybrid employees can alternate time between both remote and office. Employees in hybrid roles are expected to work from the office two days a week, Tuesdays and Wednesdays with a general guidepost of being in the office 50% of the time based on business needs.
Qualifications
• 7 years of work experience with a bachelor’s degree or at least 8 years of work experience with a master’s degree• Extensive experience in implementing SQL Server 2017, SQL 2019, and MySQL 8.0 features.
• Experience in writing complex SQL queries is required.
• Hands on experience in Wherescape RED or equivalent ETL tool.
• Experience in providing data analysis and data validation is required
• Experience in scripting, scheduling and version control technologies is required
• Good understanding of the high availability and disaster recovery options. Expert in SQL Server native replication.
• Experience with tools development, automation (CI/CD, Auto Deployment with Redgate, System Availability, etc.).
• Extended experience in Agile Release Management practices, governance, and planning.
• Ability to quickly identify and manage/mitigate risks.
• Ability to influence Senior Leadership on direction of engineering efficiencies and integration management through data, roadmaps, short/long term plans, etc.
• Strong ability to build and sustain working and strategic relationships across technology.
• Strong leadership skills with demonstrated ability to lead global, cross-functional teams.
• Strong analytical and problem-solving skills.
• Ability to maintain composure under pressure and tight deadlines.
Please Note: Due to the COVID-19 pandemic and the evolving visa/travel restrictions in place, we are currently only able to extend offers to candidates with the right to work in Singapore. We are keeping the situation under close review and will adjust accordingly should the restrictive measures be lifted.
Additional Information
Visa is an EEO Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status. Visa will also consider for employment qualified applicants with criminal histories in a manner consistent with EEOC guidelines and applicable local law.* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile Architecture CI/CD Data analysis Data pipelines Data warehouse Engineering ETL Hadoop MS SQL MySQL Pipelines RDBMS SQL T-SQL
Perks/benefits: Startup environment
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Marketing Data Analyst jobs
- Open MLOps Engineer jobs
- Open AI Engineer jobs
- Open Junior Data Scientist jobs
- Open Data Engineer II jobs
- Open Senior Data Architect jobs
- Open Sr Data Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Analytics Engineer jobs
- Open Power BI Developer jobs
- Open Manager, Data Engineering jobs
- Open Product Data Analyst jobs
- Open Principal Data Engineer jobs
- Open Business Data Analyst jobs
- Open Data Quality Analyst jobs
- Open Data Manager jobs
- Open Sr. Data Scientist jobs
- Open Data Scientist II jobs
- Open Big Data Engineer jobs
- Open Business Intelligence Developer jobs
- Open Data Analyst Intern jobs
- Open Principal Data Scientist jobs
- Open ETL Developer jobs
- Open Azure Data Engineer jobs
- Open Data Product Manager jobs
- Open Business Intelligence-related jobs
- Open Data quality-related jobs
- Open Privacy-related jobs
- Open Data management-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open Deep Learning-related jobs
- Open APIs-related jobs
- Open PyTorch-related jobs
- Open PhD-related jobs
- Open TensorFlow-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open NLP-related jobs
- Open Data governance-related jobs
- Open Data warehouse-related jobs
- Open Databricks-related jobs
- Open Airflow-related jobs
- Open Hadoop-related jobs
- Open LLMs-related jobs
- Open DevOps-related jobs
- Open CI/CD-related jobs