Ab Initio Lead ETL Developer on W2
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for an Ab Initio Lead ETL Developer on W2, remote, requiring 10+ years in data warehousing with Ab Initio. Key skills include UNIX, DB2, ETL processes, and leadership. Bachelor’s degree required; master's preferred.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
-
🗓️ - Date discovered
August 20, 2025
🕒 - Project duration
Unknown
-
🏝️ - Location type
Remote
-
📄 - Contract type
W2 Contractor
-
🔒 - Security clearance
Unknown
-
📍 - Location detailed
Norfolk, VA
-
🧠 - Skills detailed
#"ETL (Extract #Transform #Load)" #Security #Web Services #Data Engineering #Computer Science #Tableau #UAT (User Acceptance Testing) #Ab Initio #Leadership #Databases #Data Management #Unix #Documentation #BI (Business Intelligence) #Quality Assurance #Metadata
Role description
Role: Ab Initio Lead ETL Developer on W2
Location Remote
10+ years' experience working in data warehousing environment using Ab Initio suite
On W2
ANY Visa Okay
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
• Only W2 No C2C Entertained
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
• Responsibilities:
As an Ab Initio ETL Senior Developer, you will:
• Data Management: Oversee the extraction, transformation, and loading (ETL) processes for data warehousing.
• Component Design: Design and integrate ETL components while addressing and resolving data-related issues, collaborating closely with project leads.
• Technical Expertise: Utilize experience with ETL tools in a DB2 environment to support and enhance ETL processes.
• Code Development: Implement and develop efficient Ab Initio code by performing source and target analysis.
• Application Development: Contribute to the development and optimization of the ETL application, ensuring it meets business requirements.
• Testing and Quality Assurance: Create and execute comprehensive system and integration test plans to validate the ETL application.
• Specification Documentation: Develop detailed ETL specifications based on business needs to guide implementation.
• Collaboration: Assist in the overall design of the ETL application and actively participate in all project meetings to ensure alignment and progress.
Requirements:
Technical Skills:
• Strong knowledge of UNIX systems.
• High proficiency in the Ab Initio Graphical Development Environment (GDE).
• Hands on experience with Ab Initio Meta Data Hub (MDH).
• Experience with Ab Initio EME (Enterprise Meta>Data Environment) and Control Center.
• Basic understanding of developing web services using Ab Initio Continuous Flows.
• Knowledge of Control-M Scheduler.
• Strong knowledge with additional Ab Initio tools, such as Query>IT, MDH, and BRE.
• Understanding of the Software Development Life Cycle (SDLC).
• Ability to create high-level and detailed designs represented as flow diagrams (preferably using Visio).
• Capability to translate business requirements into functional and technical specifications.
• Ability to breakdown complex issues into manageable components and designing solutions.
• Experience in designing end-to-end data warehousing and reporting solutions utilizing databases, ETL tools, and reporting frameworks.
• Ability to provide time estimates for development tasks based on design specifications.
• Experience collaborating with Production Validation (PV) and User Acceptance Testing (UAT) teams.
• Proficient in conducting detailed system impact analyses for change requests and providing accurate estimates.
• Leadership skills to mentor junior developers and provide feedback across multiple projects.
Soft Skills:
• Strong analytical and problem-solving abilities.
• Excellent written and verbal communication skills.
• Strong Technical design and facilitation skills with driving technical solutions while working with Business and IT leadership.
• Exceptional written and verbal communication skills.
• Effective documentation skills.
• Proficient in English for communication purposes.
• Open and honest communication with peers and management regarding estimations and project timelines, including proactive updates on issues and concerns.
• Assertiveness in presenting ideas, estimates, project scope, and timelines.
Preferred Qualifications:
• Experience with DB2 and Postgres databases.
• Familiarity with handling PHI (Protected Health Information) and PII (Personally Identifiable Information) and sensitive data.
• 10+ years' experience working in data warehousing environment using Ab Initio suite.
• Knowledge of business intelligence and analytics tools such as Cognos or Tableau.
• In-depth knowledge of the U.S. healthcare system, including medical and prescription claims processing, healthcare enrollments, and provider operations.
• Awareness of security standards in data handling.
Qualifications:
• Preferred: master's degree in computer science or a related field.
• Required: bachelor's degree in computer science or a related field.
This role is ideal for a proactive and detail-oriented individual who can lead a technical team to deliver high-quality solutions in a dynamic and fast-paced environment. If you are passionate about data engineering and have a strong technical background, we would love to hear from you!
Role: Ab Initio Lead ETL Developer on W2
Location Remote
10+ years' experience working in data warehousing environment using Ab Initio suite
On W2
ANY Visa Okay
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
• Only W2 No C2C Entertained
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
• Responsibilities:
As an Ab Initio ETL Senior Developer, you will:
• Data Management: Oversee the extraction, transformation, and loading (ETL) processes for data warehousing.
• Component Design: Design and integrate ETL components while addressing and resolving data-related issues, collaborating closely with project leads.
• Technical Expertise: Utilize experience with ETL tools in a DB2 environment to support and enhance ETL processes.
• Code Development: Implement and develop efficient Ab Initio code by performing source and target analysis.
• Application Development: Contribute to the development and optimization of the ETL application, ensuring it meets business requirements.
• Testing and Quality Assurance: Create and execute comprehensive system and integration test plans to validate the ETL application.
• Specification Documentation: Develop detailed ETL specifications based on business needs to guide implementation.
• Collaboration: Assist in the overall design of the ETL application and actively participate in all project meetings to ensure alignment and progress.
Requirements:
Technical Skills:
• Strong knowledge of UNIX systems.
• High proficiency in the Ab Initio Graphical Development Environment (GDE).
• Hands on experience with Ab Initio Meta Data Hub (MDH).
• Experience with Ab Initio EME (Enterprise Meta>Data Environment) and Control Center.
• Basic understanding of developing web services using Ab Initio Continuous Flows.
• Knowledge of Control-M Scheduler.
• Strong knowledge with additional Ab Initio tools, such as Query>IT, MDH, and BRE.
• Understanding of the Software Development Life Cycle (SDLC).
• Ability to create high-level and detailed designs represented as flow diagrams (preferably using Visio).
• Capability to translate business requirements into functional and technical specifications.
• Ability to breakdown complex issues into manageable components and designing solutions.
• Experience in designing end-to-end data warehousing and reporting solutions utilizing databases, ETL tools, and reporting frameworks.
• Ability to provide time estimates for development tasks based on design specifications.
• Experience collaborating with Production Validation (PV) and User Acceptance Testing (UAT) teams.
• Proficient in conducting detailed system impact analyses for change requests and providing accurate estimates.
• Leadership skills to mentor junior developers and provide feedback across multiple projects.
Soft Skills:
• Strong analytical and problem-solving abilities.
• Excellent written and verbal communication skills.
• Strong Technical design and facilitation skills with driving technical solutions while working with Business and IT leadership.
• Exceptional written and verbal communication skills.
• Effective documentation skills.
• Proficient in English for communication purposes.
• Open and honest communication with peers and management regarding estimations and project timelines, including proactive updates on issues and concerns.
• Assertiveness in presenting ideas, estimates, project scope, and timelines.
Preferred Qualifications:
• Experience with DB2 and Postgres databases.
• Familiarity with handling PHI (Protected Health Information) and PII (Personally Identifiable Information) and sensitive data.
• 10+ years' experience working in data warehousing environment using Ab Initio suite.
• Knowledge of business intelligence and analytics tools such as Cognos or Tableau.
• In-depth knowledge of the U.S. healthcare system, including medical and prescription claims processing, healthcare enrollments, and provider operations.
• Awareness of security standards in data handling.
Qualifications:
• Preferred: master's degree in computer science or a related field.
• Required: bachelor's degree in computer science or a related field.
This role is ideal for a proactive and detail-oriented individual who can lead a technical team to deliver high-quality solutions in a dynamic and fast-paced environment. If you are passionate about data engineering and have a strong technical background, we would love to hear from you!
