ETL / Datawarehouse Developer - Hybrid postion

Khayainfotech
New york city, NY
27 Jan 2025

Vacancy expired!

Hi,

P

osition: ETL / Datawarehouse Developer

Location: New York ( Midtown )

Duration: 12+months

Note: Only and EAD`s WHo Can work on w2 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 firm’s 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 Education and professional experience

Required: Bachelor’s degree in Computer Science, Information Systems, or another four-year degree with significant IS experience OR equivalent experience. Master’s degree preferred8+ years of experience delivering Data Warehouse solutions8+ years in Microsoft technologies – SQL Server, SSIS, SSAS technologiesData Warehousing & ETLSignificant 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 queriesAbility to design, organize, and implement modules, perform system testing,Plan and automate tasks to maintain existing systemAbility to research and trouble-shoot application problemsHighly motivated team player with strong communication and interpersonal skills

Proficient In: Basic knowledge in Cloud Data Warehouse Technologies: Azure Synapse, Azure SQLSoftware Development FundamentalsRelational Database ConceptsData Warehouse ConceptsDimensional Data Modeling and NotationMicrosoft SQL ServerMicrosoft SSISETL ProcessesOLAP Cube Development using MDX, SSAS CubesMicrosoft Team Foundation Server / GitApplication Performance Tuning and OptimizationAgile development methods and Dev/Ops CI/CD (Preferred)Jira, Azure Boards (Preferred)
  • ID: #48853364
  • State: New York New york city 10001 New york city USA
  • City: New york city
  • Salary: $60 - $70
  • Job type: Contract
  • Showed: 2023-01-27
  • Deadline: 2023-03-26
  • Category: Et cetera