Intern, Integrations

• Data integration across multi-cloud, hybrid and on-premise systems like Salesforce, Oracle EBS, Marketo etc using Informatica Intelligent Cloud Services (IICS).
• Application integration involving ResT and Soap services.
• 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.
• Utilise JAVA and Python to optimise the application integration
• 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 AWS concepts is good to have.
• Understanding JIRA application and iterative software development methodologies.

Heres What You Need:

• The candidate should have B-Tech 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 analyticalskills 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.