ETL Developer

Job Summary ASRC Federal is seeking an ETL (Extract Transform Load) Developer to work with our IT Team in support of our contract in support of the Drug Enforcement Agency's Diversion Control Division. Responsibilities Shall formulate and define 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 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 A BS/BA in Engineering, Physics, Computer Science, Information Technology, Mathematics or equivalent, and 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. Strong understanding of Data warehousing techniques and Star/Snowflake models Must have experience with AWS Glue, Data Catalog, Kafka, AWS Lambda, Python, Oracle SQL and Snowflake. Must have experience with Data Transformation and Data Integration. Must have high level of expertise in writing SQL queries on oracle and Snowflake. Experienced with orchestrating event trigger with AWS Lambda or Python to trigger workflows and process. Experienced with streaming of data with Kafka and reporting, analyzing and error correction with streams. Experience maintaining bookmarks to maintain the state of information/Data. Utilizing AWS Glue Data quality to evaluate, monitor and enforce data integrity across pipelines. Experience managing AWS Glue Data Catalog to store, discover and maintain metadata. Experience in building and maintaining data pipelines with AWS Glue. Experience with building and maintain AWS Data Lake in S3 Experience with Tuning data processing units and configuring workers. Candidate must be approved through the DEA’s Background Investigation process for a Public Trust clearance. Benefits We invest in the lives of our employees, both in and out of the workplace, by providing competitive pay and benefits packages. Benefits offered may include health care, dental, vision, life insurance; 401(k); education assistance; paid time off including PTO, holidays, and any other paid leave required by law. The salary offered will depend on several factors including, but not limited to, relevant experience, skills, education, geographic location, internal equity, business needs, and other factors permitted by law. Posted pay ranges are a general guideline only and are not a guarantee of compensation or salary. EEO Statement ASRC Federal and its Subsidiaries are Equal Opportunity 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. #J-18808-Ljbffr