Job Description
- SSI is seeking an experienced SQL Server Developer to work in a dynamic, fast paced environment. Successful candidate will have strong SQL Server 2005 experience.
- The well rounded individual should have the ability to design, maintain and implement major portions of our existing data warehouse in addition to having an excellent knowledge of SQL Server 2005 SSIS, Analysis Services (OLAP), Reporting Services and/or Integration Services.
- Responsible for creating logical data and physical models based upon functional specifications of business requirements as provided by the Systems Analysts and other members of the project team.
- Responsible for designing and developing data manipulation processes using best-practices SQL coding techniques which are performance optimized.
- Responsible for monitoring and maintaining existing ETL processes (SQL 2005 SSIS packages) for existing data warehouse including on-call support, as necessary.
- Responsible for designing new and re-factoring older systems under deadline pressure with minimum supervision.
- Responsible for Designing and developing databases optimized for reporting.
- Responsible for successful completion of code deliverables within projects.
- Responsible for ensuring that code meets specifications.
- Responsible for communicating and defending design, requirements, feature set, functionality and limitations of systems to team members and development Architect.
Responsible for diagnosing data related issues
- The qualified candidate should be well versed in agile software development methodologies, possess excellent technical problem solving skills, programming and unit testing skills.
- Candidates should be able to articulate technical issues.
- Candidates will be expected to help shape technical documents with moderate to complex designs with minimal guidance and fully understand and utilize the appropriate tool set
Responsibilities:
- Design, develop and test new applications, interfaces, software tools, ad-hoc and regular reports.
- Maintain and enhance existing applications, interfaces, software tools, ad-hoc and regular reports including bug-fixes and enhancements
- Write new reports or maintain existing ones. These could be one-off ad-hoc reports or regular reports which show financial, analytical or informational data.
- Follow the team's SDLC processes to develop, maintain and upgrade systems.
- Follow a Quality Assurance process to ensure own and other developer's work is correct.
- Ensure all tasks and progresses are recorded in the Incident Tracking software and any other task management system in use by the Development team.
- Form strong and productive relationships with team members in the Product Management and Business Applications Infrastructure (supporting operational aspects of infrastructure) teams.
- SQL Server 2005 Costing Data Warehouse ETL Developer/Analyst
Job Specification
- Excellent Communication Skills
- Hold a Bachelors / Masters Degree from well reputed and recognized international or local institution such as FAST, GIK, NUST, UET, GCU, PUCIT.
- More than 3 years experience in SQL Server and Microsoft Technologies development environment
- Understanding of design principles and practices
- Commitment to quality and high standards
- Must have a flexible attitude that enables the individual to deal comfortably with change
- Must be able to work on multiple projects in a fast-paced team environment.
- Assist with the technical guidance and training of other staff members.
- Ability to manage multiple tasks and deadlines
- Ability to Manage and plan work effectively.
- Very Good oral and written communication skills
- Must be a self-motivated independent worker