Prashanth S.in Remembrance
Data Architect at Amazon Web Services (AWS)
- Role
- Sr Data Arhitect Data Lake at Amazon Web Services (AWS)
- Location
- Houston, TX, US
- LinkedIn followers
- 500 followers
About Prashanth S.in Remembrance
Working as Lead in mentoring my team on day to day activities * Performed major role in understanding the business requirements and designing and loading data into data warehouse (ETL).* Working with utilities Like BTEQ, MLOAD, FLOAD etc… * Collection of data source information from all the legacy systems and existing data stores.* Imported various Application Sources, created Targets and Transformations using Data stage Designer (Source analyzer, Warehouse developer, Transformation developer, and Mapping designer.* Worked on data modeling using the Visio and Erwin * Involved in Data Extraction, Transformation and Loading from source systems to ODS.* Developed complex mappings using multiple sources and targets in different databases.* Actively participated in the performance of Data stage mappings.* Worked with production support team for solving the production issues.* Knowledge on Data stage and Informatica.* Security administration including creating and maintaining user accounts, passwords, profiles, roles and access rights * Tuned various queries by COLLECTING STATISTICS on columns in the WHERE and JOIN expressions * Knowledge on Teradata Architecture.* Knowledge on Star Schema and Snow Flakes Schema.* Developing BTEQ scripts to load the data from the staging tables to the base tables * Created BTEQ scripts to extract data from warehouse for downstream * Performed Unit level of testing as part of development. Also assisted the Testing team for running SIT/UAT/Pre-Production testing.
Experience
Sr Data Arhitect Data Lake
Mar 2023 — Present · Houston, TX, US
Education
Velammal Engineering College
Master of Science, Computer Technology
SBOA School and Junior College
High School
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.