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 http://www.aboutschwab.com/about/leadership/charles_schwab 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.
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 http://www.aboutschwab.com/careers/lifeatschwab/" .
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.
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
Job Type: Full Time
Activation Date: Tuesday, June 26, 2018
Expiration Date: Thursday, November 1, 2018