Job description

(1) Optimize, develop and maintain integration solutions using SQL Server SSIS and ETL Framework(BIDS) as necessary to connect legacy data stores, the data warehouse

(2) Develops, maintains and optimizes al effort related to Data Warehouse (SSIS, Stored procedures, Views etc.)

(3) Creates data warehouse components using best practices methodologies

(4) Builds and maintains through documentation of the data and how it is moved through layers

(5) Perform data conversion from OLTP to DW using tools like SSIS/Data Factory

(6) Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity

(7) Ensure the stabilization and high performance of existing ETL processes

(8) Troubleshoot and complex data related issues as well as provide support to production

(9) Develop and deploy ETL job workflow with reliable error/exception handling and rollback

(10) Must have experience working on SSRS

(11) Power BI experience is preferred

(12) Experience with Crystal Report will be beneficial

(13) API Development experience is preffered

(14) May be involved with manual testing

(15) Perform other related dutirs as required

Job Types: Contract, Temporary

Salary: $45.00 - $53.00 per hour

Schedule:

• 8 hour shift

Experience:

• Data modeling: 1 year (Preferred)
• ETL (Including SSIS or other ETL tools): 6 years (Required)
• Data Analytics: 6 years (Required)
• Data Warehouse: 6 years (Required)
• MS SQL Reporting Server (SSRS: 4 years (Required)
• Power BI: 3 years (Required)
• Web API development: 3 years (Required)

Work Location: Remote

colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, colinoncars.com is the ideal place to find your next job.