Senior Software Engineer (PL SQL developer)

• 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 

• Client / Server Concepts 

Desired Competencies (Technical/Behavioral Competency) 

• Atleast 7 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 quality of our people. That’s why we’ve made it a priority to build a culture that rewards high performance and nurtures talent.

We offer very competitive salary packages. And to keep them competitive, we regularly benchmark them against our competitors. Our annual bonuses reflect delivery of performance goals – both ours and yours.
We also provide a range of health-related benefits to employees and their families and offer competitive retirement plans – and related benefits such as life assurance – so you can save and plan with confidence for the years ahead.
But beyond the competitive salaries and comprehensive benefits, you’ll benefit from an environment where you are encouraged to fulfil your sense of purpose and drive lasting change.

ICON 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.

#L1-MM1