| Hybrid Role (Manhattan, NYC) || Sr. Senior Data Warehouse Developer || Long Term Contract at Manhattan, Kansas, USA |
| Email: pankaj@tanishasystems.com |
|
From: Pankaj, Tanishasystems.com pankaj@tanishasystems.com Reply to: pankaj@tanishasystems.com Hi, We are looking Senior Data Warehouse Developer Type: Hybrid, 3 days in the office with 2 days WFH(Manhattan, NYC) Experience: 8+ Position Overview: Senior Data Warehouse Developer develops and supports the existing in-house built Data warehouse built using SQL Server SSAS, SSIS, and T-SQL Key Responsibilities: As part of the firms IT Application Development, responsibilities will include: Provide ad hoc support in troubleshooting highly complex production issues as they arise. Analyze and assess existing platforms for maintainability, reliability, scalability, security, and performance. Design, build, and deployment of ETL (extract, transform, and load) processes for large data sets. Review the existing platform architecture and provide recommendations to solve current performance issues existing in cube processing, Data imports, Drill through processes. Conduct root cause analysis and performance tuning for data load processes. Hands on SQL development for new feature implementations & enhancements Required: Bachelors degree in Computer Science, Information Systems, or another four-year degree with significant IS experience OR equivalent experience. Masters degree preferred 8+ years of experience delivering Data Warehouse solutions 8+ years in Microsoft technologies SQL Server, SSIS, SSAS technologies 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. Technically excellent 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. Expertise in development and maintenance of MDX queries Ability to design, organize, and implement modules, 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 Proficient In: Basic knowledge in Cloud Data Warehouse Technologies: Azure Synapse, Azure SQL Software Development Fundamentals Relational Database Concepts Data Warehouse Concepts Dimensional Data Modeling and Notation Microsoft SQL Server Microsoft SSIS ETL Processes OLAP Cube Development using MDX, SSAS Cubes Microsoft Team Foundation Server / Git Application Performance Tuning and Optimization Agile development methods and Dev/Ops CI/CD (Preferred) Jira, Azure Boards (Preferred) Pankaj Kumar Tanisha Systems Inc An ISO-Certified Company Phone: 212-729-6543 Ext 365 Email: pankaj@tanishasystems.com Address: 99 Wood Ave South, Suite#308 Iselin, NJ 08830 Keywords: continuous integration continuous deployment active directory information technology New Jersey |
| pankaj@tanishasystems.com View All |
| 08:07 PM 17-Jan-23 |