Blue Cross and Blue Shield of Kansas CityData Modeler
Jan. 2020 - Feb. 2021Kansas City, Missouri, United States· Worked on defects, enhancements of preexisting SSIS ETL jobs
· Acted as a Scrum Master and Lead developer whenever needed for the team · Built basic power BI reports on User activity by using Azure data bricks as a source
· Used Alteryx to built basic debugging pipelines · Loading data from different sources, data visualization, data quality checking, using descriptive statistics and graphs like bar charts, histograms, pie charts. · Analyzed various jobs and source files using IBM DataStage Designer and performed various complex SQL queries and made changes as per the business requirement. · Worked with Codes and Data Mapping Application in performing the mapping changes and the transformation rule changes. · Worked with Data Architects in pushing in and verifying the models into Codes and Data Mapping Application in MS Access and worked with ETL Developers in forwarding the analysis and updating with the development work needed according to the business requirement. · Worked extensively using ETL Tools like Alteryx, PowerBI, Excel to connect the data exploration platform of data assets where data can be accessed, blended and cleaned from any source. · Served as cross-functional liaison for product direction, bug fixes, and enhancements using Visual Studio Team Foundation Server (TFS).
· Analyzing the source data to know the quality of data by using Talend Data Quality.
· Broad design, development and testing experience with Talend Integration Suite and knowledge in Performance Tuning of mappings.
· Developed jobs in Talend Enterprise edition from stage to source, intermediate, conversion and target. · Involved in writing SQL Queries and used joins to access data from Oracle, and MySQL.
· Developed a standard ETL framework to enable the reusability of similar logic across the board involved in System