5 Ssis Packages Jobs

- Experience with integration of Dynamics CRM with legacy and modern systems. - Familiarity with DevOps pipelines and source control tools (e.g., Azure DevOps, Git). - Proficient in JavaScript, C#, TypeScript, HTML, CSS, and .NET Framework. Required Candidate profile - Solid experience with KingswaySoft SSIS for CRM data integration. - Experience with Azure Functions and Dynamics API integrations. - Write complex SQL queries to resolve system data issues.

Key Responsibilities: • Strong knowledge of Microsoft SQL Server, ETL/SSIS Package, Query writing, store procedures, views, SQL Performance. • Managing the master data, including creation, updates and deletion. • Provide quality assurance of data imported by running query on data software like MS SQL. • Develop Report and analyse the reports generated. • Processing confidential data and information according to the guidelines. • Managing Benchmarking exercise. • Managing and designing the reporting environment, including data source and security. • Assessing tests and implementing new or upgraded software and assisting with strategic decisions on new systems. • Troubleshooting the reporting database environment and reports. • Evaluating changes and updates to source production systems. • Training end users on new reports and dashboards. Providing technical expertise on data storage structures, data mining, and data cleansing. Any job assigned from time to time.

We are seeking 3 skilled Software Engineers for a high-impact Periodic Review Project . This role involves enhancing and supporting the development of Microsoft Dynamics 365 solutions, with a focus on integrations, customizations, and data processing. Key Responsibilities: Design, develop, and maintain customizations in Dynamics 365 CRM including plugins, custom workflow activities, and JavaScript. Implement and troubleshoot API integrations and Azure Functions . Develop and manage SSIS packages using KingswaySoft for data migration and integration tasks. Write complex SQL queries to resolve system data issues. Integrate Dynamics CRM with legacy and modern systems via batch jobs or APIs. Ensure adherence to best practices and coding standards across the development lifecycle. Analyze, support, and maintain systems/code written by other teams. Collaborate with stakeholders for requirement gathering, testing, and deployment. Preferred candidate profile Required Skills: Strong hands-on experience with Microsoft Dynamics 365 CRM (configuration, customization, plugin/workflow development). Proficient in JavaScript , C# , TypeScript , HTML , CSS , and .NET Framework . Solid experience with KingswaySoft SSIS for CRM data integration. Experience with Azure Functions and Dynamics API integrations. Excellent troubleshooting and problem-solving skills. Ability to work independently and collaboratively in a hybrid work model. Preferred: Immediate joiners. Experience with integration of Dynamics CRM with legacy and modern systems . Familiarity with DevOps pipelines and source control tools (e.g., Azure DevOps, Git). Immediate joiners or candidates with less notice period

Joining Arup Arups purpose, shared values and collaborative approach has set us apart for over 75 years, guiding how we shape a better world. Were looking for a D365 Developer to join our Client Systems Team, supporting and maintaining the D365 application at Arup. Our globally distributed team of five works closely with regional and global user groups, business analysts, and marketing teams to identify, implement, and support key business requirements. Watch this short clip to discover how Arup are shaping a better world and how you could be a part of it! https://youtu.be/OS-adlHH4sw?si=Z6na_qDzuqTl_hfa The Opportunity At Arup, you belong to an extraordinary collective in which we encourage individuality to thrive. Our strength comes from how we respect, share and connect our diverse experiences, perspectives and ideas. You will have the opportunity do socially useful work that has meaning to Arup, to your career, to our members and to the clients and communities we serve. This role offers a fantastic opportunity to get hands-on with all aspects of D365 development, including integration with both internal and external applications. With a lean, globally distributed team and a large user base, theres never a dull moment. Our developers work across a range of technologies, constantly seeking ways to improve processes and increase efficiency. We actively encourage experimentation with new tools and techniques to stay at the forefront of innovation. As a D365 Functional Analyst, youll design and deliver solutions that make a tangible difference to our engineering teams and the services we provide to clients. Youll translate business requirements into high-quality CRM solutions, implement best-practice development for incremental changes, and provide end-user support across multiple functional modules. Youll also play a key role in the ongoing maintenance of our CRM in a business-as-usual capacity. To thrive in this role, youll need strong technical expertise in Microsoft Dynamics and a proven track record of delivering effective solutions. Experience supporting CRM across multiple regions is essential. Youll be comfortable working in a fast-paced, evolving environment with a strong focus on continuous improvement. You should apply if youre proficient in: Developing new and modifying existing software using C#/Javascript Developing new and maintaining existing SSIS packages and SSRS reports Implementing and supporting existing MS Dynamics configurations and custom extensions and reporting on a day-to-day basis to the client systems service leader Working closely with business stakeholders in understanding process needs, producing high quality product functional specifications and technical solutions Providing expertise in both a configuration and technical capacity, following best practice CRM standards in solution design, testing and implementation Delivering business changes to CRM modules Understanding and promoting the Microsoft roadmap and future direction to ensure that proposed designs are scalable and in line with that vision Responding in a timely manner and taking ownership of user-support requests and incidents Playing an active part in our team: helping to build an inclusive environment, sharing your knowledge, and promoting development best practices with colleagues within the team and the wider Arup community Did you know: Our Digital Technology team are proud winners of the IT Team of the Year for 2021 at the Chartered Institute of ITs UK IT Industry Awards. Is this role right for you? Essential skills and knowledge the candidate must possess: Demonstrable evidence of working with Dynamics 365 online. Experience of global customer base would be an advantage Development experience with: Dynamics 365 online (plus configuration experience) C# .Net for plugins Dynamics 365 JavaScript/jQuery Power Automate Flows Azure components Usage of 3rd party APIs SSIS packages and Kingswaysoft integration toolkit SSRS reports and SQL queries Experience with Microsoft DevOps principles and techniques, GIT source code control and automation Ability to solve complex problems and openness in sharing your knowledge and thinking with others Strong team working skills with ability to build trusted relationships with people and groups with diverse backgrounds

POSITION INFORMATION SUMMARY: The Senior Database Engineer (MS SQL) role is to perform job functions that support the advanced use of data and data structures within the organization, including development, maintenance, and basic DBA activities for all corporate databases. It is expected that the individual in this role use strong SQL skills to synthesize complex FineLine data structures for report writing, data warehouse development, and data transformations. Additionally, a key focus for this role is to ensure that databases are running optimally and to ensure high data availability to the end user. ESSENTIAL FUNCTIONS, DUTIES, & RESPONSIBILITIES: Database Design & Development: Design and develop database structures, including tables, views, indexes, and schemas. Write, debug, and maintain complex stored procedures, functions, and triggers. Create scalable database architectures to meet business and application needs. SQL Development & Optimization: Develop high-quality SQL queries and scripts to support application functionality and reporting needs. Optimize SQL code and stored procedures for speed and efficiency, particularly for large tables with millions of records. Monitor database code delivery to ensure performance and adherence to best practices. Performance Optimization: Perform query performance tuning, index optimization, and data model refinement. Utilize tools such as SQL Profiler, Execution Plans, etc. to troubleshoot performance issues. Data Warehousing & ETL: Design and implement data warehousing solutions using Star Schema and other methodologies. Develop, deploy, and maintain ETL/SSIS packages for data integration and transformation workflows. Best Practices & Security Standards: Implement and enforce coding best practices for SQL development. Ensure compliance with security standards to protect sensitive data and prevent vulnerabilities. Database Administration: Ensure database security, backups, and disaster recovery readiness. Set up and manage replication and high-availability solutions for critical databases. Collaboration & Troubleshooting: Collaborate with application development teams to integrate database solutions seamlessly. Diagnose and resolve database issues, ensuring system reliability and uptime. Delivers solutions in an agile, fast-moving work environment. Other duties and responsibilities as assigned POSITION TYPE/REQUIRED HOURS OF WORK: Full-time; provide 3 hours of coverage overlap with US EST time zone M-F Office Time: 12 PM to 9 PM IST Location: Perungudi, Chennai, India QUALIFICATIONS: Required: B. E/ B. Tech - Computer Major, M. E/ M. Tech - Computer Major, MCA 9 to 14 years of experience in MS SQL Server database development and administration. Proficiency in SQL programming, including writing and optimizing complex queries, stored procedures, and triggers. Hands-on experience in Data Warehousing and designing solutions using Star Schema. Proficient in ETL processes and SSIS package development. Solid experience in query performance tuning and database optimization techniques. Ability to monitor and optimize database code for large-scale data tables. Knowledge of database replication, high-availability setups, and disaster recovery planning. Familiarity with SQL Profiler, Execution Plans, and other performance analysis tools. Expertise in implementing coding standards and ensuring compliance with security best practices. Preferred: Experience in using source code control such as Subversion, GitHub Experience in Power BI report writing, managing data models, and user access Experience with designing and using Multi-Dimensional Data Models Technical Skills: MS SQL Server, Complex SQL Queries, Stored Procedures, Triggers, SQL Profiler, Execution Plans, Data Warehousing, Star Schema, ETL, SSIS Packages, Index Optimization, Database Replication, High-Availability Solutions, Performance Tuning, Database Security, T-SQL Scripting, PowerShell, Azure SQL, SSRS, Agile