Sayantan Pramanik
Spring,TX
Summary
Accomplished Informatica Cloud Architect with extensive experience at IQVIA, specializing in data integration and REST API development. Proven track record in optimizing ETL processes and enhancing data quality. Adept at stakeholder communication and cloud architecture design, driving successful project outcomes through innovative automation solutions.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Informatica Cloud Architect/REST API
IQVIA
Spring, TX
02.2024 - Current
- Designed and developed IDMC CDI data integration processes for ingestion from Ipsen DCRs into OneKey REST APIs.
- Pushed API response data using Swagger file definitions into Ipsen landing tables.
- Designed and developed complex Informatica mappings, tasks, and taskflows in IDMC CDI.
- Created and modified SWAGGER files to integrate REST API definitions into IICS Web-Service transformations.
- Developed search-before-create functionality, utilizing DCR data for integration with Iqvia OneKey API via Informatica's REST V2 connector.
- Collaborated with stakeholders to ensure the successful deployment of applications on the cloud platform.
- Developed architectural diagrams depicting high-level designs incorporating components such as databases, IDMC processes, and storage systems deployed on the cloud platform.
Informatica Cloud Lead
IQVIA
Spring, TX
01.2022 - Current
- Designed and developed inbound and outbound mappings, tasks, and task flows for data integration.
- Executed data loading from various sources into Informatica MDM, ensuring quality checks and match merging.
- Configured trust settings and trust decay for diverse source data within MDM HUB.
- Developed validation rules for specific column/DSP combinations to enhance data accuracy.
- Installed and administered Informatica PWC and IDQ v10.5 on a fresh EC2 instance.
- Created complex Oracle SQL views and stored procedures to facilitate MDM publish process.
- Added LOVs to cleansing functions, enhancing lookup values for MDM lookup tables.
- Designed, developed, and tested Informatica Data Quality mappings for implementing data cleansing rules.
ETL/MDM Tech Lead/Architectural Designer
IQVIA
Houston, TX
07.2022 - 12.2023
- Led Informatica ETL enhancements and automations for PowerCenter and IICS, optimizing data workflows.
- Managed three-member offshore team and two-member onsite team in Allergan/AbbVie DevOps engagement.
- Automated manual jobs to streamline daily and weekly ETL/MDM processes on PowerCenter and IICS.
- Collaborated with AbbVie testing teams to troubleshoot defects related to ETL enhancements.
Onsite Informatica Cloud Developer/IDQ
IQVIA
Spring, TX
01.2021 - 12.2021
- Developed inbound and outbound mappings, tasks, and task flows for data loading into Informatica MDM.
- Designed and implemented data quality checks and match merging processes.
- Executed data loading from AWS S3 to MDM landing tables using S3 connector.
- Created IDQ mappings on ConMed-hosted platform to enforce data quality rules.
- Collaborated with stakeholders to obtain business logic for effective mapping solutions.
- Streamlined processes for staging and outbound data file generation.
- Enhanced data integration strategies to ensure accuracy and efficiency in workflows.
Onsite Informatica Cloud Developer/Consultant
IQVIA
Houston, TX
10.2020 - 12.2020
- POC: MySQL to SFDC real-time data load using IICS CAI.
- Modified complex SFDC enterprise WSDL APIs using CAI processes for seamless integration.
- Designed and developed simple and medium Informatica Cloud application integration processes.
- Passed variables from MySQL database to upsert data into SFDC effectively.
- Troubleshot problems with existing applications running on the cloud platform.
Onsite Informatica Cloud Developer/Consultant
IQVIA
Houston, TX
05.2020 - 09.2020
- Developed and tested simple and medium ETLs for MDM DIS upgrade project.
- Upgraded ETL code from Talend to IICS platform, enhancing data-load performance.
- Designed, developed, and unit-tested ETLs to meet project specifications.
- Utilized Python scripts with Django and Boto libraries for S3 file transfer processes.
- Collaborated with testing team to troubleshoot and resolve QA and integration defects.
ETL Developer/Consultant Engineer
IQVIA
Houston, TX
09.2019 - 04.2020
- Designed, developed, and tested simple to complex Redshift queries for Collegium Pharmaceuticals.
- Collaborated with testing team to troubleshoot and resolve QA and integration defects.
- Executed unit testing on a variety of Redshift queries to ensure optimal performance.
Talend Developer
IQVIA
Houston, TX
02.2019 - 08.2019
- Designed, developed, and unit-tested medium Talend mappings for Coherus Biosciences.
- Worked closely with database administrators in order to resolve any SQL related issues during job execution.
- Collaborated with testing team to troubleshoot and resolve QA and integration defects.
- Provided expert consultation on Talend development to enhance project outcomes.
Senior Informatica Developer
IQVIA
Houston, TX
07.2018 - 01.2019
- Designed and developed medium to complex Informatica mappings for Takeda Pharmaceuticals.
- Conducted design, development, and unit testing on mappings utilizing XML and various unstructured data sources.
- Identified performance bottlenecks in existing mappings by analyzing session logs and modified them accordingly.
- Designed complex mappings involving multiple sources and targets with various transformations like Lookup, Joiner, Router, Aggregator, Expression.
- Collaborated with testing team to troubleshoot and resolve QA and integration defects.
Informatica Developer/Lead Engineer
Waste Management Inc
Houston, TX
10.2013 - 05.2018
- Developed flagship OCS for vehicle tracking, generating significant revenue for WM.
- Sourced data from various systems, including OCSD and MAS, into a staging schema.
- Applied business logic to stage data and pushed it to a Datamart schema for reporting.
- Led five-member support team providing 24x7 maintenance for 80+ critical ETL applications.
- Gathered project requirements and communicated high-level design to development teams in India.
- Migrated Informatica jobs and connection strings across environments during deployment.
- Implemented ETL solutions integrating with Salesforce, AWS S3, and Amazon Aurora MySQL DB.
- Optimized existing mappings through partitioning based on volume or complexity of the data sets being processed.
- Created data flow diagrams using MS Visio and Lucid charts to document complex ETL processes.
- Worked on Debugging existing mappings and resolving issues in mapping logic.
- Implemented various performance tuning techniques for improving the performance of the mappings.
- Documented all ETL processes according to corporate standards.
- Developed shell scripts for scheduling jobs and PMCMD commands for FTP of files from remote servers in Linux.
Senior Informatica ETL Developer
Waste Management Inc
Houston, TX
11.2015 - 04.2018
- Designed and developed ETL processes for vehicle, property, and accident loaders in AIC system.
- Performed troubleshooting of existing production jobs when needed.
- Created reusable PowerCenter sessions with parameterized datestamps for annual historical incidents data loading.
- Utilized Informatica Developer to enforce data quality and standardization rules before data transfer to AIC.
Senior Informatica ETL Developer/Informatica Developer/Lead Engineer
Waste Management Inc
Houston, TX
01.2018 - 03.2018
- Directed offshore ETL team to design processes for consuming binary blob disposal files from Fastlane Oracle DB.
- Converted binary data into PDF files for streamlined access and management.
- Resolved complex issues related to ETL process through debugging existing code or writing new programs.
- Optimized queries by analyzing query plans using SQL profiler tool.
Informatica ETL Developer/Lead
Waste Management Inc
Houston, TX
06.2017 - 01.2018
- Spearheaded design and development of ETL batch processes for payment transaction transfers to AWS MySQL database.
- Standardized reference data using IDQ Standardizer transformation prior to AWS cloud database integration.
- Engineered ETL and ELT workflows to ingest AWS Aurora MySQL payments data into on-premises Netezza warehouse for reporting.
Informatica ETL Developer/Senior Informatica ETL Developer/Informatica Developer/Lead Engineer
Waste Management Inc
Houston, TX
01.2014 - 01.2018
- Developed nightly ETL processes for batch processing customer data from WM's iSeries AS/400 DB2 into Salesforce objects.
- Leveraged Power Exchange CDC for real-time data replication from AS/400 DB2 to Oracle staging database.
- Employed Informatica Cloud for seamless synchronization of data into SFDC objects.
- Executed PowerCenter batch ETLs for historical data loads post major SFDC releases.
Lead Informatica ETL & Netezza Developer
Waste Management Inc
Houston, TX
11.2016 - 02.2017
- Engineered ETL and ELT code for Netezza, consolidating Peoplesoft HR, PMT, and Talent data for SDO report.
- Utilized Tableau to present prototype data to end users from SDO table.
- Collaborated with end users to gather requirements, creating techno-functional documents for data integration.
Informatica ETL Developer/Senior Informatica ETL Developer/Informatica Developer/Lead Engineer
Waste Management Inc
Houston, TX
01.2016 - 03.2016
- Directed ETL team to develop feeds for transferring transactional payment data from CyberSource to MAS and eBiz systems using XML/XSDs.
- Provided technical support to other team members regarding ETL development activities.
- Diagnosed and corrected QA bugs encountered during QA, SIT, and data validation testing with users.
Informatica ETL Developer/Lead
Waste Management Inc
Houston, TX
01.2015 - 10.2015
- Spearheaded design and development of new ETL processes to convert existing ESB mappings into ETL code.
- Worked closely with Business Analysts, System Analysts, Data Architects in gathering requirements for developing ETL solutions.
- Conducted troubleshooting and performance tuning of ETL mappings to enhance throughput.
ETL Informatica Developer
Waste Management Inc
Houston, TX
11.2014 - 03.2015
- Developed ETL processes to transfer WM customer data from MAS billing system to Elasticsearch server.
- Converted relational customer master data into JSON string format using Informatica transformations.
- Created reusable PowerCenter designer mapplet for conversion of relational customer master data to NoSQL string.
- Coordinated with Quality and User Acceptance teams to troubleshoot issues during Quality and Production activities.
ETL Informatica Developer
Waste Management Inc
Houston, TX
10.2013 - 03.2014
- Collaborated with financial analysts to gather requirements for ETL specifications.
- Designed and developed ETL processes integrating data from PeopleSoft Finance and PMT databases.
- Generated Essbase files containing financial consolidation, aggregated volume, rate change, and budgeting information using ETL transformations.
ETL Developer/Offshore ETL Developer/Technology Lead
Quinnox Consultancy Services
Bangalore, India
04.2011 - 10.2013
- Led ETL support team, ensuring 24/7 maintenance for 80+ business-critical applications at Waste Management Inc.
- Conducted requirement analysis and developed applications, including onboard computing and pricing tools.
- Owned critical ETL applications like OCS, Fastlane, wm.com, and Salesforce; implemented solutions for production issues.
- Executed performance tuning on both functional and mapping levels to enhance efficiency.
- Utilized relational SQLs extensively to reduce network data transfers, improving SLA compliance.
- Developed mappings for Netezza tables from various source systems using diverse mapping logics.
- Provided technical expertise to support team, facilitating collaborative resolution of production issues.
Education
Bachelor of Technology - Computer Science and Engineering
Techno India Institute of Technology
06.2006
Skills
- Data integration
- REST API development
- ETL processes
- Cloud architecture
- Informatica Cloud
- SQL development
- Data quality
- Performance tuning
- Automation solutions
- System troubleshooting
- Data governance
- Stakeholder communication
- Cloud infrastructure design
Certification
- Received Informatica Specialist Certification for PowerCenter Data Integration 10: Developer, Specialist.
- Attended 19 days long National Astrophysics Olympiad at Mumbai. Received participation awards.
Accomplishments
Received multiple appreciations from the IQVIA and Waste Management IT and business owners for commendable work on performance tuning of SLA critical data load processes, and for creating integrations with new and upcoming cloud technologies.
Activities
- Coached Informatica and the SDO project's data integration process trainings at WM.
- Competed and won in nature, wildlife as well as portrait photography events.
- Won the 2004 intra and inter-college chess tourney.
Work Preference
Work Type
Full TimeWork Location
RemoteHybridImportant To Me
Work-life balanceCareer advancementWork from home optionFlexible work hoursPersonal development programsTimeline
Informatica Cloud Architect/REST API
IQVIA
02.2024 - Current
ETL/MDM Tech Lead/Architectural Designer
IQVIA
07.2022 - 12.2023
Informatica Cloud Lead
IQVIA
01.2022 - Current
Onsite Informatica Cloud Developer/IDQ
IQVIA
01.2021 - 12.2021
Onsite Informatica Cloud Developer/Consultant
IQVIA
10.2020 - 12.2020
Onsite Informatica Cloud Developer/Consultant
IQVIA
05.2020 - 09.2020
ETL Developer/Consultant Engineer
IQVIA
09.2019 - 04.2020
Talend Developer
IQVIA
02.2019 - 08.2019
Senior Informatica Developer
IQVIA
07.2018 - 01.2019
Senior Informatica ETL Developer/Informatica Developer/Lead Engineer
Waste Management Inc
01.2018 - 03.2018
Informatica ETL Developer/Lead
Waste Management Inc
06.2017 - 01.2018
Lead Informatica ETL & Netezza Developer
Waste Management Inc
11.2016 - 02.2017
Informatica ETL Developer/Senior Informatica ETL Developer/Informatica Developer/Lead Engineer
Waste Management Inc
01.2016 - 03.2016
Senior Informatica ETL Developer
Waste Management Inc
11.2015 - 04.2018
Informatica ETL Developer/Lead
Waste Management Inc
01.2015 - 10.2015
ETL Informatica Developer
Waste Management Inc
11.2014 - 03.2015
Informatica ETL Developer/Senior Informatica ETL Developer/Informatica Developer/Lead Engineer
Waste Management Inc
01.2014 - 01.2018
Informatica Developer/Lead Engineer
Waste Management Inc
10.2013 - 05.2018
ETL Informatica Developer
Waste Management Inc
10.2013 - 03.2014
ETL Developer/Offshore ETL Developer/Technology Lead
Quinnox Consultancy Services
04.2011 - 10.2013
Bachelor of Technology - Computer Science and Engineering
Techno India Institute of Technology
Similar Profiles
Sarah VillarroelSarah Villarroel
Data Management Assistant at IQVIAData Management Assistant at IQVIA
Elizabeth AndrewElizabeth Andrew
Senior Talent Acquisition Consultant at IQVIASenior Talent Acquisition Consultant at IQVIA
Mohit KumarMohit Kumar
Senior Test Lead at IQVIASenior Test Lead at IQVIA
SUJEET KUMAR DASSUJEET KUMAR DAS
Software Developer at IqviaSoftware Developer at Iqvia
Adam J DavisAdam J Davis
Territory Manager, Texas at Agiliti HealthTerritory Manager, Texas at Agiliti Health