Duration : 3 months Contract with possible extension (Onsite) C2C
Location: Auburn ,PA
The ideal candidate will have extensive expertise in working with MSSQL databases, SSIS (SQL Server Integration Services), and SQL Agents. This role requires a self-motivated and independent individual capable of managing complex projects and collaborating effectively with cross-functional teams.
Education and Experience: • Bachelor's or higher degree in Computer Science, Software Engineering, or a related field. • 5+ years of relevant experience in back-end software development and data engineering.
Additional Skills and Qualifications: • Strong SQL Proficiency: Expertise in writing complex SQL queries, stored procedures, and optimization techniques. • Data Modelling: Proficiency in data modelling and database design principles. • ETL Design: Experience in designing and implementing efficient ETL processes for data integration and transformation. • Version Control: Familiarity with version control systems (e.g., Git) for code management and collaboration. • Self-Management: Ability to work independently and manage projects with minimal supervision. • Communication: Excellent written and verbal communication skills for documenting processes and collaborating with team members.
Key Responsibilities:
1. Batch Processing Data Pipelines: Design, develop, and maintain robust batch processing data pipelines for handling large volumes of data efficiently.
2. MSSQL Database Management: Manage and optimize MSSQL databases for performance, scalability, and reliability.
3. SSIS Integration: Develop, deploy, and maintain ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS) for data integration and transformation.
5. Data Quality Assurance: Proficiency in implementing data quality checks, data validation processes, and data cleansing techniques to maintain high data integrity and accuracy throughout the data pipelines and databases.
6. Performance Tuning: Identify and resolve performance bottlenecks in data pipelines and databases to ensure optimal system performance. 7. Documentation: Create and maintain comprehensive documentation for data pipelines, database schemas, and integration processes. 8. Monitoring and Troubleshooting: Set up monitoring tools and processes to proactively identify and address issues in data pipelines and databases.