Please complete the CAPTCHA to continue
@snaplogic.com
✓
LinkedIn matched
A concise factual answer block for searchers comparing this professional profile.
Pradeep Sathyanarayan is listed as Software Architect at SnapLogic at SnapLogic, a company with 51 employees, based in San Francisco Bay Area, United States, United States. AeroLeads shows a work email signal at snaplogic.com and a matched LinkedIn profile for Pradeep Sathyanarayan.
Pradeep Sathyanarayan previously worked as Sofware Architect at Snaplogic and Senior Principal Sofware Engineer at Snaplogic. Pradeep Sathyanarayan holds Master'S Degree, Business Administration/Project Management from Columbia Southern University.
This section adds company-level context without repeating Pradeep Sathyanarayan's masked contact details.
AeroLeads found 1 current-domain work email signal for Pradeep Sathyanarayan. Compare company email patterns before reaching out.
Experience Summary:Total Experience - 27+ years.27+ years of experience in Software Architecture & Development, Testing, Project Management, Strategic Planning, Customer Relations, & Operations Management. Extensive experience in Teradata Database Internals in a Distributed System & Parallel Processing environment. In-depth experience in Parser & Optimizer Engineering with the development SQL features like MERGE INTO, SQL UDFs, Optimizer Costing Infrastructure, Partitioned Primary index, Statistical Functions' Performance Enhancements, LEAD/LAG Analytics, etc. Provided in-house sustenance of Teradata releases dating back to V2R2.Well rounded understanding & experience in Data warehousing, Database Schema Design, Data Partitioning, Database Shards, Index Management, ELT, & ETL. Significant knowledge in Parallel Algorithms, Multi-threading, Lock Contention, Concurrency, Memory management, Database Integrity, Availability & Replication. In-depth experience in Query Processing with special emphasis in Query Optimization and Analytics, accompanied by Query Rewrites & Query Tuning.Also, worked on porting Teradata Database to various 64-bit platforms like IA64, HPUX, Solaris, & Linux. I have successfully managed a team of 30+ members on various Feature Development Projects.I am the co-inventor of 4 Patents in the area of Query Rewrite & Cardinality Estimation on massive Parallel Systems with 2 additional Patents pending in the area of SQL User Defined Operators. I have also authored over 70 Invention Disclosures. I am a V2R5 Teradata Certified Master.Over 4 years of experience in Data Integration, ETL and ELT domains.4 years on System Integration & Technical Support on Solaris, Tandem, Non-stop Kernel, Ungermann Bass Networks, LAN Terminal Servers, Modems, & Oracle Database.I am a very enthusiastic, tenacious, & a detail-oriented person. I am very passionate about my work. My leisure activities include watching movies, reading current events, & spending time learning what's new in the Software Industry.
Listed skills include Data Warehousing, Sql, Databases, Database Design, and 46 others.
Company context helps verify the profile and gives searchers a useful next step.
A career timeline built from the work history available for this profile.
San Mateo, CA, US
Involved in design and development of SubQuery Pushdown optimization for the ELT Product in order to improve the performance by almost 60 to 70 %. Drove the design effort towards supporting non-natively supported functions like Linear Regression Functions, Pivot, Unpivot etc. through complex Query Rewrites. Evolved a comprehensive SCD2 solution on ELT.
San Mateo, CA, US
Architected, Designed and Developed the Snaplogic ELT software product which provides an ability to Extract, Load and Transform data using Snaplogic pipelines with a Full Push Down Capability on target Cloud Data warehouses Snowflake, Amazon Redshift, Microsoft Azure Synapse, Databricks Lakehouse Platform and Google BigQuery. Developed more than 25.
San Mateo, CA, US
Joined the Snaplogic Big Data Engineering Group in 2018 for development of the Snaplogic Extreme Product which is a Big data Integration ETL Offering provided by Snaplogic on the AWS EMR Cloud Platform and Azure Databricks Cloud Platform. This involved development of a complete ephemeral cluster infrastructure that would provide the user to start and stop.
San Diego, California, US
Query Optimization and Analytics:Sustenance of LEAD/LAG Analytics feature until the release. Concept development for new features in analytics namely: NTH_VALUE, NTILE, Nested Window functions, improvement of performance of TOP N feature, FIRST_VALUE and LAST_VALUE functions.Also completed the concept and design for the following ANSI SQL Features for.
San Diego, California, US
Query Optimization and Analytics:Design and development of LEAD/LAG Analytics feature (executed by Myself without a Team) on Teradata Database. This involved enhancing the syntaxer to support the new LEAD/LAG function syntax in Teradata style and ANSI style, developing around 35 different internal rewrites at the Optimizer level to facilitate performance.
San Diego, California, US
Query Optimization and Analytics:Design and development of Pushing Joins into UNION ALL, Derived Tables, and Views. This involved pushing joins that involved Referential Integrity based tables, join elimination, outer to inner join conversions, non-referential integrity based tables, cost-based rewrites, and triggering other rewrite operations.
San Diego, California, US
Query Optimization and Analytics:Sustenance of Statistical and Analytic functions, Random AMP Sampling, Referential Integrity, and Query Rewrite features on Teradata.
San Diego, California, US
Query Optimization and Analytics: Feature Name: STAT Function Optimization; executed by Myself with no Team.Optimization of the run-time execution of the STATISTICAL Function Step on the AMPs by adding new optimized execution methods like Random AMP Sampling, improving the performance of Value Partitioning, reduction of the message overheads, reducing the.
San Diego, California, US
Database Kernel, Query Optimization, and Analytics:Sustenance of Columnar Partitioning feature and improving the performance of INSERT SQL operations on Columnar Tables with Fallback; sustenance of QRW (Query Rewrite), RI (Referential Integrity), and other SQL features on Teradata.
Worked as a Solution Architect scoping the design to implement a solution on Teradata Database to be integrated with Cassandra and Sqoop Utility. Also, studied the options for Database Sharding in order to improve the speed of data flow between the two different databases.
Area: Tandem Non-Stop Kernel, Oracle, Solaris, Networking.Handled Level 4 Escalations from customers and provided solutions to complex problems in the Tandem Non-stop Kernel Systems, Oracle, Solaris, LAN Terminal Servers, and Modems.
Database Kernel, Query Optimization, and Analytics:Design and development of fastpath INSERT SQL operations for Teradata Columnar Tables with empty partitions.
Database Kernel, Query Optimization, and Analytics:Design and development of the Teradata Columnar feature with special emphasis on implementing optimized single row and bulk row insert SQL operations.
Database Kernel, Query Optimization, and Analytics:Sustenance of Teradata features in the Query Optimization area.
Query Optimization and Analytics:Design and development of the Teradata SQL User Defined Function feature.
Query Optimization and Analytics:Design and development of QRW feature on Teradata that involved View Folding based Rewrites, View Projection Optimization, Outer to Inner Join Conversions, and Join Elimination.
Query Optimization and Analytics:Sustenance of ANSI Merge, Referential Integrity, Partitioned Primary Index, Random AMP Sampling, and other features.
Database Kernel, Query Optimization, and Analytics:Design and development of ANSI MERGE INTO feature with INSERT and UPDATE Syntax. The core changes involved were: adding new syntax, extensive design enhancements in the query expression of the source relation of MERGE INTO, and implementing block optimized I/O when writing the Datablocks to the disk by.
Database Kernel, Query Optimization, and Analytics:Design and development of Teradata Dynamic Partition Elimination for PPI Merge Joins. This involved optimizing the sliding window merge joins for Partitioned Primary Index (PPI) tables by reducing the number of joins between the partitions in a given window. This required new partition elimination.
Database Kernel, Query Optimization, and Analytics:Design and development of the Recursive Query Feature.
Database Kernel, Query Optimization, and Analytics:Design and development of Multiple AMP Sampling capability for improved cardinality estimation in order to facilitate better Optimizer planning. This needed changes in the Database Kernel to allow Group AMP Sampling, Node Level Sampling, and All AMP Sampling.
Query Optimization and Analytics:Design and development of a common cost based infrastructure for Teradata Optimizer on 32-bit and 64-bit platforms.
Database Kernel:Design and development of a new row redistribution and duplication methodology for very large single node SMP systems using VPROC Level buffering schemes in order to support faster methods of redistribution and duplication to reduce CPU and network usages during Query processing.
Database Kernel, Query Optimization, Analytics, Database Client, and Database Gateway:Design, development, and Porting of Teradata on 64-bit platforms including Windows 64-bit, Solaris 64-bit, HPUX 64, Linux 64-bit while continuing the support on 32-bit platforms.
Solaris, Networking:System Integration and Technical support for Solaris systems for Internet and MIME Gateways.
Tandem Non-stop Kernel, UngerMann Bass (UB) Networks:System Integration and Support of Tandem Non-stop Kernel (NSK) and UB Networks based on Fiber Optic Connections using FDDI ring method.
Solaris Sparc:System Integration and support of Solaris Systems.
Other employees you can reach at snaplogic.com. View company contacts for 51 employees →
Roger Sramkoski
Colleague at Snaplogic
Swanton, Vermont, United States, United States
View →
NL
Naomi L. Arai
Colleague at Snaplogic
San Francisco Bay Area, United States, United States
View →
SC
Sadhana Chevireddy
Colleague at Snaplogic
Berkeley, California, United States, United States
View →
WR
Wenhan Rao
Colleague at Snaplogic
San Francisco, California, United States, United States
View →
TL
Tom Luy
Colleague at Snaplogic
United States, United States
View →
VK
Vaikom Krishnan
Colleague at Snaplogic
Redwood City, California, United States, United States
View →
JM
Jordan Millhausen
Colleague at Snaplogic
Washington DC-Baltimore Area, United States
View →
AH
Andrew Hoang
Colleague at Snaplogic
Belmont, California, United States, United States
View →
AM
Aneesh Madhavan
Colleague at Snaplogic
San Francisco, California, United States, United States
View →
MG
Manohar Gurpur
Colleague at Snaplogic
Fremont, California, United States, United States
View →
Quick answers generated from the profile data available on this page.
Pradeep Sathyanarayan works for SnapLogic.
Pradeep Sathyanarayan is listed as Software Architect at SnapLogic at SnapLogic.
AeroLeads has found 1 work email signal at @snaplogic.com for Pradeep Sathyanarayan at SnapLogic.
Pradeep Sathyanarayan is based in San Francisco Bay Area, United States, United States while working with SnapLogic.
Pradeep Sathyanarayan has worked for Snaplogic, Teradata, Wipro Technologies; Client: Apple Inc., Wipro Technologies, and Wipro Technologies; Client: Teradata.
Pradeep Sathyanarayan's colleagues at SnapLogic include Roger Sramkoski, Naomi L. Arai, Sadhana Chevireddy, Wenhan Rao, and Tom Luy.
You can use AeroLeads to view verified contact signals for Pradeep Sathyanarayan at SnapLogic, including work email, phone, and LinkedIn data when available.
Pradeep Sathyanarayan holds Master'S Degree, Business Administration/Project Management from Columbia Southern University.
Pradeep Sathyanarayan is listed with skills including Data Warehousing, Sql, Databases, Database Design, Business Intelligence, C, Data Modeling, and Enterprise Architecture.
Search by job title, company, industry, location, and seniority. Export verified B2B contact data when you need it.
Start free trial Search contacts