Anish Gupte
Database Engineer (Informatica) @Montefiore Health System
Signup · Get unlimited contacts
WORK HISTORY
Database Engineer (Informatica) @Montefiore Health System
EDUCATION
University of Mumbai
BE, Information Technology
Jamnabai Narsee School
ICSE
University of Maryland
MS, Information Systems
SKILLS
ABOUT ANISH GUPTE
More than 12 years of hands on solid experience in Informatica products both on the cloud as well as on-prem environments.• Experienced in Informatica PowerCenter and Informatica Cloud (IICS-CDI) development, installation and environment upgrades on Windows, Linux platforms as well as cloud based environments such as Microsoft Azure.• Demonstrated extensive expertise with relational DBMS and MySQL, and the ability to integrate technical skills with business objectives.• Deep, progressive experience using various functionalities of Informatica PowerCenter, including transformations - Source Qualifier, Joiner, Look-up (Static & Dynamic Caches), Sorter, Aggregator etc• Expert ETL/data integration skills in developing end to end data pipelines using Informatica PowerCenter v9.1 to v10.5 /Informatica Cloud Data Integration• Proven expertise in designing and developing mappings to load data into data marts/data warehouses to capture initial and incremental loads, maintain historical information using SCD techniques (1,2,3).• Deep experience utilizing Informatica PowerCenter/Informatica Cloud to optimize workflows, perform error logging and debugging and process various data sources including flat files, JSON,XML and databases.• Experienced in Performance Tuning of PowerCenter Jobs using techniques such as Pushdown Optimization, Partitioning and Tuning of various transformations.• Solid exposure to Enterprise Data Catalog (EDC) leveraging the tool to create resources, scan data sources to capture metadata, profiling of various sources, perform similarity profiling, value frequency scans and data lineage.• Extensive experience using Informatica Axon to build data glossaries, data domains, curation of data assets and perform onboarding of technical metadata for end users and stakeholders.• Expert ETL/data integration skills in developing end to end data pipelines using Informatica PowerCenter v9.1 to v10.5 and IICS-CDISpecialties: Informatica ETL skills, PowerCenter, Data Quality, EDC, Axon, Data Analysis, System Engineering. Skilled in database design methodologies using MySQL, Oracle and SQL Server,requirement gathering, and Data Governance.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.