ETL Developer

ETL Developer Sacramento, CA Long Term Onsite role, need locals Required Skills: Develop complex data extracts, applications, and ad-hoc queries as requested, using SQL or SSIS. Research, troubleshoot, and resolve data issues impacting extract delivery. Work within the project team to complete system analysis and application design. Work closely with Business Analysts to refine requirements and ensure data quality. Collaborate on the definition, development, and maintenance of standards and processes. Must be proficient with T-SQL, and development of stored procedures. Report writing and dashboard development experience, preferably with SSRS and Power BI. Drive continuous improvement and automation in BI solutions and processes. Work effectively with System Administrators, Project Manager(s), Developers and Management. Participate in a team development environment using the TFS source control system. Desired Skills: Degree in Computer Science, business or related discipline. 4 years of experience with T-SQL, including stored procedure development Knowledge of data integration, e.g. extract, transform, and load (ETL) process development/support. Able to develop and troubleshoot reports delivered with SSRS; requires good analytical skills. Experience with data access performance tuning, and database performance optimization. Application Development Lifecycle knowledge and experience. Data transport protocols, e.g. SFTP, XML, and JDXDML. Experience with Case Management data and/or Call Center data. Documentation of system support information. Basic understanding of networking principles. Ability to analyze system resource usage and constraints. Strong communication skills; ability to interact at all levels including management. Works independently and follows through on assignments. Sunil Damagalla West Advanced Technologies, Inc E: sunil.d@wati.com D: 279-666-5837 Serving government agencies for 22 Years www.wati.com 1610 R St, Suite 300, Sacramento, CA 95811