ETL Architect with Ab Initio Experience in Plano, TX or Wilmington, DE (Onsite)

Activesoft - Plano, TX

Full-time - Senior

Plano, TX

About the position

The ETL Architect position focuses on leveraging Ab Initio to design and implement robust ETL solutions. The ideal candidate will possess a thorough understanding of ETL architecture and will be capable of independently providing designs and solutions. This role requires extensive experience with various Ab Initio program components, including Reformat, Rollup, Scan, Join, and Partition techniques. The candidate should also be familiar with parallelism techniques in Ab Initio, utilizing Data and Pipeline Component parallelisms effectively. In addition to Ab Initio expertise, the role demands a working knowledge of the Big Data ecosystem, particularly Hadoop and HDFS commands. The architect will work with heterogeneous datasets, integrating various file types such as Hadoop files, XLS, XML, and COBOL with source systems through secure transfer methods like SFTP and MFTS. Proficiency in SQL/PL SQL and Unix shell scripting is essential, along with familiarity with Ab Initio air commands and the Operation Console. The position also requires a solid understanding of data warehousing concepts and strong analytical skills. The candidate should have experience with tools like Plans, Conduct IT, Query IT, and MHUB, and must demonstrate excellent problem-solving abilities to analyze issues and provide resolutions. Participation in Agile methodologies, including Scrum calls and handovers, is expected, as well as the ability to support an onshore-offshore model. Knowledge of cloud technologies, particularly AWS services such as EKS, Athena, and S3, is preferred, especially in relation to integration with Ab Initio. Familiarity with DevOps tools like GitHub, Bitbucket, and Ansible, as well as scheduling tools such as Control M, Autosys, and Tivoli, is also beneficial. The candidate should have experience managing migration projects from end to end and a willingness to learn and adapt to new technologies beyond ETL. Leadership skills are crucial, as the architect will be responsible for managing a team and interacting with end users and clients. Proficiency in creating documentation related to project architecture, end-user manuals, and operations handoff guides is required. A good understanding of quality processes and strong verbal and written communication skills are also essential for success in this role.

Responsibilities

• Design and implement ETL solutions using Ab Initio.
• Provide independent designs and solutions in ETL architecture.
• Work with various Ab Initio program components such as Reformat, Rollup, Scan, Join, and Partition techniques.
• Utilize Ab Initio parallelism techniques effectively in ETL processes.
• Integrate heterogeneous datasets with source systems via secure transfer methods.
• Develop and execute SQL/PL SQL queries and Unix shell scripts.
• Manage and utilize Ab Initio air commands and Operation Console.
• Participate in Agile methodologies and attend Scrum calls.
• Support onshore-offshore model for project execution.
• Lead and manage a team while interacting with end users and clients.
• Create documentation related to project architecture and operations handoff.

Requirements

• 8+ years of experience in ETL architecture and design.
• Thorough understanding of Ab Initio program components and parallelism techniques.
• Working knowledge of Big Data and Hadoop ecosystem.
• Experience with heterogeneous datasets and secure integration methods.
• Proficiency in SQL/PL SQL and Unix shell scripting.
• Familiarity with Ab Initio air commands and Operation Console.
• Strong knowledge of data warehousing concepts and analytical skills.
• Experience with Agile methodologies and Scrum participation.
• Ability to manage migration projects end to end.
• Leadership skills to manage teams and client interactions.

Nice-to-haves

• Experience with cloud technologies, particularly AWS services.
• Familiarity with DevOps tools like GitHub, Bitbucket, and Ansible.
• Experience with scheduling tools such as Control M, Autosys, and Tivoli.
• Knowledge of Ab Initio BRE Business Rule Environment or ACE Application.