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.Sc, B.Tech/B.E, M.C.A, M.Sc, M.Tech

Role : ETL Developer

Industry Type : IT-Hardware & Networking / IT-Software / Software Services

Gender : [ Male / Female ]

Job Country : India