Sr. Software Developer (ETL tools (SSIS/SSRS)
About The Position
This position requires a solid background in ETL tools (SSIS/SSRS), Microsoft SQL Server, Data Flow, and Data Mapping, plus the ability to adapt business processes to benefit from technology solutions. The candidate must collaborate with various teams to test more than 75 interfaces between AMI MAMS and other systems on the Boomi platform. Additionally, they should work closely with the ConEd Infrastructure team to refresh, set up, and manage testing environments. The candidate must handle incident triage, remediation, root cause analysis, and suggest preventive measures including HPI. This role requires experience with Agile methodology, environment management for parallel projects. Candidates should demonstrate expertise in incident and defect management and corrective actions post major events. Strong business relationships and stakeholder communication skills are essential, including leading team discussions.
Requirements
- Expertise in ETL tools (SSIS/SSRS), Microsoft SQL Server, Data Flow, and Data Mapping.
- Ability to adapt business processes to benefit from technology solutions.
- Strong documentation skills.
- Ability to quickly learn new technologies.
- Experience with Agile methodology.
- Experience with environment management for parallel projects.
- Expertise in incident and defect management and corrective actions post major events.
- Strong business relationships and stakeholder communication skills.
- Microsoft SQL Server
- APIs
- ETS Tools (SSIS/SSRS)
- Word
- Excel
- PowerPoint
- TSQL
- HTML
- Agile Methodology
- Sprint Planning
- SDLC
- Root Cause Analysis
- Technical Documentation
- Testing Activities
- Teamwork
- Strong Written and Verbal Communication
- Analytical Skills
Nice To Haves
- Familiarity with the Boomi platform for enterprise integration.
- Prior experience with utility projects, including knowledge of Advanced Metering Infrastructure (AMI).
- Experience in Utility Projects or AMI knowledge
- Python
- Boomi
- BizTalk
Responsibilities
- System integration through file-based and real-time interfaces.
- 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.
- Experience with Regression, SIT, SAT, and UAT testing.
- Experience with Agile methodology, environment management for parallel projects.
- Demonstrate expertise in incident and defect management and corrective actions post major events.
- Lead team discussions.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
