We are seeking a skilled and experienced Data Integration Developer with expertise in ADF-SSIS integration runtime, ADF functions for ETL, SSIS packages, SQL Server stored procedures, and basic SQL Server table management skills. The ideal candidate will play a crucial role in designing, developing, and maintaining data integration solutions to meet the organization's business requirements.
Responsibilities
- ADF-SSIS Integration:
- Design, develop, and implement robust data integration solutions using Azure Data Factory (ADF) and SQL Server Integration Services (SSIS).
- Ensure seamless integration between ADF and SSIS runtime environments for efficient data processing.
- ADF Functions for ETL:
- Leverage ADF functions to perform Extract, Transform, and Load (ETL) operations efficiently.
- Develop and optimize ADF workflows to ensure reliable and high-performance data transformations.
- SSIS Packages:
- Create, modify, and maintain SSIS packages to support various data integration and ETL requirements.
- Troubleshoot and resolve issues related to SSIS package execution and performance.
- SQL Server Stored Procedures:
- Design and implement SQL Server stored procedures to support data manipulation, transformation, and extraction processes.
- Optimize stored procedures for performance and maintainability.
- Basic SQL Server Table Management:
- Demonstrate proficiency in basic SQL Server table management, including creating, modifying, and maintaining database tables.
- Ensure data integrity through proper indexing, constraints, and data validation.
- Collaboration and Documentation:
- Collaborate with cross-functional teams to understand data requirements and provide effective data integration solutions.
- Document all aspects of data integration processes, including design, development, and troubleshooting steps.
- Performance Optimization:
- Identify opportunities for performance improvement in data integration processes and implement optimizations as needed.
- Monitor and tune ADF and SSIS solutions for optimal efficiency.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Proven experience in data integration development using ADF and SSIS.
- Strong proficiency in T-SQL and SQL Server database management.
- Excellent problem-solving and troubleshooting skills.
- Ability to work independently and collaboratively in a team environment.
- Strong communication skills for effectively conveying technical concepts to both technical and non-technical stakeholders.
If you possess a passion for data integration, a keen eye for detail, and the ability to thrive in a dynamic work environment, we invite you to apply for this exciting opportunity to contribute to our organization's success.
#J-18808-LjbffrSimilar Jobs
- View Job
ETL/SQL developer
Rockville - View Job
ETL/SQL developer
Rockville - View Job
Senior Engineer - Data ETL (SQL & Spark)
Chevy Chase - View Job
Senior Interface Architect (Lead Software Developer - APIs / Integration)
Silver Spring - View Job
Senior Interface Architect (Lead Software Developer - APIs / Integration)
Silver Spring