Charles Schwab Corporation

Senior Data Engineer - Informatica

Job Locations US-TX-Westlake
Requisition ID
Posted Date
2 months ago(6/4/2020 5:04 PM)
Position Type
Full time

Your Opportunity

Do you want to be part of a Data Warehouse team managing over 120 terabytes of data and building the next generation analytics platform for a leading financial firm with trillions in assets under management?  At Schwab, the Global Data Technology (GDT) organization governs the strategy and implementation of the enterprise data warehouse and emerging data platforms. We help Marketing, Finance and executive leadership make fact-based decisions by integrating and analyzing data.

Charles Schwab & Co., Inc. is currently seeking a seasoned Data Engineering Lead with a passion for delivering data solutions with a hands-on approach to design, development and collaboration with our business partners. The ideal candidate must have deep experience delivering Enterprise Data Warehouse solutions, designing, coding and leading end to end solutions on Teradata, Big Data and cloud technologies.

What you are good at

  • Leading teams in design, development and delivery of data solutions on Teradata, Big Data and cloud data platforms for the Global Data Technology team.
  • Managing day-to-day development activities for new data solutions and troubleshooting existing implementations.
  • Working with product owners and technical directors to lead technical discussions and resolve technical issues
  • Applying best practices of data integration for data quality and automation
  • Reviewing data models and data architecture for Hadoop and HBase environments
  • Working with product vendors to identify and manage open product issues
  • Solving complex data integration problems
  • Working with project team and technology partners to develop high-level designs and cost and effort estimates for new work efforts.
  • Documenting design solutions and supporting documentation.
  • Developing and maintaining code for data ingestion and curation using Informatica, Talend, Scoop, Hive etc.
  • Working with business analysts to understand business requirements and use cases

What you have

  • Minimum of 7 years of experience delivering data solutions on a variety of data warehousing, big data and cloud data platforms.
  • Experience as an ETL lead with a track record of delivering design solutions (> 5 years) and leading a small team of developers
  • Substantial experience in Data Warehousing / Information Management (> 5 years)
  • Hands-on experience with ETL tools and deep experience in any integration tool (e.g. Informatica, Talend) (At least 5 years)
  • Understanding of data modeling (logical and/or physical) with familiarity of Teradata platform preferred (> 5 years)
  • Strong SQL experience with the ability to develop, tune and debug complex SQL applications is required
  • Hadoop experience – Understanding of Hadoop file format and programming (egg. Spark, Hive, etc.)
  • Knowledge of Scripting (UNIX) and scheduling tools (Control-M, ESP)
  • Experience with change data capture tools (CDC) preferred such as Attunity
  • Strong interpersonal, analytical, problem-solving, influencing, prioritization, decision- making and conflict resolution skills
  • Excellent written/verbal communication skills


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Why Schwab?

At Schwab, “Own Your Tomorrow” embodies everything we do! We are committed to helping our employees unleash their potential and achieve their dreams. Our employees get to play a central role in disrupting a multi-trillion-dollar industry, creating a better, more modern way to build and manage wealth. We’re a modern financial services firm that stands apart from the industry, where you can go as far as your ambition takes you.

Hear from employees: What’s it like to work at Schwab!

The benefits of working at Schwab: a package designed to empower your health, wealth, career and life.
Schwab is committed to building a diverse and inclusive workplace where everyone feels valued.

As an equal employment opportunity employer, our policy is to provide equal employment opportunities to all employees and applicants without regard to any status that is protected by law. (Please click here to see policy.)

Schwab is also an affirmative action employer, focused on advancing women, minorities, veterans, and individuals with disabilities in the workplace.
We believe diversity and inclusion are part of our success as a company and our purpose of serving every client with passion and integrity.