Senior ETL Developer

Job Title: Senior ETL Developer
Location: Baltimore, MD
Duration: Long Term Contract 
Client: Leidos

Key Required Skills:
Python experience for data extraction and manipulation, ETL efforts for Business Intelligence (BI) projects, data mapping/analysis, PUTTY, PSQL, File Transfer Protocol (FTP), Bitbucket; Linux/Unix Shell scripting (Bash Shell scripting) and Linux O/S

Position Description:
We are in search of a Senior ETL Developer to join our team based in supporting the contracts at the Social Security Administration.

The ideal candidate will:
·        Lead the development of highly innovative products/solutions, achieved through collaboration and dialogue with other experts in the field. The candidate will continually assess advancements in technologies to gauge and recommend better solutions for the customer to improve the software developer experience and efficient delivery of software. 
·        Mentor and coach technical staff, proactively shape product vision, and support multiple internal/external initiatives to achieve mission success. The candidate will have past and proven experiences as the technical lead on large, complex projects, and enterprise solutions. 
·        Provide technical advice/input that impact strategic client outputs and Leidos business results. 
·        Impact functional strategy by developing new solutions, processes, standards or operational plans that position Leidos competitively in the marketplace.

Required Skills:
·        Linux/Unix Shell scripting (Bash Shell scripting) and Linux O/S
·        ETL Tools: PUTTY, PSQL, File Transfer Protocol (FTP), Bitbucket
·        Knowledge of data mapping/analysis
·        Experience in supporting ETL efforts for Business Intelligence (BI) projects
·        Python experience for data extraction and manipulation
·        Strong understanding of data recovery and job rerun needs in an ETL environment.
·        Strong experience with SQL, mapping, and integration of databases such as DB2, Oracle 19c, and Greenplum.
·        Proficiency writing scripts using Oracle PL/SQL, and PostgreSQL
·        Familiarity extracting data from multiple data sources such as DB2, Oracle, and flat files.
·        Experience scripting in a Linux environment to automate ETL solutions and data migration jobs.
·        Knowledge of when to use plain SQL vs. PL/SQL.
·        Working knowledge with analyzing and developing optimal code to maintain high performance for processing large volumes of data.
·        Hands on experience with data warehouse Business Intelligence (BI) / Management Information (MI) reporting environment. Knowledge in both client-server and mainframe-based systems and the connectivity/infrastructure requirements to support, design, develop and implement such systems.
·        Experience working with enterprise data warehouses.