Ria Rastogi

Client: KITE Pharmaceuticals(Gilead)

• Working as an ETL developer for US KITE pharmaceutical client. Working extensively on SQL queries and developing data warehousing structure from E2E.
• Worked with clients to understand their requirements and creating ETL pipelines like staging, dimension , fact , intermediate and reporting tables from the raw data received from multiple sources and pushed the data to our dashboard via Amazon Redshift .
• Implemeted Data Quality framework in my project and applied multiple checks like file checker,schema check,layer to layer checks,history checks,business checks,refrential integrity checks,list of values check in order to keep data refined and make sure that correct data is visible to our end users.
• Working on mutiple enhancements received from our clients and perform thorough testing.

Client: Ferring Pharmaceutical

• Developed QC framework using SQL queries and performed checks like data validation, process validation, error handling E2E.
• Performed enhancements on existing interfaces and performed testing as per client requirements.

Client: Novartis

• Primary responsibility involves understanding the entire existing process control architecture and providing suggestions to improve the performance and better technical implementations.
• Tested the designed jobs by creating test cases and SQL queries and explored new possibilities in order to deliver value added work.
• Identified causes of issues within jobs and determined which modifications needed to be made.
• Created parallel data stage jobs and performed transformations using filter, transformer ,sort ,aggregator and many more.