Hello *Associate*, Hope you are doing well We have below requirement open. Please send me your genuine candidate on my email ID *ifthek...@canopyone.com <ifthek...@canopyone.com>*
*Senior MSBI Data Warehouse Architect / Senior Developer * *Location: NYC only(Locals)* *Type: Contract* *Key Responsibilities:* *As a part of the firm’s IT Application Development and Support department, responsibilities will include:* - Rollup sleeves to analyze and fix production issues - Analyze and assess existing platform for maintainability, reliability, scalability, security, and performance. - Define standards for the design and analysis of load processes, data flows and data models. - Lead the design, build, and deployment of ETL (extract, transform, and load) processes for large data sets. - Review the existing platform architecture and come up with recommendations to solve the current performance issues which exists in cube processing, Data imports, Drill throughs. - Facilitate code reviews, software design sessions and architectural reviews. - Participate in technical advisory roles, as required - Interact with business users, as required. - Provide ad hoc support in troubleshooting highly complex production issues as they arise. - Conduct root cause analysis and performance tuning for data load processes. - Ability to problem solve, recommend, and develop technical solutions. *Education and professional experience* *Required:* - Bachelor's degree in computer science, Information Systems, or another four-year degree with IT OR equivalent experience. Master’s degree preferred. - Overall 15+ years in Microsoft technology – SQL Server, SSIS, SSAS - 10+ years of experience delivering Data Warehouse solutions - 5+ years serving as a Data Warehouse architect with a demonstrated track record of implementing highly scalable and available solutions into a highly transactional production setting - Data Warehousing & ETL - Significant data warehouse experience from planning, to design, to implementation. - Experience of designing strategies for ETL audit, load balance, exception handling and high data volumes. - Hands on experience in all areas of SQL Server development including stored procedures, functions, and triggers. - Proven expertise in Data warehouse methodologies as well as extensive knowledge of OLTP/OLAP technologies. - Ability to design, organize, and implement module, perform system testing, - Plan and automate tasks to maintain existing system - Ability to research and trouble-shoot application problems - Highly motivated team player with strong communication and interpersonal skills - Business analysis, especially business requirements gathering *Proficient In:* - Relational Database Concepts - Data Warehouse Concepts - Dimensional Data Modeling and Notation - Microsoft SSIS - ETL Processes - OLAP Cube Development experience - MDX experience is preferred - Microsoft Team Foundation Server / Git - Application Performance Tuning and Optimization - Data Warehouse Technologies: Azure Synapse Analytics, Data Lake, pipelines - Agile development methods and Dev/Ops CI/CD (Preferred) *Thanks & Regards* *Mohammed Ifthekharuddin* Tel: 703-831-8282 Ext 223 Cell: 323-825-5662 Email: ifthek...@canopyone.com Web: www.canopyone.com <http://canopyone.com/> -- You received this message because you are subscribed to "rtc-linux". Membership options at http://groups.google.com/group/rtc-linux . Please read http://groups.google.com/group/rtc-linux/web/checklist before submitting a driver. --- You received this message because you are subscribed to the Google Groups "rtc-linux" group. To unsubscribe from this group and stop receiving emails from it, send an email to rtc-linux+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rtc-linux/CAHa9xHBa1HM68siG1rS_K68t2G_thW_jh219zaSrfAvB8Dw1eA%40mail.gmail.com.