Charles Schwab Data Engineer in Lone Tree, Colorado
Lone Tree - CO, DENR3, 9800 Schwab Way, 80124
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 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 over $2.7 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.
What you’ll do:
You are a Data Engineer who has passion for data and comes with data warehousing background.
You have 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 warehouse solution.
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.
Build and maintain code for ETL (and ELT) using Informatica 10.X and Teradata.
Design enterprise quality ETL solutions.
Explore tools and technologies in the evolving Data Engineering Space.
Work with business analysts to understand business requirements and use cases
What you have:
Hands-on development experience in Informatica 9.x/10.x (minimum 4 years)
Hands-on development experience with Teradata database using BTEQ, TPT etc
Hands-on experience with Informatica push down optimization feature. Hands-on experience with Linux and shell scripting.
Hands on experience with programming language Java/Python/Scala
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
Familiarity with Hadoop framework is preferred 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. is preferred Knowledge of Big Data ETL such as Informatica BDM and/or
Talend tools is preferred
What you’ll get:
Everyday Wellness: Healthy Rewards, Onsite Fitness Classes, Healthy Choices, Wellness Champions
Financial Fitness: 401k Match, Employee Discounts, Personalized advice, Brokerage discounts
Work/Life Balance: Sabbatical, New Mothers returning to work Program, Tuition Reimbursement Programs, Time off to volunteer
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.
Relocation Offered?: No
Work Schedule: Days
Languages: English - spoken
Current Licenses / Certifications: None
Relevant Work Experience: IT-Other Specialty Engineering-2-5 yrs
Position Located In: CO - Lone Tree
Job Type: Full Time
Activation Date: Friday, June 30, 2017
Expiration Date: Monday, October 2, 2017