Experience Inc. Jobs

Senior Software Engineer (Data Engineer) - Chennai (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.

Job Description Sum mary

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 Skill set : Hadoop, SQL, Hive/Impala, Pyspark, Python, Unix

• Good to have: Django-python, Flask - Python, Airflow, Streaming

• Years of Experience : 4+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.

#LI-SG1

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, LifeWorks, offering 24-hour access to a global network of over 80,000 independent specialized 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, subsidized travel passes, health assessments, among others.

Visit our careers site (https://careers.iconplc.com/benefits) 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 (https://careers.iconplc.com/reasonable-accommodations)

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.

Are you a current ICON Employee? Please click here (https://wd3.myworkday.com/icon/d/task/1422$1235.htmld) to apply