Prem Raj

I am an ambitious, results-driven professional seeking a long-term career that fosters continuous growth in technical expertise. My goal is to contribute meaningfully to your esteemed organization by leveraging my skills to transform challenges into innovative solutions.

With approximately seven years of hands-on experience in data engineering and performance optimization, I bring strong proficiency in technologies including Snowflake, ETL, Oracle, SQL Server, AWS S3, IICS, and DB2. I have been actively involved in all phases of the Software Testing Life Cycle (STLC) and Software Development Life Cycle (SDLC), consistently delivering high-quality outcomes within tight deadlines.

Key Competencies and Achievements:

• Extensive experience in ETL development and Snowflake data warehousing, including schema design and performance tuning.
• Collaborated with Business Analysts to interpret stakeholder requirements and translate them into robust data integration solutions.
• Solid understanding of data warehousing concepts, such as star schema, snowflake schema, fact, and dimension tables.
• Implemented Snowpipe for seamless data ingestion from AWS S3 into Snowflake.
• Created sequences for generating primary key serials, and utilized clone techniques for efficient data backup.
• Developed Snowflake streams to maintain audit trails and capture DML changes on base tables.
• Proficient in writing complex SQL queries to support transformation logic aligned with business needs.
• Skilled in both Windows OS and UNIX environments, with a strong grasp of SDLC, STLC methodologies.

Project 1

Project name: DLP, A2L SWIFT RETREAT, OLYMPIC 

Client name: BNP Paribas Bank, India 

Environment: Snowflake, DB2, Oracle 

Tools: SSIS, IICS, and JIRA 

Roles and Responsibilities: 

• Performing sanity checks for the transactions in the database environment,
• Data migration from Oracle database to Snowflake using flat files for application migration from Oracle DB to Snowflake performed Snowflake's object development such as warehouses, schemas, databases, tables, views, pipes, stages, and scaling policies,
• Data utilization, roles, and data migration for structured data by creating a stage and copy, and then transforming performed data, copy on error, file format, and all copy options, capturing all the evidence and uploading it in the Confluence page for the user reviews

Project 2: 

Project name: Fermat – ALM, ACBS 

Client name: Standard Chartered Bank, India; 

environment: Snowflake, DB2, Oracle 

Tools: IICS, SSIS, and JIRA

Roles and responsibilities: 

• Experience in loading unstructured data on minimal load using VARIANT datatype, flatten, Parquet, etc.
• Developed Snowflake procedures, functions, and UDTF (User Defined Table Function);
• Created an external table to access the data from the files when file access is denied in AWS S3
• Tested transformation functions and record formats for various input data files
• Capturing all the evidence and uploading it to the Confluence page for user reviews

I hereby declare that all the facts stated above are true to the best of my knowledge

(Premraj.S)