Provide production support in a complex application and data warehouse environment
Analyze, troubleshoot and resolve failures
Provide clarity with in-depth data research; and implement fixes
Collaborate with teams across IT to resolve complex issues and provide optimal solutions, with an emphasis on process improvement
Work to continuously enhance the stability and long-term performance of BI systems
Develop and update documentation, technical procedures, and knowledge articles
Increase proficiency and scope of involvement on all activities through guided and self-initiated learning
Participation in on-call rotation is required
Requirements
Experience with Informatica
Experience with ActiveBatch or comparable enterprise scheduling applications
Hands-on experience supporting ETL data movement in a production environment, including analyzing, troubleshooting, and resolving failures
Ability to use workflow monitoring tools to identify failure points and trace issues back through workflow components
Experience interpreting workflow and session logs to determine root cause
Strong ability to write and interpret SQL across databases such as Oracle, Netezza, and DB2
Ability to collaborate with cross-functional teams to resolve issues and improve processes
Experience supporting routine and ad-hoc changes, including deployments
Proactive in process improvement, documentation, and knowledge sharing
Experience managing a ticket queue, including prioritization and escalation
Understanding of SDLC processes
Ability to navigate Linux/Unix environments, including directories, file permissions, and environment variables
Ability to read shell scripts and use tools such as the VI editor
Willingness to participate in an on-call rotation (one week every six weeks), including after-hours and weekend support, and resolving critical workflow failures
Cloud data warehouse experience is a plus
Development experience in an operations or support role is a plus
Tech Stack
Cloud
ETL
Informatica
Linux
Oracle
SDLC
SQL
Unix
Benefits
Robust healthcare and benefits including Medical, Dental, vision, Disability coverage, and various other benefit options
Flexible Spending Accounts (Medical, Transit, and Dependent Care)
Employer Paid Life Insurance and AD&D Coverages
Health Savings account paired with our low-cost High Deductible Medical Plan
401(k) Safe Harbor Retirement plan with employer match with immediately vest