Sravan Kumar Gopathi
Charlotte,NC
Summary
Hardworking and passionate job seeker with strong organizational skills eager to secure entry-level position. Ready to help team achieve company goals. To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
1
1
year of professional experience
2
2
years of post-secondary education
Work History
Data Engineer
It Resources
Charlotte, NC
09.2022 - Current
- Generated detailed studies on potential third-party data handling solutions, verifying compliance with internal needs and stakeholder requirements.
- Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Monitored incoming data analytics requests and distributed results to support strategies.
- Designed and implemented SharePoint data extraction processes using Office365-REST-Python-Client library.
- Extracted data from SharePoint lists using SharePoint API, considering authentication and authorization requirements.
- Applied data transformation techniques to process SharePoint data retrieved, ensuring it conforms to required format.
- Developed Python scripts to load transformed data into SQL databases for further analysis.
- Automated routine SharePoint tasks using Python scripts, improving efficiency and reducing manual intervention.
- Implemented scheduled jobs for automatic data extraction and synchronization between SharePoint and other data sources.
- Managed SharePoint lists and libraries, ensuring data consistency and integrity.
- Created and maintained SharePoint views to facilitate efficient data retrieval.
- Implemented user authentication and authorization mechanisms for SharePoint API access.
- Ensured secure access to SharePoint data while adhering to organizational security policies.
- Designed end-to-end ETL processes for extracting data from diverse sources, transforming it according to business rules, and loading it into data warehouses.
- Conducted data profiling to identify and address data quality issues, ensuring that ETL pipeline produces accurate and reliable results.
- Implemented cleaning mechanisms to handle missing or inconsistent data during extraction phase.
- Implemented incremental loading strategies to optimize ETL performance, reducing processing time and resource utilization.
- Utilized CDC (Change Data Capture) mechanisms to identify and process only changed data.
- Implemented partitioning strategies to enhance ETL performance, distributing data processing tasks across multiple nodes.
- Utilized parallel processing techniques to achieve efficient data transformation and loading.
- Implemented SCD Type 2 techniques for tracking historical changes in dimension tables.
- Managed slowly changing dimensions to maintain comprehensive historical record of data changes.
- Contributed to design and development of data warehousing solutions, ensuring that ETL processes align with overall data architecture.
- Collaborated with data architects to implement star schema and snowflake schema designs.
- Demonstrated proficiency in using ETL tools such as Informatica and to streamline data integration workflows.
- Leveraged ETL tools to design and implement complex data transformations and orchestrations.
- Utilized cloud-based ETL solutions on platforms like AWS and Azure for scalable and cost-effective data processing.
- Implemented ETL pipelines in cloud environments, leveraging serverless computing and storage services.
Education
Master of Science -
Union College
Barbourville, KY 01.2021 - 08.2022
Skills
Data Curating
undefinedTimeline
Data Engineer
It Resources
09.2022 - Current
Master of Science -
Union College
01.2021 - 08.2022
Similar Profiles
Joe CastellanoJoe Castellano
Completions Consultant at Crestone Peak Resources/Sierra Resources/EP EnergyCompletions Consultant at Crestone Peak Resources/Sierra Resources/EP Energy
Alexa NoblittAlexa Noblitt
Biologist Aide / Senior Biologist Aide at Alabama Department of Conservation and Natural Resources (ADCNR) - Marine Resources Division (MRD)Biologist Aide / Senior Biologist Aide at Alabama Department of Conservation and Natural Resources (ADCNR) - Marine Resources Division (MRD)
Lori SmithLori Smith
Financial Controller & Director of Human Resources at US Resources, Inc. & US Resources, Healthcare, LLCFinancial Controller & Director of Human Resources at US Resources, Inc. & US Resources, Healthcare, LLC
Devyn ErseryDevyn Ersery
Server at Link & Pin ArboretumServer at Link & Pin Arboretum
Miralem OkicMiralem Okic
Quality Assurance Laboratory Technician at Tyson FoodsQuality Assurance Laboratory Technician at Tyson Foods