ETL Engineer III
Work with customer development team to ingest approximately 175 datasets of varying types
Maintain, enhance the customer application which is designed to the review and analysis of various data types.
Perform extraction, transformation, and load of data sets in differing formats.
Make design enhancements to the data base schema, dictionary and normalize data into a consistent schema to accept new data types
Assist in the enhancement of a user-friendly web browser interface to allow the end users to conduct efficient search, and conduct link analysis.
Assist in the enhancement of reports for dissemination or offline viewing
Develop and maintain database backup plan
Typical Education & Experience
Typically a Bachelor's Degree and 8 years work experience or equivalent experience
Required Skills and Education
At least 6 years 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.
Must be a strong communicator, written and verbal. Must be able to translate technical information for customer.
Must be strong in Bash Script.
Experience with Solr.
Solid understanding of scripting using Python to conduct ETL. Experienced with ETL for wide variety of structured and unstructured very large datasets.
Experience or familiarity with Elasticsearch .
BS in Computer Science or similar technical field recommended. Experience in lieu of education will be considered.
Quick learner; very flexible responding to changing priorities and case/mission driven tasking.
Preferred Skills and Education
It is highly desired for candidate to be equally strong in ETL and database engineering and administration.
The MySQL database holds data including bulletin boards, messages, image galleries, blogs, and market places. Configure the database servers and tune the database for optimal performance. Solid understanding of MySQL relational database design and administration tools and techniques.
About BAE Systems Intelligence & Security
BAE Systems Intelligence & Security, based in McLean, Virginia, designs and delivers advanced defense, intelligence, and security solutions that support the important missions of our customers. Our pride and dedication shows in everything we do-from intelligence analysis, cyber operations and IT expertise to systems development, systems integration, and operations and maintenance services. Knowing that our work enables the U.S. military and government to recognize, manage and defeat threats inspires us to push ourselves and our technologies to new levels. That's BAE Systems. That's Inspired Work. Equal Opportunity Employer/Females/Minorities/Veterans/Disabled/Sexual Orientation/Gender Identity/Gender Expression. To see Inspired Work in action, visit www.baesystems.com and follow us on Facebook: www.facebook.com/baesystemsintel.
Back to top