Data Integration Specialist
Core
Design, develop, and maintain data integration solutions, automated tools, and processes for federal systems, mapping and transforming data to support reliable exchanges.
Role type
Senior IC data integration specialist (ETL, secure file transfers, web services)
Builds
Data integration solutions, automated tools, and processes for new and existing federal systems
Domain
Federal government / Data integration and ETL
Required skills
ETL development, SFTP troubleshooting, web services (SOAP, REST), programming (Java, Python, C, C#, .NET, PL/SQL, T-SQL), relational databases (Oracle, PostgreSQL, MySQL, Sybase, Firebird), data transformation (XML, XSLT, XSD, DTD), data mapping, data validation, schema technologies
Preferred skills
Law enforcement data experience, IEPD specifications knowledge, vendor integration solutions
Technologies
C#, ETL, Java, MySQL, Oracle, PostgreSQL, Python, REST, SOAP, SQL, Security, Web, XML, ASP.NET
Responsibilities
Develop, enhance, and maintain data integration solutions and automated tools; Map, transform, validate, and standardize data applying relevant data standards and IEPD specifications; Troubleshoot SFTP connections, integration workflows, and data transfer issues; Develop, modify, and troubleshoot code and scripts used in integration solutions; Design vendor integrations and lead complex efforts (Senior level); Mentor junior and mid-level specialists (Senior level)
Seniority
Junior (2+ years), Mid-level (4+ years), Senior (6+ years)
