Contractor
Posted 18 days ago
Job description
8+ years of experience working with .Net ASP and SSIS packages.
• Design and develop SQL Server stored procedures, functions, views, and triggers to be used during the ETL process.
• Knowledge of developer tools across the software development life cycle(task management , source code , building , deployment, operations , real-time communication)
• Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing.
• Builds data transformations with SSIS including importing data from files, moving data from one database platform to another.
• Debug and tune SSIS to ensure accurate and efficient movement of data.
• Design, implement and maintain database objects (tables, views, indexes) and database security.
• ASP.NET framework, SQL Server and design/architectural patterns (e.g. Model-View-Controller (MVC)
• Development experience using C# .NET
• Proven Ability to understand/use APIs.
• Supporting Web Servers and App servers during OS upgrades
• Ability to excel in a fast-paced environment .
• Must be able to work independently.
• Having Lead experience is preferred.
• Creating responsive and interactive user interfaces using technologies like HTML, CSS, and JavaScript frameworks (e.g., Angular, React).
• Developing server-side logic, APIs, and databases using .NET technologies like C#, ASP.NET, and Entity Framework.
• Designing, implementing, and managing databases, often with SQL Server, ensuring data integrity and performance.
• Creating and consuming RESTful APIs and web services to facilitate communication between different parts of the application.
• Working closely with product managers, designers, and other developers to define requirements, plan sprints, and deliver high-quality solutions.
• Writing clean, well-documented, and efficient code, following best practices and design patterns.
• Participating in testing processes (unit testing, integration testing), debugging, and deploying applications.
• Identifying and resolving application issues, ensuring high performance and availability.
• Keeping up-to-date with the latest .NET technologies, trends, and best practices.
• Implementing security best practices to protect sensitive data and prevent vulnerabilities.
Most Popular Jobs Similar to Sql Ssis Developer
sql ssrs ssis developer
ssis developer
sql ssrs developer
ssis etl developer
sql developer
ms sql developer
sql application developer
sql server developer
t sql developer
sql engineer
Frequently asked questions
Q: What skills or qualities help someone succeed as a SQL SSIS Developer?
A: To succeed as a SQL SSIS Developer, key technical skills include proficiency in SQL Server, SSIS (SQL Server Integration Services), and data modeling, as well as experience with data warehousing, ETL (Extract, Transform, Load) processes, and data quality management. Soft skills such as strong problem-solving abilities, effective communication, and collaboration with cross-functional teams are also crucial, as they enable developers to troubleshoot complex data issues and convey technical insights to stakeholders. By combining these technical and soft skills, SQL SSIS Developers can design, implement, and maintain efficient data integration solutions that drive business value and support data-driven decision-making.
Q: What is the career path for a SQL SSIS Developer?
A: A SQL SSIS Developer's career path typically begins as a Junior Developer, where they focus on designing, implementing, and maintaining ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS). As they gain experience, they progress to a Mid-Level Developer role, taking on more complex projects, mentoring junior team members, and contributing to the development of SSIS best practices. Ultimately, Senior Developers lead teams, architect large-scale SSIS solutions, and drive innovation in data integration and analytics, with opportunities to transition into leadership, data architecture, or business intelligence roles.
