Manish Semwal Email & Phone Number

Pune, Maharashtra, India

-Led the redesign and implementation of enterprise-wide ETL processes using Informatica and Talend.-Established a structured framework for data error handling to streamline troubleshooting and ensure smooth ETL operations.-Coached and trained a team of several professionals in advanced data integration techniques, enhancing their expertise and productivity.-Implemented CI/CD practices to accelerate code deployment and enhance development efficiency within ETL workflows.-Advocated for the adoption of Docker for containerization in ETL tasks, improving resource utilization and scalability.-Managed a team of 7 Developers, providing guidance and overseeing their professional development.

Pune, Maharashtra, India

-Led the design and development of ETL processes to extract data from multiple sources, transform it according to business requirements, and load it into target databases or data warehouses.-Optimized ETL jobs for performance efficiency, scalability, and reliability, handling large volumes of data effectively.-Implemented best practices and standards for data quality assurance, including data cleansing, validation, and error handling mechanisms.-Collaborated closely with data architects, business analysts, and stakeholders to understand data requirements and translate them into technical solutions.-Mentored and guided junior developers, providing technical leadership and expertise in ETL tools and methodologies.-Conducted performance tuning, troubleshooting, and debugging of ETL workflows to maintain data accuracy and optimize processing times.-Documented ETL designs, data mappings, and operational procedures for transparency and knowledge sharing within the team.-Participated in project planning, estimation, and risk management activities to ensure timely delivery and alignment with business objectives.

Mumbai Area, India

-Supported senior developers in designing and implementing ETL processes.-Worked on writing and optimizing SQL queries for data extraction and transformation.-Assisted in data cleansing, validation, and error handling procedures.-Participated in testing and debugging of ETL workflows to ensure data accuracy and reliability.-Documented ETL processes, data mappings, and troubleshooting steps.-Learned and applied best practices in ETL development and data integration.-Collaborated with cross-functional teams including data analysts, business stakeholders, and IT support to meet project requirements.

Mumbai Area, India

-As a freelancer, I worked on several Data Integration and Management projects. I was involved in end-to-end development of several analytical and operational systems. I worked on multiple solution designs including EDI/EDIFACT exchange systems. These engagements included development on Informatica Powercenter, Informatica B2B Data Transformation and Informatica B2B Data Exchange.-Implemented optimized ETL processes that significantly reduced data processing times and enhanced overall system performance.-Introduced automation strategies and best practices to streamline data integration workflows, resulting in notable efficiency gains.-Engaged directly with clients to gather requirements, provide updates, and ensure alignment with project objectives, maintaining high client satisfaction.-Provided continuous support and maintenance for ETL solutions, promptly addressing client inquiries and issues with a high rate of resolution.-Optimized ETL jobs for improved performance efficiency, effectively managing large data volumes.-Fine-tuned SQL queries, data manipulation processes, and ETL workflows to boost overall performance and data processing speed.

-Conducted tests to verify functionality, performance, and compliance of products with design specifications, ensuring robust development standards and high customer satisfaction.-Developed SQL database queries to extract and manipulate data efficiently.-Drafted and revised manual test cases, optimizing organization to enhance team productivity.

-Managed daily operations by leading the implementation of strategies, both short-term and long-term, to achieve business plan objectives and enhance profitability.-Improved customer satisfaction ratings through prompt issue resolution.-Provided coaching and training to 30-40 team members across various client sites.

Orléans, Centre-Val De Loire, France

Worked on numerical modelling of Volcanic degassing and developed a mathematical simplification of the complex system.

Rome, Latium, Italy

Statistical analysis using Italian data on seismic activity.