| Sr. Data Warehouse Architect::Hybrid::NYC,NY (USC,GC) at Remote, Remote, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=342284&uid= From: Geetanjali, Absolute IT [email protected] Reply to: [email protected] Job Title Location Job Description Senior Data Warehouse Architect [Nyc, NY, 10167] Hybrid/New York City The Data Warehouse Data Architect / Developer defines and designs both solution and application architecture for the enhancing capabilities of an existing Data Warehouse technologies. This role comprises of 50% architectural and 50% hands on. Please provide all the below details with each submittal. It is required for the vendor Management system. Number of years working with: Total IT experience: Years working with: Data Warehouse architecture Years working with: SQL Years working with: SSIS.SSRS/.Net Full Name: Rate: Location: Availability to Interview: One Days notice Availability to Start: Two weeks Email Address: Phone Number: Visa Status: Education - College/Year of graduation: Link to LinkedIN Certifications Key Responsibilities: As a part of the firms 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: Bachelors degree in Computer Science, Information Systems, or another four-year degree with significant IS experience OR equivalent experience. Masters degree preferred 10+ years of experience delivering Data Warehouse solutions 10+ years in Microsoft technology SQL Server, SSIS, SSAS, C#, .Net technologies 4+ 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 using MDX Microsoft Tabular Models and SSAS Cubes Microsoft Team Foundation Server / Git Application Performance Tuning and Optimization Data Warehouse Technologies: Azure Synapse Analytics Agile development methods and Dev/Ops CI/CD (Preferred) Jira (Preferred) Kind Regards, Geetanjali Banvi | Absolute IT | Technical Resource Specialist 116 Village Blvd Suite 200 Princeton New Jersey 08540 [email protected] www.absoluting.com Keywords: csharp continuous integration continuous deployment active directory information technology New York http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=342284&uid= |
| [email protected] View All |
| 03:45 AM 07-Feb-23 |