ETL Developer

ETL DeveloperAcclaim Technical Services, founded in 2000, is a leading language, operations, and technology services company supporting a wide range of U.S. Federal agencies. We are an Employee Stock Ownership Plan (ESOP) company, which is uncommon within our business sector. We see this as a significant strength, and it shows: ATS is consistently ranked as a top workplace among DC area firms and continues to grow. We are actively hiring an ETL Developer with TS/SCI clearance and polygraph to support a program in Bethesda, MD. Individuals will play a pivotal role in shaping, and implementing cutting-edge data flow solutions centered around Apache NiFi. The candidate will provide technical expertise and support in the design, development, implementation and testing of customer tools and applications in support of Extracting, Transforming and Loading (ETL) of data into an enterprise Data Lake. The candidate will be responsible for following architectural best practices, and optimizing performance in large-scale environments, ensuring the delivery of robust, scalable, and secure data flow solutions that drive critical customer needs. Based in a DevOps framework, the ETL Developer participates in the delivery of major projects through all aspects of the software development lifecycle.Primary ResponsibilitiesBuilding complex NiFi data pipeline design: Develop and implement enterprise-level ETL NiFi data pipelines for large-scale data ingestion, transformation, and processing from diverse sources.Performance optimization and tuning: Optimize NiFi data flows, including processor tuning, memory management, and load balancing, ensuring optimal performance for batch and real-time processing.Troubleshooting and problem resolution: Identify, diagnose, and resolve complex NiFi data flow issues, including performance bottlenecks, data discrepancies, and integration failures.Integrating with big data and cloud technologies: Seamlessly 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 best practices and standards: Follow establish best practices for NiFi development, deployment, security, and governance, ensuring adherence to enterprise-wide data management policies.Documentation and knowledge sharing: Create and maintain comprehensive documentation for NiFi data flows, mappings, architectures, and standard operating procedures, ensuring knowledge transfer and promoting efficient team operations.Collaboration and communication: Collaborate effectively with data architects, data engineers, application/service developers, and other stakeholders to translate business requirements into robust technical solutions.Basic QualificationsDirect 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 servicesAbility 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.Preferred QualificationsExperience 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 scalabilityPay Range: There are many factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employee owners value the flexibility at ATS that allows them to balance quality work and their personal lives. We offer competitive compensation, career growth, benefits and learning and development opportunities. Our broad mix of exceptional benefits options is designed to support and protect employees and their families. The pay range for this position is $180,000.00 - $190,000.00 At ATS, you will be eligible to participate in a comprehensive benefits package such as: healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits. Learn more here Employee ResourcesSalary TransparencyThere are many factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employee owners value the flexibility at ATS that allows them to balance quality work and their personal lives. We offer competitive compensation, career growth, benefits and learning and development opportunities. Our broad mix of exceptional benefits options is designed to support and protect employees and their families. At ATS, you will be eligible to participate in a comprehensive benefits package such as healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits. Learn more at Employee ResourcesEqual Employment Opportunity (EEO) StatementATS is committed to a program of equal employment opportunity without regard to race, color, ethnicity, national origin, ancestry, citizenship, sex, pregnancy, marital status, sexual orientation, age, religion/creed, hairstyles and hair textures, handicap/disability, genetic information/history, military/veteran status, or any other characteristic or condition protected by applicable law. We support the employment and advancement in employment of individuals with disabilities and of protected veterans, and we treat qualified individuals without discrimination on the basis of their physical or mental disability or veteran status. Acclaim Technical Services