Roopam Sharma

Senior Data Engineer & Technical Lead with experience in designing scalable ETL/ELT pipelines and serverless data processing workflows. AI-Driven Development: Proactively leveraging GitHub Copilot/Claude for AI-assisted development, accelerating the delivery of complex Python scripts, SQL queries, and unit tests while maintaining high code quality. Specialist in complex Data Transformations, including SCD Type-1/Type-2 logic, high-volume data processing, and multi-source integration (Cloud, Relational, Flat Files, and APIs).

Snowflake Architecture & Security: Proficient in native data ingestion and protection features including the COPY command, Snowpipe for real-time streaming, Zero-Copy Cloning, Time Travel, and Fail-Safe recovery, optimizing multi-cluster virtual warehouses for cost governance while securing datasets via RBAC, Data Masking, and Row Access Policies. Expert in SQL & PL/SQL Performance Tuning, consistently optimizing long-running ETL batches and complex database procedures to meet tight SLAs.

Proven

Lead capable of translating business requirements into scalable technical designs (HLD/LLD) and managing the full ETL development lifecycle (SDLC) in Agile environments.

Senior Specialist Development (Technical Lead) - SunLife Global Solutions - Gurugram

(2023-09)

• Serverless Data Orchestration: Developed AWS Lambda functions (Python/Boto3) to automate the ingestion of source files from S3.
• Automated Data Sanitization: Built a custom Python logic within Lambda to validate file headers; implemented auto-reordering of columns to match target schemas, ensuring 100% pipeline reliability despite inconsistent vendor formats.
• Lead ETL Design: Architected end-to-end ETL Taskflows in IICS to ingest and transform data to and from diverse sources (AWS S3, REST APIs, SQL Server, Snowflake).
• End-to-End Pipelines: Architected IICS Taskflows to pick up processed files and load them into target, managing the entire lifecycle from raw landing to production-ready tables.
• Team Leadership: Lead a team of 5 developers, conducting code reviews and ensuring ETL best practices (naming conventions, modularity, and error handling) are followed.

Senior Developer - HCL Technologies - Noida

(2021-03 - 2023-09)

• ETL Development: Designed and implemented complex PowerCenter mappings using Aggregator, Joiner, Filter, Lookup (Connected/Unconnected), and Transaction Control transformations to process multi-vendor financial feeds.
• Data Integration: Successfully integrated disparate financial data streams from multiple vendors into the SLGI data warehouse.
• Managed data extraction from diverse formats including JSON/API and Flat Files for loading into SunLife Global Investment systems.
• SQL Performance Tuning: Optimized complex PL/SQL procedures and SQL overrides, significantly reducing the daily batch window for SLGI data loads.

Assistant Management – Software Development - Home Credit - Gurugram

(2021-03 - 2021-03)

• Production Support

System Analyst - Amdocs Development Center - Gurugram

(2017-08 - 2021-02)

• Orchestrated the migration of legacy customer data to Amdocs CRM for a major Philippines telecom provider (Project Globe).
• Built performance-tuned PL/SQL subprograms and indexes to handle high-volume data movement during production cutovers.
• Proactively managing Client calls, War rooms and Solutions closure with Client.
• Authored complex PL/SQL subprograms, cursors, and indexes to facilitate high-speed data movement from staging to production.

Master of Computer Application - Computer Application - NIT Jamshedpur (2017)

BSc (HONS) Computer Science - Computer Science - University of Delhi (2014)