Fulltime position for Abinitio Developer Location: Cincinnati, OH

Job Description

Job Description

Position : Abinitio Developer

Location : Cincinnati, OH

Duration : Fulltime / Permanent

Job Description

Technical / Functional Skills Languages : SQL, Unix Shell

Tools : Ab Initio software suite Co>

Op, EME, BRE, Conduct>

It, Express>

It, Metadata>

Hub, Query>

it, Control>

Center

Ab Initio frameworks Acquire>

It, DQA, Spec-To-Graph, Testing Framework

Databases : Db2, Oracle, MySQL, Teradata, and MongoDB

Big Data : Cloudera Hadoop, Hive

Dev Methodologies : Agile, Waterfall

Others : JIRA, Service Now, Linux 6 / 7 / 8, SQL Developer, AutoSys, and Microsoft Office

Experience Required Same as Relevant experience

Roles & Responsibilities

• Total of 7+ Years of IT Experience predominantly in Data Integration / Data Warehouse area
• Must have 6+ years of ETL Design and Development experience using Ab Initio
• 2+ years of Data Integration project experience on Hadoop Platform, preferably Cloudera
• Experience in Ab Initio EME, GDE, parallelism techniques, Graphs using Data, Pipeline & Component parallelism.
• Ability to design and build Ab Initio graphs (both continuous & batch) and Conduct>

it Plans, and integrate with portfolio of Ab Initio softwares.

• Complete understanding and analytical ability of Metadata Hub metamodel.
• Build graphs interfacing with heterogeneous data sources Oracle, Snowflake, Hadoop, Hive, AWS S3.
• Parse XML, JSON & YAML documents including hierarchical models.
• Build and implement data acquisition and transformation / curation requirements in a data lake or warehouse environment and demonstrate experience in leveraging various Ab Initio components.
• Build Control Center Jobs and Schedules for process orchestration.
• Build BRE rulesets for reformat, rollup & validation use cases.
• Ability to identify performance bottlenecks in graphs and optimize them.
• Rigor in high code quality, automated testing, and other engineering best practices, ability to write reusable code components.
• Ability to unit test the code thoroughly and to troubleshoot issues in production environments.
• Code management and development for Extract, Transform, & Load (ETL) routines using Ab Initio.
• Ensure Ab Initio code base is appropriately engineered to maintain current functionality and development that adheres to performance optimization, interoperability standards and requirements, and compliance with client IT governance policies.
• Build automation pipelines for Continuous Integration & Delivery (CI-CD), leveraging Testing Framework & JUnit modules, integrating with Jenkins, JIRA and / or ServiceNow.
• Successful project implementation of Ab Initio CDC (Change Data Capture) in a Data Integration / ETL project
• Demonstrable experience with Ab Initio components such as Rollup, Scan, join Partition by Key, Partition by Round Robin, Gather, Merge, Interleave, Lookup, and others.
• Excellent SQL, UNIX shell scripting, and performance tuning skills.
• Technical experience in design (mapping specifications, HLD, LLD), development (coding, unit testing) using Ab Initio.
• Some Java development experience is nice to have.
• Knowledge of Agile / Waterfall Development practices is required.
• Must be able to work independently and support other junior developers as needed.
• Keep abreast of Ab Initio best practices and new features to continuously improve development processes.

Desired Candidate Profile

Qualifications : BACHELOR OF COMPUTER SCIENCE