SSIS Developer
Cleveland, OH
12 Months
Skills:
Online Servicing Data Warehouse redesign/enhancements
Assignment will entail SQL Server expert knowledge in order to:
(1) develop application log extract routines (from multiple app logs) and movement to staging area(s)
(2) reconstruction of session data from clickstream data logs. Scripting business rules for construction of sessions for various user types
(3) staging of fact and dimension tables for loading Main Frame DB2 data warehouse
(4) Construction of various reporting cubes for further analysis from the loaded warehouse data. Participant contractor may also be assigned duties in project to redesign/replace OSDW
The Lead Programmer is responsible for serving as a point person or technical lead for projects which involve developing complex, cost-effective information technology solutions for business related problems by creating new or enhancing and maintaining existing software programs/applications or components. Works on problems which requires substantial knowledge of IT technologies. Key activities include, but not limited to, providing guidance to others with regard to technical projects, systems enhancements, defect fixes, and on-call production support.
• Assists others in the steps involved in the life cycle of software development. Ensures code quality by coaching and reviewing the work of other developers, which could include conducting code walk-throughs.
• Creates and executes unit test plans, which could include integration, performance and systems testing. Recommends improvements to testing approach. Uses skills and knowledge of an advanced and seasoned professional in the area of software program/application development and implementation.
• Has a wide range of experience in applying software program/application development methodology and life cycle.
• Works on problems of diverse scope and high complexity where analysis of situations or data requires a review of a variety of factors.
• Leads software application development and/or enhancement projects, exercising exceptional judgment and creativity in selecting methods and techniques to obtain solutions, and escalating only the more unusual and/or unique software program/application development issues when necessary. Provides recommendations for improving processes and procedures.
• Stays current with industry best practices and shares with others. Functions as an escalation point for other resources.
DUTIES AND RESPONSIBILITIES (% of Time):
(Specific responsibilities and % of time may differ depending on the needs of the department and/or the needs of business area being supported.)
100% Software/Application Development and Maintenance
• Analyzes requirements for software program/application development, enhancements, and/or modifications, which could include further defining and interpreting requirements, conducting research to help write requirements, and creating requirement documents. Provides guidance others as needed. May develop prototypes as needed.
• Designs solutions that will meet requirements, which typically includes identifying what technology will be used, cost of implementation, and maintainability. May provide input to architecture approaches as needed. Analyzes and coaches others with regard to existing code/programming standards to come up with the best design, and to understand the potential impact on products and systems. Provides estimates for enhancements to current systems. Informs others of the limitations of the system or platform structures where applicable. Creates and provides guidance to others about detailed design documents and specifications. Conducts design sessions and design walkthroughs, which could include attending design walkthroughs for others, and providing feedback on design documents developed by others. May practice techniques to support the creation of more stable and effective software.
• Writes or modifies code for software program/application development and/or modifications using detailed design documents, which could include developing components for various platforms, compiling the code, and copying, creating, and altering files and/or workspaces and considering refractoring needs, and other technical faculties for programming purposes. May mentor or guide others in programming/application development tasks. Reviews code of other developers.
• Tests (which could involve unit, acceptance, integration, performance or stress testing) and audits the code/programming to ensure it works with minimal defects before going to Quality Assurance. Recommends improvements for testing approaches.
• Provides support and maintenance for software programs/applications once they are elevated/implemented to production environments, which could include providing on-call support, assisting others in troubleshooting systems defects, and monitoring of platforms if necessary. Restores and/or fixes data that has been corrupted by production issues. Works with external vendors to correct issues if needed.
• Prepares the documentation needed throughout the software program/application development and/or modification processes, which includes documenting the design and code/programming used, event response for production support issues, Unit Test Plans, Code Reviews and issues, and code walkthroughs. Prepares presentations and/or documents for upper management regarding software application developments and/or enhancements. May create and maintain models of the software environment that show all software parts and their relationships.
• May provide coaching and mentoring to other programming resources outside of assigned projects as a means of helping others develop technical expertise and problem resolution skills. May be called upon to create and/or facilitate technical training sessions.
KNOWLEDGE, SKILLS & EXPERIENCE:
Education Requirements: Bachelors Degree in an Information Technology, or related discipline, which could include Computer Science, Information Systems (IS) or Management Information Systems (MIS). In lieu of a degree, related work experience will be accepted.
Work Experience Requirements: Must have at least 8-10 years of related work experience designing/developing, programming, and supporting software programs/applications in mainframe or client server environments. Must have exceptional working knowledge of software applications, software development life cycle, and computer code/programming languages.
• Excellent interpersonal and communication skills with the ability to interact effectively with others and lead others through change.
• The ability to work in a team-oriented environment and independently organize work resources from current team or other teams to solve technical problems.
• The ability to consider technical decisions as part of a multidimensional problem, balancing standards, principles, project management disciplines (time, cost, schedules), team norms (consultation, decision-making, communication) and process.
• Excellent organization skills with the ability to work on multiple projects and/or assignment simultaneously.
• The ability to support department goals that align with current and future Company objectives and initiatives.
• Excellent negotiation skills with the ability to find successful resolutions for moderate to complex issues, escalating those that require management involvement, when necessary.
• Must be able to work in a fast-paced environment with tight deadlines and changing priorities.
• The ability to effectively troubleshoot system problems by identifying and implementing software or process changes that allow business transactions to continue with minimal risk.
WORKING CONDITIONS:
The demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
• Typical office environment.
• Typical work hours, but additional hours may be necessary to complete assigned tasks, and may be required to be on-call to support specific business areas.
• Some travel required.
| Category | Name | Required | Importance (1=Highest) | Level | Last Used | Experience |
| Database Platforms | SQL Server | Yes | 1 | Expert | Currently Using | 6 + Years |
| Development Tools | SQL Server Analysis Services (SSAS) | Yes | 1 | Expert | Currently Using | 4 - 6 Years |
| Development Tools | SQL Server Integration Services (SSIS) manipulating data | Yes | 1 | Expert | Currently Using | 6 + Years |
| Development Tools | SQL Server Reporting Services (SSRS) | Yes | 1 | Expert | Within 1 Year | 4 - 6 Years |
| Programming Languages | .Net | Yes | 1 | Intermediate | Within 1 Year | 2 - 4 Years |
| Programming Languages | SQL | Yes | 1 | Expert | Currently Using | 6 + Years |
Additional Skills : Additional notes from the platform manager: Working with Policy Servicing team in designing/developing SQL Server stored procedures, SQL (SSIS) SQL Server Integration Services scripts, designing/developing Data Warehouse applications and reporting. Should be comfortable with data warehousing concepts and dimensional modeling.
Thanks & Regard's
Bravens Inc
Note: We respect your on-line privacy. This is not an unsolicited mail. Under Bill 1618 Title III passed by the 105th US Congress this mail cannot be considered Spam as long as we include contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line. We truly apologize for the inconvenience caused.
--
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.
To post to this group, send email to sureshotjobs@googlegroups.com.
To unsubscribe from this group, send email to sureshotjobs+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/sureshotjobs?hl=en.
Y! messenger: - sanket_eteam
