ETL Developer

Ameriinfovets, Inc.
Baltimore, MD Full Time
POSTED ON 9/15/2022 CLOSED ON 10/26/2022

Job Posting for ETL Developer at Ameriinfovets, Inc.

Position Title: EDW ETL Developer
Client: Leidos/SSA
Location: Baltimore, MD
Rate: $60/hr on W2 without benefits.
Key Required Skills:
Experience in scripting (Shell scripting, Python, Java) and automation. High-level knowledge of various industry leading data warehouse components (databases, ETL tools, BI/reporting tools)
Position Description:
We are in search of a Database Extract, Transform and Load (ETL) Developer with experience in designing, developing, testing, and maintaining complex Data Warehouse projects to join our team based in supporting the contracts at the Social Security Administration.
Day to Day Responsibilities:
  • Use various data loading techniques for Greenplum MPP database and
develop the process to automate it and troubleshoot any data load
errors
  • Use your database development experience with strong skills in SQL
and PL/pgSQL.
  • Provide expertise in shell scripting, regular expression and automating
tasks
  • Perform source system data analysis to understand data relationships
  • Investigate and resolve data quality, data loading failures and develop
data cleansing routines
  • Design and document logical and physical data models in data
modeling tool
  • Generate Data Definition Language (DDL) scripts from modeling tool
  • Design and document source to target data mappings
  • Design, develop and test custom ETL or data stage routines
  • Automate the custom data loading process and continue to improve
based on requirements.
  • Provide ad hoc query support for ad hoc query requests
  • Use experience with AWS, EC2, S3
  • Provide mentorship to group members and help develop and support
junior level staff
  • Provide occasional after hours on-call support and support production
releases during non-peak hours
  • Conduct other duties as directed by management
Skills Requirements:
Required Skills
  • Experience working with complex data warehouse projects
  • Experience designing custom ETL processes to populate the data
warehouse
  • Ability to analyze source data for potential data quality issues and
address these issues
  • Ability to effectively communicate information, both verbally and written
with 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 presentations
  • Familiarity with Atlassian product suites, git, bitbucket, confluence, Jira.
Desired Skills:
  • Ansible scripting
  • Experience with cloud environment, AWS
  • Database Administration (DBA) skills
Experience Level:
  • Database (PostgreSQL v9.6 or Greenplum v5 ) - 4 years
  • Custom ETL Scripting – 5 years
  • SQL and pg/PLSQL - 4 years
  • Shell Scripting – 5 years
  • Python – 5 years
  • AWS (EC2 & S3) – 1 year
Education:
  • Bachelor's degree and 5 years of experience in a related field or
master’s degree and 3 years of experience in a related field
  • Must be able to obtain a Public Trust
ETL Informatica Developer / Lead
Sonsoft Inc -
Owings Mills, MD
GC014SD3 - Sr Software Developer - Cleared
Sr Software Developer - Cleared - NiSUS Technologies Corporation -
Annapolis, MD
311 - Software Developer - II (Python)
Software Developer - II (Python) - Next Phase Solutions and Services, Inc. -
Columbia, MD

Popular Search Topics

Salary.com Estimation for ETL Developer in Baltimore, MD
$69,146 to $96,202
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Sign up to receive alerts about other jobs that are on the ETL Developer career path.

Click the checkbox next to the jobs that you are interested in.

Income Estimation: 
$67,262 - $93,581
Income Estimation: 
$88,375 - $116,773

Sign up to receive alerts about other jobs with skills like those required for the ETL Developer.

Click the checkbox next to the jobs that you are interested in.

  • Cross-Functional Integration Skill

    • Income Estimation: $78,952 - $114,172
    • Income Estimation: $72,084 - $97,036
  • Data Conversion Skill

    • Income Estimation: $88,375 - $116,773
    • Income Estimation: $118,841 - $149,869
This job has expired.

Job openings at Ameriinfovets, Inc.

Ameriinfovets, Inc.
Hired Organization Address Atlanta, GA Full Time
Position: Logistics Systems Specialist Location: Atlanta, GA. Task 1: Logistics Systems Specialist Services The vendor s...
Ameriinfovets, Inc.
Hired Organization Address San Francisco, CA Full Time
Job Title: Business Systems Analyst Location: On-site, 3-4 days at South San Francisco site Job Description: Experience ...
Ameriinfovets, Inc.
Hired Organization Address Gaithersburg, MD Full Time
Software Developer/Programmer: Formulates and defines system scope and objectives for assigned projects. Prepares detail...
Ameriinfovets, Inc.
Hired Organization Address Chantilly, VA Full Time
Title: Technical Writer Duration: 2 Months Location: Chantilly, VA Work Authorization: US Citizen JOB DETAILS: We are se...

Not the job you're looking for? Here are some other ETL Developer jobs in the Baltimore, MD area that may be a better fit.

ETL Developer

Johns Hopkins Medicine, Hanover, MD

Senior ETL Developer

Johns Hopkins Medicine, Hanover, MD