Senior ETL Engineer- Cloud

Senior ETL Engineer- Cloud

Location- Chantilly, Va

Clearance-Top Secret security clearance with ability to obtain SCI access and polygraph.

Salary- 190k/yr (will not go above)

The above salary range represents the range expected for the position; however, final salary offers are based on a number of factors such as the position's responsibilities; the candidate's experience, education, and skills; location; travel required; and current market conditions.

This program requires US Citizenship.

Clearance-Top Secret security clearance with ability to obtain SCI access and polygraph.

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, 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 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, 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

Desired Experience

• MQ experience

ABBTECH is an EOE/Minorities/Women/Disable Individuals/Veterans

#IND1