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: -
...ready for shipment the next day. With a focus on customer service made evident by 24/7 availability. A company built on decades of experience and a love for the industry, Eskimo Cold Storage employs the latest technology to deliver the highest quality service. Manual...
This is where your work makes a difference.At Baxter, we believe every personregardless of who they are or where they are fromdeserves a chance to live a healthy life. It was our founding belief in 1931 and continues to be our guiding principle. We are redefining healthcare...
...Join The Dreisilker Team!We are a family-owned business and we pride ourselves in providing the very best electric motors solutions for our customers. If you are an electrical motor mechanic who enjoys working with your hands, breaking down and repairing motors we'd like...
...Bitfinex sucht eine engagierte AML-Untersuchungsexpertin bzw. einen AML-Untersuchungsexperten zur Bearbeitung verdchtiger Aktivit... ...Investigation Team, berichten an den Teamleiter und arbeiten eng mit Compliance, Customer Support sowie Legal zusammen, um Risiken in Geldw...
...Jackson Hewitt Inc. in Mississippi is hiring an Entry-Level Seasonal Tax Preparer to help clients with tax interviews, build your client base, and deliver outstanding service. You will receive professional development and ongoing training to expand your skills, with...