ETL Application Developer

ASRC Federal · Washington DC

Company

ASRC Federal

Location

Washington DC

Type

Full Time

Job Description

Job Description

ASRC Federal is seeking a seasoned ETL Developer to join our team to support a DEA contract in Arlington, VA.

Work arrangement: ( Remote or Hybrid)

Clearance: Public Trust (must be a US Citizen)

Responsibilities:

  • Shall formulate and define system scope and objectives.
  • Shall devise or modify procedures to solve complex problems considering computer equipment capacity and limitations, operating time, and form of desired results.
  • Shall prepare detailed specifications from which programs will be written and shall 81 design, code, test, debug, and document those programs.
  • Shall be competent to work at the highest technical level of all phases of applications systems analysis and programming activities

Requirements

Requirements:

  • Strong understanding of the Data warehousing techniques and star/snowflake models.
  • Must have experience in DataStage Director and job designs:
  • Experience in DataStage parallel and sequential job scheduling for multiple jobs.
  • Experience in DataStage job scheduling process with Autosys and DataStage scheduler.
  • Experience in DataStage error resolutions.
  • Experience using Parallel processing Infrastructure using DataStage.
  • Experience in developing Data stage jobs for extract and transformation to load to data warehouse.
  • Experience with Join, Lookup, Merge stages.
  • Experience using data stage functionalities like file loading and unstructured data.
  • Experience with Oracle databases and building PL/SQL Procedures, Functions, Triggers and packages.
  • Experience in writing Unix/Linux shell scripts.
  • Must be a US Citizen and ability to obtain/maintain a Public Trust.
  • Must be able to pass a government issues background check.

Education:

  • BS/BA in Engineering, Physics, Computer Science, Information Technology, Mathematics or equivalent
  • At least four (4) years' experience in the field. Eight (8) years of related experience is equivalent to a BS/BA in Engineering, Physics, Computer Science, Information Technology, Mathematics or related discipline.

**COVID-19 Vaccination Requirement Statement

The COVID-19 vaccination requirement in Executive Order 14042 and FAR 52.223-99 is currently not effective. But please note that if those or other related requirements become effective, positions will require successful candidates to obtain and show proof of COVID-19 vaccination(s). ASRC Federal is an equal opportunity employer and will provide reasonable accommodation to those individuals who are unable to be vaccinated consistent with federal, state, and local law.

EEO Statement

ASRC Federal and its Subsidiaries are Equal Opportunity / Affirmative Action employers. All qualified applicants will receive consideration for employment without regard to race, gender, color, age, sexual orientation, gender identification, national origin, religion, marital status, ancestry, citizenship, disability, protected veteran status, or any other factor prohibited by applicable law.

Date Posted

01/05/2023

Views

6

Back to Job Listings Add To Job List Company Profile View Company Reviews
Positive
Subjectivity Score: 0.9

Similar Jobs

Information Security Consultant - Application Security Engineer - MassMutual

Views in the last 30 days - 0

MassMutual is seeking an experienced Application Security Engineer to join their dedicated team The role involves driving security best practices cond...

View Details

Regional Director Public Sector Sales DOW - Chainguard

Views in the last 30 days - 0

The job seeks a Regional Director with sales expertise and security clearance to lead public sector initiatives and build partnerships Responsibilitie...

View Details

2025 Sensor Modeling and Simulation Analysis Engineer - The Aerospace Corporation

Views in the last 30 days - 0

The Aerospace Corporation is a trusted partner to the nations space programs providing technical expertise and innovative solutions across satellite l...

View Details

Manager, Customer Success - Bold Penguin

Views in the last 30 days - 0

Bold Penguin a leading digital solution platform for small commercial insurance is seeking a Manager of Customer Success The role involves leading a t...

View Details

Manager, Project Manager - Capital One

Views in the last 30 days - 0

Capital One a Fortune 500 company and one of the nations top 10 banks is seeking a Manager Project Manager The role involves leading critical and stra...

View Details