ETL Developer

JD

Experience : 5-12 years (min 5 years in Informatica Power Center + DWH
Development ) IICS basic development/mig skills is a plus. ETL Development
project for Data Warehouse program with a strong Sql and data analysis
skills in either of ANSI db (Teradata, Oracle, Sql server etc) with onsite
coordination experience with offshore and customer interfacing role. Banking
domain is a plus

ETL skills: strategies, adept in writing complex SQL queries and
understanding Queries as well. He / She should be able to understand the
Data warehousing, concepts such as schema types, Dimensions, facts, SCD
concepts and Basic data modelling/data architecture concepts, pushdown
optimization, partitioning. understand the properties and uses of various
transformations and functions available for use in Informatica as well as
SQL. Should have knowledge of basic data cleansing, load balancing,
performance tuning, parameterization as well as Data integration from
various types of sources.

DB skills: Relational database management systems basic knowledge is a must,
along with the capacity to create logics to perform various functions in an
efficient and error free manner, should at least knowhow to create
algorithms to perform specific functions which could later be translated in
any required programming language. Knowledge of any other programming
languages like Python, APIs, Stored procedure development, Data Marts, Data
Visualization tools,, KPI extraction, Scheduling tools, Unix or batch
scripting and other BI reporting tools is a plus point.