MAHESH BATHINA

5+ years of extensive work experience in ETL analysis, designing, developing, implementing ETL process in IBM Info Sphere Data stage & Quality stage 11.7 and 11.5 including performance tuning and ETL process streamlining. 3+ years of experience in IICS on Application Integration components like Processes, Service Connectors and process object etc. Technically experience on building ETL pipelines by constructing mappings, tasks, taskflows, schedules, and parameter files. Have good experience with ETL design, Development and implementation using Datastage and IICS with AWS Redshift and S3, Lambda functions, Oracle, Snowflake Databases in handling huge data workloads. Good working experience on Control-M workload scheduler for automating ETL end to end processes, including alert mechanism. Well versed knowledge in Data modeling. 3+ years of experience on data engineering with Snowflake along with python for data transformation. Hands on experience using Snowflake-specific features Snowpipe, Streams, Tasks. 2+ years of Extensive hands-on experience crafting data integration solutions with DBT and complementary data pipeline tools.

VEDA PDB integration, Data Engineering Consultant, GGK Tech (Innova), 05/01/24 to Present, IICS, DataStage 11.7, Snowflake, Control-M, S3, Python, This project is designed to achieve significant improvements in pharmacy operations and vendor relationships. By effectively integrating Vendors and pharmacy dashboard data, Centene Healthcare can make more informed decisions, improve the quality of care for its members, and optimize its pharmacy operations. ETL solutions those designed for performing analysis over identifying high-performing vendors and target improvement areas. To achieve enhanced pharmacy care delivery this dashboard data integration with vendor enhancement data is necessary. Optimizing drug utilization and avoiding medication errors in future based on the historic data of both sources used. CSX Reporting, Data Engineering Consultant, Virtusa, 02/01/22 to 03/31/24, DataStage 11.7, IICS, EC2, AWS-Redshift, S3, Python, DBT, CSX Reporting is an ETL solution that designed for performing analysis over the data of insurance service request/claim/enquiry details. This majorly involves the customer request handling and resolution status and timeframes of various transactional data. Based on the Priority of the business users reports will be generated from downstream systems. Code migration from Datastage to IICS happened majorly as part of this project and also new developments and enhancements. Datastage integrations with the AWS cloud from EC2 environment. VAT-SOFY-REPORTING, Data Engineering Specialist, HSBC, Capgemini, 09/01/19 to 02/28/22, DataStage 11.5, Oracle 11g, Linux, Control-M, IICS, The VAT/GST is the solution for the extraction, transmission and loading of finance data to Sofy application provided by third party vendor. The Sofy application has been on-boarded to assist the global VAT/GST teams with data cleansing and analysis on finance data, via the Data Analytics module. Sofy also provides functionality to allow users to prepare and submit VAT/GST returns to Tax Authorities, via the Compliance and Reporting module. Submission of the VAT/GST returns is done via an API built within the C&R module. M-Power, ETL Developer, IBM, Future Focus Infotech Pvt Ltd, 02/01/16 to 03/31/19, DataStage 11.3, Oracle 11g, Unix, M-Power is a BI-application developed to provide retailer/site wise KPIs to suffice data fulfilment for decision making process of business. Most of the KPIs are part of KPI pool of RED (Revenue, E-Acquisition, Distribution). This application helps business users to track the performance of Retailer/Distributor/Cellsite. This application gives information about every retailer/Distributor/Cellsite/Site and their KPI values based on latency day/week/month wise.