At HCL Tech, I work as a Senior Software Engineer on CWR-Analyst for The ODP Corporation – Office Depot, building ETL pipelines with DataStage and Snowflake to ingest HR and ITSM data from cloud storage.
I design Snowflake tables and views and develop SQL transformations and stored procedures for reporting platforms. I also tune query execution and warehouse costs using micro-partitioning, virtual warehouse rightsizing, and Snowflake caching.
I implement data classification, role-based access control, and dynamic data masking to help protect sensitive PII. I also automate CCPA request-processing workflows to identify, isolate, and sanitize PII across data layers.
I validate and reconcile data, manage code migration and CI/CD deployments with Git/GitHub and Jenkins, and support production ETL runs by investigating failures with UNIX/Linux scripts.
