Data Warehouse ETL Developer

company banner
Charles Schwab & Co., Inc.
Full Time

Job Description

Your Opportunity

Do you want to be part of a Data Solutions Delivery team managing over 150+ terabytes of data and building the next generation analytics platform for a leading financial firm with over $3.2 trillion 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.

We are looking for a Data Engineer who has passion for data and comes with data engineering background. Someone who has experience in designing and coding batch as well as real time ETL (and ELT) and one who wants to be part of a team that is actively designing and implementing the Enterprise Data solutions. Someone who wants to be challenged every day and has passion to keep up to date on new technologies in the Data Engineering space, set new standards and collaborate with the team members along the way.

You will be working on highly visible Marketing DW & Big Data projects.

What you are good at

  • You will be a Data Engineer with a large team that includes onshore and offshore developers using best-in-class Big Data and relational Data warehouse technologies including MAPR Big Data environment, Talend, Teradata, Informatica etc.
  • You will be prototyping data solutions to enable faster access to data for the analytics use case developers
  • You will work closely with Marketing and Analytics & Business Insights (ABI) business teams on the implementation of Data Solutions
  • You will be developing re-usable data solution patterns to enable quick to market data assets
  • You will be analyzing & profiling business data on relational and Big Data Environment
  • You will be a liaison between the data SMEs and analytics use case developers to facilitate rapid response from GDT
  • You'll have the opportunity to grow in responsibility, work on exciting and challenging projects, train on emerging technologies and help set the future of the Data Solution Delivery team


What you have

  • Total minimum experience of 3-5+ years in Data / Software engineering.
  • Experience with all aspects of data systems including database design, ETL, aggregation strategy, performance optimization. Minimum 3 Years of experience in traditional Data Warehousing
  • Hands-on development experience in Informatica 9.x/10.x or any enterprise class ETL tool. Minimum 3 years
  • Understanding of best practices for building and designing ETL code Strong SQL experience with the ability to develop, tune and debug complex SQL applications is required
  • Expertise in schema design, developing data models and proven ability to work with complex data is required
  • Proven experience in working in large environments such as RDBMS, EDW, NoSQL, etc.
  • Hands-on development experience with parallel processing databases like Teradata. Minimum 4 years


Highly Preferable:

  • Experience in Cloud platforms like Google Cloud Platform or AWS. Preferably in Data Warehousing
  • Experience in Google Big Query or Snowflake
  • Experience in Big Data technologies as a Developer
  • Experience developing applications on Big Data platform for both batch and real time ingestion
  • Hands-on experience with massive data processing frameworks like Apache SPARK
  • Knowledge of Big Data ETL such as Informatica BDM and/or Talend tools is preferred
  • Hands on experience with programming language Java/Python/Scala
  • Hands-on experience with Linux and shell scripting
  • Hands on experience with CI/CD tools like Bamboo, Jenkins, Bitbucket etc.


Why work for us?

Own Your Tomorrow embodies everything we do! We are committed to helping our employees ignite their potential and achieve their dreams. Our employees get to play a central role in reinventing a multi-trillion-dollar industry, creating a better, more modern way to build and manage wealth.

Benefits: A competitive and flexible package designed to empower you for today and tomorrow. We offer a competitive and flexible package designed to help you make the most of your life at work and at home-today and in the future. Explore further .

Schwab is committed to building a diverse and inclusive workplace where everyone feels valued. As an Equal 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 the policy.

Schwab is an affirmative action employer, focused on advancing women, racial and ethnic minorities, veterans, and individuals with disabilities in the workplace. If you have a disability and require reasonable accommodations in the application process, contact Human Resources at or call .

TD Ameritrade, a subsidiary of Charles Schwab, is an Equal Opportunity Employer. At TD Ameritrade we believe People Matter. We value diversity and believe that it goes beyond all protected classes, thoughts, ideas, and perspectives.


Company Information

At Schwab, we inspire the driven; individuals who want to take ownership of their career and their future. You are appreciated for your work, respected for your unique strengths and rewarded for the possibilities you create for our clients. Working in Schwab Technology is not just a job; it's an opportunity to do the best work of your life. This team drives Schwab's mission to harness the power of data to deliver the next gen client experience. They relentlessly pursue simplification and modernization, laying the foundation for the digital enterprise. They act boldly together to provide security for our clients and enterprise, safeguarding client trust all while delivering on their core commitments to availability, capacity and project execution with excellence and efficiency. If you are looking to be challenged with projects that stretch and grow your abilities, and push you towards further developing your expertise, apply to one of our openings today.
Dice Id : 10228622
Position Id : 2021-77336
Originally Posted : 6 months ago

Similar Positions at Charles Schwab & Co., Inc.

Data Warehouse Systems Analyst
  • Westlake, TX
  • 18 hours ago
ETL/Database Developer
  • Westlake, TX
  • 18 hours ago
Senior Data Engineer
  • Westlake, TX
  • 18 hours ago
Data Engineer
  • Westlake, TX
  • 18 hours ago
Data Engineer
  • Westlake, TX
  • 18 hours ago
Associate Data Engineer
  • Westlake, TX
  • 18 hours ago
Data Engineer
  • Westlake, TX
  • 18 hours ago
Sr. Manager - Data Engineering
  • Westlake, TX
  • 18 hours ago
Sr Data Engineer
  • Westlake, TX
  • 18 hours ago