Nithya Subramaniam

Techincal Lead

TCS

Bangalore

11.2018 - Current

Integrated Snowflake with Informatica IICS, AWS S3, and REST APIs to automate ingestion and processing from diverse data sources.

Leveraged Oracle to Snowflake migration projects, managing data modeling, schema optimization, and end-to-end ETL integration using IICS (CDI/CAI).

Implemented data cloning, time travel, Materialized Views (MVWs), Views (VWs), Streams, and Tasks in Snowflake to optimize data processing, enhance data recovery, and improve query performance.

Designed and implemented Snowpipe and external stages for near real-time ingestion of semi-structured and streaming data into Snowflake.

Built flattened views and implemented variant columns with lateral flattening in Snowflake to simplify nested JSON querying for downstream analytics teams.

Applied Cloud Application Integration (CAI) to process real-time API events, routing JSON payloads to Snowflake via orchestrated data flows.

Automated file pre-processing and load dependency logic with Unix shell scripts, improving data reliability and pipeline efficiency.

Developed reusable transformation logic, parameterized workflows, and JSON parsing pipelines using IICS, improving maintainability and reducing development time.

Provided technical leadership, mentored junior developers, conducted code reviews, and drove architectural decisions to maintain high-quality deliverables.

Supported CI/CD implementations using Git, participating in Agile sprints and release planning to deliver incremental value.

Collaborated closely with QA and BI teams to ensure accurate and timely delivery of data for financial and operational reporting.

Developed and enhanced complex Informatica PowerCenter and BDM mappings/workflows, integrating data from sources such as Oracle, flat files, XML, COBOL, EBCDIC, and X937 file formats.

Applied BDM’s Spark-based pushdown execution on Hadoop and Hive for big data processing, reducing transformation time and enabling fast pre-load validations.

Interacted with business stakeholders and analysts to convert functional requirements into optimized technical designs for ETL processes.

Independently performed complex troubleshooting, root cause analysis, and issue resolution across high-volume production workflows.