Lead Ab Initio ETL Administrator

2 weeks ago


Reston, Virginia, United States Three Point Solutions Full time
Job Overview

Position Title: Ab Initio Administration Lead / Information Technology - Systems Engineer

Client Sector: Health Care Industry

Role Summary:

This position is focused on the administration of the Ab Initio ETL tool rather than development tasks. We are looking for an experienced Ab Initio Administrator with a strong background in the tool, along with familiarity in Cloudera and AWS environments, to enhance our IT team. The Lead Ab Initio ETL Administrator will oversee all administrative functions related to the ETL tool (Ab Initio) within a cloud infrastructure, while also engaging in hands-on tasks.

Key Responsibilities:

  • Lead the administration of the ETL tool, ensuring optimal performance and reliability.
  • Support the deployment of Data Integration and Data Warehouse solutions for various data products.
  • Guide and mentor junior staff members, providing expertise and support.
  • Collaborate with matrixed resources to achieve project goals.

Essential Qualifications:

  • Expertise in Administration: Extensive experience in managing relational databases (e.g., MySQL, PostgreSQL, MongoDB, RDS, DB2).
  • Big Data Proficiency: Knowledge of Cloudera Data Platform in both private and public cloud settings.
  • Automation Skills: Familiarity with automation tools such as Ansible, Terraform, and Bit Bucket.
  • AWS Cloud Experience: A minimum of 10 years working with AWS Cloud services.

Ab Initio Knowledge:

  • At least 10 years of experience in administering the ETL tool (Ab Initio).
  • Advanced understanding of the Ab Initio Graphical Development Environment (GDE), Metadata Hub, and Operational Console.
  • Experience in creating ETL pipelines from on-premises to cloud storage solutions.

Technical Skills:

  • Proficient in UNIX, Linux, Shell scripting, and SQL.
  • Experience in troubleshooting issues related to Hive, ICFF, and HDFS.
  • Management of metadata hub and operational console.
  • Expertise in scripting and automation for ETL processes.

Cloudera and AWS Services:

  • Strong knowledge of Cloudera administration (Hadoop, HDFS, YARN, Hive, Spark).
  • Hands-on experience with AWS services including EC2, S3, RDS, VPC, and IAM.

Additional Skills:

  • Familiarity with scripting languages such as Python and Shell.
  • Experience with CI/CD tools like Jenkins and GitLab CI.
  • Understanding of containerization technologies (Docker, Kubernetes) is advantageous.

DB2 Knowledge:

  • Demonstrated knowledge of DB2 database management.

Leadership and Collaboration:

  • Act as a representative in architectural and design discussions.
  • Provide subject matter expertise across various impacted areas.
  • Monitor and track project progress and tasks as the lead administrator.

This role requires a combination of technical acumen, practical experience, and leadership capabilities to ensure effective administration of ETL tools and support for data integration and warehouse initiatives.



  • Reston, Virginia, United States Three Point Solutions Full time

    Job OverviewPosition Title: Ab Initio Administration Lead / Information Technology - Systems EngineerIndustry: Health CareContract Duration: 6 MonthsLocation: RemoteRole Summary:This position is focused on the administration of the Ab Initio ETL tool rather than development tasks. We are looking for an experienced Ab Initio Administrator with a strong...


  • Reston, Virginia, United States INSPYR Solutions Full time

    Position: Lead ETL Administrator for Ab Initio Location: Remote/Hybrid Contract Type: 6 month contract to hire Salary: $80.00/hour - $90.00/hour Eligibility: US Citizens, Green Card Holders, or Authorized Workers in the U.S.We are in search of an experienced Lead ETL Administrator specializing in Ab Initio to join our innovative IT team. This role is pivotal...


  • Reston, Virginia, United States INSPYR Solutions Full time

    Position: Lead ETL Administrator for Ab InitioLocation: Remote/HybridContract Duration: 6 months with potential for permanent placementCompensation: $80.00/hour - $90.00/hourEligibility: US Citizens, Green Card Holders, or individuals authorized to work in the U.S.We are in search of a proficient Lead ETL Administrator specializing in Ab Initio, complemented...


  • Reston, Virginia, United States System One Full time

    Position Overview:We are seeking a Senior Ab Initio ETL Administrator to join our dynamic IT team. This role involves leading the administration of the ETL tool, Ab Initio, within a cloud environment. The ideal candidate will possess extensive experience in Ab Initio, alongside familiarity with Cloudera and AWS.Key Responsibilities:Oversee all aspects of ETL...


  • Reston, Virginia, United States nTech Workforce Full time

    Employment TermsContract-to-Hire, 6 MonthsThis role is hybrid, requiring flexibility for onsite attendance as necessary.Advance notice will be provided for any required onsite presence.Preferred candidates are located in specific states.Position OverviewnTech Workforce is in search of a seasoned Senior Ab Initio Systems Administrator to become a vital part...


  • Reston, Virginia, United States Three Point Solutions Full time

    Job OverviewPosition Title: Ab Initio Administration Lead / Information Technology - Systems EngineerIndustry: Health CareRole Summary:This position is designated for an Ab Initio Administration Lead, focusing on overseeing the administration of the ETL tool, Ab Initio, within a cloud environment. The ideal candidate will possess extensive experience in Ab...

  • Ab Initio Developer

    4 weeks ago


    Reston, Virginia, United States TEKsystems Full time

    Description:PURPOSE This is an Ab Initio Administration Lead position and not a developer position. We are seeking a highly skilled Ab Initio Admin with a robust in Ab Initio as well as with some experience with Cloudera and AWS to join our dynamic IT team. The Lead Ab Initio ETL Administrator is responsible for leading all the tasks involved in...


  • Reston, Virginia, United States nTech Workforce Full time

    Employment TermsContract-to-Hire, 6 MonthsThis position is considered hybrid. Candidates must be flexible and willing to come onsite as needed.Advanced notice will be provided for any required onsite presence.Candidates based in the surrounding regions are preferred.Position OverviewnTech Workforce is in search of a skilled Senior Ab Initio Systems...


  • Reston, Virginia, United States RIT Solutions, Inc. Full time

    Senior Ab Initio Systems AdministratorLocation- Hybrid - onsite as needed Duration- 6 Months CTH Interview Process- 2 round video interview Job OverviewProject Overview RIT Solutions, Inc. is seeking a Senior Ab Initio Systems Administrator to oversee all activities related to the management of Ab Initio in a Cloud environment, which includes essential...


  • Reston, Virginia, United States System One Full time

    Position Overview:We are seeking an experienced Cloudera Administrator with a strong leadership background to manage and enhance our big data infrastructure. This role requires a hands-on approach to oversee the deployment, maintenance, and scaling of cloud-based solutions tailored for data management.Key Responsibilities:Lead the orchestration and...

  • Accounting Manager

    5 days ago


    Reston, Virginia, United States VW Credit Full time

    Job SummaryThe Senior Accountant - Asset-Backed Securitization position leads structured finance activities for VW Credit's asset-backed securitization (ABS) programs in a team-oriented environment with emphasis on analysis, documentation, and compliance.Key ResponsibilitiesStructured Finance Leadership: Represents Structured Finance on the structuring team...

  • ETL Developer

    1 day ago


    Reston, Virginia, United States Luna Data Solutions, Inc. Full time

    About the RoleWe are seeking a highly skilled ETL Developer to join our team at Luna Data Solutions, Inc. as a long-term contract opportunity. The successful candidate will be responsible for designing and implementing complex ETL processes for dimensional data models using modern data platforms.Key ResponsibilitiesDevelopment & Design (40%)Create and...

  • ETL Developer

    4 weeks ago


    Reston, Virginia, United States Cleared Solutions Inc Full time

    Locations: Dulles Corridor; Reston, VAPosition Title: ETL DeveloperDescription: This role will support a DevSecOps program in an Agile SAFe environment and leverage standard and custom tools for Extract, Transform and Loading of data between databases for the customer. The role requires the development custom code/scripts to quickly extract, triage and...


  • Reston, Virginia, United States GSSR Inc Full time

    Job OverviewGSSR Inc is seeking a seasoned professional to lead its Cloudera infrastructure team. As a key member of our data platform, you will be responsible for configuring, troubleshooting, and installing infrastructure systems.Key ResponsibilitiesDesign and implement scalable Cloudera infrastructure solutionsLead a team of data administrators and...


  • Reston, Virginia, United States Commonwealth of Virginia Full time

    Department: College of Science Classification: Financial Services Specialist 2 Job Category: Classified Staff Job Type: Full-Time Work Schedule: Full-time (1.0 FTE, 40 hrs/wk) Location: Fairfax, VA Workplace Type: Hybrid Eligible Pay Band: 05 Salary: Salary commensurate with education and experience Criminal Background Check: Yes ...


  • Reston, Virginia, United States Commonwealth of Virginia Full time

    Department: College of Science Classification: Financial Services Specialist 2 Job Category: Classified Staff Job Type: Full-Time Work Schedule: Full-time (1.0 FTE, 40 hrs/wk) Location: Fairfax, VA Workplace Type: Hybrid Eligible Pay Band: 05 Salary: Salary commensurate with education and experience Criminal Background Check: Yes ...


  • Reston, Virginia, United States Commonwealth of Virginia Full time

    Department: College of Science Classification: Financial Services Specialist 2 Job Category: Classified Staff Job Type: Full-Time Work Schedule: Full-time (1.0 FTE, 40 hrs/wk) Location: Fairfax, VA Workplace Type: Hybrid Eligible Pay Band: 05 Salary: Salary commensurate with education and experience Criminal Background Check: Yes ...


  • Reston, Virginia, United States 00100 LEIDOS, INC. Full time

    Job SummaryWe are seeking a highly skilled Senior Database Architect to join our team at Leidos, Inc. (00100 LEIDOS, INC.). As a key member of our database engineering team, you will be responsible for designing, implementing, and maintaining high-performance database systems.Key ResponsibilitiesDatabase Design and Implementation: Design and implement...


  • Reston, Virginia, United States Grid Networks LLC Full time

    Job OverviewGRID Networks LLC is in search of a Lead Linux Systems Administrator who possesses a robust foundation in Linux management and prevalent open-source applications. The successful candidate will bring a minimum of 6 years of expertise in Linux system administration and will be expected to guide less experienced team members in areas such as system...


  • Reston, Virginia, United States Analytic Recruiting Inc. Full time

    A leading financial institution is seeking a Senior Data Engineer to develop ETL pipelines, data scripts, models, and queries.The role will involve collaboration with data scientists, enterprise architects, product owners, and functional leadership to implement solutions aligned with business initiatives.Compensation: Up to $140k baseWork Arrangement: Hybrid...