SSIS ETL Architect

esign, model and develop complex data models and data integrations utilizing SQL server (SSIS) based ETL processes for new and existing systems : Participate in planning and implementing the data integration and data migration activities. : Coordinate with team members to perform database programming based on project requirements. : Develop stored procedures, complex SQL queries, scripts and database programming for systems. : Perform quality assurance tests for ensuring data integrity across multiple databases. : Interact with project leaders to understand project requirements. : Provide valid inputs in database architectural discussions. : Assist in identifying process improvements for database performance, reliability and stability. : Perform troubleshooting and analysis to assess root cause of data issues in a timely manner. : Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file and MS SQL Server by using SSIS services and transformation objects : Understands best practices for data modelling, database programming and job scheduling and ETL package dependencies.Job Level Specific Duties• Entry-level position into business systems analysis.• Provides end user support for a specific application while learning about the application and customer. • Assists in application implementations and assists in testing end user processes using defined guidelines. • Updates existing tables and verifies the accuracy. • Collects data and runs basic reports in response to client inquiries as directed by more senior associates. • Interacts with clients, both internal and external, to supply basic information. • Analyzes business and user needs, documenting requirements, with the guidance of a senior associate.• Documents business rules/functional requirements to support system enhancements with the guidance of a senior associate.• Logs and tracks basic problems / work tickets with external product vendors or support organizations.Typical Years of Experience• Typically requires 2-4 years relevant experience.Minimum Education and Certifications• Undergraduate degree or equivalent combination of education and work experience.Skills• Awareness of system development methodology, project management and system architecture. Basic analytical / problem solving skills. • Ability to consider IT and business challenges.• Influencing and communication skills. Ability to translate between non-technical business users and technical IT resources. Strong client service attitude.• Organizational and time management skills.Physical Requirements/ Working Conditions• Ability to physically perform general office requirements. • Must be able to perform essential responsibilities with or without reasonable accommodations.• Significant travel including overnight domestic or international trips may be required.SQL Server 2016SSIS 2016Design, model and develop complex data models and data integrations utilizing SQL server (SSIS) based ETL processes for new and existing systems : Participate in planning and implementing the data integration and data migration activities. : Coordinate with team members to perform database programming based on project requirements. : Develop stored procedures, complex SQL queries, scripts and database programming for systems. : Perform quality assurance tests for ensuring data integrity across multiple databases. : Interact with project leaders to understand project requirements. : Provide valid inputs in database architectural discussions. : Assist in identifying process improvements for database performance, reliability and stability. : Perform troubleshooting and analysis to assess root cause of data issues in a timely manner. : \Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file and MS SQL Server by using SSIS services and transformation objects : Understands best practices for data modelling, database programming and job scheduling and ETL package dependencies.Requirements:4-5 years of SQL experience writing queries, stored procedures, triggers, views, etc.3+ years of SSIS experience (2012, 2016)2-3 years Azure experienceesign, model and develop complex data models and data integrations utilizing SQL server (SSIS) based ETL processes for new and existing systems : Participate in planning and implementing the data integration and data migration activities. : Coordinate with team members to perform database programming based on project requirements. : Develop stored procedures, complex SQL queries, scripts and database programming for systems. : Perform quality assurance tests for ensuring data integrity across multiple databases. : Interact with project leaders to understand project requirements. : Provide valid inputs in database architectural discussions. : Assist in identifying process improvements for database performance, reliability and stability. : Perform troubleshooting and analysis to assess root cause of data issues in a timely manner. : Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file and MS SQL Server by using SSIS services and transformation objects : Understands best practices for data modelling, database programming and job scheduling and ETL package dependencies.Job Level Specific Duties• Entry-level position into business systems analysis.• Provides end user support for a specific application while learning about the application and customer. • Assists in application implementations and assists in testing end user processes using defined guidelines. • Updates existing tables and verifies the accuracy. • Collects data and runs basic reports in response to client inquiries as directed by more senior associates. • Interacts with clients, both internal and external, to supply basic information. • Analyzes business and user needs, documenting requirements, with the guidance of a senior associate.• Documents business rules/functional requirements to support system enhancements with the guidance of a senior associate.• Logs and tracks basic problems / work tickets with external product vendors or support organizations.Typical Years of Experience• Typically requires 2-4 years relevant experience.Minimum Education and Certifications• Undergraduate degree or equivalent combination of education and work experience.Skills• Awareness of system development methodology, project management and system architecture. Basic analytical / problem solving skills. • Ability to consider IT and business challenges.• Influencing and communication skills. Ability to translate between non-technical business users and technical IT resources. Strong client service attitude.• Organizational and time management skills.Physical Requirements/ Working Conditions• Ability to physically perform general office requirements. • Must be able to perform essential responsibilities with or without reasonable accommodations.• Significant travel including overnight domestic or international trips may be required.Posting Date:Department: -