JITENDRA SUTAR

As part of data analytics team, created robust framework which will ingest data through data pipelines using (DATAFLOW AND PYSPARK) from various sources and populate the data to Google Cloud Storage. Created serverless function using CLOUD FUNCTION to ingest business file for various regions across the GLOBE. Created framework for collecting power and sensor data from HIVE and load to GCS storage which will run as a pipeline based on different batches.

To provide the reliable data based on the different region, provided solutions to create or stop VM as per timezones on which DataScience team can run their models for the prediction of upcoming customer, workforce based on the matrices provided by different sources.

The information factory is an existing Cigna asset used to integrate business data from different sources of truth and consistent information from a common platform. Information factory converts data from BDRS and other sources into consumable information. CIF enables consistent and stable accesses to data across all channels both internal & external. Created high level design for HEALTHCARE ID CARD GENERATION DATAFLOW to create the mappings through Informatica Power Center tools - Source Analyzer, Target designer, Mapping & Mapplet Designer and Transformation Designer. Perform thorough end to end unit testing of the functionality and solved the defect during system. The asset used to integrate 9 yrs of business data (through INCREMENTAL) from different ORACLE sources to HADOOP system. Correlate the business to technical aspect and come up with high level design to match with HADOOP environment. Parsing data through high-level design framework extract data from existing ORACLE ecosystem to HADOOP using frameworks such as HIVE, HDFS, SQOOP. Creation of HIVE and HBASE tables to extract and load data into ORACLE for easy extraction on user end. Extraction of data through different PIG queries and automation of jobs done by OOZIE.