The job will require you to:
- 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 customer along with its technical/functional intent and inter-dependencies
- Participate in the technical design, data requirements gathering, making recommendations 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
Requirements:
- 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
- Some Knowledge of C#/VB.NET/Javascript or analytical packages like R is desirable
- Knowledge and experience in Hadoop is a plus
- 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 to 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