Technical Consultant - Bengaluru, India - Way to Success IT Services Private Limited

Description

• Design, build and deploy effective SSIS packages to validate, synthesize, transform customer data for integrated business planning and analytics
• Understand o9 platform's data model (table structures, linkages, optimal designs) for designing various planning use cases
• Review and analyze the data provided by customers along with its technical/functional intent and interdependencies
• Participate in the technical design, data requirements gathering and making recommendations on best practices, in case of inaccurate or missing data
• Design and automate the data loading and insights generation process with intelligent checks and balances for sustained value delivery
• Create and execute test plans, document issues and track progress at resolving issues.

• At least 3 years of experience with implementing ETL solutions for clients in different is a MUST
• Proficiency in databases (SQL Server, MySQL) and skills in one or more languages like SQL, MDX, T-SQL with knowledge of DDL, DML, stored procedures, triggers and performance tuning is a MUST
• Knowledge on handling JSON files, Serializing the data, Posting data to API is desirable.

• Good to have experience working withHive/Hadoop/Python.
• Knowledge and experience inApache NiFi / Apache Airflow.
• Prior work experience on Supply chain.
• Some Knowledge of C#/VB.NET/Javascript or analytical packages like R is desriable
• Proficient in the use of Microsoft Excel/PowerPoint for analysis and presentation
• Strong ability to lead by example and demonstrate proficiency in both product and domain.
• Patient listener with the ability clearly articulate your view point to manage and deliver to customer expectations, even under pressure
• Ability to take complete ownership of the work and deliver with minimal oversight