Job description

ETL Developer

Key Skills:

Database developer with custom ETL scripting skills, Unix shell scripting, and Python

Position Description:

Experience working with complex data warehouse projects designing 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.

Skills Requirements:

Basic Qualifications: bachelor's Degree in Computer Science, Mathematics, Engineering, or related field2-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 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 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:

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

Job Types: Full-time, Contract

Pay: Up to $56.00 per hour

Benefits:

• Dental insurance
• Health insurance
• Paid time off
• Vision insurance

Experience level:

• 4 years

Schedule:

• Monday to Friday

Ability to commute/relocate:

• Windsor Mill, MD: Reliably commute or planning to relocate before starting work (Required)

Education:

• Bachelor's (Required)

Experience:

• SQL: 4 years (Required)
• Data warehouse: 4 years (Required)
• Database developer: 4 years (Required)
• custom ETL scripting: 4 years (Required)
• Unix shell scripting: 4 years (Required)
• Python: 4 years (Required)
• PL/pgSQL: 2 years (Required)
• Jira and Confluence: 2 years (Required)
• creating custom ETL using Python: 2 years (Required)
• complex data warehouse projects: 2 years (Required)
• designing custom ETL processes: 2 years (Required)

Security clearance:

• Confidential (Required)

Work Location: In person

www.colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, www.colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, www.colinoncars.com is the ideal place to find your next job.