Demo

WMATA ETL Developer position in Washington, DC - locals required

CSZNet Inc
Washington, DC Temporary
POSTED ON 3/3/2025
AVAILABLE BEFORE 5/27/2025

Job Description

Job Description

Job Title : Sr ETL Developer

Location : Washington, DC

Duration : 12 months contract

Job ID : WMATA ETL Developer - 758544

Client : WMATA

Only locals Direct F2F interview 100% onsite position

This resource will be responsible for Design, automate and support sophisticated applications for data extraction, transformation, and loading.

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 4resources for supporting Open Payment Project.

Duties / Responsibilities to include :

  • 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.
  • 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

Required Skills

  • 5 years of experience with Data warehousing, modeling, integration, migration and extract transfer load (ETL) process
  • 5 years of experience with conceptual, logical and physical data modeling
  • 5 years of experience with data import task from external environments into hosted environments
  • 5 years of experience using Visio and Moqups to document the relationship of application architectures.
  • 5 years of experience coordinating software requirements and working with development teams.
  • 5 years of experience with PowerShell Scripting for data manipulation are key
  • Bachelor's degree in computer science, Information Technology, Management Information Systems, or in a related discipline
  • Regards

    Kanchan Illa

    CSZNet, Inc.

    Direct : 202-903-0969

    Phone : 202 524 9658 Ext 106

    Email : kanchan.illa@csznet.com

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a WMATA ETL Developer position in Washington, DC - locals required?

    Sign up to receive alerts about other jobs on the WMATA ETL Developer position in Washington, DC - locals required career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $68,745 - $88,154
    Income Estimation: 
    $87,428 - $116,878
    Income Estimation: 
    $91,609 - $116,575
    Income Estimation: 
    $87,428 - $116,878
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $129,640 - $165,363
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $129,640 - $165,363
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at CSZNet Inc

    CSZNet Inc
    Hired Organization Address Washington, DC Full Time
    Job Title : Solution Architect Location : Washington, DC Duration : 12 months contract Job ID : WMATA Solution Architect...
    CSZNet Inc
    Hired Organization Address Washington, DC Temporary
    Job Description Job Description Job Title : Sr Report Developer( Cognos and Power BI ) Location : Washington, DC Duratio...
    CSZNet Inc
    Hired Organization Address Washington, DC Full Time
    Job Details Service Desk Technician Senior Location : Washington, DC Duration : 12 Months Contract Interview Types: Webc...
    CSZNet Inc
    Hired Organization Address Washington, DC Full Time
    Job Details IT Security Engineer Location : Washington, DC(*Hybrid position - will require on-site reporting*) Duration ...

    Not the job you're looking for? Here are some other WMATA ETL Developer position in Washington, DC - locals required jobs in the Washington, DC area that may be a better fit.

    WMATA ETL Developer

    Avid Systems LLC, Washington, DC

    AI Assistant is available now!

    Feel free to start your new journey!