Summary
Overview
Work History
Education
Skills
Affiliations
Certification
Accomplishments
Languages
References
Work Availability
Work Preference
Software
Portfolio
Timeline
Generic
Sayantan Pramanik

Sayantan Pramanik

ETL Tech Lead/Architect
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
2
2
Certification
4
4
years of post-secondary education

Work History

Informatica Cloud Architect/REST API

IQVIA
Spring, TX
02.2024 - Current
  • Project: IPSEN ETL/MDM Integration with OneKey API
  • 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
  • Project: Collegium Hosted Informatica MDM/ETL Implementation
  • 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
  • Project: AbbVie/Allergan DevOps.
  • 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
  • Project: ConMed Informatica MDM Implementation.
  • 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
  • Project: MDM DIS Upgrade
  • 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
  • Project: Collegium Customer Data Warehouse.
  • 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
  • Project: Coherus CDM
  • 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
  • Project: Takeda Pharmaceuticals.
  • 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/ Quinnox Inc.
Houston, TX
10.2013 - 05.2018
  • Project: ETL Development and Support.
  • 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
  • Project: WM Accident Injury Management System (AIMS) v2.0
  • 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

LeadWaste Management Inc
Houston, TX
01.2018 - 03.2018
  • Project: WM Fastlane Disposal e-Manifest Project.
  • 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
  • Project: WM Canada reporting
  • 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
  • Project: WM Salesforce Data Integration.
  • 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
  • Project: WM Service Delivery Optimization (SDO)
  • 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
  • Project: WM EBIZ BAMs Project
  • 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
  • Project: WM MAS to OCS Route Automation (OCSD)
  • 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
  • Project: WM Customer at a Glance (CAAG)
  • 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
  • Project: Finance Cubes Automation (ETL/Essbase)
  • 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, Waste Management Inc
Bangalore, India
04.2011 - 10.2013
  • Project: Waste Management Development and Support
  • 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

Bachelors of Technology - Computer Science And Engineering

Techno India
Kolkata, India
06.2002 - 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

Affiliations

  • 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.

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.

Languages

English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2

References

References available upon request.

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Work Preference

Work Type

Full Time

Work Location

HybridRemote

Important To Me

Personal development programsHealthcare benefitsWork from home optionPaid time offWork-life balanceCareer advancementCompany CultureFlexible work hoursPaid sick leave

Software

Informatica IICS

Informatica Powercenter

Oracle SQL

Informatica MDM

Portfolio

Featured Picture
Informatica Specialist Certification

Timeline

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

LeadWaste 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/ Quinnox 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, Waste Management Inc
04.2011 - 10.2013

Bachelors of Technology - Computer Science And Engineering

Techno India
06.2002 - 06.2006
Sayantan PramanikETL Tech Lead/Architect
Resume profile created at Resume-Now.com