1. Analyze the source data, Data modelling and designing solutions for data flow, Provide Source to Target mappings and act as SME to the technical team in ETL development and end to end testing.2.Responsible in data governance and Data Quality using Collibra.3. Identify current production issues and help resolve them.

Summary:Senior Software Engineer with 6 years of experience in SQL development, Data Analysis and ETL development. Have worked on Data Integration and migration projects along with management of Advanced Database System. Have strong expertise in various domains like General Insurance, Cyber Security Insurance, Transportation and Health care. Have hands on experience in data reporting tools which helped in robust data analytics. Have sound knowledge in Big data concepts and AWS tools. Great communication skills to handle communications between various teams. Good team player with excellent communications skills to articulate information between various teams.Responsibilities:•Collaborated with various teams to prepare source to target mapping document and design target data models to integrate multiple data sources.•Designed and developed ETL processes using IBM Infosphere DataStage.•Implemented complex store procedures, triggers using SQL/TSQL.•Performed Data analysis on real time insurance data using DB2 and Snowflake and generated reports using Power BI, which helped the stake holders in decision making and cost management.•Implemented multiple schemas on the same database to enable parallel development in contrary to having multiple databases supporting Agile development cycle.•Involved in integration and system testing before deploying the application to higher environments.•Improved the performance of the application by tuning stored procedures using Dynatrace tool.

Summary: Senior Software Engineer with about 3 years of experience as Data analyst and ETL testing, with expertise in Transport and Health care domains. Received outstanding contribution Employee awards for two quarters successively.Responsibilities:•Performed ETL operations on health insurance claims data using Ab Initio by adhering to HIPAA rules.•Involved in Database design and development for Australia’s major transportation ticketing system.•Developed complex SQL scripts on Teradata, SSIS packages to migrate data from source to Enterprise Data Warehouse. •Developed SSRS reports for real time transportation data, which helped business to analyze and design innovative techniques in ticketing system.