Software Engineer II

Title: Software Engineer II

Job Location: 1100 North Market Street, Wilmington, DE 19801. Position requires in-office work four (4) days every week.

Job Description: Develop, design, and support ETL processes. Prepare and manage the technical components of project plans. Perform unit testing of the jobs and assist with SIT (System Integration Testing) and UAT (User Acceptance Testing). Create pipelines to deploy code to higher environments. Work closely with data stewards to understand data mapping and implement extraction and transformation of data from various sources. Work with ETL tools and programming languages to create ETL workflows. Collaborate with other development, operations, and technology staff in overall systems development. Maintain code repositories. Document ETL processes, procedures, and specifications. Maintain the efficient operation and effectiveness of supported applications. Fine-tune production applications for performance. Support production applications and resolve production incidents from the incident queue.

Minimum requirements: Bachelor’s degree (or foreign equivalent) in Computer Science, Computer Engineering, Electronics Engineering, or related fields of study plus five (5) years of experience in the job offered or as a Sr. Software Engineer/Developer, ETL/Big Data Developer, Software Programmer, or related occupation.

Requires one (1) year of experience with the following:

• Designing and developing Data Warehouse applications using Hadoop technologies;
• Using Shell Scripting as part of the application design;
• Designing and developing applications in Python;
• Using Snowflake as the backend for Data Warehouse applications;
• Using ETL tool Informatica for building ETL workflows;
• Maintaining code repositories and creating pipelines using Git or Bitbucket;
• Using PySpark which is a Spark programming language for data processing;
• Using CA Automic as a scheduling tool to schedule jobs and workflows and monitor the daily runs of jobs and workflows;
• Using SQL to query data from SQL Server; and,
• Working on Data Warehousing applications using Teradata.

Salary: $154,684.88 - $164,684.88 per year

Location

Wilmington, Delaware, United States of America