Company DescriptionPro17Analytics is a specialist IT solution company with esteemed global clientele. We help companies of every size to achieve their business objectives by leveraging our deep IT Consulting expertise, domain knowledge and IT best practices. We are among the very few players in the global IT industry providing customer centric services and solutions. Backed by a strong techno-functional management team and pool of talented IT consultants, we provide high end consulting services. We have successfully executed many projects to global clients across industries.
Job Title: SQL Server Database Developer with SSIS ExpertiseLocation : RemoteMust have 8+ Years of Experince
Company Overview:[Company Name] is a dynamic and innovative [industry/sector] company known for its commitment to excellence and cutting-edge solutions. We are currently seeking a skilled SQL Server Database Developer with expertise in SSIS (SQL Server Integration Services). This is an exciting opportunity to be part of a collaborative team that is dedicated to delivering high-quality database solutions.Position Overview:As a SQL Server Database Developer with SSIS expertise, you will play a pivotal role in the design, development, and maintenance of our database systems. The ideal candidate will have a strong background in SQL Server and a proven track record of implementing effective ETL (Extract, Transform, Load) processes using SSIS. This role requires a combination of technical proficiency, problem-solving skills, and a passion for optimizing data management.Key Responsibilities:Database Development:Design, develop, and maintain SQL Server databases to meet the organization's data storage and retrieval needs.Implement database schema changes and optimizations to enhance performance.ETL Development (SSIS):Design and develop ETL processes using SQL Server Integration Services (SSIS) to facilitate seamless data integration across systems.Optimize and troubleshoot SSIS packages to ensure efficient and reliable data movement.Data Modeling:Collaborate with data architects to design and implement effective data models for various business requirements.Ensure data integrity and consistency through proper normalization techniques.Performance Tuning:Identify and resolve performance issues within SQL Server databases and SSIS packages.Implement best practices for indexing, query optimization, and overall system performance.Documentation:Create and maintain comprehensive documentation for database designs, SSIS packages, and related processes.Provide training and support for end-users and colleagues on database-related solutions.Qualifications:Bachelor's degree in Computer Science, Information Technology, or a related field.Proven experience as a SQL Server Database Developer with a focus on SSIS.Strong T-SQL programming skills and experience with stored procedures, functions, and triggers.Knowledge of database administration and performance optimization.Familiarity with data warehousing concepts and methodologies.Preferred Skills:Certifications in SQL Server or SSIS.Experience with other Microsoft BI tools (SSRS, Power BI).Knowledge of data governance and security best practices.