eTeam
Database Developer - Sr
eTeam, Lenexa, Kansas, United States,
5 years of database/ ETL development experience using SQL Server and SSIS technologies .Masters Degree in Computer Science (or related field) with 3 years of database/ ETL development experience using SQL Server and SSIS technologies .T-SQL development experience - 6+ yearsSSIS development experience - 6+ yearsReporting/data analysis 6+ yearsFuzzy matching and Grouping (must have)Extensive knowledge of ReplicationData analysis, data mapping, data migration, writing specifications for system interfacesOptimization of indexesOptimization of stored proceduresStored procedure and function scripting as required to support projects/tasksDatabase performance tuningMSSQL Database Administrator experience required +5 yearsOversight of database design and the enforcement of companywide usage of SQL best practices and development standardsWork with other database administrators, developers, technical analysts, architects, and project management teams to refine the application design requirements based on customers business needsCreate ad hoc SQL queries customer reports, executive management reports
Duties/Job Responsibilities:Analyze, design, develop and maintain ETL/SSIS applications that service internal and external vendor and client systems aligning with the business needs.Create detailed specification documents based on business requirements.Develop quick prototypes for business stakeholder verification to use as a foundation for design/development solutions.Create and execute testing plans and procedures.Automate processes using software tools and scripts.Manage system enhancements and upgrades.Participate in latest technology research applicable to meet new business challenges.Provide guidance, mentoring, education, and leadership on how to effectively create and support the applications.Follow best practices for technology and business level technology implementation.Conduct system architecture reviews to guarantee corporate alignment.Conduct code level and other systems quality assurance tests and procedures.Experience with enterprise architecture tools such as MS SQL Server Management Tools, source control, defect tracking, integration, and workflow tools.
Duties/Job Responsibilities:Analyze, design, develop and maintain ETL/SSIS applications that service internal and external vendor and client systems aligning with the business needs.Create detailed specification documents based on business requirements.Develop quick prototypes for business stakeholder verification to use as a foundation for design/development solutions.Create and execute testing plans and procedures.Automate processes using software tools and scripts.Manage system enhancements and upgrades.Participate in latest technology research applicable to meet new business challenges.Provide guidance, mentoring, education, and leadership on how to effectively create and support the applications.Follow best practices for technology and business level technology implementation.Conduct system architecture reviews to guarantee corporate alignment.Conduct code level and other systems quality assurance tests and procedures.Experience with enterprise architecture tools such as MS SQL Server Management Tools, source control, defect tracking, integration, and workflow tools.