Location: McLean, VA
Date Posted: 04-11-2018
RCT Systems is looking for a Programmer who provides support in the areas of data extraction, transformation and load (ETL), data mapping, data extraction, analytical support, database support, and maintenance support of Banking and Financial Systems. Team members work in a multi-tasking, quick-paced, dynamic, process-improvement environment that requires experience with the principles of financial systems technology, Large-Scale (Terabytes), database development, large-scale file manipulation, data modeling, data mapping, data testing, data quality, and documentation preparation. We are looking for a dynamic, professional, team-oriented, self-motivated individual with good communication skills and positive attitude.
- Perform duties and tasking as directed to meet varying mission needs across multiple projects and programs.
- Strong problem-solving skills and ability to comprehend database methodologies.
- Solid oral and written communication skills, with the demonstrated ability to communicate complex technical topics to management and non-technical audiences.
- Is able to work with little direction or supervision but understands when to ask for support and promotes an open flow of information so that all are well informed.
- Demonstrates good personal time management skills, including punctuality, time reporting and completion of assigned tasks within agreed time frames.
- Provide off hours On-Call support to resolve production issues.
Duties: Solves complex application development problems. Provides technical and administrative direction for personnel performing software development tasks, including the review of work products for correctness, adherence to the design concept and to user standards, and for progress in accordance with schedules. Responsible for developing and implementing applications. Develops plans for Information Technology (IT) systems from project inception to conclusion. Analyzes the problem and the information to be processed. Defines the problem, and develops system requirements and program specifications, from which programmers prepare detailed flow charts, programs, and tests. Coordinates with programmers to ensure proper implementation of program according to system specifications. Develops, in conjunction with functional users, system alternative solutions. Prepares test plans and test data to test the proposed systems.
Mandatory Skills
  1. Demonstrated experience with Software/Database Developer, ETL Developer, Data Modeling, Testing and Documentation.
  2. Demonstrated experience as an ETL developer.
  3. Demonstrated experience as a Database developer.
  4. Demonstrated experience in multiple programming languages (e.g. Java, SQL, Oracle, etc.)
  5. Demonstrated experience of database design in major Relational Data Management Systems (e.g. Oracle, MySQL, SQL Server, PostGres, Sybase, DB2, etc.)
  6. Knowledge of formal data modeling methodologies, DW Information Supply Chain (ISC), BioAPI, CBEFF, and ANSI Standards and best practices.
  7. Ability to analyze, design, build, test, implement and support ETL solutions for multiple subject areas sourced from disparate data sources that are associated with banks and/or financial institutions.
  8. Ability to develop ETL design documentation including source/target mapping and data dictionary information.
  9. Ability to design mappings for Data Capture, Staging, Cleansing, Transforming, Loading, and Auditing.
  10.  Ability to perform data quality analysis, gather information to determine data sources, data targets, data definitions, data relationships, document business rules, and develop data quality metrics.
  11. Demonstrated experience with SQL, Oracle, PERL, and Shell Scripting
  12. Good to high-level knowledge of servers operating systems (Linux, Windows, Cluster Environments.
Desired Skills

1. Demonstrated experience in Java a Plus.
2. Demonstrated experience with other ETL Tools a Plus: (e.g., Pentaho, SAS ETL, Oracle DataWarehouse, Embarcadero, Twister).
3. Demonstrated experience with Large-Scale (Terabytes) Data Sensitivity and Handling a Plus.
4. Banking Systems and Financial Analysis experience a Plus.

RCT Systems is an Equal Employment Opportunity Employer.  Qualified applicants will receive consideration for employment without regards to race, color, religion, sex, sexual orientation, gender identity, national origin disability or protected veteran status.   
this job portal is powered by CATS