This position is responsible for managing the SSIS
development team and designing, developing and supporting SSIS
packages, and documenting the data flow. The SSIS Team Lead will work
with business analyst, DBAs and Managers in developing and generating
the data as per requirements.
Design, Develop, Support SSIS
Packages:Support IT staff and business users in the development, usage
and troubleshooting of database-driven applications
Consult with the business to determine logical design for new business solutions
Perform code reviews, analyze execution plans, and re-factor inefficient code
Design and develop data movements using SQL Server Integration Services, VBScript, C#, TSQL and Stored Procedures.
Follow data standards, resolve data issues, complete unit testing and system documentation for ETL processes
SDLC process is followed Collaborate with business analysts, subject
matter experts, and other team members to determine data extraction and
Collaborate with IT operations,
development teams, and testing teams to ensure timely releases of
projects and make sure database environments are sustainable
Collaborate with IT operations to perform root cause analysis of production issues
Provide estimates and meet the agreed timeline with Business
Provide the weekly status and update as and when required to the Manager/Management
X Team Lead:Assign work to the team and assist SSIS developers to complete work as per the schedule and on budget
Mentor and train junior SSIS resources
X Production Support:Provide production support for critical packages and analyze run times for performance tuning
Miscellaneous:Participate in special projects as needed
Performs miscellaneous duties as required
coordination Operate office equipment Daily 100%
listening, writing Talking with co-workers, customers, outside contacts
to communicate and gather information Daily 100%
X Critical thinking
and comprehension skills Analysis and data integration; exercise good
judgment; interpret and understand discussions and instructions;
intrinsic motivation; ability to learn and utilize new information,
systems, processes, etc.; creative thinking and problem solving skills;
ability to read and understand complex charts, graphs, documents,
manuals Daily 100%
X Bending, lifting Files, boxes of up to 5lbs in weight Daily <5%
Standing, sitting, walking At work station, in meetings, getting to
other work areas and operating office equipment. Daily 100%
Skills, and Ability: These are considered to be Essential Job Functions
Excellent computer skills, including Microsoft SQL Server 2000/ 2005 /
2008 R2, Microsoft Visio, and Microsoft Office.
Ability to manage team effectively to deliver projects assign to the team
collaboration skills within a variety of environments including
operations, development, testing, business analysis, etc.
written and verbal communication skills in English including listening
and retaining critical information and the ability to communicate
complex ideas clearly.
Good interpersonal skills to work effectively with others and develop partnerships internally and externally.
organizational skills and the ability to be flexible, prioritize work,
and follow through in order to meet tight deadlines in a fast-paced
Attention to detail; multi-tasking skills; excellent time-management skills.
Ability to thrive in a matrix environment.
Ability to work independently and take initiative, not requiring significant direction.
Ability to work with offshore team.
IV. Education, Training and Experience Required:
Special courses/licenses needed:
Formal education required.
BS in Computer Science preferred Prior experience needed:
Previous mortgage industry experience How many weeks,
months, or years of experience is required to do the job satisfactorily:
8+ years of experience in SQL Development primarily in SSIS technology , including
Database Administration, and Data Modeling (OLTP/OLAP)
Direct hire based in Sherman Oaks! Fulltime, benefits, 401K match, PTO, Holidays ect!
For more info, visit: www.myprospectmortgage.com
Or take a peek at: https://twitter.com/myprospectmtg