Snowflake Schema

Job Description:

Project Role : Application Designer  Project Role Description : Assist in defining requirements and designing applications to meet business process and application requirements.                                                                                                                                                                                                                                                                                                                                                                                                                              Must have Skills : Snowflake Schema  Good to Have Skills :  Oracle Procedural Language Extensions to SQL,Snowflake Data Warehouse  Job Requirements :    Key Responsibilities :   a: The person will be responsible for end to end implementation ie gathering requirements, analyzing, designing, coding and deployment to Production b: The person will be in client facing role talking to client SME on regular basis to get requirements and clarifications c: The person will be responsible for reviewing and overseeing team-mates work d: The person should be able to work with different teams to coordinate on requirements and data requirements    Technical Experience :   Good exposure to snowflake cloud database Snowflake integration with ETL-informatica Should be able to convert the DB2 scripts to snowflake compatible format Perform the data testing in snowflake after migration Build the new informatica ETL by pointing to snowflake database Integrate the BO report to snowflake Process the informatica workflows and validate the data in snowflake Database History data will be migrated from DB2 to Snowflake, We need to perform data checks integrity, count    Professional Attributes :   a: Resource should have good communication skills b: Resource should have good analytical skills and reasoning skills    Educational Qualification :   Min 15 years of full time education    Additional Information :   a: Resource should have good communication skills b: Resource should have good analytical skills and reasoning skills