Informatica IICS Integration Developer

algoleap; Gurugram District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

algoleap is seeking an Integration Specialist to lead data integration and governance across multi-cloud, on-prem and legacy systems. You will focus on code development, performance tuning, and ETL workflow design within Informatica and Salesforce environments.

The role covers design, development, testing and deployment duties, including API development, data quality, and master data management, with strong SQL and scripting skills in Python/Java.

Qualifications

• B-Tech or MCA degree.
• Strong RDBMS & DWH-BI conceptual knowledge.
• Experience writing SQL queries for Oracle, SQL Server and Postgres.
• Provide knowledge transfer and extensive documentation on design, development, implementation, daily loads and process flow of 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-motivated and able to work under minimal supervision.
• Exposure to MSBI/SSIS is a plus.
• Hands-on contributor in projects.

Responsibilities

• Data integration across multi-cloud, hybrid and on-premises systems like Salesforce, Oracle EBS, Marketo etc. using Informatica Intelligent Cloud Services (IICS).
• APIs development in Informatica on Rest & SOAP protocols using JSON/XSD/XML formats for real-time or batch uploads.
• Involvement in POC to evaluate feasibility of integrations on APIs.
• Data Quality structure and master data management solutions in Salesforce CRM.
• Implementation in Informatica Data Quality (IDQ) to build web services and ETL workflows.
• Parse unstructured data and standardise it into understandable business value.
• Develop/optimise complex mappings to upload data from Concur, Stripe, Financial Force, JSON/XML files.
• Develop Salesforce SOQL queries to create metadata for Informatica scripts.
• Create complex Informatica mappings using unconnected Lookup, Sorter, Aggregator, router and SCDs.
• Develop scripts on Python/Java.
• Strong functional understanding of RDBMS & DWH-BI conceptual knowledge.
• Understanding of AWS concepts is good to have.
• Understanding of JIRA and iterative software development methodologies.

Skills

RDBMS & BI

SQL Queries

Informatica IICS

Salesforce SOQL

Python/Java

ETL Mappings

Data Quality

AWS concepts

JIRA

MSBI SSIS

Education

B.Tech or MCA

Tools

Informatica IICS

Informatica IDQ

Salesforce

JIRA

MSBI SSIS

Concur

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 standardise it into understandable and business value added services.
• Develop/optimise 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.