Sr SQL SSIS Developer - with Coding in XML and XSLT

Dice is the leading career destination for tech experts at every stage of their careers. Our client, People Force Consulting Inc, is seeking the following. Apply via Dice today!

Sr SQL SSIS Developer - with Coding in XML and XSLT

Remote

Experience level 12 years

Must have: Coding in XML and XSLT

Key Skill /Skill : Specialization SQL Server Integration Services (SSIS) with Google Cloud Platform knowledge

Mandatory Skills : SQL , ETL-SSIS, Strong Communication Skills

Desired Skills : Google Cloud Platform, Other ETL & Cloud Technologies, Healthcare Data Experience.

Job Description

Mandatory

Design, develop, test, deploy and troubleshoot SSIS packages that implement complex ETL processes. Scheduling and monitoring the ETL jobs Build and review functional and business specifications (S2T) Strong understanding of Microsoft SQL Server, T-SQL, Stored Procedures, Views, and Functions. Provide the estimates for the ETL work 5. Familiar with Agile methodologies. Actively work with Architect, Business Analyst, Data Analyst, Cube and Report Developers Work with DBA s on Database creation and performance tuning. Expertise in query construction, including writing and optimizing complex SQL queries that contain sub queries, joins, and derived tables Troubleshooting and fixing the code. Unit testing the code and documentation of results Work with gate keeper on promoting the data stage jobs to QA and Production. Participate in code reviews Strong analytical and thinking capabilities, good communication skills to conduct requirement gathering sessions/interview customers Ability to perform independent research to understand the product requirements and customer needs Communicates effectively with the project teams and other stakeholders

Key Skills

• SQL