Sql/bi developers Job at Sriven Infosys, Inc., Hicksville, NY

dW1HOUpmSVlpOUM4ejNnSmNUbUpzNGJFZ1E9PQ==
  • Sriven Infosys, Inc.
  • Hicksville, NY

Job Description

Sriven Info, Inc. is looking for SQL/BI Developers to work in Hicksville, NY and various unanticipated locations throughout the U.S. Must possess Master's degree in Computer Science or related field and exp. in Tableau, SQL Server, T-SQL, SSIS, Power BI, SSAS, SharePoint, Snowflake, Azure Data Lake, Azure Data Factory, TFS and GIT. Send resumes to hr@sriveninfosys.com, REF# 5076.055. Job Duties:Responsible for design, development activities, code review, testing strategies, testing support and on time deliveries; Perform root cause analysis of any issues that arise post-implementation and work on solutions related to issue fixing; Coordinate with business users in gathering business requirements and translating them to technical specifications; Researching, designing and writing new software programs and involvement in complete software development life cycle (SDLC); Use ETL tools with the Efforts to populate the Data Model and involve in Unit testing, Integration testing and System testing; Create ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and load the data into target data sources by performing different kinds of transformations using SSIS; Create SSIS Package for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data); Create scripts using Joins and Subqueries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key, Foreign Key Constraints; Collect requirements from Marketing for different types of migrations and plan the migration dates and also coordinate with different teams to complete end to end migration without any issues; Creating test plans and interpret complex SQL stored procedures, Triggers, Functions, Views, indexes in Microsoft SQL; Participate in KT sessions, help prepare system appreciation documents and support the transition process; Analyze and create complex SQL stored procedures, Triggers, Functions, Views, Indexes in Microsoft SQL Server 2018; Use Snowflake, ADF and SQL Developer for data pull for all migration requests coming from Customer Care; Manage all QA documents using GIT. Tracking defects using Quality Center; Execute test cycles and troubleshoot cycle problems. Conducting Pre-deployment analysis/test on test & test-production servers for the new code changes; Preparing test reports and presentations for QA training on domain and automation. Conducting review & status meetings with QE, BA and Developers; Provides recommendations regarding issues, processes and procedures both internally and externally; Demonstrates proven expertise and knowledge in technology or operational methods. Creating sub-task for stories of every sprint as per Agile / Scrum process. And executing the same. Using Agile methodology, responsible for each iteration deliverables within 2 weeks along with unit testing. Use of Tableau, SQL Server, T-SQL, SSIS, Power BI, SSAS, SharePoint, Snowflake, Azure Data Lake, Azure Data Factory, TFS and GIT. Position may require travel. Minimum Requirements: Education:Master's degree in Computer Science or related field. Experience: 6 months experience in the position offered or related position.Special Requirements: Aforementioned 6 months of experience must include the following skills:Tableau, SQL Server, T-SQL, SSIS, Power BI, SSAS, SharePoint, Snowflake, Azure Data Lake, Azure Data Factory, TFS and GIT.

Job Tags

Similar Jobs

U.S. Army

Unmanned Aircraft System Operator (15W) Job at U.S. Army

 ...civilian career, or both.Keep your civilian job. Advance in your full-time civilian job and keep pursuing your career goals, as Army Reserve Soldiers can follow passions while serving the country part time.The Army Reserve offers you the flexibility to pursue your... 

Legacy Inc.

Heating and Cooling Technician Job at Legacy Inc.

 ...management, and rehabilitation of a diverse range of properties, including commercial, residential (single-family and multi-family), and Airbnb rentals. Our small but passionate team operates like a family, committed to working hard, thinking smartly, and fostering a culture... 

Independence

Summer Intern - Conference Solutions Job at Independence

Description:We are looking for a motivated and detail-oriented intern to join our Conference Solutions team. This internship provides hands-on experience supporting the technologies and workflows that provide day-to-day in person conference room support and work closely... 

Fairmount Global Freight

Hot Shot Owner Operator Job at Fairmount Global Freight

Fairmount Global Freight is growing and we are looking into new opportunities! THIS IS NOT A DRIVER JOB, WE DO NOT HAVE TRUCKS AND TRAILERS FOR YOU! MUST HAVE YOUR OWN! What we are looking for: ~3/4 or 1-ton Truck with less than 200k miles, 2015 and newer. ~30-...

Agilent Technologies, Inc.

Research scientist analytical services Job at Agilent Technologies, Inc.

 ...chemical intermediates and final products that supports Active Pharmaceutical Ingredient (API) manufacturing. Essential duties and...  ...according to job level. Guide work activities of analytical research associates Author and review method validation protocols...