Zachary Piper Solutions is seeking a Software ETL Developer/ Data Integrator to join a team dedicated to supporting Infrastructure Development and Application Development for the Defense Intelligence Agency (DIA) Site III A&P in Reston, VA.

Responsibilities of the Software ETL Developer/Data Integrator:

• Collaborating with a team of developers to meet data integration requirements.
• Crafting and maintaining code utilizing an Extract-Transform-Load (ETL) platform to convert data into suitable formats in alignment with IC ITE initiatives.
• Establishing connections with external teams and systems to retrieve data using various protocols, such as HTML and SFTP.
• Enhancing the ETL platform by adding features that expedite future data integration endeavors.
• Creating and preserving code while integrating software into a fully operational software system.
• Coordinating with external teams to validate data ingestion.
• Supplying and maintaining comprehensive documentation related to system architecture, development, and enhancements.

Qualifications for Software ETL Developer/ Data Integrator Include:

• 8 or more years of experience
• Proficiency in Linux/Unix
• Experience with object-oriented programming languages: PHP, Python, C#, Java, Abstraction, Encapsulation, polymorphism, inheritance: single, multiple, and multilevel, understanding objects and classes, experience working with interfaces
• Expertise in data ingestion, data transformation (ETL), and data modeling
• Bachelor's degree or Master's degree Engineering, Computer Science, Mathematics, Physics, or Chemistry.
• Active TS/SCI or above. Will upgrade to CI Poly

Compensation for the Software ETL Developer/ Data Integrator includes:

• Salary Range: $112,000- $193,000 depending on experience
• Full benefits: Cigna Medical/ Dental/ Vision, 401K with match via ADP requirement, holidays, Paid Time Off (PTO), etc.
• Term: long term project,5- year program (in option year one)
• Environment: 100% onsite in Reston VA (or College Park, MD OR Washington, DC) with hybrid flexibility during parts of the program, dependent on workload

Keywords: Linux, Unix, Object Oriented programming language, OOPL, PHP, Python, C#, Java, Ruby, Abstraction, Encapsulation, Polymorphism, Inheritance, objects and classes, interfaces, interface, interfacing, problem- solving, Self-starter, data ingestion, data transformation, ETL, data modeling, , data warehouse, data lake, data analysis, Restful, web services, Rest, code development, deployment, versioning, cloud architecture, AWS EC2, RDS, S3, VPC, Elastic Search, Cloud integration, connecting data, SaaS, software as a service, cloud services, XML, XSLT, Xpath, object-oriented programming language, Software ETL Developer, Data Integrator, HTML, SFTP, Extract-Transform-Load, computer science, mathematics, physics or chemistry, Infrastructure Development, Application Development, Defense Intelligence Agency, DIA, Write code, maintain code, write, wrote, writes, written, writing, maintain, maintains, maintained, maintaining, maintenance, support, supports, supported, supporting, develop, develops, developed, developing, coding, coded, codes, integrate software, software system, National Geospatial-Intelligence Agency, Site III, big data, high volume of data transfer, systems engineer, systems admin, administrator, administration, data transfer, ETL Tester, ETL Developer, ETL Analyst, Systems Engineering, systems Integration, IC ITE, Interface, interfaces, interfacing, interfaced, collect data, collecting data, collected data, collecting data, collected, myriad protocols, HTML, SFTP, add, added, adding, adds, addition, ETL platform, shorten timelines, validate data ingest, validated, validates, validating, ingestion, ingests, ingested, Provide, provides, provided, providing, provider, system architecture, development, enhancements, low codes, low code, low-code, codes, coded, coding, coder, solve, solved, solves, solving, transferred, transfer, transfers, transferring, transformation, extract, transform, load, extracting, extracts, extraction, extracted, transforms, transforming, transformed, transform, loading, loads, load, loaded, loader