P.T GRACE ANITHA

Role: Snowflake Developer

Domain: BFSI

Client : HSBC

• Proficient in Snowflake object development including tables, views, stages, flat files, functions, stream, pipe and stored procedures and maintained data models and schema designs to support scalable efficient data solutions.
• Implemented Snowflake task-trees to automate incremental loads and backups during DML events, using streams for audit support and leveraging time travel and fail-safe for recovery and compliance.
• Developed and maintained ETL/ELT pipelines, integrating data from Oracle, AWS S3, and other sources into Snowflake.
• Designed and optimized advanced Snowflake stored procedures using dynamic SQL, user-defined functions, and table functions to enable flexible, metadata-driven ETL processes, streamline complex transformations, and support seamless integration across systems.
• Implemented CDC using Snowflake Streams to track incremental changes in source tables, enabling real-time data pipelines, and ensuring efficient downstream processing with minimal latency.

Domain: BFSI

Role: Date Migration Analyst

Client : Barclays

• Migrated data from Oracle Database to Snowflake using flat files as part of application modernization and cloud migration initiatives.
• Designed and implemented Snowpipe to automate data ingestion from AWS S3 into Snowflake, enabling seamless and continuous data integration from Oracle to Snowflake.
• Handled semi-structured data using Snowflake’s VARIANT datatype, FLATTEN function, and flat files.
• Executed structured data migration using Snowflake's STAGE and COPY INTO commands.
• Utilized Snowflake's advanced features in combination with third-party tools to design and implement efficient ETL/ELT pipelines, auto data ingestion, transformation, and loading.
• Implemented SCD Type 2 logic in Snowflake using MERGE statements, Streams, Tasks, and Time Travel to save historical records and track changes over time for dimensional tables.
• Built and automated scalable SQL-based data transformation pipelines using DBT, enabling scalable, testable, and documentation-rich analytics workflows.

• Experience in software support using/ Internal tools.
• Sound knowledge on Telecom domain & Life cycle of Telecom operation.
• Establishing the networking environment by designing system configuration, directing system installation and defining, documenting and enforcing system standards
• Have well knowledge in OCR, OFR, ODF BERT planning and OTH connection
• Allocation - Planning and allocating daily volumes to my team within the given TAT and to ensure 100% SLA. Responsible for keeping commitments in a timely manner and resolving issues promptly.
• Domain: BFSI
• Role: Process Associate