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:
o Inner and Outer Joins
o Aggregate functions
o Subqueries
o Regular Expressions
o Analytical functions
o Packages and Function
Should have profound knowledge of Analytical functions, Table functions, excellent SQL query writing skills, 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
Valuable to have
Experience with Account Billing Concepts (Invoices, Accounts, Line Items, etc.)
Experience with Telecom/Telephony types of invoices