Senior Database Developer

Apptad Inc; New York (NY); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Apptad Inc. in New York, NY is seeking a Senior Database Developer to support the FA Registration Team. Hybrid work arrangement (3 days on site) and a 12-month engagement.

You will design and optimize SQL Server databases, build ETL components, and drive data quality across registration data and reporting platforms. The role requires 5+ to 7 years of experience, strong T-SQL and Informatica skills, and collaboration across teams to deliver changes in an Agile environment.

Qualifications

• 5+ to 7 years of experience in database development and ETL.
• Experience translating business needs into technical specs.
• Strong batch processing and data integration experience.
• Proficiency with T-SQL and SQL Server.
• Familiarity with enterprise ETL workflows.

Responsibilities

• Translate business needs into clear technical specifications.
• Develop scalable T-SQL stored procedures and database components.
• Adhere to enterprise development standards in a process-driven delivery model.
• Collaborate with business, QA, infrastructure, and application teams to deliver changes and provide production support.
• Centralize and streamline production requests.
• Contribute to database design to improve data access and performance.
• Support batch workflows across ingestion, validation, reconciliation, monitoring, and downstream delivery.
• Apply AI-assisted engineering tools (GitHub Copilot, Claude) to improve productivity and quality.

Skills

Batch processing

SQL Server development

Data modeling

ETL processes

Agile Scrum

Communication skills

SDLC discipline

Jira execution

Data quality

AI-assisted tools

Education

Bachelor's degree in computer science

Master's degree or MBA is a plus

Tools

Informatica

GitHub Copilot

Claude

Job description

Job Title: Senior Database Developer

Location: New York, NY (Hybrid 3 days)

Experience level : 5+ to 7 years

No. Of position: 1

Duration: 12 months

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.

Responsibilities

• 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.