Responsibilities
- Participate in JAD (Joint Application Design), RAD (Rapid Application Development) and DSD (Design Specifications Document) sessions to define and understand the business requirements and present detailed systems design documentation for reports, data interface files, data conversion and any other method of data exchange.
- Develop, test, manage and implement SSIS Packages from development server to production server using package configuration.
- Work on maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
- Ability to automate the execution of SSIS packages using SQL Server Agent Jobs.
- Ability to build complex queries and reports using Microsoft SQL.
- Diagnose and resolve incident tickets and errors.
- Develop ETL specifications, data mapping and other documentation required for ETL development.
- Use SQL, data models, data element dictionary and schema to perform data and business analysis.
- Understand business data and perform quality assurance testing to ensure the data presented is correct.
- Ability to establish and maintain positive and effective work relationships with coworkers, clients, members, providers and customers.
- Support Unit Testing, System Integration Testing, End-to-End System Testing, and User Acceptance Testing.
- Design and guide other developers on complicated interfaces and should have strong debugging skills.
Skills Requirement
- Bachelor’s Degree in Computer Science, Information Systems, Engineering or a related field.
- 7-10 years of applications design and development experience with SQL Server/MS-SQL scripting and SSIS.
- Proactively engage on continuous improvement efforts.
- Analytical and data analysis skills using Microsoft SQL.
- Previous team leadership experience to include analyzing, mentoring and monitoring.
- Knowledge in Unix and Control-M is an added advantage.
