Are You An Employer?
If you're looking to post a job, go to our employer website. (Thanks, but I'm searching for a job).)
Are You A Job Seeker?
If you're searching for a job, go to our job seeker website. (Thanks, but I'm looking to post a job).)
Don't display this message again x
Sign In
 [New User? Sign Up]
Mobile Version

Data Integration Developer I

Carrington Mortgage Holdings, LLC


Location:
Aliso Viejo, California 92656
Date:
08/09/2017
2017-08-092017-09-08
Job Type:
Employee
Job Status:
Full Time
Categories:
  • Information Technology
  • Computer Programming/Systems
Carrington Mortgage Holdings, LLC
  •  
  • Save Ad
  • Email Friend
  • Print

Job Details

Data Integration Developer I (Carrington Mortgage Holdings, LLC – Aliso Viejo, CA)

Administer, test, and implement computer databases, applying knowledge of database management systems. Analyze data, perform data cleaning, data validation to provide mortgage information to investors. Design and optimize complex stored procedures to perform database operations. Create Database objects to perform analysis and collect data for accounting report. Support large databases, troubleshoot problems, and document root cause analysis. Participate in the ETL process involving the extraction, analysis, transformation, loading and presentation of information to the end users. Utilize the Dynamic SQL for user customizable queries to be answered by the SQL Server and to input and export data (Bulk Load). Develop complex mappings using SSIS to transform and load data from various source systems. Created reports with Document Map for easy navigation to the reports data. Create various views and materialized views that will be accesses by both the end users and the database administrators. Conduct JRD sessions with business users to gather data warehouse requirements and analyzed database requirements in detail with the project stakeholders. Create data dictionary including data transformation or data mediation between a data source and a destination.

 

Requires a Bachelor's degree (or foreign equivalent) in Computer Science, Information Systems, Statistics, Mathematics, or related technical field and 2 years of experience in the job offered or in a database administration, business analyst, or similar role. Must have 2 years of experience in the following: requirements gathering, analysis and design of ETL processes using SQL Server Integration Services (SSIS); translating business requirements into workable functional and non-functional requirements at detailed production level; creating SSRS ad-hoc reports using report, drop-down, multi-valued, and debugging parameters and issue matrix reports and charts; and, developing complex Stored Procedures, Triggers and User Defined Functions for implementing business logic and process in backend, for data extraction, reports and client interfaces. Experience may be gained concurrently.

 

To apply, please send resume to recruitingdl@carringtonmh.com and reference JobID#: 2017-5472.

Quick Search:

Enter Keyword(s):
Enter Location:
Advertisements