<p>Must Have Technical/Functional Skills</p> <p>Languages: SQL, Unix Shell</p> <p>Tools: Ab Initio software suite - Co>Op, EME, BRE, Conduct>It, Express>It, Metadata>Hub, Query>it, Control>Center</p> <p>Ab Initio frameworks - Acquire>It, DQA, Spec-To-Graph, Testing Framework</p> <p>Databases: Db2, Oracle, MySQL, Teradata</p> <p>Dev Methodologies: Agile, Waterfall</p> <p>Others: JIRA, Service Now, Linux 6/7/8, SQL Developer, AutoSys, and Microsoft Office</p> <p>Roles & Responsibilities</p> <ul> <li>Experience in Ab Initio EME, GDE, parallelism techniques, Graphs using Data, Pipeline & Component parallelism. </li><li>Ability to design and build Ab Initio graphs and Conduct>it Plans, and integrate with portfolio of Ab Initio </li><li>Complete understanding and analytical ability of Metadata Hub metamodel. </li><li>Build graphs interfacing with heterogeneous data sources - Oracle, Snowflake, Hadoop, Hive, AWS S3. </li><li>Parse XML, JSON & YAML documents including hierarchical models. </li><li>Build and implement data acquisition and transformation/curation requirements in a data lake or </li></ul> <p>warehouse environment and demonstrate experience in leveraging various Ab Initio components.</p> <ul> <li>Build Control Center Jobs and Schedules for process orchestration. </li><li>Build BRE rulesets for reformat, rollup & validation use cases. </li><li>Ability to identify performance bottlenecks in graphs and optimize them. </li><li>Rigor in high code quality, automated testing, and other engineering best practices, ability to write reusable </li></ul> <p>code components.</p> <ul> <li>Ability to unit test the code thoroughly and to troubleshoot issues in production environments. </li><li>Code management and development for Extract, Transform, & Load (ETL) routines using Ab Initio. </li><li>Ensure Ab Initio code base is appropriately engineered to maintain current functionality and development that </li></ul> <p>adheres to performance optimization, interoperability standards and requirements, and compliance with</p> <p>client IT governance policies.</p> <ul> <li>Build automation pipelines for Continuous Integration & Delivery (CI-CD), leveraging Testing Framework & Junit </li></ul> <p>modules, integrating with Jenkins, JIRA and/or ServiceNow.</p> <ul> <li>Successful project implementation of Ab Initio CDC (Change Data Capture) in a Data Integration/ETL project </li><li>Demonstrable experience with Ab Initio components such as Rollup, Scan, join Partition by Key, </li></ul> <p>Partition by Round Robin, Gather, Merge, Interleave, Lookup, and others.</p> <ul> <li>Excellent SQL, UNIX shell scripting, and performance tuning skills. </li><li>Technical experience in design (mapping specifications, HLD, LLD), development using Ab Initio. </li></ul> <p>Generic Managerial Skills, If any</p> <p>Good Writte n and Communication skills</p> <p>Salary Range: $100,000-$140,000 a year</p> <p>TCS Employee Benefits Summary:</p> <p>Discretionary Annual Incentive.</p> <p>Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.</p> <p>Family Support: Maternal & Parental Leaves.</p> <p>Insurance Options: Auto & Home Insurance, Identity Theft Protection.</p> <p>Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.</p> <p>Time Off: Vacation, Time Off, Sick Leave & Holidays.</p> <p>Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.</p> <p>#LI-SP1</p>