SSIS Developer

Job Role: SSIS Developer

Job Location: Warren, MI (Remote then Onsite)

Job Type: Full Time

Note: No Visa Transfer, No Visa Sponsorship

Detailed JD:

Responsibilities:

Working with Business Intelligence & Data Warehouse production support team to analyze issues reported by business users. Diagnose, debug & correct existing software problems & data issues. The candidate will be responsible for monitoring daily ETL jobs & Datawarehouse Processes, resolve any issues encountered during daily load processes and communicate status to stakeholders. The candidate will be responsible for communicating with business users and come up with explanation for data discrepancies reported by business users or analyzing while the jobs failed and resolving Job failures. The candidate should have a good understanding of current business intelligence tools and data warehousing tools and can support the implementation of the tools.

Requirements:

Strong T-SQL knowledge and skills required. 3 years' Experience in Writing SQL Scripts, Stored Procedures, Functions, Creating Tables, Triggers and other DB Objects required.

Bachelor's degree in one of the following subject areas: Computer Science, Data Science, Information Technology or related field.

Around 3 years of software development experiences with strong understanding of database structures, theories, principles, and practices. (or an advanced degree in related areas)

3 years of Experience in creating Microsoft SSIS packages, enhancing SSIS Packages and Modifying when needed and deploying to stage and production environments.

Knowledge of Microsoft SSRS/QlikView is good and having Power BI is a BIG plus.

Attention to detail written and verbal communication skills

Able to prioritize and execute tasks to meet deliverable deadline.

Candidate will be primarily responsible for Maintaining and resolving Datawarehouse related issues. And troubleshooting SSIS ETL Packages.