Ab Initio Technical Lead
Apply NowCompany: Tata Consultancy Services
Location: Milford, OH 45150
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.
Generic Managerial Skills, If any
Good Writte n and Communication skills
Salary Range: $100,000-$140,000 a year
TCS Employee Benefits Summary:
Discretionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Maternal & Parental Leaves.
Insurance Options: Auto & Home Insurance, Identity Theft Protection.
Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
#LI-SP1
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.
Generic Managerial Skills, If any
Good Writte n and Communication skills
Salary Range: $100,000-$140,000 a year
TCS Employee Benefits Summary:
Discretionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Maternal & Parental Leaves.
Insurance Options: Auto & Home Insurance, Identity Theft Protection.
Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
#LI-SP1