Mid ETL Developer
Brillient Corporation
Reston, VA
See who Brillient Corporation has hired for this role
- Must be US Citizen and hold a Public Trust, or ability to attain a Public Trust.
The ETL Developer/Engineer will play a pivotal role in supporting the IRS data warehousing initiatives. This role involves the design, implementation, and maintenance of the ETL processes to extract data from various source systems, transform it according to business rules and load it into the data warehouse. The successful candidate will collaborate with various teams including data architects, business analysts, and data quality specialists to ensure that data is accurate, consistent, and available for business users.
Key Responsibilities
Design and Development
- The primary duties involve moving data/tables from Unix operating systems and performing the required extract, transformation, and loading operations (ETL) to data/tables to Sybase IQ.
- This process may include refactoring jobs in entirely new ways by:
- Providing users support and documentation on moving data into Sybase IQ and providing metadata for the metadata repository.
- Provide development of an object-oriented style UNIX-based framework and engine of scripts and stored procedures that will execute and monitor multiple ETL processes and statistic processes.
- A successful candidate will have the ability to troubleshoot errors in shell and SQL, configure own SSH client and operate across servers.
- Participate in Scrum and client meetings, create documents, and update Kanban board cards.
- Optimize ETL processes to ensure data is processed efficiently and quickly.
- Monitor ETL jobs and address any performance bottlenecks.
- Ensure the accuracy and integrity of data through validation, cleansing, and auditing.
- Work closely with the Data Quality team to address any data inconsistencies or issues.
- Collaborate with Data Architects to design data models and schemas that meet business needs.
- Work with Business Analysts to understand transformation requirements.
- Document ETL processes, workflows, and data dictionaries for transparency and future reference.
- Address any failures in the ETL processes and resolve them in a timely manner.
- Provide support to business users and address any data-related queries or issues.
- Stay updated with the latest ETL techniques and tools.
- Recommend and implement improvements in ETL processes and infrastructure.
Work Environment: Work performed in an office environment. Involves frequent contact with staff and customers.
- Must be US Citizen and hold a Public Trust, or ability to attain a Public Trust.
DISCLAIMER: The above statements are intended to describe the general nature and level of work performed. They are not intended to be an exhaustive list of all responsibilities, duties, skills, efforts, requirements, or working conditions. Management reserves the right to revise the job or to require that other or different tasks be performed as assigned in accordance with business demands and/or contractual requirements.
Qualifications
Level II
Bachelor’s degree in computer science, Information Systems, or a related field.
[7-12] years of experience in ETL development, preferably with SQL, with a focus on the load, select, and update commands.
A successful candidate must have knowledge of the following tools:
- Linux/Unix Shell scripting
- Sybase DB
- Sybase Scripting
- Postgres DB
- Strong analytical and problem-solving skills
- DBeaver, Visual Studio, SecureCRT, SecureFX, Gitlab, Jira, Wiki, JSON
- Informatica, SAP Data Services
- (KSH, BASH, SH) tools like sed, awk, and Perl
-
Seniority level
Mid-Senior level -
Employment type
Full-time -
Job function
Business Development and Sales -
Industries
IT Services and IT Consulting
Referrals increase your chances of interviewing at Brillient Corporation by 2x
See who you knowGet notified about new ETL Developer jobs in Reston, VA.
Sign in to create job alertSimilar jobs
-
Full-Stack Engineer
Full-Stack Engineer
Sprig
-
Software Engineer I
Software Engineer I
The Walt Disney Company
-
Software Engineer - Recent Graduate
Software Engineer - Recent Graduate
PayPal
-
Software Engineer - Recent Graduate
Software Engineer - Recent Graduate
PayPal
-
Junior React Developer
Junior React Developer
Team Remotely Inc
-
Software Engineer, Training
Software Engineer, Training
Rover.com
-
Fullstack Software Engineer, Airbnb for Real Estate
Fullstack Software Engineer, Airbnb for Real Estate
Airbnb
-
Entry Level Software Engineer (Remote)
Entry Level Software Engineer (Remote)
Engtal
-
Software Engineer (Remote)
Software Engineer (Remote)
The Home Depot
-
Software Engineer (Remote)
Software Engineer (Remote)
The Home Depot
-
Junior Software Developer
Junior Software Developer
Great Northern Equipment Distributing, Inc.
-
Software Engineer
Software Engineer
iHeartMedia
-
Junior React Developer
Junior React Developer
Patterned Learning Career
-
Junior Python Developer
Junior Python Developer
Team Remotely Inc
-
Junior Web Developer
Junior Web Developer
Team Remotely Inc
-
Software Engineer 2
Software Engineer 2
Nike
-
Software Engineer - Frontend
Software Engineer - Frontend
Refuel
-
Junior Level Software Engineer (REMOTE)
Junior Level Software Engineer (REMOTE)
SynergisticIT
-
Junior Software Engineer
Junior Software Engineer
First Advantage
-
Software Engineer
Software Engineer
Hayden AI
-
Software Developer 1
Software Developer 1
Oracle
-
Software Engineer
Software Engineer
Magic
-
Software Engineer
Software Engineer
Deltek
-
Junior Full Stack Software Engineer
Junior Full Stack Software Engineer
Radiance Technologies
-
Software Engineer - Front-End Development
Software Engineer - Front-End Development
Blink Health
-
Software Engineer (Entry-level)
Software Engineer (Entry-level)
Fuel Cycle
-
Junior Full Stack Web Developer
Junior Full Stack Web Developer
Patterned Learning Career
People also viewed
-
Junior Node.JS Developer
Junior Node.JS Developer
-
Software Developer
Software Developer
-
Jr. Software Development Engineer - Sunnyvale
Jr. Software Development Engineer - Sunnyvale
-
Software Engineer, Front-end
Software Engineer, Front-end
-
Software Engineer, New Grad
Software Engineer, New Grad
Looking for a job?
Visit the Career Advice Hub to see tips on interviewing and resume writing.
View Career Advice Hub