Hyderabad Jobs |
Banglore Jobs |
Chennai Jobs |
Delhi Jobs |
Ahmedabad Jobs |
Mumbai Jobs |
Pune Jobs |
Vijayawada Jobs |
Gurgaon Jobs |
Noida Jobs |
Hyderabad Jobs |
Banglore Jobs |
Chennai Jobs |
Delhi Jobs |
Ahmedabad Jobs |
Mumbai Jobs |
Pune Jobs |
Vijayawada Jobs |
Gurgaon Jobs |
Noida Jobs |
Oil & Gas Jobs |
Banking Jobs |
Construction Jobs |
Top Management Jobs |
IT - Software Jobs |
Medical Healthcare Jobs |
Purchase / Logistics Jobs |
Sales |
Ajax Jobs |
Designing Jobs |
ASP .NET Jobs |
Java Jobs |
MySQL Jobs |
Sap hr Jobs |
Software Testing Jobs |
Html Jobs |
Job Location | Ahmedabad |
Education | Not Mentioned |
Salary | Not Disclosed |
Industry | IT - Software |
Functional Area | Sales / BD |
EmploymentType | Full-time |
Competencies(Technical)Expert T-SQL skillsa. Write stored procedures that pass parameters and return values.Writing complex queries, CTE, Sub Queries, use of Temporary Tables, Date, String Functions, stored proceduresAbility to create Stored SQL objects, validation and deploy the processQuery optimizationd. By optimizing the queries, Query Execution Plane. Adding indexes to the objectGood knowledge of Multidimensional Tabular modelAble to create cube ProcessOptimize cube, use of PartitionAbility to create data warehouse, data mart end to enddata modelling (ERwin)Create end to end ETL process (SSIS, SSAS)Slowly changing dimensionDatabase securityRead execution plan and optimizeSSISAble to use majority of the transformation within SSIS, SSASParallel processing, Debugging, Event handlers, DeploymentTFSUnderstand the use and purpose of TFSCode check in , check outCreate task and reportingDBA Knowledger. Backup- Restore, Creating Filegroups, Creating Link Serverss. Appropriate selection of database objects and data typesCompetencies (Non-Technical):1. SME of IT Solution/ Softwarea. Give technical presentations/ solutionsb. Engage in discovery sessions to shape complex technical solutionsi. Document solutionii. Create Estimate of solutioniii. Recourse solution2. Business Acumena. Understand Stakeholder business, Industry Environmentb. Able to speak professionally/ intelligently with Directors and below3. Leadershipa. Welcome responsibilityb. Take ownershipc. Delivery purposeful, strategic and resourceful wayd. Embrace changee. Cultivate passion, creativity and sense of adventuref. Practice self-awareness, self-management, social awareness and relationship management,
Keyskills :
datamodeling socialawareness parallelprocessing it sql etl sme ssis cube tsql string writing objects business strategy database warehouse debugging edprocedures direct