Abile Headquarters

  • ETL Engineer

    Job Locations US-VA-Chantilly
    Posted Date 6 days ago(1/10/2019 2:27 PM)
    Job ID
    2019-1234
    # of Openings
    1
    Category
    Engineering
  • Overview

    Abile Group has an exciting and challenging opportunity for an ETL Engineer on a Cyber Exploitation Contract supporting a law enforcement customer. 

     

    Abile Group, Inc. was formed in July 2004 to partner with the Intelligence Community and their Contractors in the areas of Enterprise Analytics & Performance Management, IT & Systems Engineering and Program & Project Management. We have significant experience with the Federal Government and are an EDWOSB dedicated to our employees and clients.  We are looking for high performing employees who enjoy providing advice and guidance along with solutions development and implementation support, crafted by combining industry best practices with the clients’ subject matter experience and Abile’s breadth of expertise. Abile Group is an Equal Opportunity Employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, veteran status, disability, or national origin.

     

    The right candidate will possess the below skills and qualifications and be ready to handle all responsibilities independently and professionally.

    Responsibilities

    • Developing, sustaining, and improving the current system data ingest functions and make adjustments, as needed, by performing analysis, monitoring and configuring the solution
    • Creating or updating detailed design information
    • Accessing and reviewing the code repository, administering code reviews, adjusting unit testing, maintaining build support, including continuous integration, sustain operational support activities and respond to mission critical requests
    • Working with application development tools, standards and languages in support of a mission critical system in an Agile Scrum environment
    • Perform SQL and PL/SQL development, including design and maintenance of back-end ETL processes utilizing Informatica workflow, custom PL/SQL and SQL scripts
    • Build and maintain database schemas
    • Design, build, deploy, and maintain ETL workflows
    • Install, configure, maintain and upgrade ETL software and repositories
    • Develop, optimize, and tune scripts within in an Oracle enterprise database environment
    • Support the sustainment and delivery of an automated ETL pipeline using a suite of COTS and GOTS products, Java, Perl, and other tools. Validate that data is extracted from structured and unstructured data inputs, databases, and other repositories, using scripts and other automated capabilities, logs, and queries.
    • Collaborate on code reviews, internal processes, and software enhancements, and understanding of PL/SQL and SQL coding standards
    • Perform data extracts, data purges, or data fixes in accordance with internal procedures and policies
    • Complete problem tickets, documenting bug fixes, design modifications, and changes based on customer requirements

    Qualifications

    Clearance Required: This position requires the candidate to have a current Top Secret security clearance and the ability to obtain a polygraph.  Candidate must possess SCI eligibility. 

     

    Degree and Years of Experience: BS degree, with five (05) years of relevant experience desired. Equivalent experience may be considered in lieu of degree.

     

    Required Skills:

    • At least 1 year of experience with PL/SQL, SQL, Oracle 11g and 12c, Informatica,  XML, XSLT, Java, web services, SVN, RCS, Git, OLS Security, JIRA, Oracle 11g/12c, Sun Solaris OS, Linux (CentOS, Red Hat), and Windows.
    • 2 years of experience using ETL tools to perform data cleansing, data profiling, transforming, and scheduling various workflows 

    Desired Skills: 

    • 1 year of experience with analysis and performance optimization and data structures, SQL, PL/SQL, and stored procedures 
    • 1 year of experience developing and data modeling within Oracle 
    • 1 year of experience reading and maintaining Java code 
    • Working knowledge of Unix commands and shell scripting
    • Experience working with application development tools, standards, and languages, including PL/SQL
    • Experience working with core infrastructure technologies such as Linux, Windows, and Oracle 11g/12c
    • Experience writing monitoring scripts, queries, and automating system tasks
    • core infrastructure technologies such as Linux, Windows, and Oracle 11g/12c

     

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed