Senior Software engineer - Chennai, India - Office with flex(Hybrid)
ICON plc is a world-leading healthcare intelligence and clinical research organization. We're proud to foster an inclusive environment driving innovation and excellence, and we welcome you to join us on our mission to shape the future of clinical development
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, SQL, Spark/Pyspark, Python
Years of Experience : 6+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
- 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-MM1
What ICON can offer you:
Our success depends on the quality of our people. That's why we've made it a priority to build a diverse culture that rewards high performance and nurtures talent.
In addition to your competitive salary, ICON offers a range of additional benefits. Our benefits are designed to be competitive within each country and are focused on well-being and work life balance opportunities for you and your family.
Our benefits examples include:
Various annual leave entitlements
A range of health insurance offerings to suit you and your family's needs.
Competitive retirement planning offerings to maximize savings and plan with confidence for the years ahead.
Global Employee Assistance Programme, TELUS Health, offering 24-hour access to a global network of over 80,000 independent specialised professionals who are there to support you and your family's well-being.
Life assurance
Flexible country-specific optional benefits, including childcare vouchers, bike purchase schemes, discounted gym memberships, subsidised travel passes, health assessments, among others.
Visit our careers site to read more about the benefits ICON offers.
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, colour, 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 or submit a request here.
Interested in the role, but unsure if you meet all of the requirements We would encourage you to apply regardless there's every chance you're exactly what we're looking for here at ICON whether it is for this or other roles.
