Sr ETL Developer

Description

**Must be US Citizen or Green Card Holder

What makes Brillient a GREAT fit for you?  

  
When you join Brillient, you become part of an award-winning Full Spectrum Digital Transformation company focused on helping agencies in the continuum of analog, to digital, to analytics, leading to insight-driven decision making and mission execution.  

Our mission is to provide value to our clients and our people, operate with the highest integrity as a trusted business partner, adopt a workstyle that is flexible allowing us to effectively collaborate while being agile and nimble, and be innovative in everything we do. We are passionate about ensuring our employees experience a work environment that is inclusive, professional, and supportive. In addition to these core values, the Brillient team is driven by:  

• Focus on Sustainability- Being an environmentally conscious, green company with sustainable practices  

• Impact on the Community- Social responsibility to the communities we live and work in  

At Brillient, we achieve our purpose by hiring brilliant people with passion, drive, capabilities, and experience to help our clients achieve their mission goals through innovation in processes and technologies.  

Brillient is a client-centric, employee-focused company with a vibrant culture.  

What We Offer (See Our Career Page for Further Details):  

An engaging and supportive work environment where every employee is valued, a rewarding career, and outstanding benefits which currently include:  

• Ample paid time off  

• Medical, Dental, & Vision Plans  

• Company Sponsored Wellness Programs  

• Paid Life Insurance and STD  

• Paid Employee Assistance Program  

• Voluntary Life & TD coverage  

• 401(k)  

• Competitive wages  

• Quarterly Performance Development  

• Company Discounts  

• Anniversary & Birthday Programs  

• Spot Bonus Award Recognition up to $3K  

• College Loan Repayment Support  

• Continuing Education Support  

  
Who You Are:  

· Value based, High Integrity, Flexible, & Innovative  

Position Overview:

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.

Optimization and Performance

• Optimize ETL processes to ensure data is processed efficiently and quickly.
• Monitor ETL jobs and address any performance bottlenecks.

Data Quality

• 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.

Collaboration and Documentation

• 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.

Troubleshooting and Support

• 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.

Continuous Improvement

• Stay updated with the latest ETL techniques and tools.
• Recommend and implement improvements in ETL processes and infrastructure.

Equipment Operated: Standard office equipment including computers, fax machines, copiers, printers, telephones, etc.

Work Environment: Work performed in an office environment. Involves frequent contact with staff and customers.

Mental/Physical Requirements: Manual dexterity for office machine operation; stooping, bending to handle files and supplies, mobility to complete errands or deliveries. Must be able to remain in stationary position for extended periods of time. Stress can be triggered by multiple demands and deadlines. 

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

Qualifications:

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

Familiar with the following tools:

• DBeaver, Visual Studio, SecureCRT, SecureFX, Gitlab, Jira, Wiki, JSON
• Informatica, SAP Data Services
• (KSH, BASH, SH) tools like sed, awk, and Perl

Level III

Bachelor’s degree in computer science, Information Systems, or a related field.

[13 ] years of experience in ETL development, preferably with SQL, with a focus on the load, select, and update commands.

Must be able to obtain a Public Trust Security Clearance

Salary : $126,000 - $135,000