Tata Consultancy Services
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 Written and Communication skills
Salary Range: $100,000 - $130,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 & amp; 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
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 Written and Communication skills
Salary Range: $100,000 - $130,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 & amp; 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