ETL Software Developer II

TD Ameritrade - Columbia, MD3.9

The Software Developer will be responsible for performing analysis and development tasks for TD Ameritrade’s applications and systems. The incumbent typically has 2-3 years of application development experience is required. This position exists within the Data Warehouse Production Support team. We source over 60-70 databases and over 20 vendors to bring internal/external data into the Data Warehouse, where the data is cleansed , standardized and integrated, The data is used by over 800 business analysts for their Operational and Reporting needs, The Data Warehouse team is a very visible group and supports all lines of business in the firm.

BAU Operation:
Work on SalesForce Incident tickets (60-70 per week) – involves working with Financial Consultants , executing SQL queries in Oracle and verifying results in SalesForce
Review capacity and monitoring of our applications and design, then implement or manage enhancements to improve their stability
Analyze the issues being raised against our applications and design, then implement or manage enhancements to prevent any future occurrences of these problems or issues
Document and maintain Run Book for our applications
Automate repeated processes
Track SLAs for all processes and communicate to Business in case of delays
Maintain logs of all issues and ensure resolutions according to quality assurance tests for all production processes.
Review and maintain robust continuity of business processes
Provide technical solutions and liaise with the Operations business during critical production outages
Manage the remediation tasks following critical outages, to avoid repeat failures
Work with the Development and Release Management teams to ensure robust code implementations.
Provide reporting to Operations and Technology Management, that facilitate strategic and tactical initiatives
Liaise with Operations business in translating their problems in to technical solutions
Provide technical and business solutions to off-shore teams who require direction in their approach
Create innovative solutions and proactive approaches to optimizing processes
Follow thru to ensure each problem is resolved according to SLA
Effectively communicate issues and status updates with business users, second level support, and development teams

Development Value:
Training, both on the job training and presented training courses.
Increased Product knowledge.

4 Year College Degree; Computer Science or related discipline or equivalent experience

Knowledge/Experience (Essential):
Experience in Production support or software development for 1- 3 years, preferably in financial industry

Experience in a demanding environment, working to strict deadline

Experience in a service based environment would be beneficial

Experience in analyzing and solving problem

Experience in the Financial Industry would be beneficia

Military education or experience may be considered in lieu of civilian requirements listed

Unix, Perl, Scripting (Basic)
Oracle (Strong)
SQL (Strong)
Informatica (Basic)

Ability to communicate well at all levels
Strong organizational skills
Ability to work in a team environment
Ability to learn new skills quickly with little supervision
Possess strong communication skills, in both verbal and written format
Well organized and able to multi-task
Planning, delegation, multi-tasking and prioritization skills.
Team-oriented with a collegial approach to addressing challenges.
Will be a highly-motivated, strong performer with a proven ability to manage remote vendor teams to full effectiveness.
Willingness and proactivity to take ownership of issues and see them through to resolution.
Desire, and proven ability, to constantly improve technical environments and platforms.
Must have strong attention to detail and not be willing to settle for a job half done.
Be flexible with working hours, to react to situations within the production support environment.