Roles and Responsibilities: Design Stored Procedures, Views, Functions, triggers, indexes, constraints etc. Develop complex SQL code using joins, subqueries and troubleshoot the SQL code. Integration of multiple data sources and databases into one system. Build clean and reusable SQL queries for future use. Improve the performance and optimise SQL queries to get best results. Work with team members on design of software systems and support to development team. Establish processes and best practices with defined database standards. Skills / competencies: Extensive experience working with enterprise applications using relational databases (Postgresql is preferred). Strong knowledge and experience in query optimisation, performance tuning, using SQL profiler, Performance monitor and related monitoring tools. Experience developing complex queries, Stored Procedures, Views, Functions, Triggers and troubleshooting the same. Familiarity with RDBMS principles, normalisation, database design is an added advantage. Understanding of the fundamental design principles behind a scalable application. Special Requirements: 5+ years experience in SQL development, performance tuning and query optimisation. Strong analytical, problem solving, English communication skills, both written and spoken. Knowledge of PHP/ Laravel will be an added advantage. Experience with enterprise-scale systems a major plus.
Job Description Individuals should have - Good hands on experience of ETL development on tools like Informatica - Good experience in Informatica ETL and Workflow development- Good experience writing complex SQL and doing data analysis- Experience with Oracle SQL and PL/SQL- Experience with Stored Procedures - Good SQL experience & knowledge- Good Experience on UNIX commands- Should have understanding of one of the programming language. - Individuals should have understanding of the cloud based ETL by using Redshift- Understanding of the Healthcare / Life Science domain is big Plus.
PHP with Laravel or Codeigniter... Immediate Joiny