This job offer is not available in your country.

Senior Data Engineer - ETL Lead

Anicalls (Pty) LtdChennai, Tamil Nadu, India

3 hours ago

Job description

Over 9+ Years of Experience in IT and Data warehousing, ETL (Extract, Transform and Load)

Experience in Informatica (Power center / Power Mart / Power Exchange).

Experience in SQL Server with CUBE

Extensively experience on ETL Informatica Transformations using Lookup, Filter, Expression, Router, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator and created complex mappings.

Experience in implementing the entire life cycle of the project

Experience in Unix Shell Scripts for automation of the ETL process.

Should be able to provide the end to end architecture of the ETL process for loading staging / landing zone and audit control process.

Experience in creating detailed technical design documents, including the Source to target mapping docs.

Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins, and hash indexes in Oracle / Teradata and Postgre SQL databases.

Expertise in Data modeling techniques like Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.

Experienced in the Performance of Mapping Optimizations in Informatica.

Create a job alert for this search

Senior Data Engineer • Chennai, Tamil Nadu, India