ETL Developer (2025-0117)

Acclaim Technical Services•Bethesda, MD

3d•$180,000 - $190,000•Onsite

About The Position

Acclaim Technical Services (ATS), founded in 2000, is a leading language, operations, and technology services company supporting a wide range of U.S. Federal agencies. As an Employee Stock Ownership Plan (ESOP) company, ATS is consistently ranked as a top workplace and continues to grow. We are actively hiring an ETL Developer with TS/SCI clearance and polygraph to support a program in Bethesda, MD. This role is pivotal in shaping and implementing cutting-edge data flow solutions centered around Apache NiFi. The candidate will provide technical expertise in the design, development, implementation, and testing of customer tools and applications for Extracting, Transforming, and Loading (ETL) data into an enterprise Data Lake. Responsibilities include adhering to architectural best practices, optimizing performance in large-scale environments, and ensuring the delivery of robust, scalable, and secure data flow solutions. Operating within a DevOps framework, the ETL Developer will participate in all aspects of the software development lifecycle for major projects.

Requirements

Direct experience designing, developing, and managing complex NiFi data flow solutions in large-scale enterprise environments.
Experience in programming languages like Java and/or Python and scripting for automation.
Experience writing and optimizing complex queries, along with experience in interacting with relational and NoSQL databases (e.g., Postgres, Elasticsearch, DynamoDB).
Experience with real-time streaming, and API integration (REST) for seamless data connectivity.
Experience with cloud platforms like AWS, Azure, or OCI and related data services.
Ability to analyze complex data challenges, identify root causes, and implement effective solutions.
Ability to collaborate effectively with cross-functional teams and articulate technical concepts clearly.
HS diploma and at least 8 years of relevant experience; or BS degree and at least 4 years of relevant experience; or Masters degree and at least 2 years of relevant experience.

Nice To Haves

Experience deploying ETL solutions in an AWS environment.
Experience developing custom NiFi processors with Java and/or Python.
Direct knowledge of NiFi architecture, processors, and configurations, along with hands-on experience with NiFi Registry and clustering for high availability and scalability.

Responsibilities

Develop and implement enterprise-level ETL NiFi data pipelines for large-scale data ingestion, transformation, and processing from diverse sources.
Optimize NiFi data flows, including processor tuning, memory management, and load balancing, ensuring optimal performance for batch and real-time processing.
Identify, diagnose, and resolve complex NiFi data flow issues, including performance bottlenecks, data discrepancies, and integration failures.
Integrate NiFi with various databases, big data ecosystems, and cloud platforms (e.g., AWS, OCI, Azure), demonstrating familiarity in relevant services (e.g., Kafka, Elasticsearch, S3, SQS/SNS).
Follow established best practices for NiFi development, deployment, security, and governance, ensuring adherence to enterprise-wide data management policies.
Create and maintain comprehensive documentation for NiFi data flows, mappings, architectures, and standard operating procedures.
Collaborate effectively with data architects, data engineers, application/service developers, and other stakeholders to translate business requirements into robust technical solutions.