Senior Ab Initio ETL Architect | Lead Data Integration

TechInvents; Woodlawn, Northern (MD, KY); Hybrid; USD 120,000 - 160,000; Full time

Job summary

TechInvents in Maryland is seeking a Senior Data Engineer to lead the design, build, and testing of complex ETL graphs using Ab Initio. You will set technical direction for the data engineering team and collaborate with cross-functional partners.

The role requires deep Ab Initio expertise, strong SQL, Linux scripting, and data warehousing know-how. You will mentor juniors, drive architecture decisions, and ensure scalable data flows from multiple sources into BI systems.

Qualifications

• Must have a Bachelor's degree in a technical field.
• Deep experience with Ab Initio tool suite in Unix/Linux environments.
• Strong SQL and data warehousing knowledge.
• Experience with ETL design and optimizing data workflows.

Responsibilities

• Design, build, and test ETL graphs across the Ab Initio suite (GDE, OSS, Data Quality).
• Create ETL frameworks for audit and data reconciliation across batch and real-time interfaces.
• Optimize performance for high-volume processing and automated loading from multiple sources.
• Map and integrate relational data across DB2, SQL Server, PostgreSQL, and Greenplum.
• Provide technical leadership and mentorship to junior and mid-level developers.
• Collaborate with cross-functional teams and brief stakeholders at the right technical level.
• Maintain technical documentation and lead knowledge-transfer sessions.

Skills

Ab Initio

SQL

Linux scripting

ETL design

Data warehousing concepts

Leadership

Mentorship

Stakeholder communication

Education

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

Tools

Ab Initio v4

Job description

TechInvents in Maryland is seeking a Senior Data Engineer to lead the design, build, and testing of complex ETL graphs using Ab Initio. You will set technical direction for the data engineering team and collaborate with cross-functional partners.

The role requires deep Ab Initio expertise, strong SQL, Linux scripting, and data warehousing know-how. You will mentor juniors, drive architecture decisions, and ensure scalable data flows from multiple sources into BI systems.