• Bulk loading from the external stage (AWS S3), internal stage to snowflake cloud using the COPY command.• Loading data into snowflake tables from the internal stage using snowsql.• Used import and Export from the internal stage (snowflake) from the external stage (AWS S3).• Writing complex snowsql scripts in snowflake cloud data warehouse to business analysis and reporting.• Used SNOW PIPE for continuous data ingestion from the S3 bucket.• Developed snowflake procedures for executing branching and looping• Performed data quality issue analysis using Snow SQL by building analytical warehouses on Snowflake• Experience with AWS cloud services: EC2,RDS.• Perform troubleshooting analysis and resolution of critical issues• Creating and managing triggers, indexes and constraints on database.• Reporting from different and remote location/Platforms.• Creating and managing stored procedures using T-SQL.• Writing Database Procedures, Functions, Tuning Database Queries.• Query Optimization for different new or existing module using Query-Execution Plans, Index Utilization.• Designing, testing, installing and monitoring new solution.

• Design, build, testing and maintenance of data integration / ETL processes.• SQL Server performance tuning, execution plans, and indexing.• Writes and executes scripts to create or modify tables, triggers, constraints, functions and procedures.• Designed SSIS Packages to extract data from various heterogeneous data sources such as Excel spreadsheet and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS.• Participate in the development of processes and procedures for the implementation project.• Active involvement in data gathering and processes study along with functional team.

• Automation of data extractions for exiting clients using Talend Open Studio.• Good Knowledge about US Healthcare. Experience on the Healthcare processes/workflows and interface integrations. Knowledge on US Healthcare Standards (ICD 9/10, HIPAA, & HL7). • Knowledge of industry best practices for ETL and the common approaches to data warehouse architectures • Created ETL jobs on Talend open Studio(Data preparation, data integration, application integration, data management and big data)• Worked on LAB (orders & results), ADT, SIU and DFT interfaces issues and developed/updated source code in mirth interface engine based on requirements. • Worked on troubleshooting / testing of the interfaces issues. Worked On the Mirth Connect Integration Engine.