GOWTHAM RAJAN A

Accomplished Data Engineer at Wavicle Data Solutions with expertise in Snowflake and a proven track record of optimizing ETL processes. Skilled in collaborating with cross-functional teams to deliver robust data solutions, ensuring data integrity and reliability. Adept at automating tasks and enhancing performance, driving significant improvements in data retrieval efficiency.

Hands On Essentials - Data Engineering

Hands On Essentials - Data Lake

Hands On Essentials - Data Sharing

Hands On Essentials - Data Applications

Hands On Essentials - Data Warehouse - Snowflake, https://www.credly.com/users/gowtham-rajan.835e07d4

Microsoft Certified: Azure Data Fundamentals DP 900 - Microsoft, 03/25/23, https://learn.microsoft.com/api/credentials/share/en-us/GowthamRajan-4559/15B105713DC8F595?sharingId=E90E18A636E5872E

• Clayton Homes - Snowflake, MySQL, Led the migration of MySQL to Snowflake, ensuring seamless data transfer and performance optimization., Converted MySQL queries, stored procedures, and scripts into Snowflake SQL., Conducted extensive feasibility testing to evaluate Snowflake’s suitability for Clayton Homes’ data architecture., Performed data validation and reconciliation to ensure accuracy and integrity post-migration.
• GATX - Snowflake, Extracted data from Snowflake DB, transformed it to meet business needs, and loaded it into another Snowflake DB for further processing., Utilized Snowflake Dashboards to monitor ETL processes and ensure data pipeline efficiency., Created views and tasks for scheduling stored procedures to automate data workflows., Implemented data quality checks, including row count validation, source-to-target and target-to-source key attribute comparisons, and data duplicate validation.
• SLA- Informatica PowerCenter 10.4, Oracle Database, Collected various customer, policy, claim, product, and financial-related data from various OLTP systems and flat files. Extracted and changed using Informatica Power Centre, loaded data into a data warehouse and produced reports., Developed new mapping designs using Informatica Designer's tools., Created complex mappings that involved implementation of Business Logic to load data into staging area., Used Informatica reusability at various levels of development., Developed mappings/sessions using Informatica Power Center 10.4 for data loading.

• Date of Birth: 08/03/93
• Nationality: Indian

• Tamil
• English
• Telugu

Molex - Consumer electronics company, Snowflake, AWS – S3, Glue, Athena, Lambda, Redshift, Talend, Designed and implemented an enterprise-level data integration pipeline to extract ERP data, store it in Amazon S3, transform it using Snowflake stored procedure, and load it into Snowflake for scalable analytics. Ensured data integrity and optimized ETL processes for efficient decision-making., Integrated ERP data from multiple sources, including SAP ECC, Salesforce, and Marketo, into Snowflake., Used Fivetran and HVR Sync for real-time data replication into Snowflake staging tables., Implemented Snowflake stored procedures for data transformation, aligning with business requirements., Performed multiple data quality checks to ensure accuracy and integrity before finalizing the data load., Optimized ETL workflows to enhance performance and streamline data processing.

• With over 6.5 years of experience in data integration and warehousing, I specialize in leveraging Snowflake alongside other technologies like Informatica PowerCenter, Oracle database, MySQL database, AWS S3, Redshift, and Glue to build robust data solutions.
• Extensive experience in directly extracting, transforming, and loading data from diverse sources, such as SQL Server, Oracle, and flat files, into Snowflake data warehouse through AWS S3 and Redshift.
• Have extensively worked in ETL programme to support Informatica Power Center's data extraction, transformation, and loading.
• Proficiently utilizing AWS services like S3 for secure and scalable data storage, Redshift for high-performance data warehousing, and Glue for ETL job orchestration, ensuring seamless and cost-effective cloud-based data solutions.
• Collaborated with cross-functional teams to gather business requirements and translate them into effective ETL solutions, utilizing Snowflake, AWS S3, Redshift, and Glue technologies to meet project objectives.
• Using the document requirements as a guide, fully comprehend the business rules and put the data transformation techniques into practice.
• Managed and executed object deployments across development, QA, and production environments using version control systems, ensuring smooth and reliable releases. Monitoring and fixing environmental-related production problems.
• Proactively monitored and resolved production environment issues, minimizing downtime and ensuring data pipeline stability.