Vinod Rampur

• Currently working as snowflake developer and SQL Data Modelling.

• Worked on Migration project where the source is oracleR12 and 11i and the target is snowflake. Loading data in to Oracle from client, the informatica tool is used to extract, transform, and load the data in to snowflake SRC layer. As per the data model (STTM document), load the data from CNF to PUB layer. Some of the data are loaded in AWS s3 bucket and load the data from s3 to snowflake external stage and further loaded to table using copy commands. After the data loaded in to the publish zone, testing and reporting teams will pull the data for report generation in Qlik.

• Worked on Migration project where the source is oracleR12 and 11i and the target is snowflake. Loading data in to Oracle from client, the informatica tool is used to extract, transform, and load the data in to snowflake SRC layer. As per the data model (STTM document), load the data from CNF to PUB layer. Some of the data are loaded in AWS s3 bucket and load the data from s3 to snowflake external stage and further loaded to table using copy commands. After the data loaded in to the publish zone, testing and reporting teams will pull the data for report generation in Qlik.

Executed migration project from Teradata to Snowflake, ensuring seamless data transition.

Utilized Talend ETL tool for extracting, transforming, and loading data into Snowflake raw layer.

Built DDLs aligning with data model specifications incorporating essential business logic.

Developed stored procedures in Snowflake to manage data flow from raw to core layer.

Automated processes using Streams and tasks for real-time data change capture.

Conducted unit testing post data load to ensure integrity between layers.

Performed bulk loading from AWS S3 to Snowflake using COPY command.

Generated status reports to communicate team achievements to stakeholders.

• Developed SQL queries based on customer requirement using various joins.
• Analysing the areas of service improvements and implement fix for the same.
• Issues reporting/clarifications, raising bugs if product issues.
• Attending daily stand-up meeting and give updates.
• Involved in daily run for Regression.
• Team Management in knowledge transfer as well as mentoring activities.
• Providing weekly & monthly report on project activities and performance.

• Company Overview: Provides software for e-commerce application. Product categories like consumer electronics, fashion, home essentials, groceries, and life style products.
• Onboarding applications on AWS platform as per required workflow for CI/CD.
• Setup/configure CI/CD pipeline leveraging AWS native services or traditional tools (e.g., Jenkins, GitHub, Artifactory etc.).
• Administration of GitHub tool includes creating branches, tagging, access permissions and setting up webhook.
• Maintaining Subversion code repository and backup files.
• Experience in Creating branches and tags to separate build system after a milestone releases and Create build storage archives for back tracking builds.
• Used Maven scripts to build the source code. Supported and helped to create Dynamic Views and Snapshot views for end users.
• Automated build scripts using Maven and Shell Scripts.
• Configured Jenkins tool for project and setup Nightly Builds.
• Automated the code deployment process in each environment (development, QA, Staging, Production).
• Used Docker Container for running different individual services and optimizing the infrastructure cost.
• Provides software for e-commerce application. Product categories like consumer electronics, fashion, home essentials, groceries, and life style products.