Sr. Software Engineer - SSIS

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 SSIS Professionals in the following areas :

Job description:

Senior Data Engineer

As a Senior Data Engineer, you will support the Global World Area using the Windows & Azure suite of Analytics & Data platforms. The focus of the role is on the technical aspects and implementation of data gathering, integration and database design.

We look forward to seeing your application!

In This Role, Your Responsibilities Will Be:

• Migration of existing ETL packages: Migrate existing SSIS packages to Synapse pipelines
• Data Transformation: Develop ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS), Azure Synapse Pipelines, or other relevant tools to prepare data for analysis and reporting.
• Data Modelling: Assist in designing and implementing data models, data warehouses, and databases in Azure Synapse Analytics, Azure Data Lake Storage, and other Azure services.
• Data Ingestion and Integration: Collaborate with Product Owners and analysts to understand data requirements & design, develop, and maintain data pipelines for ingesting, transforming, and integrating data from various sources into Azure Data Services.
• Data Quality and Governance: Implement data quality checks and data governance practices to ensure the accuracy, consistency, and security of data assets.
• Monitoring and Optimization: Monitor and optimize data pipelines and workflows for performance, scalability, and cost efficiency.
• Documentation: Maintain comprehensive documentation of processes, including data lineage, data dictionaries, and pipeline schedules.
• Collaboration: Work closely with cross-functional teams, including data analysts, data scientists, and business stakeholders, to understand their data needs and deliver solutions accordingly.
• Azure Services: Stay updated on Azure data services and best practices to recommend and implement improvements in our data architecture and processes.

For This Role, You Will Need:

• 5-8 years of experience in Data Warehousing with On-Premises or Cloud technologies
• Strong practical experience with T-SQL or any variant from other RDBMS.
• Strong practical experience of developing ETL packages using SSIS.
• Strong analytical and problem-solving skills.

• Strong communication skills in dealing with internal customers from a range of functional areas.

• Strong practical experience of Synapse pipelines / ADF.
• Graduate degree educated in computer science or a relevant subject.

• Willingness to work flexible working hours according to project requirements.
• Technical documentation skills.
• Fluent in English.

Preferred Qualifications that Set You Apart:

• Good to have hands-on / exposure to Tabular Model and PowerBI reporting.
• Experience in working on Azure Services like Azure Synapse Analytics, Azure Data Lake.
• Working experience with Azure DevOps paired with knowledge of Agile and/or Scrum methods of delivery.
• Azure certification if any related to data engineering.

Who You Are:

You understand the importance and interdependence of internal customer relationships. You seek out experts and innovators to learn about the impact emerging technologies might have on your business. You focus on priorities and set stretch goals.

Our Offer to You

We understand the importance of work-life balance and are dedicated to supporting our employees' personal and professional needs. From competitive benefits plans and comprehensive medical care to equitable opportunities for growth and development we strive to create a workplace that is supportive and rewarding.

Depending on location, our flexible work from home policy allows you to make the best of your time, by combining quiet home office days with collaborative experiences in the office so that you can personalize your work-life mix.

Moreover, our global volunteer employee resource groups will empower you to connect with peers that share the same interest, promote diversity and inclusion, and positively contribute to communities around us.

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