SSIS SQL Developer

Syntricate Technologies

Morristown, NJ

JOB DETAILS
JOB TYPE
Full-time
SKILLS
Best Practices, Business Analysis, Business Intelligence, Business Support, Data Analysis, Data Management, Data Modeling, Data Quality, Data Science, Data Warehousing, Database Extract Transform and Load (ETL), Identify Issues, Performance Tuning/Optimization, Problem Solving Skills, Query Optimization, Relational Databases (RDBMS), SQL (Structured Query Language), SQL Server Integration Services (SSIS), Security Information and Event Management (SIEM), Validation Testing
LOCATION
Morristown, NJ
POSTED
30+ days ago
Required Skills: Data Integration and ETL Development:- Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into data warehouses and other storage solutions. - Ensure data integrity and quality through thorough testing and validation. SQL Development:- Write complex SQL queries to retrieve, manipulate, and analyze data from relational databases. - Optimize SQL queries for performance and efficiency. Data Warehousing:- Design and implement data models and schemas to support business intelligence and analytics needs. - Manage and maintain data warehouse solutions, ensuring data consistency and availability. Performance Tuning:- Monitor and optimize the performance of ETL processes and SQL queries. - Identify and resolve performance bottlenecks and issues. Collaboration and Communication:- Work closely with business analysts, data scientists, and other stakeholders to understand data requirements and deliver solutions. - Provide support and troubleshooting for data-related issues and queries. Documentation and Best Practices:- Document ETL processes, data flows, and database designs. - Adhere to industry best practices and standards for data management and security.

About the Company

S

Syntricate Technologies