Informatica IICS Integration Developer

AlgoLeap Technologies Pvt Ltd.; Gurugram District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

AlgoLeap Technologies Pvt Ltd. is seeking an Integration Specialist with hands-on experience in data integration and governance.

You will work on integrating our legacy products, CRM applications and financial systems, focusing on code development, performance tuning, and ETL workflow optimization. The role involves design, development, testing and deployment activities with exposure to multi-cloud, on‑premises, and hybrid environments.

Qualifications

• Degree in engineering or computer science required.
• Strong knowledge of data integration concepts and ETL.
• Experience with multiple data sources and platforms.

Responsibilities

• Data integration across multi-cloud, hybrid and on‑prem systems using Informatica.
• Develop APIs with Rest & SOAP using JSON/XML formats for real‑time or batch loads.
• Participate in POC to evaluate integration feasibility and effort.
• Implement Data Quality and master data management in Salesforce CRM.
• Build web services with IDQ and embed in ETL workflows.
• Parse unstructured data and derive business value.
• Develop/optimize mappings for data uploads from Concur, Stripe, etc.
• Write Salesforce SOQL and create metadata for Informatica scripts.

Skills

Data integration

Informatica IICS

API development

Python/Java

RDBMS & DWH-BI

Salesforce

AWS concepts

JIRA

Education

B-Tech

MCA

Tools

Informatica

IDQ

Salesforce

Oracle/SQL

Job description

Job Description:

This is a unique opportunity for an individual with working experience in Data Integration and Governance projects who is seeking new challenges and responsibilities. This Integration Specialist will be working for our cutting-edge technology and integrating them with our entire portfolio of our legacy products, CRM applications and Financial systems. While the prime focus of this position is on code development, performance tuning, optimization and administration. This position will also be responsible with duties ranging from Design, Development, Testing and Deployment activities.

Position Duties

• Data integration across multi-cloud, hybrid and on-premises systems like Salesforce, Oracle EBS, Marketo etc. using Informatica Intelligent Cloud Services (IICS).


• API’s development in Informatica on protocols like Rest & SOAP services using JSON/XSD/XML formats to build real time or batch upload processes.


• Involve in the POC to evaluate the feasibility and effort of implementing integrations on API’s.


• Data Quality structure and master data management solutions in Salesforce CRM.


• Implementation in Informatica Data Quality (IDQ) to build web services and club them into ETL workflows to drive business processes.


• Should use unstructured data, parse and standardize it into understandable and business value added services.


• Develop/optimize complex mappings to upload data from different applications like Concur, Stripe, Financial Force, JSON/XML files etc.


• Developed Salesforce SOQL queries to create metadata pertaining to Informatica scripts.


• Created complex informatica mappings using unconnected Lookup, Sorter, Aggregator, router and tracking slowly changing dimensions for populating data in efficient manner.


• Should be able to develop scripts on python/java.


• Strong functional understanding of RDBMS & DWH-BI conceptual knowledge.


• Understanding on AWS concepts is good to have.


• Understanding on JIRA application and iterative software development methodologies.

Candidate Requirements

• The candidate should have B-Tech/MCA degree.


• Person should have Strong RDBMS & DWH-BI conceptual knowledge.


• Experience in writing SQL queries on various RDBMS like Oracle, SQL server and Postgres.


• Provide Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.


• Supports database platforms and helps define strategies for data acquisition, recovery, migration and archiving.


• Excellent problem solving and analytical skills and outstanding verbal and written communication skills.


• Self-motivation and the ability to work under minimal supervision are a must.


• Exposure to Business Intelligence tool other than Informatica like MSBI (SSIS) would be an added advantage.


• Person should be very hands on and should be able to play individual contributor role technically in some projects.