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
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 software.
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.
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.