Job Description :
Informatica Developer,
Armonk, NY
3+ Months Contract
Phone + Skype
Description:
In-depth SQL programming knowledge - partitioning, indexing, tuning knowledge, stored procedure, views
Good acquaintance with DW concepts start, snowflake schema, facts, dimensions, KPI, load strategies, surrogate keys, business keys, slowly changing dimensions, staging layer, information layer, analytic layer, data loading concepts
Data model Understanding of data model, OLTP, OLAP, Normalized and de-normalized schema, users
Deep ETL concepts Tool can be anything but should have deep knowledge in that. Should handle complex transactions like folder traversing, transaction handling, logging, auditing, error handling, data versioning with the tool, deployment concepts
Azure Knowledge Knowledge in various Azure PAAS offerings e.g. ADLS, Azure BLOB, Batch Service, Azure Data factory V1, Key Vaults etc.
Code repository and versioning concepts
Good understanding on Microsoft offerings such as SSIS, SSRS and Azure Analysis Service.
Knowledge on CloverDX preferred, knowledge on Informatica acceptable.
Lead the offshore developers