Hi
hope you doing wee
*JD:*
*SSIS Skills*
• Advanced skillset with SSIS 2008+ experience
• Ability to explain an overview of an ETL end (source) to end (target).
Experience in constructing the same scenario.
• Ability to explain objects contained within the ETL and why they are
used. Experience in working with the SSIS objects.
• Ability to explain alternatives to accomplish the same goal (we all know
there are always a multitude of ways to accomplish any task). Experience in
working with a multitude of objects and functionality in SSIS.
• Ability to explain situations in which one way would be better to code
over another.
*SSMS Skills*
• Knowledge of a variety of objects within a DBMS
Ability to explain purpose and alternatives
Experience in coding each from scratch
Experience in understanding and altering existing code
• Knowledge and experience in performance tuning various types of objects
within a DBMS
o Ability to explain their method for performance tuning
o The person needs to be able to troubleshoot a poorly
performing query holistically – meaning that they don’t just look at how
the query is structured but also look at the underlying
structures such as indexes, data sets, etc.
o Poorly performing stored procedures need to have queries
reviewed, as well as the objects contained within the stored procedure
(Cursors? Function calls? Etc)
• Developer needs to be able to track through complex code to understand
what it is doing and why
• Developer needs to be able to create stored procedures to solve complex
problems. This could require:
o Referencing multiple crosswalk tables to pull in all
necessary values
o Trace through any other code that is also touching/affecting
the data set
o Look at the solution from multiple views to find the one that
best fits the environment and task at hand
*Troubleshooting Skills*
• These skills need to be advanced
• *Ability to dissect a failed process to:*
o Determine cause
o Deduce correction
o Confidence to take action on the correction
o Move with a sense of urgency
• *Ability to dissect data issues to:*
o Determine one or more causes of the issue
o Determine resolution of coding defects
o Ability to assess impact to other processing
*Communication Skills*
• Ability to be easily understood both verbally and written
• Initiative
o To rephrase a question if they don’t understand or are unsure
o To follow up to make sure that the information they provide is
correct/sufficient
o To ask questions to gain knowledge about the full picture
• Provide detailed answers without being overly verbose
• Provide examples to further demonstrate knowledge
Thanks & Regards
Aravindkumar Komminenei
[image: cid:[email protected]]
Phone: 703-831-8282 Ext 2532, Fax: 703-439-2550
Email: [email protected] URL: www.canopyone.com
USA : 4229 Lafayette Center Dr , Suite #1625, Chantilly, VA 20151 || *CANADA:
*Bankers Hall - West Tower, 888 - 3rd Street SW, 10th Floor, Calgary, AB
T2P 5C5*||* *INDIA:* 4th Floor, #7, Techno Enclave, Sector 3, Hyderabad
500081*||*
--
You received this message because you are subscribed to the Google Groups
"Android Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/android-developers/CAHdSO-E1K4eu%2BQ_d4AA9P35q_tdYcKrNB6TyuPE2zinwek0Wbw%40mail.gmail.com.
