U.S. Bank Sr. Informatica Admin/Data Platforms Engineer in Houston, Texas
At U.S. Bank, we're passionate about helping customers and the communities where we live and work. The fifth-largest bank in the United States, we’re one of the country's most respected, innovative and successful financial institutions. U.S. Bank is an equal opportunity employer committed to creating a diverse workforce. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status, among other factors.
U.S. Bank is seeking an accomplished Informatica Administrator/Data Platforms Engineer who will contribute toward the success of our technology initiatives in our digital transformation journey. The ideal candidate is well versed in managing Informatica products such as PowerCenter & DEI (Big Data Edition) and has experience with ETL Pipelines for traditional databases Oracle, DB2, SQL Server. Exposure to Big Data Products connecting to Hive & Spark with Hadoop is expected/preferred.
The position requires hands on experience installing, upgrading, configuring, and maintaining Informatica components in an enterprise environment. You must be able to efficiently perform throughput analysis, capacity planning, on-going optimization, and tuning of Informatica components for business-critical solutions. This requires in-depth understanding of ETL and Data Transformation Tools and administering the Informatica platform. The successful candidate would work with other technology and business teams to understand the business process, functional design, and source data. The primary goal is to enjoy your work and develop your career while maintaining an Integrations platform that is secure, reliable, scalable, and built to U.S. Bank standards.
In addition to Informatica Product expertise the ideal candidate would also have exposure to supporting newer cloud native platforms and be familiar with next generation application platforms such as Kubernetes and have skills or expect also evolve their skillset into an overall data platform operation engineer to support our future state data platform called UDAIP. Data and digital are critical to transform U.S. Bank business success. UDAIP is US Bank next generation cloud-based data and AI platform to enable data success cross business units within the company. At high level, UDAIP success includes industry leading hybrid cloud infrastructure, cutting edge data capabilities with leverage of many open-source technologies, successful migration of existing business critical data solution onto UDAIP, and ensure ultimate end user success cross the company.
Manage ETL Environments, Patches, Connections, Data Pipelines, Modeling, Processes, and support Testing activities, while maintaining and growing existing multi-technology integration capabilities.
Participate in on-call rotation supporting 24/7 operations.
Troubleshoot & Resolve ETL Job Failures related to platform
Install, upgrade, configure and maintain Informatica components including PowerCenter, DEI formally known as Big Data Edition, HA grid, Power Exchange-CDC, on Linux servers.
Recommend and implement the automation of different administration tasks via UNIX Shell scripts, command-line utilities or maps.
Coordinate with Informatica support for issue resolution, patches, and bug fixes.
Work with infrastructure teams to ensure an effective operating environment. This includes throughput analysis, capacity planning, on-going optimization and tuning of Informatica objects and environment.
Understand complex Informatica maps, workflow, and session log, and participate in configuring and tuning of respective objects to meet the performance and recovery objectives.
Collaborate with business and technology partners to transform system requirements into environment specific ETL designs
Setting up LDAP and Users/ Groups Creation, Access Management (Privileges and Permissions)
Support disaster recovery testing and implement disaster recovery functions.
Coordinate with development and infrastructure groups to prepare and implement planned maintenance outages
Design and implement monitoring and alerting strategies to enforce application SLAs
Develop, test, and debug automated tasks (Apps, Systems, Infrastructure)
Troubleshoot priority incidents, facilitate blameless post-mortems
Perform analytics on previous incidents and usage patterns to better predict issues and take proactive actions
Work with development teams throughout the software life cycle ensuring sustainable software releases
Bachelor’s Degree or foreign equivalent, will consider work experience in lieu of a degree
5+ years of experience with Information Technology
3+ years of experience as Informatica Administrator
Good experience in end-to-end implementation of DW BI projects, especially in data warehouse and mart developments
Strong SQL, PL/SQL experience
Strong UNIX scripting experience
Excellent analysis, debugging, troubleshooting, performance tuning and problem-solving skills are required
Agile experience and the ability to work on a cross functional, self-organizing development teams
Excellent technical documentation writing skills
Insightful background and experience about various modern bigdata technologies including but not limited to Spark, Hadoop, Kafka, Cassandra, Presto, Druid etc.
Nice to Have/Looking for in addition
Familiarity with ELK, Prometheus, Open Telemetry, Jaeger, Graphite, or any other widely used observability tools.
Familiarity with Kubernetes, Docker, Service Mesh(Istio), Terraform, Ansible, Jenkin
Experience working in a DevOps environment (Git/GitHub, GitOps, CI/CD Pipelines
If there’s anything we can do to accommodate a disability during any portion of the application or hiring process, please refer to our disability accommodations for applicants (https://www.usbank.com/careers/disability-accommodation-for-applicants.html) .
Take care of yourself and your family with U.S. Bank employee benefits. We know that healthy employees are happy employees, and we believe that work/life balance should be easy to achieve. That's why we share the cost of benefits and offer a variety of programs, resources and support you need to bring your full self to work and stay present and committed to the people who matter most - your family.
Learn all about U.S. Bank employee benefits, including tuition reimbursement, retirement plans and more, by visiting usbank.com/careers (https://www.usbank.com/careers/index.html) .
EEO is the Law
Applicants can learn more about the company’s status as an equal opportunity employer by viewing the federal EEO is the Law (https://www.dol.gov/sites/dolgov/files/ofccp/regs/compliance/posters/pdf/eeopost.pdf) poster.
U.S. Bank participates in the U.S. Department of Homeland Security E-Verify program in all facilities located in the United States and certain U.S. territories. The E-Verify program is an Internet-based employment eligibility verification system operated by the U.S. Citizenship and Immigration Services. Learn more about the E-Verify program (https://www.usbank.com/careers/verification-of-eligibility-for-employment.html) .
Due to legal requirements, U.S. Bank requires that the successful candidate hired for some positions be fully-vaccinated for COVID-19, absent being granted an accommodation due to a medical condition, pregnancy, or sincerely held religious belief or other legally required exemption. For these positions, as part of the conditional offer of employment, the successful candidate will be asked to provide proof of vaccination or approval for an accommodation or exemption upon hire.
U.S. Bank is an equal opportunity employer committed to creating a diverse workforce. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status, among other factors.