Logistics Data Integration Specialist with Apache NiFi ETL, Oracle SQL, MongoDB and PostgreSQL Exp. || U.S.C & Public Trust Clearance Mandatory
10+Months
Frederick, MD (Onsite)
W2 Only (No C2C) :: U.S.C & Public Trust Clearance Mandatory
Overview:
Seeking a hands-on integrator to build and operate data pipelines that power logistics operations. You will design, optimize, and maintain Apache NiFi workflows and database procedures across Oracle, MongoDB, and PostgreSQL, with a strong focus on data quality, lineage, and accurate migrations.
Core Responsibilities:
- Design, develop, troubleshoot, deploy, and maintain Apache NiFi ETL/ELT workflows integrating Oracle SQL, MongoDB, and PostgreSQL.
- Build and optimize SQL stored procedures and complex queries for data transformation, transaction management, error handling, input validation, and performance tuning across multiple RDBMS platforms.
- Apply advanced SQL techniques, including scalar, grouping, and analytical functions, as well as correlated subqueries.
- Define and implement automated data migration validation rules aligned to business requirements.
- Research, document, and maintain data lineage, authority, and usage across value streams to support governance and traceability.
- Execute and validate pre- and post-migration data checks to ensure 100% accuracy and reconciliation.
Required Qualifications:
- Proven experience with Apache NiFi for data integration, including building, monitoring, and optimizing flows.
- Strong proficiency in Oracle SQL and PostgreSQL, with ability to write and tune stored procedures and complex queries; familiarity with MongoDB data modeling and integration patterns.
- Expertise in SQL performance tuning, transaction control, exception handling, and input validation.
- Demonstrated experience implementing automated data quality and migration validation rules.
- Ability to document data lineage and usage across systems and processes, with attention to detail and auditability.
- Track record of delivering accurate, fully validated data migrations.
Preferred Qualifications:
- Background in DoD medical logistics or comparable supply chain/logistics domains.
- Familiarity with LogiCole or similar medical logistics applications.
- Experience working in Agile or SAFe delivery within a federal environment.
