Data Warehouse Analyst Sr

U.S. Bank is seeking a Data Warehouse Analyst Sr to install, configure, and administer Informatica environments, including PowerCenter and PowerExchange CDC components, within Unix/Linux infrastructure. The role requires collaboration with infrastructure teams to support deployments, maintenance activities, patching, and upgrades. The position also involves incident, problem, and change management processes, coordination with vendor support teams for issue resolution, and participation in planned maintenance activities to ensure reliable platform operations.

What You Will Do

The Data Warehouse Analyst Sr will be responsible for providing production and BAU support for ETL and data integration platforms, troubleshooting and resolving job failures and incidents, and ensuring the stability, availability, and performance of data pipelines and services.

Why It Might Be a Fit

The role requires a strong technical background, experience with Informatica environments, and the ability to work collaboratively with infrastructure teams. The position also involves incident, problem, and change management processes, coordination with vendor support teams for issue resolution, and participation in planned maintenance activities to ensure reliable platform operations.

Requirements

• Bachelor’s degree in Computer Science or Information Science
• 5 years of progressive experience installing, configuring, upgrading, and administering Informatica PowerCenter and PowerExchange (PWX) in enterprise environments
• Experience with Informatica domains, including grid architecture and high availability configurations
• Experience with ETL operations, including monitoring, troubleshooting, and resolving job and platform failures
• Experience integrating enterprise data sources and targets, including Oracle, SQL Server, DB2, PostgreSQL, Salesforce, VSAM, and IMS
• Experience with Change Data Capture (CDC) and real-time data streaming solutions using Kafka
• Experience designing and maintaining Disaster Recovery (DR) and Business Continuity Planning (BCP) solutions
• Experience with user, role, and group access management using Active Directory and LDAP
• Experience automating system administration tasks using UNIX/Linux shell scripting and PowerShell
• Experience with platform maintenance activities, including patching, upgrades, and Emergency Bug Fix (EBF) deployments
• Experience implementing certificate management and secure configuration controls
• Experience with Autosys, Jira, Agile SDLC methodologies, and monitoring and logging frameworks

Benefits

• Healthcare (medical, dental, vision)
• Basic term and optional term life insurance
• Short-term and long-term disability
• Pregnancy disability and parental leave
• 401(k) and employer-funded retirement plan
• Paid vacation
• Up to 11 paid holiday opportunities
• Adoption assistance
• Sick and Safe Leave accruals