Ab Initio ETL Developer

Virtualan Software, LLC; Woodlawn (MD); On-site; USD 90,000 - 150,000; Full time

Job summary

Virtualan Software, LLC seeks an experienced Ab Initio ETL Developer to design, develop, test, and optimize enterprise-scale ETL applications and data integration solutions.

You will design ETL graphs, build scalable batch and real-time integration, and mentor junior developers while collaborating with stakeholders to deliver robust data management capabilities.

Qualifications

• Strong hands-on experience designing, developing, testing, and troubleshooting ETL graphs and applications using Ab Initio.
• Strong experience with GDE, Co>Operating System, Express>IT, DQE, Continuous Flows, and Amazon S3 utilities.
• Strong understanding of ETL lifecycle analysis, design, implementation, testing, deployment, and code migration.
• Experience designing ETL frameworks for audit and data reconciliation.
• Experience supporting batch and real-time interfaces.
• Experience with ETL automation, monitoring, and performance optimization.
• Strong SQL, data mapping, and relational database integration experience.
• Experience loading data from multiple sources into BI/MI systems.
• Experience processing and optimizing large volumes of data.
• Strong technical leadership, problem-solving, and stakeholder communication skills.
• Experience preparing technical documentation and conducting knowledge-transfer sessions.
• Ability to independently research technical problems and develop solutions.
• Federal agency or public-sector experience is preferred.

Responsibilities

• Design, develop, test, deploy, and maintain Ab Initio ETL applications and graphs.
• Develop scalable batch and real-time data integration solutions.
• Build reusable ETL frameworks for audit, reconciliation, monitoring, and data quality.
• Integrate multiple source systems into BI/MI platforms.
• Develop and optimize SQL and database integration processes.
• Troubleshoot ETL, data quality, and production issues.
• Support ETL code migration and deployment.
• Automate ETL workflows and monitoring.
• Prepare technical documentation and conduct knowledge-transfer sessions.
• Collaborate with technical teams and stakeholders.
• Provide technical recommendations and mentor other developers.

Skills

Ab Initio

GDE

Co>Operating System

Express>IT

DQE

Continuous Flows

Amazon S3

SQL

Relational DB

Education

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

Tools

DB2

Microsoft SQL Server

PostgreSQL

Greenplum

Job description

We are seeking an experienced Ab Initio ETL Developer to design, develop, test, maintain, and optimize enterprise-scale ETL applications and data integration solutions.

Responsibilities

• Design, develop, test, deploy, and maintain Ab Initio ETL applications and graphs.
• Develop scalable batch and real-time data integration solutions.
• Build reusable ETL frameworks for audit, reconciliation, monitoring, and data quality.
• Integrate multiple source systems into BI/MI platforms.
• Develop and optimize SQL and database integration processes.
• Troubleshoot ETL, data quality, and production issues.
• Support ETL code migration and deployment.
• Automate ETL workflows and monitoring.
• Prepare technical documentation and conduct knowledge-transfer sessions.
• Collaborate with technical teams and stakeholders.
• Provide technical recommendations and mentor other developers.

Qualifications

• Bachelor's degree in Computer Science, Mathematics, Engineering, or a related field.

Required Skills

• Strong hands-on experience designing, developing, testing, and troubleshooting ETL graphs and applications using Ab Initio.
• Strong experience with GDE, Co>Operating System, Express>IT, DQE, Continuous Flows, and Amazon S3 utilities.
• Strong understanding of ETL lifecycle analysis, design, implementation, testing, deployment, and code migration.
• Experience designing ETL frameworks for audit and data reconciliation.
• Experience supporting batch and real-time interfaces.
• Experience with ETL automation, monitoring, and performance optimization.
• Strong SQL, data mapping, and relational database integration experience.
• Experience with DB2, Microsoft SQL Server, PostgreSQL, and/or Greenplum.
• Experience loading data from multiple sources into BI/MI systems.
• Experience processing and optimizing large volumes of data.
• Strong technical leadership, problem-solving, and stakeholder communication skills.
• Experience preparing technical documentation and conducting knowledge-transfer sessions.
• Ability to independently research technical problems and develop solutions.
• Federal agency or public-sector experience is preferred.

Preferred Skills

• Modern software development tools and methodologies.
• Data warehousing concepts, including star and snowflake schemas.
• Automated unit testing, TDD, performance analysis, and continuous integration.
• Experience with architectural recommendations, information solutions, and technical roadmaps.
• Large-scale enterprise data integration and migration experience.
• Experience mentoring junior and mid-level developers.