Job Description :
Title: Data Integration Developer
Location: Mount Laurel, NJ
Duration: 12 month
Visa Type: GC or higher
Interview Type: In-person
Job Purpose: Perform development, testing and implementation of .NET, Oracle PL/SQL, and miscellaneous Windows and Linux scripts to support client data integration needs.
Essential Functions:
Work directly with clients or thru client services, to ingest client data or prepare client data for delivery to clients in support of billing and data interchange
Design, develop and document processes that consolidate and integrate data per client requirements.
Work with file inputs on custom programs that are .Net coded and transfer them to the database by running processes that load the data into their system
Use Microsoft Office products (ie – Excel) to facilitate import/export/transformation of data
Work with technical leads to tune and troubleshoot functional and performance problems in ETL jobs.
Work with the DBA team to tune and refactor SQL used in ETL jobs
Identify and suggest patterns within existing processes to introduce efficiencies and increased throughput.
Provide some technical guidance to team members
Technical Environment:
SAP data services
Rational and Dimensional models
Oracle 11 or 12 as backend database platform
Knowledge and Skill
4+ years of working experience in data warehousing/ETL development
Working knowledge of SQL, ANSI SQL, PL/SQL
Working knowledge of reading and creating ER diagrams
Knowledge of Oracle 11g development
Demonstrated knowledge and experience using custom .NET and PL/SQL programs for data manipulation.
Experience developing and interacting with custom-built web services for purposes of data import/export
Use of Microsoft Office desktop tools such as Excel for data loading and extracting
Excellent verbal and written communication skills with ability to clearly articulate and discuss technical issues
Strong analytical skills, able to effectively solve problems in a timely manner
Bonus Skills:
Knowledge of billing processes and procedures, particularly invoice formatting
Experience querying and loading dimensional and relational data models in a data warehouse environment
with