Knowledge of working on at least 2 to 3 different databases including Postgres SQL(important), SQL Server, Oracle, MySQL, SAS.
Knowledge and experience of working on SQL Queries and database scripting (procedures, functions, jobs, physical data model creation).
Knowledge of improving database/query performance.
Knowledge of at least one ETL tool and Implementation.
Knowledge of Unix/Linux commands/scripts, scheduling cron jobs.
Knowledge on the transformations Quality, Data Integration, Utilities, etc.
Able to interpret business requirements, business rules & validation rules, Transform them in to Low Level Design / technical terms.
Hands-on exposure to Data Set, ODBC & Manage data from heterogeneous sources, Data Cleansing, Data Standardization.
Good communication (both writing and speaking) skills.
Good Analytical and Technical skills.
Thorough knowledge of SDLC life cycle in data warehousing environment.
Willingness to work on new technologies on need basis.
Should be a quick and self learner