ETL Developer

Abaco Strategy LLC$90K — $120K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 5-10 years of experience in data warehousing and data mart development (SQL Server)
  • 5-10 years of ETL program development and stored procedures experience (e.g., SSIS, Informatica)
  • Excellent knowledge of data warehousing concepts, modeling, and OLAP
  • Demonstrated problem-solving skills for complex data-driven challenges
  • Ability to handle multiple projects in a collaborative team environment
  • Good communication skills
  • Experience with federal contracts preferred

Responsibilities

  • Design, develop, and test ETL data processes using SQL SSIS
  • Capture and analyze business requirements with business analysts
  • Create technical specifications based on requirements
  • Develop Source-to-Target mappings for data processes
  • Develop and execute unit test plans

Benefits

  • Regular, full-time employment classification
  • Work within the federal sector in a major metropolitan area
  • Opportunity to support important agency projects
  • Engage in a collaborative team environment
  • Potential for advancement within the agency's contract structure
Full Job Description
Job Description

General Information

Location: Washington, DC

Employment Classification: Regular, FT Employee

Minimum Experience - 5-10 Years' experience with data warehousing

Required Degree - 4 Year Degree in Computer Science, Information Technology, or related discipline

Clearance - Public Trust

US Citizens Only

Abaco is seeking an ETL Developer to support a federal Agency located
in the Washington, DC Metro Region. The ideal candidate will be
responsible for designing and testing ETL data processes, capturing and
analyzing business requirements, and developing reports. To be
successful, it is critical that you are flexible and able to work well
within a team environment. The ideal candidate for this opportunity will
have solid industry experience in the following area(s):

* Design, develop and test ETL (Extract, Transform, and Load) data processes (using SQL SSIS)

* Work with Business analysts to understand requirements and create technical specifications

* Develop Source-to-Target mappings

* Develop and execute unit test plans

Minimum Qualifications and Experience

* Excellent knowledge of data warehousing, dimensional, relational, and OLAP data modeling

* Demonstrated independent problem solving skills and ability to develop solutions to complex analytical/data-driven problems

* 5-10 years' experience in data warehouse and data mart development (SQL Server)

* 5-10 years' experience designing and developing ETL programs and
stored procedures for Data Warehousing (using tools such as SSIS,
Informatica, etc.)

* Ability to work on multiple projects

* Ability to work with a team

* Good communication skills

* Experience working on a Federal contract

* Preferred Skills:

o Experience with SAP Business Objects, Embarcadero ER Studio, and Tableau

o Experience with source control repository

o Experience with Financial Data Warehouse

Qualifications

Minimum Experience - 5-10 Years' experience with data warehousing

Required Degree - 4 Year Degree in Computer Science, Information Technology, or related discipline

5-10 years' experience in data warehouse and data mart development (SQL Server)

5-10 years' experience designing and developing ETL programs and stored procedures for Data Warehousing (using tools such as SSIS, Informatica, etc.)

Clearance - Public Trust

US Citizens Only

Additional Information

Clearance - Public Trust

US Citizens Only

Similar Jobs

More Jobs at Abaco Strategy LLC

  • ETL Developer
    $90K — $120K *
    Washington, DC 20011 (District Of Columbia County)
    Information Technology
    In-Person
  • Middleware Engineer
    $100K — $130K *
    Arlington, VA 22204 (Arlington County)
    Information Technology
    In-Person

More Information Technology Jobs

Find similar ETL Developer jobs: