ETL Developer- Informatica Power Center + DWH Development San Antonio, TX onsite Contract Role Description:
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.
Competencies: Informatica Powercenter, Data Warehouse
This e-mail message may contain confidential or legally privileged information and is intended only for the use of the intended recipient(s). Any unauthorized disclosure, dissemination, distribution, copying or the taking of any action in reliance on the information herein is prohibited. Please notify the sender immediately by email if you have received this email by mistake and delete this e-mail from your system. You have received this email as we have your email address shared by you or from one of our data sources or from our member(s) or subscriber(s) list. If you do not want to receive any further emails or updates, please reply and request to