DMI is a leading global provider of digital services working at the intersection of public and private sectors. With broad capabilities across IT managed services, cybersecurity, cloud migration and application development, DMI provides on-site and remote support to clients within governments, healthcare, financial services, transportation, manufacturing, and other critical infrastructure sectors. DMI has grown to over 2,100+ employees globally and has been continually recognized as a Top Workplace in both regional and national categories.
DMI, LLC is seeking a Conversion/Data Specialist to join us.
The Washington Metropolitan Area Transit Authority (WMATA) is seeking two Data Conversion Specialists to facilitate
the migration of data from PeopleSoft to the Oracle FDIP (Fusion Data Intelligence Platform) system, ensuring data
integrity and optimal performance. As a Data Conversion Specialist, they will be responsible for extracting, transforming,
and loading (ETL) data from PeopleSoft into FDIP. They will also need to possess front end development skills to
develop reports and dashboards as required. They will ensure that data is accurately migrated and optimized for
reporting and analytics, collaborating with various teams to achieve project goals.
Analyze the existing data structures in PeopleSoft and confirm the necessary transformations for Data Warehouse compatibility.
• Extract data from PeopleSoft using SQL and other relevant tools.
• Creation of efficient data structures that support reporting and analytics (expertise in dimensional modeling and entity-relationship (ER) modeling)
• Develop and implement data transformation processes to clean, standardize, and enhance the quality of the data during migration. • Create data mapping documents that outline the relationships between source and target data fields.
• Design and implement ETL processes to load data into the Data Warehouse, ensuring efficient performance and data integrity.
• Utilize ETL tools for data integration.
• Validate data accuracy and completeness post-migration to ensure that all data has been successfully transferred.
• Work closely with business analysts, data architects, and stakeholders to understand
data requirements and ensure alignment with business objectives.
• Familiarity with data governance, compliance, and data security protocols, including
encryption, data masking, and compliance with regulations (e.g., PII, HIPAA)
• Recommending and analyzing the possibility of Cloud Data Warehousing
Education and Years of Experience: Bachelor's degree in computer science, information systems, or a related field plus 8 years experience
Additional Requirements:
Preferred Skills:
• Experience with cloud-based Data Warehouse solutions (e.g., Oracle FDIP, Snowflake,
Amazon Redshift, Google BigQuery).
• Relevant certifications in data management or ETL tools are a plus.
Min Citizenship Status Required: Must be a U.S. Citizen or Work Visa Holder
Physical Requirements: No Physical requirement needed for this position.
Location: Washington, DC
Software Powered by iCIMS
www.icims.com