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:image008.png@01CE7195.60877940]
Phone: 703-831-8282 Ext 2532, Fax: 703-439-2550
Email: k.arav...@canopyone.com 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 android-developers+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/android-developers/CAHdSO-E1K4eu%2BQ_d4AA9P35q_tdYcKrNB6TyuPE2zinwek0Wbw%40mail.gmail.com.
