Software Engineering (ETL Testing)

Pyramid Consulting; San Diego (CA); On-site; USD 80,000 - 110,000; Full time

Job summary

An IT consulting firm in California is seeking a Software Engineer for ETL Testing on a 12-month contract. The role requires extensive experience in ETL Testing and SQL, with a background in big data technologies such as Vertica or Hadoop. Candidates should be self-starters, proficient in Agile methodologies, and capable of managing multiple tasks. This position involves developing back-end systems, integrating REST services, and contributing to design patterns within an AWS stack.

Qualifications

• 5 years or more ETL Testing experience.
• Proficient with complex SQL.
• 3+ years working with big data technologies.

Responsibilities

• Develop back-end stack of projects using AWS.
• Integrate back-end REST with front end UI.
• Assist in design and implementation of back end changes.

Skills

ETL Testing

Complex SQL

Big data experience

Python

Shell scripting

Agile methodology

Tools

Hadoop

Vertica

Netezza

Java

Oracle

ActiveMQ

Redis

Job description

Pyramid is a leading Information Technology Consulting services company headquartered in metropolitan Atlanta, GA with prime emphasis on the following service offerings:

• Staff Augmentation
• Lifecycle IT solutions
• Application Development & Support
• Outsourced Testing
• Mobile Development and Test Automation

Job Description

Job Title: Software Engineering (ETL Testing)

Duration: 12 Months Contract

Job Description:

This role is more of a data/ quality engineering - functional integration role. First 30 days - understand schema and pick any story and write test-case (huge data schema) 60-90 regular project work via agile, expect no hand holding after this time they should be able to run with project Updates on tasks will be necessary in Agile meetings

Soft Skills

• Seeking a self-starter, this person will need to wear many hats and not need hand holding
• Good Agile experience, so the candidate is flexible, and be able to assess priorities when multiple tasks queued up.

Qualifications

• 5 years or more ETL Testing experience
• Profession with complex SQL
• 3 plus years of experience to work with big data, Vertica is preferred, but also accept Hadoop, Netezza, or similar DWH experiences.
• Have good skill of scripting, prefer Python and Shell
• Need proven record of being a team player, good communicator and faster learner

Additional Information

All your information will be kept confidential according to EEO guidelines. Day to Day Duties :

• Develop complete back-end stack of projects using Java, Oracle, ActiveMQ, Redis, on an AWS stack.
• Help write new design patterns, improve and adapt existing design component integration.
• Integrate back-end REST with front end UI.
• Assist in the design of, and implementation of back end changes across our product base.
• Debug services oriented architectural components.