Ab Initio Developer

The Amatriot Group; Woodlawn (MD); On-site; USD 100,000 - 180,000; Full time

Job summary

A leading technology solutions provider is seeking an experienced software developer specializing in ETL pipelines and the Ab Initio tools suite. The role requires strong technical leadership to design and develop data integration solutions while collaborating with cross-functional teams. Candidates should have over 10 years of experience, a Bachelor's degree in a relevant field, and the ability to communicate effectively. This position offers a competitive salary range of $100,000 to $180,000 depending on qualifications and experience.

Qualifications

• 10+ years as a software developer with Ab Initio experience.
• Strong knowledge of ETL designs and lifecycle.
• Experience automating ETL solutions in a Linux environment.

Responsibilities

• Design and develop ETL pipelines using Ab Initio tools.
• Collaborate with cross-functional teams to gather requirements.
• Prepare comprehensive technical documentation.

Skills

Ab Initio tools suite experience

ETL pipeline development

SQL proficiency

Linux scripting

Data warehousing concepts

Excellent communication skills

Education

Bachelor's Degree in Computer Science, Mathematics, Engineering or related field

Tools

Ab Initio

DB2

Microsoft SQL Server

PostgreSQL

Greenplum

Job description

Security Clearance: Must be able to obtain and maintain a Public Trust

Location: Woodlawn, MD

Job Type: Full-Time

Target Salary Range*: $100,000 - $180,000.

This represents the potential salary range for this position depending on education level, years of experience and/or certifications in addition to other position specific requirements which may impact salary.

Position Overview

Strong experience with designing, developing, and maintaining Extract Transform Load (ETL) pipelines and data integration solutions using the Ab Initio tools suite.

Key Responsibilities

• Strong experience in design, building and testing graphs and ETL applications using Ab Initio 4. Familiarity with the Ab Initio tool suite and Unix/Linux environments.
• Strong experience in enterprise-complexity ETL solutions using Ab-initio suite including products such as GDE>Co-Operating System, Express>IT, Data Quality Environment (DQE), Continuous Flows, Amazon S3 utilities.
• Strong knowledge of Ab Initio lifecycle analysis, designs, implementation, and code migration.
• Design ETL Framework for an audit and data reconciliation to manage batch and real time interfaces.
• Develop ETL jobs for automation, monitoring and responsible for job performance optimization using ETL development tools or custom developed procedures.
• Strong experience with SQL, mapping, and integration of relational databases such as DB2, Microsoft SQL Server, PostgreSQL, and Greenplum.
• Experience automating the loading of data from multiple sources into BI/MI systems.
• Working knowledge with analyzing and developing optimal code to maintain high performance for processing large volumes of data.
• Provide technical leadership and guidance to project teams and stakeholders.
• Collaborate with cross-functional teams to gather requirements and deliver effective search features.
• Prepare and maintain comprehensive technical documentation and deliver knowledge transfer sessions to SSA staff.
• Ensure compliance with SSA security, privacy, and data management policies.
• Brief management, customer, team, or vendors using written or oral skills at appropriate technical level for audience.
• Provide guidance/support to other junior/mid-level developers.

Qualifications

Education

• Bachelor's Degree in Computer Science, Mathematics, Engineering or a related field.
• Masters or Doctorate degree may substitute for required experience.

Experience

• 10+ years as a software developer with Ab Initio experience.

Skills

• Experience identifying requirements, researching options, designing, and implementing solutions at a leadership level on project work.
• Experience scripting in a Linux environment to automate ETL solutions and data migration jobs.
• Experience with data warehousing designs/concepts such as star and snowflake schemas.
• Understand and apply quality techniques and practices (automated unit testing, Test Driven Design/Development, performance analysis, continuous integration).
• Ability to assist with architectural tactical thinking, information solutions and road maps to drive architectural recommendations.
• Excellent communication and written skills.
• Detail oriented and committed to consistently completing repetitive production-like tasks on-time and error-free.
• Prior experience working in a federal agency or public sector environment.
• Ability to independently research problems and provide solutions.

Preferred Qualifications

• Experience identifying requirements, researching options, designing, and implementing solutions at a leadership level on project work.
• Experience scripting in a Linux environment to automate ETL solutions and data migration jobs.
• Experience with data warehousing designs/concepts such as star and snowflake schemas.
• Understand and apply quality techniques and practices (automated unit testing, Test Driven Design/Development, performance analysis, continuous integration).
• Ability to assist with architectural tactical thinking, information solutions and road maps to drive architectural recommendations.
• Experience with modern development software, tools, and methodologies.
• Experience working on Agile projects and understanding Agile terminology.