The Role
Design, develop, tune and administer data integrations using Informatica IICS/IDQ across cloud, hybrid and on-prem systems (Salesforce, Oracle EBS, Marketo). Build APIs (REST/SOAP), parse/standardize unstructured data, create complex mappings, write SQL/SOQL, and support testing, deployment, documentation and knowledge transfer.
Summary Generated by Built In
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.
Skills Required
- Experience in Data Integration and Governance projects using Informatica IICS
- Experience with Informatica Data Quality (IDQ) and building web services integrated into ETL
- API development using REST and SOAP with JSON/XSD/XML
- Develop complex Informatica mappings (Lookup, Sorter, Aggregator, Router, SCD handling)
- Ability to parse and standardize unstructured data
- Develop scripts in Python or Java
- Strong RDBMS and DWH/BI conceptual knowledge
- Experience writing SQL on Oracle, SQL Server and Postgres
- Experience with Salesforce and writing SOQL queries
- B-Tech or MCA degree
- Understanding of JIRA and iterative software development methodologies
- Provide knowledge transfer and produce documentation for designs, loads and process flows
- Exposure to MSBI (SSIS)
- Understanding of AWS concepts
- Excellent problem solving, analytical, verbal and written communication skills; ability to work with minimal supervision
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
AlgoLeap specializes in AI-powered software solutions, digital product engineering, and IT consulting services, focusing on digital transformation and AI-driven innovation.
