Senior Software Engineer
- Chennai
- Engineering
- ICON Full Service & Corporate Support
- Office Based
Talent Acquisition Business Partner
- Full Service Division
About the role
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
A better career. A better world. A better you.
Our people are our greatest strength, are the core of our culture and the driving force behind our success. Throughout all levels of the company, our people have a drive to succeed and a passion that ensures what we do, we do well. We help you build exciting and rewarding careers, deliver results to help bring life-changing medicine and devices to market and maintain ICON’s success as an industry leader. See all locations Read more
Day in the life
Who we are
Similar jobs at ICON
Salary
Location
US, Blue Bell (ICON)
Department
Full Service - Development & Commercialisation Solutions
Location
Blue Bell
Remote Working
Hybrid: Office/Remote
Business Area
ICON Full Service & Corporate Support
Job Categories
Engineering
Job Type
Permanent
Description
At ICON, it’s our people that set us apart. Our diverse teams enable us to become a better partner to our customers and help us to fulfil our mission to advance and improve patients’ lives. Our ‘Own
Reference
JR118207
Expiry date
01/01/0001
Author
Jasmine GarciaAuthor
Jasmine GarciaSalary
Location
US, Blue Bell (ICON)
Department
Full Service - Symphony Health
Location
Blue Bell
Remote Working
Office Based
Business Area
ICON Full Service & Corporate Support
Job Categories
Engineering
Job Type
Permanent
Description
ICON plc is a world-leading healthcare intelligence and clinical research organization. From molecule to medicine, we advance clinical research providing outsourced services to pharmaceutical, biotech
Reference
JR116178
Expiry date
01/01/0001
Author
Tallulah PierreAuthor
Tallulah PierreSalary
Location
Poland, Warsaw
Department
Full Service - Development & Commercialisation Solutions
Location
Sofia
Warsaw
Lisbon
Bucharest
Barcelona
Edinburgh
Reading
Remote Working
Hybrid: Office/Remote
Business Area
ICON Full Service & Corporate Support
Job Categories
Engineering
Job Type
Permanent
Description
At ICON, it’s our people that set us apart. Our diverse teams enable us to become a better partner to our customers and help us to fulfil our mission to advance and improve patients’ lives. Our ‘Own I
Reference
JR117116
Expiry date
01/01/0001
Author
Katty Barreto MaiaAuthor
Katty Barreto MaiaSalary
Location
Ireland, Dublin
Department
Information technology
Full Service - Symphony Health
Location
Dublin
Remote Working
Office Based
Business Area
ICON Full Service & Corporate Support
Job Categories
Software Engineer
Job Type
Permanent
Description
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, biotech
Reference
JR118398
Expiry date
01/01/0001
Author
Damien KehirAuthor
Damien KehirSalary
Location
Ireland, Dublin
Department
Information technology
Location
Dublin
Remote Working
Office Based
Business Area
ICON Full Service & Corporate Support
Job Categories
Engineering
Job Type
Permanent
Description
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, biotech
Reference
JR116637
Expiry date
01/01/0001
Author
Damien KehirAuthor
Damien KehirSalary
Location
US, Blue Bell (ICON)
Department
Full Service - Symphony Health
Location
Blue Bell
Remote Working
Office Based
Business Area
ICON Full Service & Corporate Support
Job Categories
Engineering
Job Type
Permanent
Description
ICON plc is a world-leading healthcare intelligence and clinical research organization. From molecule to medicine, we advance clinical research providing outsourced services to pharmaceutical, biotech
Reference
JR116127
Expiry date
01/01/0001
Author
Tallulah PierreAuthor
Tallulah Pierre