Full Job DescriptionJob 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 Cvent’s 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-premise 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.
Utilized Informatica IDQ Data Analyst Developer for data profiling and matching/removing duplicate data fixing the bad data fixing NULL values.
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
Candidate Requirements:
The candidate should have B-Tech/MCA with 6-8 years of work experience in Informatica Intelligent Cloud Service (IICS) and Informatica data quality (IDQ).
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.