Job Description

Job Title: Abinitio Developer

Work Location: Charlotte, NC

Job Overview:

We are actively seeking an Abinitio Developer, to join our dynamic team! If you're passionate about growing your skills and working in an Abinitio environment, this opportunity might be perfect for you. As an Abinitio Developer, you will be responsible for overseeing and supporting existing production data pipelines created in Abinito, while also addressing complex technical issues within the organization. Key tasks include debugging and resolving daily production issues, collaborating across departments, and ensuring the quality and effectiveness of technical solutions.

Primary Responsibilities:

• Monitoring and Support: Oversee production data pipelines developed in Abinitio, identifying and resolving issues promptly.
• Issue Resolution: Analyze complex business requirements and debug production issues, ensuring jobs are rerun successfully after troubleshooting.
• Cross-functional Collaboration: Work closely with various teams across the organization to identify and resolve technical challenges.
• Design Feedback: Participate in and provide valuable insights during design reviews to improve project outcomes.
• Documentations: Complete detailed component design documentation for assigned projects.
• Coding and Development: Research, design and develop advanced components for Abinitio applications, ensuring quality and efficiency in the code.
• User Interaction: Engage with analysts and end users to gather information requirements and ensure user needs are met.
• Abinitio Graphs & Components: Develop and code Ab Initio graphs using ETL tools, ensuring alignment with user requirements.
• Performance Tuning: Optimize Ab Initio processes by maximizing the use of components and MFS file systems to reduce processing time.
• Data Manipulation: Build and execute queries to store, retrieve, and analyze data based on system requirements.
• Design Implementation: Apply design patterns in Ab Initio and create UNIX wrapper scripts to manage complex transformation logic.
• Testing & Documentation: Conduct unit testing, design, and create comprehensive documentation for the development process.
• Timely Delivery: Ensure all deliverables meet deadlines and maintain high standards of quality.
   

Key Qualifications:

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• Strong experience with Ab Initio development, including debugging, troubleshooting, and deployment architectures.
• Expertise in managing large data volumes and solid knowledge of data integration, batch processing, delta processing, and data capturing.
• Proficient in UNIX shell scripting and Python, with a deep understanding of Agile methodologies and frameworks.
• Demonstrated critical thinking and problem-solving skills, with the ability to work independently and within a team.
• Excellent communication skills to interact effectively with stakeholders and team members.
• Detail-oriented with a commitment to delivering high-quality work on time.
   

Requirements:

• Minimum of 1.5 years of hands-on experience building ETL applications and processes using SAS.
• Experience with Ab Initio and Hadoop technologies (HDFS, Hive, Impala, etc.).
• Solid understanding of ETL concepts and tools like Informatica, DataStage, and CloverETL.
• Proficient in working with relational databases such as Oracle, SQL Server, and PL/SQL.
• Familiarity with Agile methodologies and experience in various stages of the SDLC.
• Strong technical and functional documentation skills.
   

Soft Skills:

• Ability to work independently with minimal supervision.
• Strong communication and teamwork abilities.
• Analytical and problem-solving skills.
   

Bonus Qualifications:

• Experience with additional technologies like Java, J2EE, CTL-M, XML, PERL, Messaging, and Informatica is a plus.
• Hands-on experience with Ab Initio on Hadoop would be highly beneficial.