Yash Pratap Singh

Data Migration from Oracle to Cloud | Client: Nissan

• Designed and developed ETL pipelines in Informatica to facilitate the seamless migration of client data from Oracle to Snowflake
• Developed Merge Scripts, Copy Scripts, and optimized multiple SQL queries to enhance data processing efficiency
• Technologies Used: Snowflake, Informatica, Informatica Intelligent Cloud Services (IICS), SQL.

Development of mappings in Informatica | Client: Cummins

• Engineered complex mappings in Informatica PowerCenter, ensuring smooth deployment to production and efficient monitoring through Workflow Manager.
• Implemented rigorous testing and validation strategies to guarantee data integrity post-deployment.
• Technologies Used: Informatica PowerCenter, SQL.

Application Development & Reporting | Client: REI

• Designed and developed a Work From Home application for the client utilizing Oracle Apex, SQL, and JavaScript, streamlining remote work operations.
• Created detailed reports identifying data/funding mismatches, highlighting errors, and proposing solutions to rectify discrepancies.
• Technologies Used: Oracle Apex, SQL, PL/SQL.

• Developed familiarity with high-level automation, including Numerical Control (NC) and Computer Numerical Control (CNC) coding, enhancing technical proficiency in automated manufacturing systems.