Engineer - ETL Engineer (Cloud) (Sr)
Senior ETL Engineer (Cloud)
Chantilly, VA
MUST :
Top Secret Clearance required
Experienced Senior ETL Engineer (Cloud)
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
At least three (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
MQ (message queue) Experience highly preferred
Demonstrated 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
Bachelor's degree with 8+ years of relevant experience; master's degree with 6+ years of experience or PHD with 3 yrs of experience
DUTIES :
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
Quadrant is an affirmative action / equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, status as a protected veteran, or status as an individual with a disability.