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.

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 Con Ed 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.

• 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

• Experience in Utility Projects or AMI knowledge
• Python
• Biz Talk Platform