SOFTWARE DEVELOPER (ETL), LEAD (62985)
Information Systems - Programming
USA-VA-Reston
Security Clearance: TS/SCI with Polygraph
Clearance Status: Must be Current
Schedule: Full Time
Type of Travel: None
Percent of Travel Required: None
Description
62985 - SOFTWARE DEVELOPER (ETL), LEAD
Security Clearance:TS/SCI with POLY+
Location: McLean, VA area
CACI featured in Washington Business Journal "Book of Lists" for the Washington, DC metro area
- Largest software developer in the national capital area
- Eighth largest government contractor
General Description:
Performs as the technical expert with thorough understanding of the business application of an assigned project. Performs as a project lead with the responsibility for the instruction, assignment, direction, and monitoring of the performance of assigned software developers working on a specific project. Assists in the scheduling and coordinating of projects and may be involved in the design phase of a project. Works with customers and technical staff in the resolution of software problems and responds to suggestions for software modifications or enhancements. Prepares internal software design documentation. Participates in the development of software user manuals.
Software EngineerDuties and Responsibilities:
- Perform extract, transform, load (ETL) work in a multi-disciplinary team in the development and integration of COTS/GOTS tools in a mission-oriented, extremely rapid development space.
- Assisting in system architectural designs
- Rapid integration of COTS/GOTS products with the current product suite
- Rapid implementation of software architectural designs
- Configuration of COTS/GOTS applications to meet design and security requirements.
- Design and maintain a system to ingest data from a variety of sources, model aggregated data, and provide the modeled data to a number of downstream consumers.
- Will respond to ad hoc queries about the content/quality of the data.
Required Qualifications and Experience:
- Typically requires bachelor's degree or equivalent, and seven to nine years of related experience.
- The clearance level required is dependent on the type of clearance supported by our client. (TS/SCI with POLY+)
- Writing complex SQL queries with joins.
- Writing data, table, and index management statements.
- Using understanding of database structure, indices, normal forms, etc., to improve performance.
- Designing and writing scripts to process files and glue together process.
- Strong knowledge of at least one scripting language, preferably PEARL.
- Writing simple and complex DOS and BASH scripts.
- Writing regular expression.
- Basic understanding of the TCP/IP stack, routing protocols, DNS and IRC.
- Expertise using MS Office automation tools (Word, Excel, PowerPoint, Visio) to document, communicate and collaborate on software design concepts and architectures.
- Designing and writing classes, interfaces, and algorithms in an object oriented language, preferably Java.
- Developing in an IDE, preferably Eclipse.
- Using OO language to connect with database and manipulate data.
Desired Qualifications and Experience: include knowledge of emerging parallel data management systems, e.g., Pentaho, Hadoop, Neteeza, LexusNexus
- Writing stored procedures and functions.
- Administration of Oracle and/or MySQL databases.
- Experience working in customer environment and organizational culture.
- Familiarity with Customer INFOSEC process, reviews and boards
- Experience with Pentaho or other ETL tools
- Experience using and developing against open source products
- Oracle Certified Professional, with experience deploying, administrating, and exploiting Oracle and MySQL databases.
- Experience with modern software development related technologies, (e.g., Eclipse, CVS, JUnit, Ant, Apache Tomcat, XML)
- Knowledge of unix utilities like sed and awk.
- Writes code to create single-threaded or user interface event driven applications, either stand-alone or those which access servers or services.
- Develops code necessary to complete the assigned project(s) in the specified time frame according to departmental standards and guidelines.
- Identifies and reports problems in new and existing software. Recreates reported software problems to facilitate solutions. This includes validating the fix for the software problem.
- Writes, modifies, and debugs software for client applications.
- Develops the critical components of the solution, including but not limited to, security, rules infrastructure, custom adapter implementation, and application interfaces.
- Uses source debuggers and visual development environments.
- Interprets business requirements and implements the necessary technology to fulfill requirements.
- Serves as the primary technical lead for projects at the enterprise level, analyzing existing application interfaces, schemas and data needs.
- Architects and codes multi-environment system solutions utilizing various programming languages
- Profiles, analyzes and optimizes the software he/she is responsible for implementing.
- Employs best practices for design, development, unit testing and test plan development.
- Actively participates in the documentation of software requirements, functional design, flowcharts and diagrams.
- Supports completed software throughout the Software Development Life Cycle and in production.
- Performs as a project lead with the responsibility for the instruction, assignment, direction, and monitoring of the performance of assigned software developers working on a specific project.
- Assists in the scheduling and coordinating of projects and may be involved in the design phase of a project.
- Seeks to improve personal job related knowledge and departmental process by studying state-of-the-art development tools, programming techniques, and computing equipment; participating in educational opportunities, and reading professional publications.
CACI is an Equal Opportunity Employer M/F/D/V.
J2W:CLRJ J2W:TE
