Sr. Technical Architect (sql/ssis) Job in Valiance Analytics Pvt Ltd

JOB DESCRIPTION

Understand company 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 interdependencies 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 Design, build and deploy effective SSIS packages to validate, synthesize, transform customer data for integrated business planning and analytics

TECHNICAL SKILLSET

At least 5 years of experience with implementing ETL solutions for clients using SSIS and other ETL tools. At least 5 years of experience in SQL Server database and proficient with T-SQL with knowledge of DDL, DML, stored procedures, stored functions, triggers and performance tuning is a MUST Some Knowledge of Python 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