Sandeep Reddy

About Sandeep Reddy

Over the past decade, I\'ve worked extensively with both Oracle (SQL and PL/SQL) and SQL Server (SQL and SSAS). DataData Migration, Data Integration and Data Modeling and ETL. • Extensive knowledge of Oracle 11g, 12c, 18c and SQL Server 2019• Extensive knowledge in back-end coding technologies like as Oracle 18c/12c SQL, PL/SQL, and developing apps in Developer suit 11g.• Worked on numerous types of financial derivatives projects with excellent technical capabilities on Client / Server and hands-on expertise in technologies such as TOAD, SQL* Loader, and SQL Impact.• Well-versed in the building of interfaces and information centers in PL/SQL utilizing control files for SQL*Loader and the UTL FILE package.• Using Oracle PL/SQL to create Stored Procedures, Functions, Views, Triggers, and Packages.• A solid understanding of Python and Linux shell scripting, as well as Apache Kafka AWS S3, DMS, ATHENA, PRESTO, HP VERTICA, and APACHE SPARK is required.• Proficient in the design of Oracle Forms and the development of Reports using Oracle Developer Suit 11g.• Proficient in performance tuning jobs, such as TKPROF, AWR, and so on.• Capacity to prioritize and manage many tasks. Managing four members in a group.• Having Solid Informatica 8.6 Knowledge• Knowledge in creating mappings, processes, data cleansing, scrubbing, and aggregation tasks, and designing DFDs, among other things.• Good exposure to data visualization technologies such as BI Pub, Tableau, and others.• Experience with Agile and Kanban Methodologies.• Previous experience gathering requirements from business users, business analysts, and project leads and transforming them into technical documents.• Some experience in developing the BRS (Business Requirement Specifications) document, which contains specific information about the needs.• Skilled in creating data models, ERD diagrams, logical and physical models based on business needs using standard tools like Microsoft Paint.• Extensive expertise designing data marts in Star Schema and Snowflake Schema, as well as building data warehouses.• Created and developed Slowly Changing Dimensions tables to help with history maintenance (SCD type-1, type-2, type -3).• Significant experience creating Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages, and Oracle Objects - Tables, Materialized Views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections, and Dynamic SQL.

Experience

1. Sr Pl Sql Developer

   Charles Schwab

   Aug 2021 — Present · Austin, TX, US

   Austin, TX