Verify that the exact ETL requirements are recorded for every requirement.
Design ETL pipeline to read from various sources including on-premise databases, and files, and to prepare the feed for the downstream systems that includes external systems as well.
Critical understanding of data security standards and data safety, data auditing and hands-on implementation around these.
Solid analytical and development experience expertise and understanding.
Determine performance problems with the extraction of the source system and independently work on technical Proofs of Concept in Snaplogic and any new ETL tool if required.
Hands-on experience with Snaplogic in a cloud environment especially AWS Cloud,
Ensure that the requirements and design are appropriate for the purpose and well documented.
Collaborate with IT team members, business application owners, and external partners to ensure the smooth integration of many systems and data sources.
Develop, test, and deploy API-based connections between internal and external systems to ensure seamless data flow and communication.
Collaborate with business analysts and other SMEs to map data fields, perform data transformations, and maintain data consistency across several systems.
Assist in defining the CICD process for the application's unique components.