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

YVd0cytVQVRRd2xiTEgxa2FUR1JtdW5Lbnc9PQ==
  • 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

Aerotek

Conveyor Mechanic Job at Aerotek

**Job Title: 3rd Shift PM Mechanic****Job Description**We are seeking a highly skilled...  ...position requires strong expertise in conveyors and troubleshooting to ensure machinery...  ...handling system components.+ Perform on-site installation, servicing, and repair processes... 

NJD Delivery

FEDEX CLASS C-FOR HIRE ENDORSEMENT REQUIRED. Job at NJD Delivery

 ...FEDEX- Class C - For-hire Endorsement required. NJD Delivery Services Co. is looking for team players to deliver packages...  ...drivers strive to get every order to the customers door on time. We offer full and part-time opportunities. Company Vehicle Provided Class A/Class... 

Western Kentucky University

Assistant / associate / professor psychology Job at Western Kentucky University

 ...Assistant/Associate/ Professor, Developmental Psychology About Western Kentucky University: Western Kentucky University (WKU) is...  ...B.A. in psychology with a general major, and concentrations in sport and forensic psychology. We alsooffer a psychology minor and an... 

Unilever

Talent advisor Job at Unilever

 ...events. Background & Purpose of the Job Join our North America Talent Acquisition team and become part of a group of welcoming,...  ...experience. Experience: 3+ years of recruitment experience (mix of agency and corporate preferred) with full cycle hiring. Must have... 

Resolution Think

Strength and Conditioning Coach Job at Resolution Think

Resolution Think, LLC is currently recruiting a skilled and proactive Strength and Conditioning Coach (SCC) to join the Holistic Health and Fitness (H2F) Human Performance Team (HPT) in support of the US Army's transformative approach to soldier readiness and well-being...