Charles Schwab Senior Informatica Administrator in Fort Worth, Texas


Fort Worth - TX, TX13601F, 13601 North Freeway, 76177

Charles Ott Jones


We believe that , when done right, investing liberates people to create their own destiny. We are driven by our purpose to champion every client’s goals with passion and integrity. We respect and appreciate the diversity of our employees, our clients, and the communities we serve. We challenge conventions strategically to create value for our clients, our firm and the world. We live and bring to life the concept of ‘own your tomorrow’ every day. We champion our employee strengths, guide their development, and invest in their long-term success. We hire optimistic, results-oriented, curious, innovative, and adaptable people with the desire to help our clients and one another succeed.

As a company, we were established by Chuck at over 40 years ago to champion Main Street over Wall Street, and to help Americans transform themselves from earners to owners. Through advocacy and innovation, we work to make investing more affordable, accessible and understandable for all. As we enter our fifth decade, we are looking for talented, innovative and driven people who believe they can help themselves, and our clients, create a better future.

Our Opportunity:

Do you want to be a Senior Informatica Administrator for a large EDW team managing over 200 terabytes of data, 4000+ workflows and a diverse technology stack ranging from Teradata to MongoDB? At Schwab, the Global Data Technology organization governs the strategy and implementation of the enterprise data warehouse and emerging data platforms. We need Senior Informatica Systems Administrator who is passionate about user support and high quality systems implementation.

What you’ll do:

You will be a Senior Informatica (ETL) Systems Administrator for a large Informatica installation supporting multiple groups with >100 developers. You will be responsible for the health of the ETL environment and the support of current users and technologies. You will also onboard other user groups onto the shared platforms. You will engage and work with the architecture team for future environment changes, additional add-on usage and upgrades.

Details of the role include:

  • Supporting the Production, UAT, QA and Development Informatica PowerCenter 10.1.x environments with responsibility for environment uptime and overall system performance.

  • Coordinating downtime with the application support team to perform upgrades and install hot fixes.

  • Ensuring developer/user compliance with environment strategy including devising monitoring methodologies and/or processes.

  • Outlining best practices for Informatica repository usage, security controls, version control, code migration, Unix scripting, logging, and other development and deployment procedures.

  • Troubleshooting during system downtime to restore service (working with vendor if necessary), determining root cause and establishing procedures to avoid recurrence.

  • Supporting the system running on a Linux OS.

  • Supporting current configuration of Unix and BTEQ scripts, Informatica objects and connections to multiple database platforms.

  • Lead a 24x7 ETLTeam to provide production & off-shore development support; Manage Tier 1 production support for processes; the Lead Informatica Systems Administrator may be contacted to provide tier 2 support as a point for escalations.

What you have:

  • Experience as an Informatica Administrator (5-7 years)

  • Experience performing Informatica upgrades and hot fix installations.

  • Experience with Unix Shell Scripting including troubleshooting.

  • Experience with multiple database platforms including Teradata, Oracle and SQL Server. Working knowledge of Informatica Grid Environment.

  • Experience coordinating effective communication between teams.

  • Experience with the CA-ESP scheduler.

  • Proficiency in Informatica Power Center 9.6/10.1x or higher (Designer, Workflow Manager, Workflow Monitor).

  • Complete understanding of code promotion activities and best practices.

  • Experience with the Informatica security model, LDAP integration, and managing large ETL environments.

  • Experience in Release Management Processes – Leveraging Informatica / and or 3 rd Party Tools & Utilities

  • Experienced in managing share (multi-users) Informatica environments

  • Experienced in system & performance management (Unix/Linux/Database environment)

  • Experienced in analytical reporting of job/workflow performance

  • Experienced in SQL, XML, Java, Web services

  • Experienced in BI/ visualization and reporting solutions Tools (BO, Tableau, Micro-strategy

  • Experience with Job Schedulers – such as Autosys / ESP

  • Understanding of database design concepts and best practices, and management techniques

What you’ll get:

  • Comprehensive Compensation and Benefits package

  • Financial Health: 401k Match, Employee Stock Purchase Plan, Employee Discounts, Personalized advice, Brokerage discounts

  • Work/Life Balance: Sabbatical, Paid Parental Leave, New Mothers returning to work Program, Tuition Reimbursement Programs, Time off to volunteer, Employee Matching Gifts Program

  • Everyday Wellness: Health and Lifestyle Wellness Rewards, Onsite Fitness Classes, Healthy Food Choices, Wellness Champions

  • Inclusion: Employee Resource Groups, Commitment to diversity, Strategic partnerships

  • Not just a job, but a career, with an opportunity to do the best work of your life

Learn more about Life@Schwab at" .

Charles Schwab & Co., Inc. is an equal opportunity and affirmative action employer committed to diversifying its workforce. It is Schwab's policy to provide equal employment opportunities to all employees and applicants without regard to race, color, religion, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), gender identity or expression, national origin, ancestry, age, disability, legally protected medical condition, genetic information, marital status, sexual orientation, protected veteran status, military status, citizenship status or any other status that is protected by law. Schwab also does not discriminate against applicants or employees because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. At Schwab, we believe that every employee, through their diverse abilities and experiences, can contribute to our growth, innovation and client loyalty. We embrace diversity and are committed to providing equal opportunity to all employees and applicants. If you have a disability, and require reasonable accommodations in the application process, call Human Resources at 800-725-3535. We will be happy to assist you. Schwab will only share your accommodation request with those individuals who have a specific need to know. The request for an accommodation will not affect Schwab's hiring decisions. All other submissions should be performed online.

Job Specifications

Relocation Offered?: No

Work Schedule: Days

Languages: English - spoken

Current Licenses / Certifications: None

Relevant Work Experience: IT-Other Specialty Engineering-6+ yrs

Position Located In: TX - Westlake

Education: BA/BS

Job Type: Full Time

Category:Information Technology

Activation Date: Tuesday, June 26, 2018

Expiration Date: Thursday, November 1, 2018

Apply Here