Santosh Patil

About Santosh Patil

I am a Software Developer currently working with Vistra international expansion ltd and looking for new opportunities with immediate joining. • As part of business intelligence domain having 8+ years of total IT experience in Informatica Intelligence Cloud Services, Informatica Power Center, SQL server, Oracle, Unix Scripting, Agile, Test Driven Development and Data migration, Support, Enhancement & Customization, Project Execution & Service Delivery Operations as well as relevant experience in Data Warehousing Platform. • Good knowledge on Data Warehouse concepts and Data warehouse methodologies such as dimensional modeling, star and snowflake schemas, DataMart, fact and dimension table Identification. • Good understanding of Data warehousing and Database concepts. • Extensively working on ETL - Informatica Power Center 8.6.1/9.1/10.1. • Used transformations like Joiner, Expression, Connected, Unconnected lookups, Filter, Aggregator, Rank, Update Strategy, Normalizer, Router, Sorter, Sequence generator, Mapplets, Source qualifier etc. • Created complex Views & SP in SQL- Server and executed them through Informatica 9.6./10.1 • Worked on UNIX scripts to copy source files from SFTP Remote server to Infa server. • Involved in all phases of Data Warehousing software development life cycle (Analysis, Development, Testing and Documentation). • Implemented Data Warehousing techniques for Data Cleaning, Slowly Changing Dimension (SCD) phenomenon, Surrogate Key assignment and Change Data Capture (CDC). • Strong skills in Informatica, SQL, performed debugging, troubleshooting and performance tuning. • Performed warranty support activities. Handled critical issues & production deployment. • Automated the Informatica jobs using UNIX shell scripting. • Good knowledge in Data analysis and Data modeling concepts. • Interaction with the onshore team on daily basis (Agile Scrum) for the development/Support and issues handling. • Done deliverables on time.

Experience

1. Software Developer

   VISTRA

   Nov 2021 — Present · Mumbai, IN

   1.IICS ETL Development: Design and develop ETL pipelines using Informatica Intelligent Cloud Services (IICS) for data extraction, transformation, and loading.2. Snowflake Integration: Integrate and load data from multiple sources into Snowflake data warehouse; optimize queries and performance.3. Data Modeling: Implement data models in Snowflake, ensuring proper schema design and data structure.4. Power BI Development: Design and develop interactive Power BI reports and dashboards based on business requirements.5. Data Transformation: Perform data transformation using IICS and ensure quality data is loaded into Snowflake for reporting.6. Performance Tuning: Optimize ETL jobs, Snowflake queries, and Power BI reports for better performance and faster response times.7. Data Quality Assurance: Implement data quality checks and validations to ensure accurate and reliable reporting.8. Automation: Automate ETL workflows in IICS and schedule data loads into Snowflake for seamless reporting.9. Collaboration: Work with data architects, business analysts, and stakeholders to understand requirements and deliver data solutions.10. Troubleshooting: Monitor, debug, and resolve issues in ETL pipelines, Snowflake queries, and Power BI reports.

Education

• Willingdon College Of Arts and Sciences, Sangli

  Bachelor of Computer Science

  2007 — 2010

• Siddhant Institute of Business Management, A/p. Sudumbare, Tal. Maval, Dist.Pune 412109

  Master of Computer Applications - MCA

  2010 — 2013