Custom ETL Developer

(using scripting only)

Remote

Job Description / Position Description:

Experience working with complex data warehouse projects.

Care and feeding of the Data warehouse​

Design custom ETL processes to populate the data warehouse using scripting only(Shell scripting, python, Java) automation using  DevOps practices.   ETL Tools will not be used in this project.

Utilize Atlassian product suites, git, bitbucket, confluence, Jira.

Analyze source data for potential data quality issues and address these issues.

Prepare technical documents and presentations.

Key Skills:

Database developer with custom ETL scripting skills only

Java

Unix shell scripting

Python

Atlassian product suites, git, bitbucket, confluence, Jira.

Basic Requirements/Qualifications:

Bachelor's degree 4 years of prior relevant experience or Master's degree +2 years of prior relevant experience.

Must be able to obtain a Public Trust

Bachelor's Degree in Computer Science, Mathematics, Engineering, or a related field.

2-4+ years of combined experience with SQL and/or PL/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, shell, Java

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 communicate information effectively, both verbally and written to end users, team members and management.

Experience in scripting (Shell scripting, python, Java) and automation

Experience with DevOpsPrepare 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)

Education/Work Experience:

Bachelor's degree 4 years of prior relevant experience or Master's degree +2 years of prior relevant experience.

📧

Please send/Email resumes:

careers@ommincorp.com