Smita Khilari

About Smita Khilari

IT professional with 17+ yrs years of extensive experience in project design, architecture, development and testing of various sized applications using Data Engineering, Datawarehousing technologies Abinitio ETL Tool under AIX UNIX, Linux, Windows environments and Data Governance using Collibra BPMN tool, Data Integration with Mulesoft, Databases like Oracle, Teradata, Microsoft SQL Server, Hive, Postgres, Mongo DB, Hadoop BigData Technologies etc.• Extensive experience with development in complex and high volume Abinitio ETL applications including requirement gathering, design, implementation, unit testing, debugging, documentation under Unix Environment. Good experience in leadership as well. Excellent Data warehousing technical skill set with robust knowledge of DWH architecture.• Hands on experience on PDL metaprogramming, XML data processing, generic graph implementation, advanced Abinitio components, psets, plans and Abinitio product tools like Abinitio GDE, Conduct>IT, Cooperating system, Abinitio operational console, EME Technical Repository, metadata hub, Data Profiler, Control Center, Express>IT, BRE etc.• Strong experience in both waterfall as well as agile methodology.• Experience in requirement gathering, impact analysis, data cleansing, data transformations, data relationships, source systems analysis.• Working experience in design & development of Collibra governance workflows using BPMN Flowable/Activiti.• Strong working experience in RDBMS development using Oracle, Teradata and MS SQL Server and large scale database management including building and tuning complex SQL queries. Good understanding of Teradata Architecture and load utilities.• Good exposure to UNIX shell scripting, commands, problem solving and analytical capabilities.• Good experience in various kinds of testing like Unit testing, Regression testing, and System integration testing, Manual testing including preparation of test plan, creation of test cases, test case documents, test data creation.• Excellent understanding of the SDLC, PMLC. • Extensive knowledge and experience of Banking and Financial, Retail, Healthcare Domain applications.• Excellent communication, interpersonal skills and strong ability to work as part of a team and as well as handle independent roles with positive attitude towards responsibilities and challenges.

Experience

1. Software Development Engineering- Advisor i

   Fiserv

   Feb 2024 — Present · US

Education

• Savitribai Phule Pune University

  Bachelor of Engineering (B.E.), Computer Engineering

  2002 — 2006

Skills

• Unix
• Data Modeling
• Mainframe
• Unix Shell Scripting
• Sql
• Databases
• Oracle
• Requirements Analysis
• Pl/Sql
• Teradata
• Etl
• Ab Initio
• Requirements Gathering
• Extract, Transform, Load (Etl)
• Data Warehousing
• Data Integration
• Microsoft Sql Server
• Sdlc
• Shell Scripting
• Business Intelligence
• Software Development Life Cycle (Sdlc)
• Agile Methodologies