Job requirement for Informatica with Snowflake (Job Code 027) Job For 7-8 Year Exp In Radical Technologies Pune – 3044134

Job Description:-
2. Profile: Informatica with SNOWFLAKE Experience
• Understanding requirements and review Mapping Document and design the logic to implement
the same.
• Extensively using Informatica ETL Power Center Tools to design, develop ETL jobs for extracting,
transforming, and loading the data
• Create new workflows, sessions, mappings to extract information from different sources and
load data into SAP HANA or SNOWFLAKE Tables.
• Unit and System Testing of ETL Code (Mappings and Workflows)
• Work on Scheduling Tool to run Informatica ETL jobs
Area:
Informatica Power Center:
• Flat File Loading
• Version 10.4 and Above
• XML File Loading
• 8 to 10 Years of Development Experience
• Database to Database Loading
• Reading from Other data bases like HANA, Oracle etc.
Databases:
• 8 Years’ Experience in any of the following databases:
o (Oracle, Netezza, SQL Server, HANA)
• Minimum 2 Years’ Experience in SNOWFLAKE and good knowledge on below areas
o Data Cloning
o Strong SQL Skills
o Using Multiple Warehouses
o Performance tuning
o Data Sharing
o XML Functions
o Use of clusters and Micro Partitions.
Unix/Linux:
• Minimum 3 Years’ Experience Using Shell Scripts
Others:
• Good Communications Skills
• Must be a Team Player.
• Ability to work independently.
• Experience in Cloud Area
• Good Documentation Skills
Nice to Have:
• Experience in any Scheduling tools (Tidal/Autosys etc.)
• Retail Experience
• Data Conversion Experience