ETL Developer

Depends on Experience

Full Time

  • No Travel Required

Skills

  • ETL
  • PL / SQL
  • data warehouse
  • Unix shell scripting
  • Python
  • ETL processes
  • BI / reporting

Job Description

Description

Formed in 2011, INADEV is focused on its founding principle to build innovative customer-centric solutions incredibly fast, secure, and at scale. We deliver world-class digital experiences to some of the largest federal agencies and commercial companies. Our technical expertise and innovations are comprised of codeless automation, identity intelligence, immersive technology, artificial intelligence/machine learning (AI/ML), virtualization, and digital transformation.

We are seeking a database developer with custom ETL scripting skills, Unix shell scripting, and Python.

POSITION DESCRIPTION:

  • Experience working with complex data warehouse projects
  • Design custom ETL processes to populate the data warehouse
  • Analyze source data for potential data quality issues and address these issues
  • Work with various industry leading data warehouse components (databases, ETL tools, BI/reporting tools)
  • Use scripting (Shell scripting, python, Java) and automation and DevOps
  • Prepare technical documents and presentations
  • Utilize Atlassian product suites, git, bitbucket, confluence, Jira.
Requirements

MINIMUM QUALIFICATIONS:

  • Ability to obtain Public Trust clearance
  • Bachelor's Degree in Computer Science, Mathematics, Engineering, or a related field
  • Bachelor's degree + 4 years of prior relevant experience or Master's degree + 2 years of prior relevant experience
  • 2 - 4+ years of combined experience with SQL and/or PL/SQL, pgSQL
  • 2+ years of combined experience with Jira and Confluence
  • The ideal candidate will have a strong desire to learn new skills, embed with a team, solicit ideas, and feedback.
  • Excellent communication skills
  • Expert in Shell scripting including but not limited to regular expressions, and automating tasks
  • Experience creating custom ETL using Python

REQUIRED SKILLS:

  • Experience working with complex data warehouse projects
  • Experience designing custom ETL processes to populate the data warehouse (not Tool based ETL)
  • Ability to analyze source data for potential data quality issues and address these issues
  • Ability to effectively communicate information, both verbally and written to end users, team members and management
  • High-level knowledge of various industry leading data warehouse components (databases, ETL tools, BI/reporting tools)
  • Experience in scripting (Shell scripting, python, Java) and automation
  • Experience with DevOps
  • Prepare technical documents and presentation
  • Familiarity with Atlassian product suites: Git, Bitbucket, Confluence, Jira.
  • High availability to support On-Call rotations for 24/7 Production database environment
  • Be comfortable working independently as well as in a team with a collaborative attitude

DESIRED SKILLS:

  • Ansible scripting
  • Experience with cloud environment, AWS
  • Database Administration (DBA) skills
  • Ability to work individually and as part of a team
  • Basic knowledge of relational databases (PostgreSQL, DB2, and Oracle)