Vinay

Data Engineer with 4 years of experience in building and supporting data pipelines using Snowflake, Informatica IICS/IDMC (CDI & CAI), dbt, and Oracle SQL. Experienced in batch and incremental ETL/ELT pipelines, API-based data ingestion, data validation, and production support.

Data Engineer at Innova Solutions (2022-06 – Present)

• Developed and maintained IDMC CDI mappings to load data from Oracle, SQL Server, files, and APIs into Snowflake.
• Implemented batch and incremental loads using parameterized mappings for scalable processing.
• Created taskflows to control execution with success and failure handling.
• Used Snowflake Streams and Tasks to support incremental data processing.
• Assisted in query performance tuning and warehouse monitoring in Snowflake.
• Built API-based integrations using IDMC CAI Processes and Service Connectors.
• Implemented REST API calls with OAuth2/JWT authentication, headers, parameters, and pagination.
• Developed dbt models with incremental logic and basic data quality tests.

Bachelor of Technology in B.Tech – Sree Vidyanikethan Engineering College (2022)