Sql Data Analysts Please Come Here

[k2s]

[quote name='charygaru' timestamp='1344263823' post='1302263696']
meeru em chestharu jo duties em untayi jara cheppi punyam kattukondi vayya
[/quote]

[b]SQL[/b][color=#666666][font=Arial,] Server/Oracle [/font][/color][b]Data[/b][color=#666666][font=Arial,] Analyst Responsibilities:[/font][/color]
[color=#666666][font=Arial,]- Serves as facilitator to the business [/font][/color][b]data[/b][color=#666666][font=Arial,] owners and supporting IT owners in the development of the [/font][/color][b]data[/b][color=#666666][font=Arial,] models.[/font][/color]
[color=#666666][font=Arial,]- Captures [/font][/color][b]data[/b][color=#666666][font=Arial,] requirements clearly, completely and correctly, and represents them in a formal and visual way through the [/font][/color][b]data[/b][color=#666666][font=Arial,] models. [/font][/color]
[color=#666666][font=Arial,]- Drives for the consolidation of redundant [/font][/color][b]data[/b][color=#666666][font=Arial,] and enforce the strategic vision through [/font][/color][b]data[/b][color=#666666][font=Arial,] models and [/font][/color][b]data[/b][color=#666666][font=Arial,] architecture.[/font][/color]
[color=#666666][font=Arial,]- May update conceptual project level [/font][/color][b]data[/b][color=#666666][font=Arial,] model, develop project level logical and physical [/font][/color][b]data[/b][color=#666666][font=Arial,] models for operational [/font][/color][b]data[/b][color=#666666][font=Arial,] stores, [/font][/color][b]data[/b][color=#666666][font=Arial,]warehouses, [/font][/color][b]data[/b][color=#666666][font=Arial,] marts, and multi-dimensional databases.[/font][/color]
[color=#666666][font=Arial,]- Performs [/font][/color][b]Data[/b][color=#666666][font=Arial,] Analysis to identify [/font][/color][b]data[/b][color=#666666][font=Arial,] cleansing and quality processes.[/font][/color]
[color=#666666][font=Arial,]- Creates metadata documentation to column level detail.[/font][/color]
[color=#666666][font=Arial,]- Performs [/font][/color][b]data[/b][color=#666666][font=Arial,] mapping analysis and works with [/font][/color][b]data[/b][color=#666666][font=Arial,] integration development efforts, making sure that the business rules are implemented correctly and clarifying issues as they arise[/font][/color]

[b][font="Calibri"]Responsibilities include:[/font][/b]

[font="arial"][size="2"][color=#555555][size=3][font="Calibri"]Ensure that the [b]data[/b] import process runs smoothly and to quickly be able to trouble shoot and fix when the import fails. You will also be responsible for any development of new SSIS packages for new imports of your clients [b]data[/b] and be able to effectively communicate and work with the Business [b]Analysts[/b] to gather[b]data[/b] requirements, [b]data[/b] mapping and QA of the client*s [b]data[/b]. Additional duties are, bug fixing import and[b]data[/b] cleansing issues, fine tuning and enhancing performance of existing store procedures.[/font][/size][/color][/size][/font]

[font="arial"][size="2"][color=#555555][size=3] [/size][/color][/size][/font]
[font="arial"][size="2"][color=#555555][size=3][font="Calibri"][b]Experience:[/b][/font][/size][/color][/size][/font]
[font="arial"][size="2"][color=#555555][size=3][font="Calibri"]* 3 or more years of relevant hands on [b]data[/b] management and design experience[/font][/size][/color][/size][/font]
[font="arial"][size="2"][color=#555555][size=3][font="Calibri"]* Strong Microsoft [b]SQL[/b] Server 2005/2008 and Transact Structured Query Language (TSQL) skills.[/font][/size][/color][/size][/font]
[font="arial"][size="2"][color=#555555][size=3][font="Calibri"]* Capable of fine tuning [b]SQL[/b] queries by use of indexing,[/font][/size][/color][/size][/font]
[font="arial"][size="2"][color=#555555][size=3][font="Calibri"]* Capable of writing and debugging complex SSIS packages.[/font][/size][/color][/size][/font]
[font="arial"][size="2"][color=#555555][size=3][font="Calibri"]* [b]Data[/b] Cleansing[/font][/size][/color][/size][/font]
[font="arial"][size="2"][color=#555555][size=3][font="Calibri"]* Strong SSIS/DTS/ETL skills.[/font][/size][/color][/size][/font]
[font="arial"][size="2"][color=#555555][size=3][font="Calibri"]* Working knowledge of C#[/font][/size][/color][/size][/font]
[font="arial"][size="2"][color=#555555][size=3][font="Calibri"]* Working knowledge SSRS is preferred but not essential.[/font][/size][/color][/size][/font]
[font="arial"][size="2"][color=#555555][size=3][font="Calibri"]* Preferred knowledge on these applications but not essential; LINQPAD, SVN, Red Gate.[/font][/size][/color][/size][/font]
[font="arial"][size="2"][color=#555555][size=3][font="Calibri"]* Query optimization techniques, including table indexing and analyzing execution plans.[/font][/size][/color][/size][/font]
[font="arial"][size="2"][color=#555555][size=3][font="Calibri"]* Deep understanding of relational database concepts.[/font][/size][/color][/size][/font]
[font="arial"][size="2"][color=#555555][size=3][font="Calibri"]* [b]Data[/b] Analysis * Experience consolidating disparate [b]data[/b] sets into usable [b]data[/b].[/font][/size][/color][/size][/font][color=#555555]
[font="arial"][size="2"][font="Calibri"]* Ability to collaborate and communicate clearly with other team members and management.[/font][/size][/font][/color]
[color=#555555]
[size=3]Advanced [/size][b]SQL[/b][size=3] skills[/size][/color]
[color=#555555]o Complex joins[/color]
[color=#555555]o Table creation/manipulation[/color]
[color=#555555]o Pivots[/color]
[color=#555555]o Loops[/color]

[color=#555555]• Experience dealing with large [/color][b]data[/b][color=#555555] sets[/color]

[color=#555555]• Requirements gathering and documentation skills[/color]
[color=#555555]o Proven experience working with business customers to define and document requirements[/color]

[color=#555555]• Strong communication skills[/color]
[color=#555555]o Experience working with non-technical customers to understand business needs and document them accordingly[/color]

[color=#555555]• Excellent Microsoft Excel skills[/color]
[color=#555555]o Excellent sorting/filtering/[/color][b]data[/b][color=#555555] manipulation skills, familiarity with VLOOKUP[/color]
[color=#555555]Additional Preferred Skills:[/color]

[color=#555555]• Experience using MS Access[/color]

[color=#555555]• Familiarity with TOAD[/color]

[color=#555555]• Excellent overall technical skills[/color]

[color=#555555]• Excellent organizational and time management skills[/color]

[k2s]

[color=#555555]
Involves analysis and presentation of information to business owners, including marketing, finance, and human resources.[/color][color=#555555]
- Must be proficiency with analytical tools, knowledge of [b]data[/b] analysis methodologies, use of reporting and presentation software, and strong communication skills.[/color][color=#555555]
- Perform complex [b]data[/b] analysis to ensure the accuracy and integrity of [b]data[/b][/color][color=#555555]
- Perform [b]data[/b] mining and [b]data[/b] modeling to facilitate decision making by business owners[/color][color=#555555]
- Identify problematic areas and conduct research to determine the best course of action to correct the [b]data[/b][/color][color=#555555]
- Troubleshoot and research [b]data[/b] anomalies and recommend corrective actions[/color][color=#555555]
- Monitor for timely and accurate completion of select [b]data[/b] elements[/color][color=#555555]
- Identify, analyze, and interpret trends or patterns in complex [b]data[/b] sets[/color][color=#555555]
- Monitor [b]data[/b] dictionary statistics[/color][color=#555555]
- In collaboration with business owners, interpret [b]data[/b] and develop recommendations based on findings[/color][color=#555555]
- Develop graphs, reports, and presentations of project results[/color][color=#555555]
- Perform basic statistical analyses for projects and reports[/color][color=#555555]
- Create and present quality dashboards[/color][color=#555555]
- Generate routine and ad-hoc reports[/color][color=#555555]
- Provide timely and accurate progress information to project status reports[/color][color=#555555]
- Provide technical assistance to other developers and systems [b]analysts[/b] when needed[/color][color=#555555]
- Work on multiple high priority projects concurrently[/color][color=#555555]
- Maintain and enhance technical skills through formal and on-the-job training[/color][color=#555555]
- Respond to and assist with other problem tickets as required[/color]

[charygaru]

uncle i dont want that stuff !! i want a real life scenario and daani explanation

for ex:-- i was dealing with real estate data in my last job and my CV says i did sql data analysis so repu interview la em peekav ani adigithe nenem cheppaali ??? i could just tell them we had some business requirements where in we had to analyze some data that was coming in if it was all in place or something was missing so we imported the data into the tables and checked for consistency and also we had tolerance levels set for some columns which had to be met else the data was corrupted or we requested the client to send the data again with missing fields or data mis matches or something.

ee paina raasindi entha relevant oo emo naaku telvadu just so i dont come across as a fool i wanted to know if someone really did some data analysis if yes what was it and what was the scenario so that i can apply it to my own and tell them that is what i did in my last project samjhe !!

[k2s]

[quote name='charygaru' timestamp='1344267128' post='1302264102']
uncle i dont want that stuff !! i want a real life scenario and daani explanation

for ex:-- i was dealing with real estate data in my last job and my CV says i did sql data analysis so repu interview la em peekav ani adigithe nenem cheppaali ??? i could just tell them we had some business requirements where in we had to analyze some data that was coming in if it was all in place or something was missing so we imported the data into the tables and checked for consistency and also we had tolerance levels set for some columns which had to be met else the data was corrupted or we requested the client to send the data again with missing fields or data mis matches or something.

ee paina raasindi entha relevant oo emo naaku telvadu just so i dont come across as a fool i wanted to know if someone really did some data analysis if yes what was it and what was the scenario so that i can apply it to my own and tell them that is what i did in my last project samjhe !!
[/quote]gotcha

[ganesh]

[quote name='k2s' timestamp='1344267223' post='1302264115']
gotcha
[/quote]GM UNCLE

[charygaru]

SQL baba's come and answer me re