| Hiring ETL Developer-Mechanicsburg, PA(Local to PA only)-C2C at Mechanicsburg, Pennsylvania, USA |
| Email: [email protected] |
| Job Title: ETL Developer / Data Integration Specialist Key Responsibilities: Integration Solutions Development: Optimize, develop, and maintain integration solutions using SQL Server SSIS and ETL Framework (BIDS) to connect legacy data stores and the data warehouse. Data Warehouse Management: Develop, maintain, and optimize all efforts related to the Data Warehouse, including SSIS, stored procedures, and views. Best Practices Implementation: Create data warehouse components using best practice methodologies. Documentation: Build and maintain comprehensive documentation of data flows and processes. Data Conversion: Perform data conversion from OLTP systems to the Data Warehouse using tools like SSIS and Azure Data Factory. Data Quality Assurance: Identify, analyze, and resolve data discrepancies and quality issues to ensure consistency and integrity. ETL Performance: Ensure stabilization and high performance of existing ETL processes. Troubleshooting: Troubleshoot complex data-related issues and provide support to production environments. ETL Job Workflow Development: Develop and deploy ETL job workflows with reliable error/exception handling and rollback mechanisms. Reporting Tools: Utilize MS SQL Reporting Services (SSRS) for reporting tasks. Power BI Development: Work with Power BI to create dashboards and reports (preferred). Crystal Reports: Experience with Crystal Reports is beneficial. API Development: Involvement in API development is preferred. Manual Testing: Participate in manual testing as required. Additional Duties: Perform other related duties as assigned. Required Skills and Qualifications: Education: 4-year college degree or equivalent technical study with advanced study. ETL Experience: 6+ years of experience with ETL tools, including SSIS. Data Analytics: 6+ years of data analytics experience. Data Warehouse Knowledge: 6+ years of experience in data warehouse concepts and implementation. SSRS Experience: 4+ years of experience with MS SQL Reporting Services (SSRS). Power BI Experience: 3+ years of experience with Power BI. Web API Development: 3+ years of experience in web API development. -- Keywords: business intelligence information technology microsoft Hiring ETL Developer-Mechanicsburg, PA(Local to PA only)-C2C [email protected] |
| [email protected] View all |
| Tue Oct 22 00:57:00 UTC 2024 |