Job Information
ASRC Federal Holding Company ETL Application Developer in Arlington, Virginia
ASRC Federal is seeking a seasoned ETL Developer to join our team to support a DEA contract in Arlington, VA.
Work arrangement : Hybrid/Onsite
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:
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.
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.