Senior Software Engineer
ICON Public Limited Corporation
Office Based, Chennai
ICON plc is a world-leading healthcare intelligence and clinical research organisation. From molecule to medicine, we advance clinical research providing outsourced services to pharmaceutical, biotechnology, medical device and government and public health organisations.
With our patients at the centre of all that we do, we help to accelerate the development of drugs and devices that save lives and improve quality of life.
Our people are our greatest strength, are at the core of our culture, and the driving force behind our success. ICON people have a mission to succeed and a passion that ensures what we do, we do well.
Job Description Summary
Symphony Health, part of the ICON plc family, is a leading provider of high-value data, analytics, technology solutions and actionable insights for healthcare and life sciences manufacturers, payers and providers.
The company helps clients drive revenue growth and commercial effectiveness, while adapting to the transformation of the healthcare ecosystem, by integrating a broad set of patient, prescriber, payer and clinical data together with primary and secondary health research, analytics and consulting.
Symphony Health delivers a comprehensive perspective on the real dynamics that drive business in the healthcare and life sciences markets.
Essential duties and Responsibilities:
Mandatory Skillset : Hadoop and PLSQL
Years of Experience : 5+years
Maintain highly scalable data platform and analytical solutions including but not limited to the following technologies RDBMS / Big Data / Cloud.
Applies knowledge of general business functions and systems to develop IT strategies, operational plans, and standards to support achievement of department, business, and corporate goals.
Responsible for partnership with internal and external stakeholders to ensure high quality delivery of information technology solutions.
Designs and develops database by setting expectations and features priorities throughout development life cycle; determining design methodologies and tool sets; completing programming using languages and software products; designing and conducting tests.
Recommends system solutions by comparing advantages and disadvantages of custom development and purchase alternatives.
Completes applications development by coordinating requirements, schedules, and activities; contributing to team meetings; troubleshooting development and production problems across multiple environments and operating platforms.
Identify opportunities to fine-tune and optimize applications.
Hands on experience needed in Hadoop Ecosystem Cloudera CDP (Preferred), HiveSQL, Impala, Apache Spark (PySpark) for enhancement of any projects.
Monitoring and troubleshooting the scheduled jobs using Autosys.
Monitoring and troubleshooting issues with the data loads to S3, Athena databases in the Cloud.
Ensures daily deliverables complete in time for clients and monitors schedules that involves adjusting the priority of the jobs, usage of space, memory, and resources.
Automates any repeated manual process using Autosys scheduler and Unix/ Linux.
Preferred Knowledge/ Experience:
Know the key concepts like procedures, functions, triggers, constraints, package, Sub Programs, PL/SQL error handling etc.
Performance Tuning, Data Modeling and Unix /Python Scripting.
Aware about code optimization techniques.
Hadoop Ecosystem Cloudera CDP (Preferred), HiveSQL, Impala, Apache Spark (PySpark) (Nice to have)
SQL / RDBMS – Relational Database Management Systems
1. Relational Database Concepts
2. Client / Server Concepts
Desired Competencies (Technical/Behavioral Competency)
Atleast 5 years hands on experience in Oracle PL/SQL UNIX / LINUX/ Python Scripting – Aware about Oracle installation, database creation, maintenance and performance tuning.
Behavioral traits such as right attitude, motivation, taking initiatives, organizational skills and effective time management.
Excellent written and oral communication skills.
Being a team player as well as ability to work independently with reliability and integrity.
Ability to establish and maintain productive working relationships in multi-disciplinary teams with good adaptability, flexibility, and negotiation skills.
2+ years of experience in Hadoop Ecosystem Hive, Impala, Pyspark. (Cloudera – CDP Preferred).
2+ years of experience in scheduling Autosys jobs.
Knowledge in cloud platform/ tools (S3, Athena) concepts and trends. AWS preferred.
Expert troubleshooting skills.
Benefits of Working in ICON:
Our success depends on the knowledge, capabilities and quality of our people. That’s why we are committed to developing our employees in a continuous learning culture – one where we challenge you with engaging work and where every experience adds to your professional development.
At ICON, our focus is to provide you with a comprehensive and competitive total reward package that comprises, not only an excellent level of base pay, but also a wide range of variable pay and recognition programs. In addition, our best in class employee benefits, supportive policies and wellbeing initiatives are tailored to support you and your family at all stages of your career - both now, and into the future.ICON, including subsidiaries, is an equal opportunity and inclusive employer and is committed to providing a workplace free of discrimination and harassment. All qualified applicants will receive equal consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.
If, because of a medical condition or disability, you need a reasonable accommodation for any part of the application process, or in order to perform the essential functions of a position, please let us know through the form below.
#LI-SG1
Job posted: 1970-01-01
