Skip Navigation
Find a job
at TD Ameritrade.

Find a job at TD Ameritrade.

Senior ETL Software Developer

Quick Facts

Columbia, Maryland ID# 2018-16869 Regular Full-Time Second Level Professional

Role:

The Sr. Software Developer  is responsible for extracting, transforming and loading (ETL) data into the Data Warehouse. The Sr. Software Developer  will design, develop, maintain, and support the enterprise data warehouse system and corresponding data marts. This team member will analyze and review object and data models and the metadata repository in order to structure the data for better management and quicker access. The Sr. Software Developer  will be competent to complete most data warehousing tasks independently and should be able to work with little guidance, including stakeholder communication, hands-on root cause analysis & resolution. 

Responsibilities:

  • Participate in requirements gathering
  • Responsible to work with Data architecture team, design and develop ETL solutions, unit testing, code reviews, enhance standards, and performance tuning
  • Responsible for auditing tracking process and error handling
  • Develop project documentation
  • Interact with the Quality Assurance team during integration and user acceptance testing
  • Coordinate with external teams to assure the quality of master data and conduct integration testing
  • Responsible for code migrations from Dev. to QA and production and providing operational instructions for deployments
  • Responsible for Production support including immediate responsiveness during system down or system component down situations to analyze root cause and restore system functionality. 
  • Position requires on-call and off-hours support.
  • Perform other duties as assigned
  • This is a lead position, and role may mentor junior team members
  • Cross-train and provide guidance to other associates
  • Position requires on-call and off-hours support.

Requirements:

  • Bachelor's degree in Computer Science or related discipline
  • Excellent written and verbal communication skills
  • Must have strong analytical skills for effective problem solving
  • Ability to work independently, handle multiple tasks simultaneously and adapt quickly to change with a variety of people and work styles
  • Ability to work well as a team
  • Exceptionally self-motivated and self-directed. Keen attention to detail, understand the need for consistent process and when to deviate
  • Must be capable of fully yet concisely articulating technical concepts to non-technical audiences
  • At least 7 years of experience with a strong background and competency in enterprise data warehouse data architecture and data modeling patterns, following established Kimball and Inmon methodologies
  • More than 5 years of experience in Informatica tools like PowerCenter along with a clear understanding of core best practices
  • Must have 3-5 years of experience working with Informatica Big Data Edition
  • At least 7 years of Relational Database experience (DB2/Oracle/Netezza/Teradata)
  • Must be capable of navigation and file manipulation in a Unix/Linux environment, and building Unix scripts
  • Change data capture (Incremental Processing) , surrogate keying and other related enterprise data warehouse concepts
  • Performance Tuning of Informatica jobs/SQL scripts
  • Knowledge on Big Data concepts and technologies like MDM, Hadoop, Data Virtualization, Reference Data/Metadata Management preferred
  • Programing experience i.e. Java, Perl, Python ,shell scripting preferred
  • Experience in Financial / Brokerage Industry preferred

 

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.

  • Finance and Accounting, Columbia, Maryland, United StatesRemove
  • Information Technology, Columbia, Maryland, 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 Finance and Accounting 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 a Finance 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 Finance 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