Send me more jobs like this

Keywords / Skills : Java, Software Development, Sales, SSRS, MS SQL Server, PHP, SSIS, Web Development, T - SQL, Marketing

10 - 15 years
Posted: 2019-11-21

Industry
IT/Computers - Software
Function
IT
Role
Team Leader/ Technical Leader
Posted On
21st Nov 2019
Job Description
MS SQL Lead
Experience: 10+yrs

Work Location : Hyderabad

Job Requirements:

Develop a Commissions engine for a world-wide multi-level marketing business. This engine needs to be able to handle cross-border compensation with foreign exchange capabilities. This requires a thorough understanding of compensation plans in the direct selling industry and the ability to work with large data sets and complex algorithms.

Maintain, troubleshoot and enhance the payment systems used for paying Commissions to hundreds of thousands of consultants.

Design, implement and test interfaces and communication protocols between storefront, enterprise systems, the Commissions engine, and the payment system.

Plan, analyze, and design reporting databases and build automated processes that exchange data with external vendors' systems for customer loyalty programs.

Migrate large volumes of data between different platforms in an efficient manner.

Configure, develop, deliver and support high-performing applications.

Provide accurate estimates for tasks and projects.

Identify and resolve performance issues in existing code, and conduct performance analysis and code reviews on new code.

Apply your extensive experience in testing, debugging, and bug fixing to continuously refactor code in accordance with agreed-upon best practices.

Analyze technical requirements and design new data models.

Create and maintain technical documentation and training materials, and mentor and train junior developers.

Qualifications - Essential:


Bachelor's degree in Computer Science or a related field.4 years

Overall 10 years of software development experience.

A minimum of 6 years of experience in MS SQL (2008/2008 R2, 2012, 2014,2016) Server and a very strong knowledge of T-SQL, SSRS and SSIS.

5+ years' experience on multiple database platforms, including MS SQL Server administration.

Experience writing complex T-SQL stored procedures, functions, triggers.

Ability to create SSIS packages to clean and process data for data loads and extracts for use by downstream systems, with appropriate logging and error handling.

Ability to perform data analysis and visualization of complex data sets.

Experience in creating jobs and alerts, and in scheduling SSIS packages.

Experience using Red Gate Tools for version control, comparing database schemas, explore object dependencies and visualize complex datasets, performing searches on databases, creating data dictionaries and creating test data. Familiarity with SVN and Git.

Knowledge of the Atlassian Toolset (Confluence, Jira, SourceTree).

Ability to perform unit and functional testing by writing T-SQL scripts and validating the data coming from a various sources into the Commissions Engine Database.

Expertise in creating client UA Test cases and test conditions for functional verification testing.

Develop testing program for the project team that addresses areas such as database impact, software scenarios, regression testing, negative testing, error or bug retests, or usability.

Ability to work cross-functionally within the company among Requirements, Development, Testing, Management, and Quality Assurance teams to track product from conception to post-launch monitoring and improvements.

Experience working in an Agile development team and delivering high-quality code in a timely and predictable manner.

Ability to switch focus between the big picture (architecture and work flow) and the need to pay strong attention to detail.

Excellent written and verbal communication skills.

Creative problem-solver.

Ability to anticipate needs, innovate, multi-task and excel in a fast paced environment.

Qualifications - A strong plus would be:

Web development experience either .net or Java platform

Familiarity with Java, PHP and .Net code used for user interfaces to the database.

Should be able to develop Excel Macros along with other add-ins to identify, analyze, and interpret trends or patterns and work with large and complex data sets to create month-end reports as well as provide analytical support to management.

Experience w SSAS. Experience in data modeling with expertise in creating star and snow-flake schemas, fact and dimensions tables, physical and logical data modeling using ER Studio.

Proficiency in development and deployment of reports, report subscriptions and data driven subscriptions using SSRS.

Sales Commissions experience or other incentive compensation experience


About Company

COMPANY PROFILE:
GSPANN is a US California Bay Area based consulting services provider focused on implementations in the Enterprise Content Management, Business Intelligence & Mobile Solution initiatives. More than 90% of our current clientele are FORTUNE 1000 organizations. We specialize in strategy, architecture, delivery and support of solutions in the ECM, BI and Mobility space.
Since 2004, our consultants have successfully served over 150 fortune 500 clients. We have implanted solutions in Enterprise Content Management, Business Intelligence, Data Warehousing, Information Management, Big Data, Mobility, QA Automation & Project Management areas. Good mix of subject matter experts, project managers, senior and junior consultants. We have a successful & proven cost-effective onsite, offsite and off-shore model.
Our consultants helps our Clients with Strategy development, Architecture build outs, Delivery Services and Post Delivery Services (maintenance & support).

Our Specialties: Enterprise Content Mgmt, Information Mgmt (BI and DW), Web Strategy and Solution, QA Automation, Creative and Design Mgmt, Interactive Marketing solutions, Content Authoring and Migration, 24 X 7 Application Support, Mobile App Development, Omni Channel Strategy
Similar Jobs
View All Similar Jobs
Walkin for you