Chayan Roy Patwary

Lead ETL Data Engineer specializing in Informatica IDMC, PowerCenter, and end-to-end ETL pipeline delivery on Cloud (AWS/Azure) and On-premises platforms. Designs, develops, tests, and migrates data flows for PC to IICS conversion work, translating requirements into user stories and execution plans in Azure DevOps and Jira. Supports deployment planning through Azure Pipelines and VSDS while applying Agile and SAFe Scrum practices across delivery teams.

IICS Cloud Data Integration Services Certification

LTM – Current Organization

Lead ETL Developer - Capital Group Projects [2023-08 - Current]

• Capital Group (CG) is a U.S.-based financial services company with a data mastering platform utilizing Informatica MDM and PowerCenter ETL architecture.
• Technology Stack - Informatica CDI-PC, Informatica MDM, Autosys, SQL SERVER, POSTGRESQL, Unix, Python, AWS S3, EC2.
• Acting as ETL Lead - Helping team to gather requirements, planning assignments/task, review and deployment planning.
• Collaborating with stakeholders to analyze requirements and discuss ETL solutions.
• Designed and build ETL pipelines using with thorough unit testing, peer review.
• Optimized ETL performance with thorough analysis of ETL workflows by detecting performance bottlenecks.
• Mentored junior developers in ETL best practices, boosting overall team productivity and knowledge.
• Helped build automation tools using python+batch tp improve deployment packaging and reduce manual effort to saving time and resources.
• UAT support, Production go-live hyper-care support

Informatica Migration Factory Consultant - Volvo [2022-11 - 2023-07]

• Under the contract of Informatica Professional Services (IPS), I have worked as Migration Factory Consultant
• Configured RPA tools for asset conversion.
• Validated IICS assets and resolved conversion errors.
• Conducted dry run testing and data validation for all assets.
• Worked with GCS team in case of Informatica Product related issues.

Informatica Migration Factory Consultant - NYC DOITT [2022-10 - 2022-10]

• Department of Information Technology and Telecommunications in New York. It was a Informatica PC to IICS migration project.
• RPA tools configuration for asset conversion. and validated IICS assets.
• Resolved PDO compatibility issues and fixed conversion errors.
• Department of Information Technology and Telecommunications in New York.

Senior ETL Developer - Japan Tobacco [2022-07 - 2022-09]

• Responsible for understanding functional requirements from Japanese stake holder and transformed business logic into data transformation logic.
• Implemented PowerCenter workflows and Informatica DIH [Data Integration Hub] processes with"Pub-Sub" [Publisher-Subscriber] architecture for different "Topics".
• Delivered code with thorough unit testing with standardized documentation/artifacts in "Agile"project development cycle.

IICS Administrator - Novo Nordisk [2022-06 - 2022-07]

• Analyzed SSO setup requirements and pre-requisites.
• Configured SSO/SAML on Azure and IICS, synchronized users, roles, and groups.
• Tested single sign-on(SSO) functionality.

Senior IICS Developer - Deloitte Audit & Assurance [2021-09 - 2022-04]

• Collaborated with stakeholders/product owners during Program Incremental Planning [PI Planning] as part of SAFe Agile scrum process and recurrent scrum sessions to understand business requirements.
• Worked with design/solution architects to understand data model and architecture to design ETL pipelines using IICS.
• Delivered product backlog items in agile manner with thorough unit testing, peer reviews and standardized documentation.

Cognizant – Past Organization

IICS Developer and Administrator - Wellmark Blue Cross Blue Shield Medical [2021-01 - 2021-07]

• A major US-based Blue Shield medical insurance company. The project is to enable business to build and maintain its data warehouse and data lakes for various business modules.
• Collaborated with stakeholders to gather requirements, analyzed requirements and transformed business logic into data transformation logic.
• Designed end to end data integration pipeline using IICS/ICDI, Amazon S3, Dynamo DB and ActiveBatchand developed ICAI processes for near realtime data ingestion.
• Delivered code with thorough unit testing with standardized documentation/artifacts in "Agile"project development cycle.
• Conducted defect analysis and resolution.
• Supported IICS admin activities part-time for deployments, users AD account access configuration, server downtime maintenance.

IICS Developer - Mattel Corporation [2019-05 - 2020-02]

• Collaborated directly with customer to understand requirements and developed ETL using IICS/ICDIand integrated ETL data flows with Blackline API.
• Delivered code with thorough unit testing with standardized documentation/artifacts.

ETL Developer - Wyndham Hotel Group [2017-12 - 2019-04]

• Analyzed requirements and developed PC mappings and workflows in collaboration with onsite coordinator and business analyst.
• Implemented Powercenter workflows and unix scripts to build end to end ETL processes.
• Performed thorough unit testing and produced documents
• Analyzed defect root cause and provided resolution.
• Delivered packaged deployable code components.
• Worked as part of Data Maintenance team also to fix L3 productions issues with SLA.

ETL Developer - First Data Corporation [2016-09 - 2017-11]

• A major US-based financial company.
• Analyzed requirements in collaboration with onsite coordinator and developed PowerCenter mappings and workflows.
• Worked with workload automation tools like Appworx.
• Worked in collaboration with Informatica expertise Team (COE) team debug performance issues and find optimized solutions.
• Performed unit testing as part of project delivery
• Worked on defect analysis to provide resolution.
• Post Production Hypercare Support.

Music, Gardening, Motorcycle, Cycling, Painting.