Skip Navigation
Find a job
at TD Ameritrade.

Find a job at TD Ameritrade.

Senior Software Developer

Quick Facts

Chicago, Illinois ID# 2017-11589 Regular Full-Time Second Level Professional

Role:

To all recruitment agencies: TD Ameritrade does not accept agency resumes. Please do not forward resumes to our jobs alias, TD Ameritrade employees or any other company location. TD Ameritrade is not responsible for any fees related to unsolicited resumes.

 

The primary role of Sr. Software Developer focuses on the thinkorswim (TOS) Data Warehouse database development and the ongoing administration of SQL Server databases (2008 R2/2012) and/or Netezza. Ideal candidate should draw on leading industry standards for SQL Server/Netezza database design, and bring to bear the DW manager's vision of standardized, highly scalable, conformed Data Warehouse processes and Database structures to drive various BI initiatives within Agile framework. It is highly desirable for the candidate to be experienced in other database systems like Oracle and Netezza, and familiarity with other data integration tools like Informatica.

Responsibilities:

  • Implement stringent ETL, Report and database change management process
  • Establish well thought-out standards for various ETL processes, database objects, performance benchmarking, scalability, etc., which will be followed by rest of the development team
  • Incorporate code management repository for all database scripts and production codes
  • Pursue all production database related issues with a goal of establishing root causes, remediation and documentation
  • Govern all databases in development, non-production and production environments to ensure all team members are adhering to various security policies and development practices
  • Provide a roadmap for database and process migration activities, data archival strategies and monitor scheduled backup activities
  • Implement high-availability and disaster recovery plans based on the directives provided by enterprise level infrastructure architects
  • Seek out opportunities for continuous improvement, process automation and risk mitigation
  • Participate and contribute to cross-functional developmental activities which involves working on Netezza and Oracle
  • Develop, test and support Informatica ETL processes

 

Requirements:

  • 4 Year College Degree; Computer Science or related discipline or equivalent experience
  • 5+ Years related experience         
  • 5-7 Years total experience
  • Excellent written and verbal communication skills
  • Expertise in Data Warehouse concepts and methodologies
  • Expertise in developing data integration solutions using SQL Server BI stack (SSIS, SSRS, SSAS)
  • Expertise in design, administration and support of SQL Server database systems (2008 R2 and 2012) and/or Netezza
  • Expertise in writing and performance tuning complex SQL queries and stored procedures
  • Adept in understanding business requirements and translating ad hoc requests to SQL queries
  • Experience with real time, high volume transaction systems preferred
  • Experience working within Agile framework and related lifecycle methodologies
  • Experience working with highly concurrent systems preferred
  • Experience working with automation tools like TIDAL or related technologies
  • Experience working with code versioning framework like Git or SVN.
  • Financial services experience preferred
  • Experience working with Informatica desired
  • Experience working with Netezza and/or Oracle desired
  • Experience in Java or other programing languages desired    
  • Military education or experience may be considered in lieu of civilian requirements listed

Taher - JAVA Developer

Advanced Technology – Ann Arbor

Christa - Site Support

UX Video

Sign Up for Job Alerts

Interested InSelect a job category from the list of options. Search for a location and select one from the list of suggestions. Finally, click “Add” to create your job alert.

  • Information Technology, Chicago, Illinois, United StatesRemove

Your Saved Jobs

You have not saved any jobs.

About TD Ameritrade.

A leader in brokerage and investment services for over 35 years, TD Ameritrade offers a full spectrum of powerful solutions and innovative tools for trading and investing. We're constantly expanding our knowledge and bolstering our capabilities, from a leading active trader program to intuitive long-term investment solutions and a national branch system. Combined with some of the industry's brightest minds, there's no limit to how big our accomplishments can be.

From first-time investors to sophisticated traders, TD Ameritrade is focused on helping individuals seek out their financial goals. And you're the ambassador to all that we do. Beginning with our trading platform and proprietary technology to our resolve to outperform, you'll maintain the high level of quality and integrity we're known for, each and every day. With the right opportunity, there's no limit to what you can accomplish.

As a leading employer in financial services, we believe in building strong relationships, achieving quality results and working with integrity. It's at the heart of everything we do. That's why we provide you with comprehensive training, benefits and programs that inspire you to achieve more every day. Apply to a TD Ameritrade job today and help our clients pursue their dreams, while you fulfill yours.

Applicants must be eligible to work in the U.S. Immigration sponsorship is typically not available for this position.

TD Ameritrade participates in the E-Verify program. For additional information on this program please click here. TD Ameritrade is an Equal Opportunity Employer. We value diversity and offer a quality workplace. TD Ameritrade, Inc. member FINRA/SIPC/NFA is a subsidiary of TD Ameritrade Holding Corporation (NASDAQ:AMTD). TD Ameritrade is a trademark jointly owned by TD Ameritrade IP Company and the Toronto-Dominion Bank.

© 2014 TD Ameritrade IP Company, Inc. All rights reserved. Used with permission.

Read More

About Information Technology Jobs

TD Ameritrade has been a leader in brokerage and investment services for over 40 years and offers a full spectrum of powerful solutions and innovative tools for trading and investing. We’re constantly expanding our knowledge and bolstering our capabilities, from a leading active trader program to intuitive long-term investment solutions and a national branch system. And in order to continue achieving, we need the best professionals to join us with an Information Technology job.< br > At TD Ameritrade we understand that one of the biggest investments we make as a Company is in our people. And that’s why we are committed to a successful, client-focused business model, training programs and advancement paths and an outstanding work environment where you can grow your career.< br > Learn more about Information Technology jobs with TD Ameritrade today.

All about growth.

By virtue of what we do, our world is filled with numbers. Here are just a few that we believe best describe TD Ameritrade at its finest.

  • 5,900 Full-time
    Employees

    Graphic 2 people
  • 100+Branches
    in 34 States

    Graphic 2 people
  • 96,000 Hours Volunteered to
    Community Programs

    Graphic 2 people