Sign In
 [New User? Sign Up]
Mobile Version

Tech Lead

Secunderabad, Telangana
Job Code:
  • IT
Applying for this job will take you to an external site
  • Shortlist
  • Email Friend
  • Print

Job Details

Proficient on all SQl server concepts including SSAS,SSRS and SSIS and integration, sharepoint etc .. Should have ETL development skills . Should have very good data analysis skills.. Suggest design alternatives. Architect proficency Can work with different modules and make tactical decisions. Lead team to create prototypes to validate design decisions. Design and Code Review. Establish build and unittesting processes. Mentor the team on the technology and design front. . Knowledge in Design, Capacity Planning and Architecting ETL solutions Soundknowledge in Performance TuningPackages Implementing Transactions based packages. . Sound knowledge in Best Practices of developing SSIS Project UsingSSIS beyond ETL (DB Maintanance). SQL Constructs Ablility to understand and implement Data Types, Basic SQLSELECT Statements, Restricting and Sorting Data, System Functions, Joins, Sub-Queries, Creating & Managing DB Objects, Manipulating Data (DML),Constraints,Views . SQL Query Tuning Basics Understanding of concepts like TuningMethodology, SQL Statement Processing,SHOWPLAN, Introduction to the Optimizer,Indexes and Basic Access Methods, Gathering Statistics, Optimizer Hints,Monitoring queries, Optimizing queries.. Adv SQL COMPUTE Clause, AdvancedINSERT, Transact-SQL conditions and expressions, Dealing with collation sequences, Using scalar and aggregate functions, Multiple Table Queries Tools. Adv SQL & SQL Tuning Techniques Able to implement Executingfull-text searches, Managing Data and Concurrency, Writing Scripts and Batches,querying System tables Ability to implement TunningConcepts/Techniques likeShow Plan, Managing Optimizer Statistics, Indexes, Plan Stability, Application Tracing Tools SQL Access Advisor Adv SQL Tuning Mastering in resolvingComplex Performance issues throughAdvanced SQL Tuning Techniques . Database Programming Basics Ability to understand and implement DeclaringVariables, Building Blocks,Control Structures, Explicit Cursors, HandlingExceptions, Creating Procedures, Creating Functions, Creating Database Triggersand Transaction Management. Adv Database Programming Ability to understand andimplement Dynamic SQL Usage, Programming with locks and isolations andWorking with Temporary Tables . Should have competency in Data warehouse Concepts and ETL concepts, Data warehouse architecture anddifferent stages of datawarehouse. . Operational Data source andData mart concepts. Should have worked on atleast one database testproject.Should be aware of the OLTP and OLAP concepts.
Degree: MCA/ PGDCA

Additional Degree: BE/ B.Tech (Engineering)

Experience: 3-5


Application Programming | Database Administration (DBA) | Software Engineer
Applying for this job will take you to an external site


© Copyright 2015 Al Nisr Publishing LLC - powered by Gulf News