Staff (Servicenow) Systems Engineer

Visa Ashburn , VA 20147

Posted 3 months ago

As the world's leader in digital payments technology, Visa's mission is to connect the world through the most creative, reliable and secure payment network - enabling individuals, businesses, and economies to thrive. Our advanced global processing network, VisaNet, provides secure and reliable payments around the world, and is capable of handling more than 65,000 transaction messages a second. The company's dedication to innovation drives the rapid growth of connected commerce on any device, and fuels the dream of a cashless future for everyone, everywhere. As the world moves from analog to digital, Visa is applying our brand, products, people, network and scale to reshape the future of commerce.

At Visa, your individuality fits right in. Working here gives you an opportunity to impact the world, invest in your career growth, and be part of an inclusive and diverse workplace. We are a global team of disruptors, trailblazers, innovators and risk-takers who are helping drive economic growth in even the most remote parts of the world, creatively moving the industry forward, and doing meaningful work that brings financial literacy and digital commerce to millions of unbanked and underserved consumers.

You're an Individual. We're the team for you. Together, let's transform the way the world pays.

Essential Functions

  • Develop SSIS projects / packages to import data sets using ETL capabilities including, transmission, encryption, and archiving of data sets received and generated

  • Design, develop, and maintain database tables, stored procedures, and supporting objects

  • Develop Views with Business Logic as part of new data import sets into the CMDB

  • As part of Releases and Updates, document and perform necessary System / Unit test to ensure the ETL code delivered is running and conforms to specifications and design guidelines

  • Develop test plans to ensure functionality has been implemented correctly

  • Document deployment procedures

  • Develop documentation to support the ongoing support and maintenance of any solutions developed

  • Support Management & Business Analyst's, as well as other members of the team in gathering and/or clarifying data and requirements from subject matter experts

  • Build and maintain relationships with users to ensure adoption and buy-in of ETL solutions

  • Manage platform and currency of system and database related patches, along with necessary drivers for integrations and data imports, in accordance with VISA policy and guidelines.

  • Troubleshoot and remediate issues with nightly job processing and data import

  • Identify corrective actions and long term fixes to address chronic / recurring issues.

  • Develop SQL queries and support ad hoc requests for data

  • Monitor the status of packages on a daily basis to ensure no operational issues and data is staged accordingly for import

  • Develop new Reports and Dashboard capabilities related to Operational Health of SSIS packages, jobs, and job latency or timing issues.

  • Maintain operational documentation to support the environment

  • Ability to work independently with users and stakeholders

Minimum Qualifications:

  • Bachelor's degree in Computer Science, Computer Engineering, Information Systems, or a related field

  • 5-7 years' experience operating, managing and developing ETL packages / projects in a large enterprise environment supporting large datastores.

  • 5+ years' experience with Microsoft SSIS version 2012 or later

  • 5+ years' experience writing complex stored T-SQL, procedures, functions, and SQL queries

  • Working experience integrating systems using various methods including direct SQL queries, Powershell or other Scripting logic, Rest API's, and / or .CSV's.

  • Experience loading and extracting XML and or JSON data to/from databases

  • Experience developing reports using Microsoft SQL Server Reporting Services (SSRS) 2012 or later

  • Working knowledge / experience with system / platform administration to manage patching, drivers, etc.

  • Experience implementing data warehouses

  • Hands on experience in Java/JavaScript and open source tools in a Windows Platform, MySQL and agile development environment.

  • Experience with database design schemas and data modelling.

  • Familiarity with JavaScript, JSON, AJAX, CSS, XHTML and XML

  • Previous experience of working in a Agile development methodology / environment.

  • Experience working with code repositories including TFS to manage packages & code libraries for releases and updates

Preferred Qualifications

  • SSIS development with large scale database experience (millions of rows per day), both developing new packages and modifying/refactoring existing packages.

  • SQL Server DBA experience with complex queries, views and stored proc design and development.

  • SQL Server 2016 or newer with experience developing REST integrations to external sources utilizing the SSIS packages

  • Some C# development to do basic source file validation and exception handling

  • ServiceNow Data Source / Transform Map development experience.

Additional Information

Work Hours

This position requires the incumbent to be available during core business hours.

Travel Requirements

This position requires the incumbent to travel for work 10% of the time.

Mental/Physical Requirements

This position will be performed in an office setting. The position will require the incumbent to sit and stand at a desk, communicate in person and by telephone, frequently operate standard office equipment, such as telephones and computers, and reach with hands and arms.

EEO Statement

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.


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Staff (Rhel) Systems Engineer

Visa

Posted 1 week ago

VIEW JOBS 1/16/2020 12:00:00 AM 2020-04-15T00:00 As the world's leader in digital payments technology, Visa's mission is to connect the world through the most creative, reliable and secure payment network - enabling individuals, businesses, and economies to thrive. Our advanced global processing network, VisaNet, provides secure and reliable payments around the world, and is capable of handling more than 65,000 transaction messages a second. The company's dedication to innovation drives the rapid growth of connected commerce on any device, and fuels the dream of a cashless future for everyone, everywhere. As the world moves from analog to digital, Visa is applying our brand, products, people, network and scale to reshape the future of commerce. At Visa, your individuality fits right in. Working here gives you an opportunity to impact the world, invest in your career growth, and be part of an inclusive and diverse workplace. We are a global team of disruptors, trailblazers, innovators and risk-takers who are helping drive economic growth in even the most remote parts of the world, creatively moving the industry forward, and doing meaningful work that brings financial literacy and digital commerce to millions of unbanked and underserved consumers. You're an Individual. We're the team for you. Together, let's transform the way the world pays. The Team: The global systems engineering group is responsible for engineering and support of the IT infrastructure for Visa Inc. and VisaNet. This includes planning, design, evaluation, installation, deployment, and maintenance of the IT infrastructure for the data centers and office facilities. The Job Purview: This is an individual contributor role responsible for solving complex problems and taking a broad perspective to identify creative solutions. This role serves as a technical and functional specialist and works independently with guidance only in the most complex situations. This position can be hired in Foster City, CA, Highlands Ranch, CO, or Ashburn, VA. Essential functions: * Work in a complex, highly-secure, and highly available operations environments and interacting with the technology domain authorities required to maintain those environments * Function as the compute lead on critical infrastructure projects and initiatives * Write technical design and build documentation for compute infrastructure * Develop ITIL procedures, technology strategy, engineering standards, methodologies, task-plans and standard methodologies for Distributed Compute Engineering * Collaborate with partner Engineering Disciplines to develop Infrastructure Building Blocks based Reference Architectures and standards that can be offered as services to our customers * Mentor junior team members Basic Qualifications: * 10-15 years of work experience with a Bachelor's Degree in Computer Science or a related field, or at least 8 years of work experience with an Advanced Degree (e.g. Masters/MBA/JD/MD) or at least 3 years of work experience with a PhD * 5+ years' experience with RHEL * In-depth experience (5+ years) with one of the following Operating Systems: Red Hat Enterprise Linux 6 or 7, or Ubuntu 18.x above * 5+ years of strong Hardware and OS deployment experience in one of the following server product lines: HP ProLiant and/or Dell PowerEdge * 2+ years experience with one of the enterprise class virtualization technologies such as VMware and/or Linux KVM Virtualization * Ability to write technical design and build documentations for all aspects of a technical infrastructure * Solid ability to integrate content from other domain areas and construct final technical design documents * Solid ability to provide level 3 support and guide level 2 administrators on problem resolution. Exhibit understanding and perform operational acceptance/turnover activities Preferred Qualifications: * Engineering knowledge and hands-on experience with either Linux container technology, Docker and/or SELinux. * Hands on experience on Kubernetes is a plus. * Strong scripting skills in UNIX environments. In-depth experience in deployment and workflow automation * Experience in one of the automation and workflow tools such as Ansible and/or Jenkins. * Strong analytical and technical troubleshooting skills, and possess an ability to explain technical concepts and provide mentorship to junior staff * Strong expertise and experience in system monitoring techniques and tools * Strong understanding of big data technologies including Hadoop and/or GPFS * Hands on experience with back end technologies including Satellite Server and Landscape * Authoritative knowledge in server end SAN/NAS configuration and troubleshooting * Ability to analyze, fix and take on storage stack issues (Hosts, SAN switches and Storage Devices) * Engineering knowledge in TCPIP networking link aggregation/redundancy, switches, routing and load-balancing Work Authorization: * Authorization to work in the U.S. in a precondition of employment for this position. Visa will not sponsor applicants for work visas in connection with this position. Job Location * This position and its incumbent can be based in Foster City, CA, Highlands Ranch, CO, or Ashburn, VA. Work Hours: * Incumbent must make themselves available during core business hours * Requires availability to meet with teams in the Asia Pacific or Europe time zones as needed Travel Requirements: * This position requires the incumbent to travel for work ~5% of the time. Physical Requirements: * This position will be performed in an office setting. The position will require the incumbent to sit and stand at a desk, communicate in person and by telephone, frequently operate standard office equipment, such as telephones and computers, and reach with hands and arms. 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. Visa Ashburn VA

Staff (Servicenow) Systems Engineer

Visa