Engineer - ETL Engineer (Cloud) (Sr), Quadrant, Chantilly, VA
Quadrant -
Chantilly, VA,
US
Engineer - ETL Engineer (Cloud) (Sr)
Date Posted: 2024-05-18
Job description
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, Inc. is an equal opportunity and affirmative action employer. Quadrant is committed to administering all employment and personnel actions on the basis of merit and free of discrimination based on race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or status as an individual with a disability. Consistent with this commitment, we are dedicated to the employment and advancement of qualified minorities, women, individuals with disabilities, protected veterans, persons of all ethnic backgrounds and religions according to their abilities.
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