TS Cleared ETL Engineer – Cloud

Responsibilities

  • 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
  • Install, configure, maintain and upgrade ETL software, repositories, and pipelines
  • Develop and maintain Python code and shell Scripts in on-premises and cloud environments
  • Maintain, optimize, and tune Oracle and DB2 database scripts
  • Perform data mining and performance tuning for large-scale datasets
  • Use ETL tools, BI tools, IBM MQ, SQL Loader
  • 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

  • At least 6 years’ experience with PL/SQL, SQL, Oracle DBMS, Informatica, XML, XSLT, Python, web services, SVN, RCS, Git, OLS Security, JIRA, Oracle 11g/12c, Sun Solaris OS, Linux (CentOS, Red Hat), and Windows.
  • Demonstrate a proficiency in the Python programming language
  • Experience with Informatica ETL / Data application development and version control systems such as Git.
  • Hands on experience with AWS cloud technologies like EC2, VPC, CloudWatch, CloudFormation, IAM, S3, RDS, ElasticCache, SNS, SQS and SWF
  • At least 3 years of experience with PL/SQL, SQL, Oracle 11g and 12c, Informatica, XML, XSLT, Linux (CentOS, Red Hat), shell scripting, and Windows.
  • 2 years of experience using ETL tools to perform data cleansing, data profiling, transforming, queuing, migrating, and scheduling various workflows
  • Top Secret clearance

Peraton Overview

Peraton drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world’s leading mission capability integrator and transformative enterprise IT provider, we deliver trusted and highly differentiated national security solutions and technologies that keep people safe and secure. Peraton serves as a valued partner to essential government agencies across the intelligence, space, cyber, defense, civilian, health, and state and local markets. Every day, our employees do the can’t be done, solving the most daunting challenges facing our customers.

Target Salary Range

$146,000 – $234,000. This represents the typical salary range for this position based on experience and other factors.

EEO Tagline (Text Only)

An Equal Opportunity Employer including Disability/Veteran.

Job Category
Job Type
Salary
Country
City
Career Level
Company
JOB SOURCE