ETL Developer

Matrix Consulting

Description

● Minimum 5 years of overall ETL and Data warehousing experience.

● Minimum 3 years of hands-on experience in Informatica Intelligent Cloud Services (IICS) implementation.

● Minimum 3 years of hands-on experience in the Design of high-level technical specification, Solution design, Build and Test –Mappings, Task Flows, MCT and application requirements in IICS.

● Minimum 3 years of hands-on experience in integrating multiple cloud applications (like Salesforce) using Informatica Intelligent Cloud Services.

● Working knowledge on how to configure the properties/connections at system, environment, and secure agent level for the IICS objects.

● Be able to design and develop REST/SOAP based webservices as a provider also as a consumer.

● Must have working knowledge on Service Connectors, Snowflake, SQL Server/Oracle connectors, Postgres, JDBC, Rest API.

● Should be familiar with Sales force and Service Now systems or should have integrated one of these.

● Should have strong knowledge around IICS features like Error Handling, In Out Parameter, LastRunTime, LastRunDate, Parameter files etc

● Should have strong focus on operational excellence to ensure healthy service levels for production work loads.

● Should be familiar with Agile (Scrum) methodology.

● Good to have exposure to working with Kafka.

● Nice to have knowledge about Databricks.

● Strong problem solving, analytical skills and ability to multitask.

● Should have excellent written and verbal communication skills.

● US mortgage domain knowledge is preferred.

● Flexible in terms of work location and timings.

● Nice to have Snowflake cloud data warehouse knowledge.

● Nice to have working knowledge on Python scripting.

Key Skills:

IICS, informatica cloud, salesforce, Snowflake, SQL Server, Postgres, REST API, SCRUM, Data warehousing.

Education Level

• Four-year college degree or equivalent combination of education and experience

• Experience

  5 - 11 Years

• No. of Openings

  2

• Education

  B.E, B.Sc, M.C.A, M.Tech, M.Sc

• Role

  ETL Developer

• Industry Type

  IT-Hardware & Networking / IT-Software / Software Services

• Gender

  [ Male / Female ]

• Job Country

  India

• Type of Job

  Full Time

• Work Location Type

  Work from Office