Data Base Developer Lead Etl/Ssis

.**Primary Purpose**:Serve as a high-level technical expert in the designing, coding, testing, supporting and debugging of new software or significant enhancement to existing software.**Essential Duties and Responsibilities**:Following is a summary of the essential functions for this job. Other duties may be performed, both major and minor, which are not mentioned below. Specific activities may change from time to time.- Create, maintain, and optimize stored procedures, functions, inline SQL, database structures, and ETL processes to adapt to changes in needs and requirements- Test coded program routines and makes revisions to eliminate errors- Review test results with business, completes final program documentation, and obtains approval for changes- Analyze and document how the business requirements fit into existing system- Develop technical specifications to resolve business client questions, problems, and to address enhancement needs- Develop new methods and procedures for accomplishing work- Provide work direction to less experienced team members- Translate detail program specifications for complex problems into coded computer instructions- Work with IT management team on project priorities and deliverable timelines- Interface with all IT and business teams to determine/communicate impacts- Analyze issues independently, use judgement to make decisions, and take necessary action- Review work of other team members for accuracy, adherence to standards, optimization- Provide on call support and provide direction to other on call resourcesJOB REQUIREMENTS**Minimum Skills and Competencies**:The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.- Bachelor Degree or in-lieu of degree equivalent education, training and work-related experience- 7+ years of experience with Structured Query Language- Experience in one or more of the following: SSIS, SSMS, SSRS, Informatica, Oracle, PostgreSQL.- knowledge of DataBase Transfers, Data Analyst.- Demonstrated knowledge of data warehouse concepts (data normalization, star schema, etc