Role: ETL Ab initio Developer
Location: Richmond, VA or McLean, VA
Employment Type: Contract W2
Experience Level: 7+
Interview: Single Round (Virtual)
Job Description
We are seeking an experienced Ab Initio Developer with 7+ years of hands-on experience in designing, developing, and supporting large-scale data integration and ETL solutions. The ideal candidate will work closely with business, data, and analytics teams to deliver high-performance data pipelines in enterprise data warehouse environments.
Key Responsibilities
Build and optimize Ab Initio graphs, plans, and continuous flows
Develop reusable and scalable components following best practices
Perform data extraction, transformation, and loading (ETL) from multiple source systems
Tune Ab Initio jobs for performance, scalability, and reliability
Collaborate with data architects, business analysts, and downstream consumers
Perform unit testing, integration testing, and production support
Troubleshoot and resolve data quality, performance, and runtime issues
Participate in code reviews and follow SDLC and data governance standards
Required Skills
7+ years of strong hands-on experience in Ab Initio ETL development
Strong experience in data warehousing concepts and ETL architecture
Proficient in Unix/Linux shell scripting
Strong SQL skills (Oracle, Teradata, DB2, or similar)
Experience with complex data transformations, joins, aggregations, and partitioning
Understanding of performance tuning and parallel processing
Experience in batch processing and scheduling tools