Ishika Goel

• Led analysis, development, and implementation of business applications spanning various domains, specializing in creation and refinement of ETL methodologies using both Informatica Power Center and Informatica IICS.
• Designed and developed comprehensive mappings incorporating wide array of transformations, including re-usable transformations, Mappings, and numerous other transformations, to facilitate seamless data flow and integration.
• Demonstrated deep understanding of software development life cycle (SDLC), ensuring adherence to industry best practices and standards throughout all stages of development, from requirements gathering to deployment.
• Executed rigorous unit testing and integration testing protocols to validate system functionality, integrity, and performance, ensuring robust and reliable data processing capabilities.
• Proactively identified and addressed bugs, inefficiencies, and performance bottlenecks, leveraging advanced troubleshooting techniques and optimization strategies to enhance overall system performance and efficiency.

Played pivotal role in analysis of Over-The-Top (OTT) platforms, focusing on understanding user behavior, content consumption patterns, and performance metrics.

• Developed end-to-end data pipelines connecting Azure Data Lake Storage to Power BI, enabling stakeholders to access and visualize key metrics in real-time.
• Led design and implementation of data cleaning and transformation processes using Data bricks, ensuring data quality and consistency across all stages of pipeline.
• Collaborated closely with cross-functional teams to gather requirements, define data schemas, and implement solutions tailored to business needs.
• Successfully completed a capstone project centered around OTT platform analysis, demonstrating proficiency in data engineering, pipeline development, and data visualization techniques.

• Formulated and executed variety of SQL queries to extract pertinent insights and answers from database, enabling informed decision-making and data-driven strategies.
• Developed complex SQL queries to perform data analysis, aggregation, filtering, and transformation tasks, optimizing query performance and ensuring timely delivery of results.
• Actively contributed to development of best practices and standards for SQL query writing and database querying techniques, ensuring consistency and reliability across all data retrieval processes.
• Documented SQL queries and related processes, maintaining comprehensive documentation to facilitate knowledge sharing and support ongoing data analysis initiatives.