Intern, Integrations

Overview Cvent is a leading meetings events and hospitality technology provider with more than 4 800 employees and 22 000 customers worldwide including 53 of the Fortune 500 Founded in 1999 Cvent delivers a comprehensive event marketing and management platform for marketers and event professionals and offers software solutions to hotels special event venues and destinations to help them grow their group MICE and corporate travel business Our technology brings millions of people together at events around the world In short we re transforming the meetings and events industry through innovative technology that powers the human connection The DNA of Cvent is our people and our culture has an emphasis on fostering intrapreneurship - a system that encourages Cventers to think and act like individual entrepreneurs and empowers them to take action embrace risk and make decisions as if they had founded the company themselves At Cvent we value the diverse perspectives that each individual brings Whether working with a team of colleagues or with clients we ensure that we foster a culture that celebrates differences and builds on shared connections About the Role 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 In This Role You Will 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 Here s 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 LI-DNI