Job Summary:
We are seeking a skilled and experienced Data pipeline engineer who has a solid background in design and development of ETL pipelines, SQL, Database Design with expertise in Informatica to join our team. In this role, you will be responsible for designing, developing, testing, and maintaining ETL processes that extract data from various sources, transform it to meet business requirements, and load it into target systems. The ideal candidate should have a strong understanding of data warehousing concepts and experience in designing and implementing data integration solutions using Informatica. You will work closely with cross-functional teams including business analysts, developers, and data scientists to understand data requirements, extract data from various sources, and transform and load it into target systems using Informatica.
Responsibilities:
Collaborate with business analysts, developers, and data scientists to understand data requirements and create ETL solutions using Informatica
Create, maintain, and optimize stored procedures, functions, inline SQL,



database structures, and ETL processes to adapt to changes in needs and requirements
Develop and maintain ETL workflows using Informatica PowerCenter.
Perform data profiling, cleansing, and transformation using Informatica tools.
Design and implement data quality checks and error handling mechanisms to ensure data accuracy and completeness.
Monitor and troubleshoot ETL jobs to ensure data integration processes run smoothly and meet performance standards.
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 ETL pipeline 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-functiona

📌 Informatica Developer (Bengaluru)
🏢 Vimerse Infotech
📍 Bengaluru