Have Interview slots – Urgent Requirement – Sr. ETL Developer/Architect – Washington DC (Onsite)

Description: 

Open Payment Project The Washington Metropolitan Area Transit Authority (WMATA) is seeking resources to build, test and deploy components of system to support the WMATA 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 WMATA components required to support the new Open Payment project. The Open Payment Solution shall allow Metro customers to pay for fare with their own contactless open payment media without the need for a SmarTrip card (or any closed loop card) and shall be available for full fare and senior customers. The solution shall enable Metro riders to use contactless bank cards to tap and pay for fare. The solution must accept contactless bank cards issued domestically as well as foreign bank cards. WMATA is looking for a total of 4 resources for supporting Open Payment Project. This resource will be responsible for

• Design, automate and support sophisticated applications for data extraction, transformation, and loading.

Duties/Responsibilities to include:

• Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence.

• Data Modeling design, analysis, and implementation – conceptual, logical, and physical data modeling, Data conversion, Data integration and Data Mining specialization in the area of Data Warehouse and Business Intelligence.

• Data import from Vendor cloud.

• Proactively solve problems to ensure milestones are met and projects are completed on time and within budget.

• Exceptional application architecture, and software development 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.

• Successfully complete mandatory WMATA security awareness training on annual basis.

• Review and assist with system hardening and vulnerability remediation

Experience:

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

Minimum Requirements:

• Exceptional application architecture, and software development 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 using MS Excel to perform basic software requirements documentation.

• Familiarity with MS Word and MS PowerPoint.

• Experience coordinating software requirements and working with development teams.

• Proven ability to plan and deploy complex custom Web 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.