Jignesh Mendpara

About Jignesh Mendpara

Experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica Powercenter. • Strong business understanding of verticals like Banking, Finance, Energy, Retail, Telecommunications and Healthcare domains. • Extensively used Informatica client tools - Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor. • Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica. • Involved in complete System Software development Life Cycle (SDLC) of Data warehousing, Decision Support System. • Worked with Informatica Data Quality (IDQ) toolkit for Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ. • Participating in problem solving and troubleshooting for the applications implemented. • Experience with dimensional modeling using star schema and snowflake models. • Expertise in SQL, PL/SQL and having good knowledge of UNIX. • Extensive experience in Client Server technology area with Oracle Database, SQL Server, DB2 and PL/SQL for the back end development of Packages, Stored Procedures, Functions and Triggers. • Experience in Unit testing, Integration Testing and System testing. • Exceptional analytical and problem solving skills. Team Player with the ability to communicate effectively at all levels of the development process, ambitious and hard working with commitment to excellence.

Experience

1. Sr, Etl Informatica Idmc Iics

   NTT DATA

   Sep 2023 — Present · Charlotte, NC, US

Education

• Sir P P Science college

  Bachelor’s Degree, I.C

  2003 — 2006

• APTECH

  Associate’s Degree, Computer Software and Media Applications

  2003 — 2004