ETL Report Developer

Derex Technologies Inc•Alexandria, VA

1d•Hybrid

About The Position

Position: ETL Report Developer (797686) Location : Alexandria Va (Hybrid) The client is seeking resources to build, test and deploy components of system to support the Open Payment project. Planning, design, and implementation work for Open Payment was awarded to a separate implementation vendor. The Offeror for this task order will be provided with extensive information around requirements, architecture, and design to use in developing the components required to support the Open Payment project. The Open Payment Solution shall enable Metro customers to pay fares using their own contactless open payment media, without requiring a SmarTrip card or any other closed-loop card. The solution shall support full-fare and senior customers and enable tapand-pay using contactless bank cards for Metro rail, bus, and parking services, as well as participating regional partner systems. The solution must accept domestically and internationally issued contactless bank cards. client is looking for a total of 2 resources for supporting Open Payment Project. This resource will be responsible for • Design, automate and support sophisticated applications for data extraction, transformation, and loading. • Ensures the accuracy of data. • Creates logical and physical data flow models for ETL applications.

Requirements

Bachelor’s degree in computer science, Information Technology, Management Information Systems, or in a related discipline.

Responsibilities

Data warehousing, Data modeling, Data integration, DataMigration, ETL process and Business Intelligence.
Data Modeling design, analysis, and implementation -conceptual, logical, and physical data modeling, Data conversion, Dataintegration and Data Mining specialization in the area of Data Warehouse andBusiness Intelligence.
Data import from Vendor cloud.
Proactively solve problems to ensure milestones are metand projects are completed on time and within budget.
Exceptional application architecture, and softwaredevelopment skills.
Strong analytical, verbal communication, and written communication skills.
Experience using Microsoft (MS) Visio or other data or application visualization software to document application architecture.
Experience coordinating software requirements and working with development teams.
Proven ability to plan and deploy complex custom application programs and process improvements.
Experience performing the application Architecture function, from conception to deployment.
Experience with administration and architecture of Business Process Management; and
Experience using Visio and Moqups to document the relationship of application architectures.
Successfully complete mandatory WMATA security awareness training on annual basis.
Review and assist with system hardening and vulnerability remediation.