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