ETL Engineer - Mid Level (Evergreen)
Plano, TX

Job Description

Purpose of JobWe are currently seeking talented ETL Engineers - Mid Level for our Plano facility.

USAA ETL Engineers are not only Data Professionals but are also well versed in our business goals and member's needs. USAA is driven by personal service, but we are fueled by data. Understanding the trends and meaning behind our data helps us improve the member experience. And to us, that's priceless (which is saying something for a financial company).

Here, you will find more than IT solutions within the data. You will discover the trust, new ideas, human interactions and better ways to impact our members.

As an ETL Engineer, you will work to harden, enhance and support our data and analytics environments, cycles, data quality, dashboards and reports. You will work with team members on projects that include Return-to-Service (RTS) analysis, break-fix enhancements, ETL framework enhancements, data quality enhancements, usage reporting and general design, coding and release/build activities.

Job Requirements

Tasks:

With limited guidance performs defect correction (analysis, design, code) on less complex issues and/or codes applications of medium complexity.

With guidance begins to install, customize and integrate commercial software packages.

Works with more tenured peers to gain understanding of systems while conducting root cause analysis of issues, reviewing new and existing code and/or performing unit testing Works with experienced team members to conduct root cause analysis of issues, review new and existing code and/or perform unit testing.

Learns to create system documentation/play books and attends requirements, design and code reviews.

Receives work packages from manager and/or delegates.

Understands and assists in gathering and analyzing customer requirements and may respond to outages following the appropriate processes.

Partners with experienced team members to develop accurate estimates on work packages.

May begin to identify issues that impact availability.

Minimum Education:

Bachelor's degree required.

4 additional years of related experience beyond the minimum required may be substituted in lieu of a degree.

Minimum Experience:

2 or more years of development experience specific to I/T discipline/technology(s)

ABOUT USAA

USAA knows what it means to serve. We facilitate the financial security of millions of U.S. military members and their families. This singular mission requires a dedication to innovative thinking at every level.

In each of the past five years, we've been a top-40 Fortune 100 Best Companies to Work For®, and we've ranked among Victory Media's Top 10 Military Friendly® Employers 13 years straight. We embrace a robust veteran workforce and encourage veterans and veteran spouses to apply.

ABOUT USAA IT

Our most important qualification isn't technical, it's human. Here, we don't just sit in front of a screen. We stand behind our 11 million members who rely on us every day.

We are over 3,000 employees strong, a passionately supportive and collaborative team built on Agile principles. We've been a top-two Computerworld 100 Best Places to Work in IT five years in a row and were recently named a Top 50 Employer for Minority Engineers & IT by Workforce Diversity Magazine.

See what it's like to work for a company where your passion meets our purpose:

https://www.youtube.com/watch?v=hnR5ZjrNrBY

* With limited guidance performs defect correction (analysis, design, code) on less complex issues and/or codes applications of medium complexity. With guidance begins to install, customize and integrate commercial software packages. Works with more tenured peers to gain understanding of systems while conducting root cause analysis of issues, reviewing new and existing code and/or performing unit testing.
* Works with experienced team members to conduct root cause analysis of issues, review new and existing code and/or perform unit testing. Learns to create system documentation/play books and attends requirements, design and code reviews. Receives work packages from manager and/or delegates.
* Understands and assists in gathering and analyzing customer requirements and may respond to outages following the appropriate processes.
* Partners with experienced team members to develop accurate estimates on work packages. May begin to identify issues that impact availability

MINIMUM REQUIREMENTS

* Bachelor's degree or 4 additional years of I/T experience beyond the minimum required may be substituted in lieu of a degree.
* AND, 2+ years of software development experience in a Data discipline with experience utilizing ETL Tools such as Informatica PowerCenter or IBM Datastage

PREFERRED

* 2+ years' experience with DataStage or Informatica
* 2+ years' experience SQL development skills
* Proficient with Unix Scripting (Python, Bash, etc.)
* Proficient in dimensional database design or data modeling
* Exposure to Big Data ecosystems (Hadoop, Hive, Sqoop, etc.), Machine Learning systems, Cloud Services (AWS, Azure, etc.), and/or Data Streaming tools (Kafka, NiFi, etc)
* Experience with Data Visualization tools and best practices

DESIRED CHARACTERISTICS

USAA ETL Engineers create innovative solutions that impact our members. Collectively, we are:

* Curious and excited by new ideas
* Energized by a fast-paced environment
* Able to understand and translate business needs into leading-edge technology
* Comfortable working as part of a connected team, but self-motivated
* Community-focused, dependable and committed
* Exceptionally detail-oriented

The above description reflects the details considered necessary to describe the principal functions of the job and should not be construed as a detailed description of all the work requirements that may be performed in the job.

At USAA our employees enjoy one of the best benefits package in the business, including a flexible business casual or casual dress environment, comprehensive medical, dental and vision plans, along with wellness and wealth building programs. Additionally, our career path planning and continuing education will assist you with your professional goals.

Relocation assistance is notavailable for this position.