Job Description: The candidate must have advance SQL Server Developer skills including broad understanding of advance SQL Functions, expertize in DDL, DML, SQL/Dynamic SQL, SSIS and SSAS. The DB Developer is responsible for the design, development and maintenance of high quality, efficient and effective solution in MS SQL Server T-SQL, ETL, Integration and related tools to support a number of large-scale data migration projects. This includes developing and managing SQL database processes and services, identifying and problem-solving for issues, interpreting and presenting program results. • 4- 7+ years of experience with Microsoft SQL Server 2012 and above. • Design, develop and maintain appropriately-scaled, effective solutions to support data quality, migration and reconciliation activity in Microsoft SQL Server T-SQL, Integration Services and related tools. Support customer experience, architecture, security and operations. • Very strong T-SQL skills and strong knowledge of ETL techniques. Creating and analyzing complex queries, store procedures, tables, views, triggers, functions, SQL Jobs. Ability to write reusable, robust, and clean code to do almost anything. • Strong experience in SSAS. • Design and implementation of SSIS, and ETL based on business requirements. • Good understanding of Database Design, Integrity, and optimization process. • In depth experience of performance-tuning SQL Server databases code and environments, and SQL profiling. • Strong background in data modelling, data management and data manipulation, code management and version control (TFS). • Strong problem-solving and analytical skills. Able to understand business requirements and develop SQL Server solutions that work within the technical boundaries. • Working directly with the business teams to understand their needs, identify and resolve data issues. • Knowledge of table replications. • Knowledge of security management such users and object permission. • Knowledge of active directory and security groups. • Writing technical design and supporting documentation. • Initiative and a strong desire to work for a fast-paced dynamic organization. • Self-motivated and willing to "do what it takes" to get the job done. Location: Bangalore Experience: 4 to 7 Years Skills Required: SQL SERVER INTEGRATION SERVICES (SSIS) Roles: The candidate must have advance SQL Server Developer skills including broad understanding of advance SQL Functions, expertize in DDL, DML, SQL/Dynamic SQL, SSIS and SSAS. The DB Developer is responsible for the design, development and maintenance of high quality, efficient and effective solution in MS SQL Server T-SQL, ETL, Integration and related tools to support a number of large-scale data migration projects. This includes developing and managing SQL database processes and services, identifying and problem-solving for issues, interpreting and presenting program results.
