Module Lead - SSIS Developer Job

Date: Dec 3, 2024

Job Requisition Id: 58958

Location:

Bangalore, KA, IN Indore, IN Indore, MP, IN, 452001 Pune, MH, IN Pune, IN Bangalore, KA, IN Hyderabad, TG, IN Hyderabad, IN Hyderabad, IN

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

6-8 Years

Job Description

Should have 6+ yrs of experience in SSIS, and SQL.

Experience in developing the complex Data flows and transformations in SSIS from different source and destination systems.
Experience in deploying SSIS experience and scheduling the SQL Jobs.
Experience in Writing complex SQL queries and in performance tuning of query execution.
ETL - Should be proficient in MS SSIS and strong SQL / PLSQL scripting
Should have data migration experience from on-prim tool to cloud or another on-prim
Experience on any ETL tool will be 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 My SQL
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

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