PL-SQL Developer - Oracle DB

Senior PL/SQL Mapper Developer The Mapping Development team is looking for a Senior SQL Mapper Developer who will primarily be responsible develop, enhance and maintain the PL SQL code for the processes that gather data out of input files, in standardized formats (EDI, Edifact, Excel, CSV etc.), and transform it into our internal format. The internal format will then be loaded in various Tangoe products for our customers. The Mapper Developer/Analyst would need to understand Data Analysis documentation and implement the code according to requirements, while also being proactive in determining input data limitations and finding solutions to respect the Data Analysis as closely as possible, providing strong feedback to Analysts and QA. Occasionally the mapper developer would have to read and learn through some legacy systems code without any detailed documentation. Required Qualifications : - 4 years of experience with SQL PL SQL, including good understanding and experience of the following : 1. Inner and Outer Joins 2. Aggregate functions 3. Subqueries 4. Regular Expressions 5. Analytical functions Packages and Function - Should have profound knowledge of Analytical functions, Table functions, excellent SQL query writing skills, and debugging skills. - Aptitude to learn Oracle PL/SQL - 3 years of experience with Microsoft Excel. - Strong analytical thinking and problem-solving ability - Well-developed communication skills - Must be able to work effectively in a team environment - Proficient at time and priority management - Strong verbal and written communication skills - Good English skills Good to have : - Experience with Account Billing Concepts (Invoices, Accounts, Line Items, etc.) - Experience with Telecom/Telephony types of invoices - Good/Basic Linux Shell Scripting knowledge (ref:hirist.tech)

Location: in, IN

Posted Date: 11/22/2024