*Hi AssociatesI have the below opportunity for you with one of our direct client.. If youare suited and interested in this position, please send me your most updated resume, so that we can discuss your availability, work status, rate etc.I look forward to your earliest response.Please Send your resumes to *s...@excellerentsolutions.com <s...@excellerentsolutions.com> or Feel free to reach me @ 412-376-7481Position- Mid-level Database DeveloperLocation- San Antonio TxDuration- LongtermPosition OverviewThe ideal candidate for this position will have a very strong SQL Server background, deep analytical skills, and experience working with end users. The ability to do ad-hoc SQL to research data questions, identify root causes, and interact closely with peers and the business data analysts is essential. Exposure to SSIS, Hadoop, data models and SharePoint for reporting/analytics purposes highly desirable.Required SkillsDevelop and support an Enterprise Data Warehouse as well as communication with the systems outside the warehouse, and support the analytical needs of the business users.•Model and design data warehousing structures in both SQL and Hadoop•Create and maintain complex SSIS ETL packages•Create complex queries, data transformation, aggregation, stored procedures.•Consult with business partners such as business analysts, software architects, application developers, management and other SQL developers to clarify program objectives, determine scope, identify problems and recommend solutions, and maintain standards.•Develop of ad-hoc SQL to research data questions•Performance tune ETL, stored procedures, and reports to keep databases and applications optimized•Identify root causes in case of ETL failures, and support operations teams with necessary documentation and assistance.•Perform code reviews, data validation, and system testing for data warehouse changes•Interact closely with members of both IT and the business•Thrive in a dynamic, technology savvy, high performance culture with minimal supervisionRequired Experience •Expert knowledge of Transact-SQL & ETL with SSIS•Exposure to database design/development knowledge to address performance, scalability, and efficiency issues with high transaction volume systems•Five to seven years experience of the following technologies is required: SQL Server 2005/2008/2012, SQL Server Integration Services•Three to five years of experience in developing with application tools such as Java and .net. Ideally Python with exposure to big data technologies on Hadoop.•Proven ability to work with end users to translate high level requirements into a solution approach including both high level and detailed estimates•Highly organized team player with the ability to innovate, multi-task and set priorities effectively•Ability to quickly understand both business and technical concepts•Self-starter with strong verbal and written communication skills•Strong familiarity of execution within an Agile/Scrum/Kanban Team setup while working on database projects.•Exposure to or experience with other data technologies such as Hadoop, Embarcadero and programming languages Python, Powershell, Java, and the Microsoft APS platform highly desired.•Education degree in Computer Science / Math / or related Engineering field strongly preferred*
-- You received this message because you are subscribed to the Google Groups "MCMS" group. To unsubscribe from this group and stop receiving emails from it, send an email to mcms+unsubscr...@googlegroups.com. To post to this group, send email to mcms@googlegroups.com. Visit this group at http://groups.google.com/group/mcms. For more options, visit https://groups.google.com/d/optout.