Job Title

Role: PL/SQL Developer - Oracle & SnowflakeLocation: Bangalore | Pune | Noida | Gurgaon | Hyderabad Experience: 4+ YearsImmediate Joiners OnlyKey ResponsibilitiesDesign, develop, and maintain Oracle SQL/PLSQL components including procedures, functions, triggers, packages, and ETL workflows.Build and optimize ETL pipelines using PL/SQL, MoneyMap, Node-RED, SQL*Loader, and Unix shell scripts.Develop and manage Snowflake Cloud Data Platform objects such as warehouses, schemas, stages, pipes, and implement features like Time Travel, Cloning, Snowpipe, and performance tuning.Create and enhance Data Warehouse models: Star Schema, Snowflake Schema, Fact/Dimension tables, MViews.Perform query tuning, execution plan analysis, indexing, clustering, and database optimization to improve system performance.Handle data migration activities—schema mapping, data extraction, loading, validation, reconciliation.Work with real-time and batch data ingestion using COPY INTO, external stages, and cloud storage integrations.Support production systems: monitoring, troubleshooting, data validation, and resolving DB issues.Collaborate with cross-functional teams for requirement analysis, impact assessment, and delivery planning in Agile/Scrum setups.Prepare technical documentation, release notes, and support smooth deployment through development to production.Required SkillsStrong expertise in SQL, PL/SQL, Oracle 11g/12c.Solid understanding of Snowflake (warehouses, pipes, stages, Snowpipe, cloning).Hands-on experience with ETL tools: MoneyMap, Node-RED, SQL Loader, Unix scripting.Strong knowledge of Data Warehouse concepts: Fact/Dimension modelling, star & snowflake schema.Proven experience in performance tuning and query optimization.Proficient in debugging, error handling, and exception management.Experience working in Agile/Scrum.Good to HaveExposure to telecom domain (Revenue Assurance – T-Mobile).Banking domain knowledge (Bank of America).Experience supporting production batches, issue resolution, and SLA-based operations.Ideal CandidateA detail-oriented, analytical professional with strong PL/SQL development skills, cloud data warehousing (Snowflake) experience, and the ability to build efficient ETL workflows and optimize large-scale datasets.