Responsibilities Collaborate with business analysts, developers, and data scientists to understand data requirements and create data integration solutions using Informatica IICS Extract, transform and load data from various sources including databases, APIs, and flat files Create and maintain data mapping documents, technical design documents, and test cases for data integration solutions Conduct unit testing, integration testing, and system testing of data integration solutions to ensure accuracy and quality Troubleshoot and resolve data integration issues by analyzing logs, debugging code, and working with cross-functional teams Develop and maintain automated data integration processes to ensure data accuracy, consistency, and reliability Provide technical expertise and guidance to team members on Informatica IICS and data integration best practices Participate in code reviews and ensure all solutions are lined to architectural and requirement specifications and provide feedback on code quality, design, and performance.Specifies data storage requirements.Builds a data warehouse for the organization's internal departments utilizing various data warehousing techniques.Creates and improves data solutions that allow for smooth data delivery, and is in charge of gathering, processing, maintaining, and analyzing huge amounts of data.Leads the design of the logical data model, implementation of the physical database structure, as well as the construction and implementation of operational data stores and data marts.Design, automate and support sophisticated applications for data extraction, transformation, and loading.Ensures the accuracy of data.Creates logical and physical data flow models for ETL applications