Ab Initio Developer & Tech Lead at Tata Consultancy Services in Milford, Ohio

Job Description:

Role :Ab Initio Developer & Tech Lead

Location: Milford, OH , USA(Onsite)

Job Type: Full Time

Job Description:

Must Have 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

Dev Methodologies: Agile, Waterfall

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

Roles & Responsibilities:

• Experience in Ab Initio EME, GDE, parallelism techniques, Graphs using Data, Pipeline & Component parallelism.
• Ability to design and build Ab Initio graphs and Conduct>it Plans, and integrate with portfolio of Ab Initio
• 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 using Ab Initio.

Apply Now