Informatica IICS Integration Developer

algoleap; Gurugram District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

algoleap is seeking an Integration Specialist with strong experience in data integration, governance, and ETL development. You will work across multi-cloud, hybrid, and on‑prem systems, leveraging Informatica IICS and IDQ to ensure data quality and timely delivery.

Proficiency in Salesforce and scripting in Python/Java is expected. The role involves design, development, testing and deployment activities, with a focus on building robust data workflows and real-time or batch integrations.

Qualifications

• B-Tech or MCA with strong data integration background.
• Experience in designing, developing and deploying ETL workloads.
• Knowledge of multi-cloud/integration governance is required.

Responsibilities

• Data integration across multi-cloud, hybrid and on-prem systems using Informatica IICS.
• APIs development in Informatica using REST and SOAP protocols.
• Involvement in POC to evaluate feasibility and effort of integrations.
• Data quality and master data management in Salesforce CRM and IDQ.
• Build/optimize mappings to upload data from Concur, Stripe, Financial Force and JSON/XML files.
• Develop scripts in Python/Java and understand AWS concepts.

Skills

Data integration

Informatica

API development

Python/Java

RDBMS skills

Salesforce

Informatica IDQ

ETL mappings

JIRA

Data quality

Education

B-Tech

MCA

Tools

Informatica

IDQ

Salesforce

SQL

REST/SOAP

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.