Software Development Engineering - Advisor

Fiserv•Milwaukee, WI

5d•Onsite

About The Position

We're Fiserv, a global leader in Fintech and payments, and we move money and information in a way that moves the world. We connect financial institutions, corporations, merchants and consumers to one another millions of times a day - quickly, reliably, and securely. Any time you swipe your credit card, pay through a mobile app, or withdraw money from the bank, we're involved. If you want to make an impact on a global scale, come make a difference at Fiserv.

Requirements

Bachelor’s degree in Computer Science, Information Technology or a related field and 4 years in any job title involving Full Stack Java and ETL development experience.
4 years designing, building, and maintaining ETL pipelines
4 years of data processing
4 years maintaining data warehouses and applications
4 years working with Spring framework including Spring Core, Spring Boot and Spring Batch for backend and batch-processing applications
4 years of full stack development including front-end development using Angular framework
4 years working with Oracle, PostgreSQL, and Snowflake
4 years writing stored procedures and functions
3 years working with Snowflake data warehouse, including data modeling, performance optimization and query turning
3 years working with AWS Services including S3, EC2, RDS, Lamba, Glue for cloud-based data and application platforms
3 years implementing and supporting CI/CD Pipelines using Git, Docker, Jenkins, and Harness
2 years working with Snowflake ML and AI features for analytics

Responsibilities

Create ETL programs to meet business requirements.
Develop Java programs to establish personalized encryption methods for sharing data with external clients in Snowflake.
Develop Java backend API services to facilitate data sharing and reporting tools.
Design and develop dynamic front-end applications for merchant solutions using Angular framework and related UI technologies.
Create tables, views, procedures, and warehouses in Snowflake for the purpose of development.
Work together with the product team and the Snowflake administration team to provide solutions that fulfill data-as-a-service needs.
Analyze, improve, and resolve issues related to query and ETL performance.
Develop and oversee a CI/CD pipeline for the deployment of database objects.
Work on cloud technologies for application development and life cycle management using AWS technologies and Kubernetes clusters to ensure high availability and efficiency.
Create an ETL pipeline and establish a timetable.
Perform audits and supply documentation for audit reports and testing of disaster recovery plans.
Create and enhance different physical database structures, including tables, indexes, objects, partitions, sub partitions, materialized views, and views, to fulfill business needs.
Create and implement new stored procedures, database packages, functions, and triggers within Snowflake, Oracle Exadata, and DB2 databases.
Address data requests and deliver extracts to the business team.
Supervise and support daily production activities while conveying notifications and alerts to the teams.
Follow the incident procedure and manage the incident issues reported by external or internal clients.
Respond to security vulnerabilities identified by external vendors or internal scanning tools.