HII - Mission Driven Innovative Solutions Inc. ETL Engineer - 18137 in Raleigh, North Carolina
ETL Engineer - 18137
Position Location Raleigh, NC
Requisition # 18137
# of Openings 1
HII - MDIS is currently seeking a ETL Engineer to work out of their clients Raleigh, NC office. The selected candidate will monitor and troubleshoot automated jobs in an ETL (Extract, Transform & Load) data integration system. Additionally, candidate will build, deploy and maintain ETL processes in that same environment. Must be able to share a rotating, nights and weekends schedule. May need to work other ETL tasks as assigned.
HII – Mission Driven Innovative Solutions Inc. (HII-MDIS) provides mission-critical engineering and technical service to Information Technology, Federal Civilian, and National Security, Aerospace & Defense and International government and commercial customers at over 100 locations worldwide.
Duties and Responsibilities (to include but not be limited to the following):
Monitor scheduled executions of automated ETL jobs, performing triage and troubleshooting as needed
Build, deploy, and maintain ETL workflows through the use of SQL, Unix Shell script programming and the Informatica Big Data Management platform
Build and maintain database schemas in Hive/Hadoop
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 Unix Shell 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
Complete various requests for enabling connectivity and access to up/downstream systems
Qualifications and Experience :
Degree from an accredited college or university in a technical field (engineering, mathematics, statistics, computer science, or related field of study) plus at least 10 years of professional service
Familiarity with operations monitoring
Experience using ETL tools to perform data manipulation and scheduling various workflows
Experience with analysis and performance optimization and data structures, SQL and stored procedures
Working knowledge of Unix commands and shell scripting
Experience working with application development tools, standards, and languages, including 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
Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information
Must be able to obtain and keep a USPS Sensitive Clearance
Must be a U.S. Citizen or Green Card holder and have been living in the U.S. for at least the last five years
Must not have traveled outside of the United States for more than 180 days in the last five years
All candidates will be subject to a pre-employment background investigation and drug screening per HII requirements.
Huntington Ingalls Industries is proud to be an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected class.