Amrita Srivastava

Data Engineer

Santa Clara, California, United States16 yrs 11 mos experience

Highly Stable

Key Highlights

11 years of experience in Data Engineering.
Expert in building data pipelines and ETL solutions.
Proficient in multiple cloud platforms including GCP and AWS.

Stackforce AI infers this person is a Data Engineer with expertise in Business Intelligence and Cloud Solutions.

Contact

Skills

Core Skills

Data EngineeringBusiness Intelligence

Other Skills

Agile MethodologiesAmazon Web Services (AWS)Apache SqoopArcGISBigQueryBusiness AnalysisCloud FunctionsCloud StorageCrystal ReportsDashboard DevelopmentData AnalysisData AnalyticsData WarehousingDatabasesDjango REST Framework

About

I have 11 years of experience working on Palantir, SQL, Python, Django REST, PowerBI reports, GCP, AWS, Azure, SSIS and SSRS. As a Data Engineer, I am working at PGE to build data pipelines and develop solutions that help optimize data ingestion from ArcGIS and SQL Server to Foundry. I have been involved in full lifecycle of database/data warehouse development, database migration, reports development. My work has inspired me to be passionate about data and find solutions to data related problems.

Experience

16 yrs 11 mos

Total Experience

3 yrs 6 mos

Average Tenure

2 yrs 8 mos

Current Experience

Epik solutions

Senior Data Engineer

Oct 2023 – Present · 2 yrs 8 mos · San Ramon, CA · Hybrid

As a Data Engineer, I am working at PGE to build data pipelines and develop solutions that help optimize data ingestion from ArcGIS and SQL Server to Foundry.

PalantirSQL ServerArcGISData Engineering

Cloudopty

Data Engineer

Mar 2023 – Sep 2023 · 6 mos · Fremont, California, United States · Remote

As a Data Engineer, I design and develop ETL and ELT solutions to ingest data to GCP. I develop Rest APIs using Python which talk to the frontend application, that provides GCP and AWS cloud optimization to the users. I am working on enhancing cloud optimization for clients by analyzing billing in GCP and AWS using Python, Cloud Functions, BigQuery and Cloud Storage.

ETLGCPPythonCloud FunctionsBigQueryCloud Storage+1

Career break

Caregiving

Jul 2016 – Feb 2022 · 5 yrs 7 mos · Santa Clara, California

Eurofins it solutions india pvt. ltd

Business Intelligence Developer

Aug 2014 – Jun 2016 · 1 yr 10 mos · Bangalore · On-site

As part of EOL Database and Business Intelligence team, I:
Designed, developed, and deployed SSIS ETL packages for data pipeline projects like migration, full/incremental load of data from multiple sources like flat files, excel files and databases.
Collaborated with business users and developed PowerBI reports
Wrote SQL scripts for database objects like Stored procedures, Triggers, Tables, Views and Functions.
Collaborated with production support team to resolve database related issues.
Key Projects
Custom Dashboard Reports – Developed on demand PowerBI and Excel reports.
Database Cleaning and Correction – Wrote SQL scripts for Tables to delete, update data.
Data Copy ETLs and Account module migration – Developed SSIS ETLs to load data.

SSISPowerBISQLBusiness Intelligence

Accenture

Analyst Programmer

Apr 2008 – Aug 2014 · 6 yrs 4 mos · Bangalore · On-site

As part of the Business Intelligence team in various projects during my tenure in Accenture, I:
Collaborated with architects, business users to work on small to large databases by writing SQL scripts for database objects.
Developed and deployed SSRS/Excel/Crystal Reports and created subscriptions for business users.
Developed SSIS ETL packages to load data from multiple sources into the data marts and data warehouses.
Key Projects
Biz-Ops Reporting – Developed SSRS reports displaying monthly and fortnightly financial information exported to excel. The data was loaded from multiple sources like excel and financial data warehouse using SSIS.
EPSI Vidant Health, North Carolina – Developed Crystal reports for providers in EPIC Clarity module.
Cost to Serve – Developed dashboard to view financial reports based on roles in the division.
Workforce Analytics - Developed dashboard for HR Analytics team to view reports.