SQL DB Developer

Job Description

Company SummaryFirst American (India) is a Global In-house Center (GIC) of the First American Financial Corporation (NYSE: FAF) family of companies, a proud member of the FORTUNE 500 companies and was named one of FORTUNE s 100 Best Companies to Work For in 2020. First American Financial Corporation provides comprehensive title insurance, closing/settlement, property data and technology solutions. First American (India) creates quality solutions for its customers by combining software, back office and knowledge processing operations to fulfill First Americans business requirements. Our priorities are our employees, customers and shareholders - in that order. FAI has been recognized as one among India s Top 75 workplaces in IT & IT-BPM 2019 by Great Place to Work Institute. Software Services helps build First Americans product suite that encompasses the best in class Title Insurance, Settlement and Mortgage solutions platforms. Leverages technology product stack across Microsoft platform predominantly to develop, enhance and maintain the best in class applications. The R & D division delivers solutions for the title insurance industry leveraging the best of NLP, AI and ML. Job SummarySenior Software Engineer will translate functional requirements into system requirements while developing applications for First American, these are typically web based applications developed by adhering to coding standards and guidelines by following a continuous Build-Integrate-Test (Agile) approach. Software Engineer will have Understanding the software development lifecycle and has knowledge of the overall application development space combined with a basic understanding of the business and domain. Role will build basic code assigned modules and features using available stacks and knowledge of programming languages generally under supervision, will apply standard trouble shooting and debugging concepts to achieve speed and efficiency. Software Engineer will understand the Agile manifesto and ceremonies, will design, and develop basic DB solutions, work with Configuration Management tools to enforce CM practices and processes. Role is required to adhere to the QA standards defined by the organization and will work with a deep understanding of performance bottlenecks, production infrastructure, interfaces, and dependencies of the product.Responsibilities:Responsibilities/Competencies:

• Gather and translate user requirements for reports, analysis, and business opportunities into technical specifications.
• Write SQL or other querying code to extract and manipulate data from database systems.
• Test and validate underlying report data.
• Provide technical support, including training. To report consumers for existing reports.
• Translate and summarize data results into written reports.
• Participate in new technology evaluation and ensure alignment of business unit data and analytics practices with enterprise data processes and practices.
• May be called upon to handle other duties as required.
• Understands and meets stated needs & requirements of the stakeholders, brings contextual nuances in deliverables and work output to truly partner with all concerned stakeholders.
• Monitors own work to ensure delivery within the desired performance standards. Understands the importance of delivery within expected time, budget and quality standards and displays concern in case of deviation.
• Takes initiative to develop own technical / behavioral skills; reflects and learns from experiences of self and others.
• Is receptive to new ideas and different perspectives, Questions routine/ procedures that do not seem efficient and can be improved.
• Adapts to other cultures and unfamiliar situations, thinks on the feet & displays sense of urgency for completion of deliverables.
• Encourages teamwork and collaboration by promoting openness and dialogue, facilitates participation of self and other team members in organizational decisions and motivates other team members and drives pride and positivity in work. Exhibits professionalism in conduct of work and respects others views.
• Displays excellent verbal and written communication skills and interpersonal skills required to interact with colleagues including customer, onshore counterpart, supervisors, team members, business analysts and business teams.

Technical Skills:

• Must have experience with SQL Server 2008/2012/2016 and T-SQL in both OLAP and OLTP environments
• Create and modify database schema, T-SQL scripts, stored procedures, and other database objects and SSIS packages in order to meet customer requirements.
• Must have strong working knowledge of MS SQL Management Studio
• Set up, maintenance and support jobs in SQL Agent.
• Strong in Jason Conversions to SQL.
• Strong in SQL Server Integration Services (SSIS) for ETL and SQL Server Reporting Services (SSRS) for report generation
• Good in performance tuning especially tuning complex queries, procedure, and indexing strategies
• Experience in Data Modeling, Database design and well versed with SQL Server best practices
• Capable of troubleshooting common database issues
• Familiar with tools that can aid with profiling server resource usage and optimizing it
• Must have experience working with high concurrency web applications
• Review the work of peer developers
• Perform performance analysis using query analyzer and SQL Profiles
• Adhere to best practices and coding standards and help to improve them over time
• Create and update documentation and project management artifacts in support of research and coding activities.
• Should have experience working with Global teams consisting of other talented developers, product managers, project managers, and architects.
• Must be able to communicate effectively in English both verbally and in writing
• Should be a very good team player possessing inter-personal skills

Educational Qualification and Experience: Minimum of 15 years of formal education - Graduate / Post Graduate in Computer Science / Information Technology.Professional work experience of 5 to 7 years.FAI invests in it s employee s development and well-being, empowers them to provide superior customer services and encourages them to serve the communities where they live and work. FAI is committed to diversity and inclusion. We are an equal opportunity employer.,

Keyskills :
sqlanalyticsetlpentahoubuntussrsssissql server reporting servicessoftware development life cyclesql server integration servicesnew technology evaluationms sqlsql serverdata modelingquery analyzertitle insurance