[Hiring] Senior Data Warehouse Analyst @U.S. Bank

Role Description

U.S. Bank is seeking the position of Data Warehouse Analyst Sr in Irving, Texas.

The Data Warehouse Analyst Sr will be responsible for:

• Installation, configuration, upgrading, and ongoing administration of Informatica environments, including PowerCenter and PowerExchange CDC components, within Unix/Linux infrastructure.
• Providing production and BAU support for ETL and data integration platforms.
• Troubleshooting and resolving job failures and incidents.
• Ensuring the stability, availability, and performance of data pipelines and services.
• Collaboration with infrastructure teams—such as storage, database, network, and system administrators—to support deployments, maintenance activities, patching, and upgrades.
• Incident, problem, and change management processes.
• Coordination with vendor support teams for issue resolution.
• Participation in planned maintenance activities to ensure reliable platform operations.
• Exposure to IBM DataStage environments and managing Informatica CDC Publisher services.
• Security and compliance responsibilities, including ensuring PII and PCI data is processed within secure enclaved infrastructure.
• Performing vulnerability management activities and maintaining adherence to regulatory requirements.
• Software lifecycle management such as obsolescence mitigation planning, annual credential rotations for PCI 4.0 compliance, and certificate and license renewals.
• Evaluating modern data platform technologies such as Informatica Data Management Cloud (IDMC) and CDI-PC.
• Contributing to platform modernization and continuous improvement efforts.

Position may allow working from home within a commuting distance of worksite location. Multiple Positions.

Qualifications

• Bachelor’s degree (or foreign equivalent) in Computer Science or Information Science.
• 5 years of progressive, post-baccalaureate experience installing, configuring, upgrading, and administering Informatica PowerCenter and PowerExchange (PWX) in enterprise environments.

Requirements

• Five years of experience with managing Informatica domains, including grid architecture and high availability configurations.
• Supporting ETL operations, including monitoring, troubleshooting, and resolving job and platform failures.
• Integrating enterprise data sources and targets, including Oracle, SQL Server, DB2, PostgreSQL, Salesforce, VSAM, and IMS.
• Implementing Change Data Capture (CDC) and real-time data streaming solutions using Kafka.
• Designing and maintaining Disaster Recovery (DR) and Business Continuity Planning (BCP) solutions.
• Performing user, role, and group access management using Active Directory and LDAP.
• Automating system administration tasks using UNIX/Linux shell scripting and PowerShell.
• Performing platform maintenance activities, including patching, upgrades, and Emergency Bug Fix (EBF) deployments.
• Implementing certificate management and secure configuration controls.
• Utilizing 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 (from two to five weeks depending on salary grade and tenure).
• Up to 11 paid holiday opportunities.
• Adoption assistance.
• Sick and Safe Leave accruals of one hour for every 30 worked, up to 80 hours per calendar year unless otherwise provided by law.