Sr. Software Developer (ETL tools (SSIS/SSRS), Microsoft SQL Server, Data Flow, and Data Mapping)

Sr. Software Developer (ETL tools (SSIS/SSRS), Microsoft SQL Server, Data Flow, and Data Mapping) Hybrid expectation: 2–3 days onsite per week. Client: Con Edison. Job Location: NY, NY. Duration: 5+ months. Rate: $80/hr (Contract). Candidates must be local and able to work on a GC/USC/EAD/H4/EAD/H1B basis. Job Description Expertise in system integration through file-based and real-time interfaces is important to ensure efficient data flow and operations. Familiarity with the Boomi platform for enterprise integration is required. This position requires a solid background in ETL tools (SSIS/SSRS), Microsoft SQL Server, Data Flow, and Data Mapping, as well as the ability to adapt business processes to technology solutions. Strong documentation skills and the ability to quickly learn new technologies are essential. Key responsibilities include: Collaborate with various teams to test more than 75 interfaces between AMI MAMS and other systems on the Boomi platform. Work closely with the ConEd Infrastructure team to refresh, set up, and manage testing environments. Handle incident triage, remediation, root cause analysis, and suggest preventive measures (including HPI). Engage in regression, SIT, SAT, and UAT testing. Apply Agile methodology and manage environments for parallel projects. Manage incident and defect resolution and post‑event corrective actions. Maintain strong business relationships and stakeholder communication, including leading team discussions. Technical Skills – Must Have Microsoft SQL Server SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS) APIs ETL Tools TSQL HTML Agile Methodology Sprint Planning SDLC Root Cause Analysis Technical Documentation Testing Activities Teamwork Strong Written and Verbal Communication Analytical Skills Nice to Have Experience in Utility Projects or AMI knowledge Python BizTalk Platform #J-18808-Ljbffr