Minimum 5+years of experience in Information Technology with emphasis on Data Warehouse/Dal Martdevelopment using MDM straiegies
Experiano In Informatica Power Center Is a huge pus - Power center is not mandatory bot lICS is mandatory.
Must have expensive involvement in composing UNIX shell script and computerization af the ET farms udlizingUNIX shell scripting - Not mandatory
Must have strong work experience in Data Warehouse lfe cycle development, performed ETL procedure 10 load data from different sources link SQL Saar, Oracle, Mainframe, Teradata and flat fils info dal marts and data warehouse using Informatica Power Center - Designer, Worcon: Manager, and Workflow Monitor.
Muel have Crealed mappings in mapping Designer to load data from various sources using trarens lika
Transaction Control, Lockup (Connacind and Unconnected), Router, Filter, Expression, Aaprega-uiner andUpdete Strategy, sot, Store Procedure and mone,
Must have experience with IDQ, MDM with knowledge on Big Data Edition Integration with Hadoop and HDFS.Hadoop and HDFS experience is not a must.. Should have a concept only.
Must have experience in Managing and perform data cleansing, deduplication and harmonization of data recalvodfrom On-Pram and Cloud sources.
Must hera roxparonce and expertise in various Performance Turing Techniques on Sources, Target, Mapping.and Workflow using Partitione/ParaleizulionundelminatingCacheIntensiveTransformations.
Muet have Strong ROBS concept and experience In ormaing, mehleining, and turing Viawa, Sicred Procedures User Defined Functions and System Function: using SCL Server, T-SQL. --- Relational database(advanced hands- on exp) is not a must but the way informatica models data in documer: DB is required
Hand on socorriance working in LINUX. UNIX and Windows environments. -. Not y must
Must have sound knowledge on data quality measurement, ueing I03 and IDE
Good to have experience in Dimensional Modeling using Star and Snowflake Schema, Identifying Facts andDimensions, Physical and logical data modeling using ErAin and ER-Studio, --not a must to have
Must be Proficient with Informatica Data Qually (ID, for clgrup and massaging at stagino ama.
Designed and Developed IDQ mappings for address validation & cleansing, doctor master data matching, data conversion, exception handling, and report exception data.
Must have experiences in handling initial full and incremental loads
Must have designed, Instaled, Configurod core Informalica'S parian Hab components such as informatics Hub Console, Hub Stora, Hub Sarver, Cleanza Match Server. Flange Adapter, IDD & Data Modeling.