Senior Database Developer
Location: New York, NY (Hybrid 3 days)
Duration: 12 months
Experience level : 5+ to 7 years
Job Summary:
This role is for an experienced SQL and ETL database developer supporting the FA Registration Team. The team owns platforms that support Financial Advisor registration data, registration validations, compliance-driven controls, and field reporting capabilities.
The team’s objective is to modernize legacy mainframe processes onto a distributed platform, enable adoption across downstream applications, and incorporate evolving compliance requirements across the FA Registration ecosystem.
The candidate will serve as a developer on the team with responsibilities including:
- Translating business needs into clear technical specifications
- Developing scalable T-SQL stored procedures and database components
- Working in a process-oriented delivery model and adhering to enterprise development standards
- Partnering with business, QA, infrastructure, and application teams to deliver controlled changes and production support
- Centralizing and streamlining production requests
- Working on database design to improve data access, performance, and maintainability
- Supporting batch workflows across ingestion, validation, reconciliation, monitoring, exception management, and downstream delivery
- Leveraging approved AI-assisted engineering tools, including GitHub Copilot and Claude, to improve productivity, analysis, documentation, and delivery quality
Primary Skills / Must Have:
- 6–8 years of experience developing batch processes using T-SQL and ETL tools such as Informatica
- Strong SQL Server development experience, including stored procedures and database components
- Strong database design and data-modeling skills
- Hands-on experience with Informatica and enterprise ETL processes
- Experience supporting enterprise batch processing, including scheduling, dependencies, file-based feeds, exception handling, reconciliation, and production support
- Strong data analysis and data quality assessment capabilities
- Excellent verbal and written communication skills with the ability to collaborate across time zones
- Strong SDLC discipline with a track record of improving operational efficiency
- Experience delivering in Agile Scrum models, including planning, backlog refinement, estimation, stand-ups, reviews, retrospectives, and Jira execution
- Practical experience using AI-assisted engineering tools such as GitHub Copilot and Claude for development, troubleshooting, unit-test support, documentation, and productivity improvement
- Ability to follow change management practices that support consistent, maintainable release.
Education
- Bachelor’s degree in computer science, Information Systems, Business Administration, or related field.
- Master's degree or MBA is a plus.
All your information will be kept confidential according to EEO guidelines.
Skills Required
- 6-8 years developing batch processes using T-SQL and ETL tools such as Informatica
- Strong SQL Server development experience including stored procedures and database components
- Strong database design and data modeling skills
- Hands-on experience with Informatica and enterprise ETL processes
- Experience supporting enterprise batch processing: scheduling, dependencies, file-based feeds, exception handling, reconciliation, production support
- Strong data analysis and data quality assessment capabilities
- Excellent verbal and written communication skills and ability to collaborate across time zones
- Strong SDLC discipline and experience improving operational efficiency
- Experience delivering in Agile Scrum models and using Jira for execution
- Practical experience using AI-assisted engineering tools such as GitHub Copilot and Claude
- Ability to follow change management practices for consistent, maintainable releases
- Bachelor's degree in Computer Science, Information Systems, Business Administration, or related field
- Master's degree or MBA
What We Do
BuzzClan is a technology consulting firm collaborating to provide software, advisory, implementation, transformation and staffing services. We provide systems integration, IT consulting, managed services and workforce solutions to public and private sector clients. BuzzClan is a certified partner for most Tier-1 Cloud, Software & Hardware Providers, including Oracle, Amazon, Microsoft & Saviynt. BuzzClan is committed to providing substantive business value on each and every client engagement. We do this through a combination of industry-specific business expertise, technical skills, proven project management methods and our “onsite - off-site - offshore” delivery model. We strive to work in partnership with our customers to build high-performance teams and create business solutions that will last. Vertically Integrated solutions company Full ownership of the solution The combined experience of more than 250+ years Various OEM Certifications such as OCP, PMP, AWS, MS Azure, etc. Onsite presence across the North American(US & Canada) clients Near-Shore & Offshore presence
