YASH Technologies, Inc.
Software Engineer - MS - SSIS Job
YASH Technologies, Inc., Jackson, Mississippi, United States,
YASH Technologies is a leading technology integrator specializing in helping clients reimagine operating models, enhance competitiveness, optimize costs, foster exceptional stakeholder experiences, and drive business transformation.At YASH, we’re a cluster of the brightest stars working with cutting-edge technologies. Our purpose is anchored in a single truth – bringing real positive changes in an increasingly virtual world and it drives us beyond generational gaps and disruptions of the future.We are looking forward to hire MS - SSIS Professionals in the following areas:Experience
2-3 YearsJob Description
Should have 2 to 3 yrs of experience in SSIS, and SQL.ETL - Should be proficient in MS SSIS and strong SQL / PLSQL scripting.Should have data migration experience from on-prem tool to cloud or another on-prem.Experience on Talend ETL tool will be an advantage.Should be an expert in writing stored procedures, functions, and inline SQL Queries using T-SQL.Should have good hands-on experience working with SQL Server, Oracle, and MySQL.Should have expertise in Microsoft Business Intelligence Suite - SSIS, SSRS, SSAS, Power BI.Responsibilities
Create, maintain, and optimize stored procedures, functions, inline SQL, database structures, and ETL processes to adapt to changes in needs and requirements.Create and maintain documentation of ETL processes, including data mappings, transformations, and workflows.Test and debug ETL processes to ensure accuracy and completeness of data.Participate in code reviews to ensure code quality and adherence to best practices.Work with data analysts to understand data sources and ensure data quality and consistency.Troubleshoot and resolve issues related to ETL processes.Assist with deployment and monitoring of ETL processes.Work with clients to understand business requirements and ensure the required business functionality of each data element is met.Interpret and analyze multi-dimensional medical, provider, pharmacy claims data as well as enrollment data to accurately assess and demonstrate key insights into key trends and opportunities.Hands-on experience in Agile methodology.Required Technical Competencies
Requirement Gathering & Analysis:Specialized knowledge of requirement management processes & tools, analysis process, tools & methodologies.Able to extract functional & non-functional requirements & document a system/software requirements specification in complex scenarios, prototype/design a prototype for demonstration to stakeholders.Able to analyze the impact of change requested/enhancement/defect fix, identify modules impacted, features/functionalities impacted & arrive at high-level estimates.Able to develop traceability matrix for requirement management, conduct technology/business gap analysis, identify transition requirements for the engagement.Application Design:Working knowledge of design principles & performance engineering concepts.Able to decide on document templates, standards & best practices, on tools & frameworks to be used.Able to create UI/Design & business logic elements & constraints, navigation, screen flow & layout.Create traceability matrix based on requirements, document design in modeling notation/project & customer preferences, develop reusable/reuse technical design components/frameworks.Working knowledge of architecture Industry tools & frameworks.Able to identify pros & cons available tools & frameworks in market, use tools & frameworks, explore new tools & frameworks.Working knowledge of estimation & resource planning techniques (WBS, FP etc.).Able to identify & assign the resources required to complete the task, use appropriate estimation models based on the project scope for medium-high complex scenarios, track & report gaps & actual spends.Technology/Product Knowledge:Specialized knowledge of product/platform & associated technologies.Able to implement code or configure/customize products & provide inputs in design & architecture, drive adoption of industry standards/practices.Able to create optimized code, adheres to the low-level design, review the code.Work on complex modules, contribute to development of reusable assets, innovative solutions.Customer Management:Working knowledge of customer business domain technology suite in client's context.Able to use the latest technology & build it into client engagement, articulate & communicate.Able to convince the customer on the technical solution, approach/estimates.Project Management:Working knowledge of customer business domain, technology suite in client's context.Able to use the latest technology & build it into client engagement, understand the customer business & pro-actively suggest solutions which will lead to additional business.Domain/Industry Knowledge:Specialized knowledge of customer's business processes, relevant technology platform or product.Able to prepare process maps/workflows/business cases/apply industry standards.Able to create complex business models, analyze current-state & define to-be processes & present recommendations with tangible benefits, drive process improvement initiatives, ROI analysis.At YASH, you are empowered to create a career that will take you to where you want to go while working in an inclusive team environment. We leverage career-oriented skilling models and optimize our collective intelligence aided with technology for continuous learning, unlearning, and relearning at a rapid pace and scale.Our Hyperlearning workplace is grounded upon four principles:Flexible work arrangements, Free spirit, and emotional positivity.Agile self-determination, trust, transparency, and open collaboration.All Support needed for the realization of business goals.Stable employment with a great atmosphere and ethical corporate culture.
#J-18808-Ljbffr
2-3 YearsJob Description
Should have 2 to 3 yrs of experience in SSIS, and SQL.ETL - Should be proficient in MS SSIS and strong SQL / PLSQL scripting.Should have data migration experience from on-prem tool to cloud or another on-prem.Experience on Talend ETL tool will be an advantage.Should be an expert in writing stored procedures, functions, and inline SQL Queries using T-SQL.Should have good hands-on experience working with SQL Server, Oracle, and MySQL.Should have expertise in Microsoft Business Intelligence Suite - SSIS, SSRS, SSAS, Power BI.Responsibilities
Create, maintain, and optimize stored procedures, functions, inline SQL, database structures, and ETL processes to adapt to changes in needs and requirements.Create and maintain documentation of ETL processes, including data mappings, transformations, and workflows.Test and debug ETL processes to ensure accuracy and completeness of data.Participate in code reviews to ensure code quality and adherence to best practices.Work with data analysts to understand data sources and ensure data quality and consistency.Troubleshoot and resolve issues related to ETL processes.Assist with deployment and monitoring of ETL processes.Work with clients to understand business requirements and ensure the required business functionality of each data element is met.Interpret and analyze multi-dimensional medical, provider, pharmacy claims data as well as enrollment data to accurately assess and demonstrate key insights into key trends and opportunities.Hands-on experience in Agile methodology.Required Technical Competencies
Requirement Gathering & Analysis:Specialized knowledge of requirement management processes & tools, analysis process, tools & methodologies.Able to extract functional & non-functional requirements & document a system/software requirements specification in complex scenarios, prototype/design a prototype for demonstration to stakeholders.Able to analyze the impact of change requested/enhancement/defect fix, identify modules impacted, features/functionalities impacted & arrive at high-level estimates.Able to develop traceability matrix for requirement management, conduct technology/business gap analysis, identify transition requirements for the engagement.Application Design:Working knowledge of design principles & performance engineering concepts.Able to decide on document templates, standards & best practices, on tools & frameworks to be used.Able to create UI/Design & business logic elements & constraints, navigation, screen flow & layout.Create traceability matrix based on requirements, document design in modeling notation/project & customer preferences, develop reusable/reuse technical design components/frameworks.Working knowledge of architecture Industry tools & frameworks.Able to identify pros & cons available tools & frameworks in market, use tools & frameworks, explore new tools & frameworks.Working knowledge of estimation & resource planning techniques (WBS, FP etc.).Able to identify & assign the resources required to complete the task, use appropriate estimation models based on the project scope for medium-high complex scenarios, track & report gaps & actual spends.Technology/Product Knowledge:Specialized knowledge of product/platform & associated technologies.Able to implement code or configure/customize products & provide inputs in design & architecture, drive adoption of industry standards/practices.Able to create optimized code, adheres to the low-level design, review the code.Work on complex modules, contribute to development of reusable assets, innovative solutions.Customer Management:Working knowledge of customer business domain technology suite in client's context.Able to use the latest technology & build it into client engagement, articulate & communicate.Able to convince the customer on the technical solution, approach/estimates.Project Management:Working knowledge of customer business domain, technology suite in client's context.Able to use the latest technology & build it into client engagement, understand the customer business & pro-actively suggest solutions which will lead to additional business.Domain/Industry Knowledge:Specialized knowledge of customer's business processes, relevant technology platform or product.Able to prepare process maps/workflows/business cases/apply industry standards.Able to create complex business models, analyze current-state & define to-be processes & present recommendations with tangible benefits, drive process improvement initiatives, ROI analysis.At YASH, you are empowered to create a career that will take you to where you want to go while working in an inclusive team environment. We leverage career-oriented skilling models and optimize our collective intelligence aided with technology for continuous learning, unlearning, and relearning at a rapid pace and scale.Our Hyperlearning workplace is grounded upon four principles:Flexible work arrangements, Free spirit, and emotional positivity.Agile self-determination, trust, transparency, and open collaboration.All Support needed for the realization of business goals.Stable employment with a great atmosphere and ethical corporate culture.
#J-18808-Ljbffr