Company 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 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 support 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 2-3 set days a week (determined by leadership/site), with a general guidepost of being in the office 50% or more of the time based on business needs.
Qualifications Basic Qualifications:
• 5+ years of relevant work experience with a Bachelor’s Degree or at least 2 years of work experience with an Advanced degree (e.g. Masters, MBA, JD, MD) or 0 years of work experience with a PhD, OR 8+ years of relevant work experience.
Preferred Qualifications:
• 6 or more years of work experience with a Bachelors Degree or 4 or more years of relevant experience with an Advanced Degree (e.g. Masters, MBA, JD, MD) or up to 3 years of relevant experience with a PhD
• 10 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 Hadoop, Tableue or Big data technologies are a big plus
• 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.
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.