Charles Schwab & Co., Inc is currently seeking a seasoned ETL Lead with a passion for hands-on design/development and collaboration with our business partners. The ideal candidate is adept at using large data sets to find opportunities for product and process optimization to test the effectiveness of different courses of action. The ETL Lead must have deep experience in Enterprise Data Warehouse, Data Mart design, development and end to end execution of data solutions. Prior experience in developing design patterns for Big Data and Cloud solutions is a big plus.
This role will require hands on development with wide range of technical skills which include data analysis, ETL (Talend / Informatica, Unix, Big Data Technologies) and modeling skills (SQL, ERwin).
This position is part of the Global Data Technology (GDT) organization that governs the strategy and implementation of the enterprise data warehouse and emerging data platforms.
The ETL Lead will be designing, building and supporting data processing pipelines to transform data using Hadoop technologies. You’ll be designing schemas, data models and data architecture for Hadoop and HBase environments. You’ll be implementing data flow scripts using Unix / Hive QL / Pig scripting. You’ll be designing, building data assets in MapR-DB (HBASE), and HIVE. You’ll be developing and executing quality assurance and test scripts. You’ll be work with product owners and business analysts to understand business requirements and use cases to design solutions. 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. You’ll l