Snowflake Schema Application Designer

About Accenture: Accenture is a global professional services company with leading capabilities in digital, cloud and security. Combining unmatched experience and specialized skills across more than 40 industries, we offer Strategy and Consulting, Interactive, Technology and Operations services-all powered by the world's largest network of Advanced Technology and Intelligent Operations centers. Our 514,000 people deliver on the promise of technology and human ingenuity every day, serving clients in more than 120 countries. We embrace the power of change to create value and shared success for our clients, people, shareholders, partners and communities. Visit us at www.accenture.com
Accenture | Let there be change
We embrace change to create 360-degree value
www.accenture.com

• 
  
• Project Role :Application Designer
• Project Role Description :Assist in defining requirements and designing applications to meet business process and application requirements.
• Management Level :9
• Work Experience :6-8 years
• Work location :Pune
• Must Have Skills :Snowflake Schema
• Good To Have Skills :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

15 years of full time education