Chayan Roy Patwary

Data Engineer with 9 years of experience specializing in Informatica Cloud (IDMC) and Power Center. Skilled in project requirement analysis, user story creation, and agile methodologies using tools like Azure DevOps and Jira. Experienced in designing, developing, and testing ETL pipelines with Informatica PC and IICS, including Migration Factory projects such as PC to IICS conversion. Proficient in Waterfall and Agile methodologies, with expertise in SAFe Agile Scrum. Competent in deployment planning and execution using Azure Pipelines and VSDS.

IICS Cloud Data Integration Services Certification

LTIMindtree – 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.
• Collaborated with stakeholders to analyze requirements and providing ETL solutions.
• Designed and developed new ETL functionalities using PowerCenter, SQL scripts, Unix Scripts and Python Scripts with thorough unit testing, peer review.
• Wrote and optimized in-application SQL statements.
• Optimized ETL performance with thorough analysis of existing workflows and identification of bottlenecks.
• Mentored junior developers in ETL best practices, boosting overall team productivity and knowledge.
• Implemented process improvement code/application using python to reduce manual intervention in routine tasks, saving time and resources.
• Packaged and deployed code to desired environments, ensuring proper peer reviews and validations.
• 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.