| Hot list by Deepthi- Sr Snowflake Administrator OR Analyst is having 15 years available immediately at Remote, Remote, USA |
| Email: [email protected] |
| From: Deepthi 630-480-4203, Thoughtwave software solutions [email protected] Reply to: [email protected] Dear Staffing Partner, Pradeep is a Teradata DBA & Snowflake Architect /Admin is having 15+ years of experience and available for projects immediately. He is located in Apex, NC and looking for positions anywhere in USA, if you'd like to receive his resume, please reply to this email with job details or contact me AT 630-480-4203 SUMMARY: Leveraged 14+ years of expertise in Business Intelligence, Global Data Warehousing, and Development across diverse cross-functional teams, spanning Database Architecture, Development, Administration & Maintenance, and Reporting & Database Performance Tuning. Demonstrated strong proficiency in Relational Databases (OLTP), Data Warehousing systems (OLAP), and Cloud Services, specializing in Dimensional Data modeling including Star Schema and Snowflake Modeling. Led Data Mapping, Data Profiling, and Data Mining initiatives to support the creation of robust Data Warehouse environments. Served as a Snowflake Architect and ADMIN for 2+ years at Comcast, focusing on large-scale EDW implementation and executing strategic Data Migration initiatives. Established efficient data pipelines from Teradata to Snowflake and developed Python frameworks for Adhoc data ingestion, alongside expert-level UNIX Shell scripting for file manipulation and text processing. Applied deep expertise in Performance Tuning, Query Optimization, and the creation and monitoring of Snowflake Virtual Warehouses to enhance system efficiency. Managed high-volume parallel CSV files generation using Informatica for seamless Snowflake data ingestion and led the Lift and Shift of Historic EDW Star Schema to Snowflake EDW. Successfully ported 250+ SAP BO Reports from Teradata to Snowflake Data Warehouse, specializing in Dimensional Modeling, Star and Snowflake Schemas, and Extended Star Schema designs. Established and optimized Data Lake environments in Snowflake (RAW/STAGE, WIP, CURATED, and SANITIZED ZONES) for efficient Data Warehouse loading and transformation. Implemented robust Data Masking Policies for PII and EBS SOC Compliance. Brought 12+ years of Teradata DBA/Architect experience, proficient in Teradata Administrator for managing Databases, Users, Tables, Indexes, and permissions management. Extensively utilized Teradata 17.20/16.20/15.10 for application performance tuning, SQL optimization, detailed design, and handling database maintenance tasks. Expertise in Teradata Workload management, collaborating with user groups to define TASM Workloads, develop exceptions, and implement filters and throttles as needed. Managed production environments, identifying bottlenecks, and ensuring workload balancing through Shell scripts, Stored Procedures, and Macros automation. Executed internal and external data stages, transformed data during loads, and performed Zero Copy cloning for DEV and QA environments, with hands-on experience in Teradata Query Grid configuration. Contributed to the Analysis, Design, and Development of Application packages/systems in Python, and Unix shell script for the Banking/Telecom industry. Proficient in Agile Software Processes, actively participating in daily scrums, Sprint planning, review meetings, and retrospectives. Utilized Erwin Data Modeler for comprehensive Data Modeling, encompassing Star Schema, Snowflake Schema, Fact and Dimension tables, and both Physical and Logical data modeling for Data Warehousing and Data Mart implementations. Thanks, Deepthi- Thoughtwave Software & Solutions, Inc. Phone: 630-480-4203 Ext:145 Email: [email protected] Web: http://www.thoughtwavesoft.com Keywords: quality analyst North Carolina Hot list by Deepthi- Sr Snowflake Administrator OR Analyst is having 15 years available immediately [email protected] hotlist |
| [email protected] View all |
| Fri Sep 06 04:02:00 UTC 2024 |