Job Description

HiGreetings of the Day.We have a critical opening with our client Data Engineer for Noida LocationExperience: 5+ yrsLocation: NoidaPayroll: CIEL HRMode of Employment: ContractJob descriptionData Migration Experience1. SSIS (SQL Server Integration Services) [ETL Processes, Data Transformation Techniques, Performance Tuning, C# in SSIS Script]2. Database Management and SQL [SQL querying, complex joins, data profiling]Must Average Knowledge:Microsoft Dynamics, specific data architecture, Data Model, Dynamics Data Migration Utility, Kingsway Soft SSIS Integration ToolkitMicrosoft Dynamics CRM/Dynamics 365 Skills\xc3\xbc Understanding of CRM Data Model: Familiarity with entities, relationships, custom fields, and CRM-specific data architecture.\xc3\xbc Experience with Data Migration: Handling data migration processes, including mapping, transformation, and import/export processes specific to Dynamics CRM.\xc3\xbc Use of Data Migration Tools: Knowledge of tools like the Dynamics 365 Data Migration Utility, KingswaySoft SSIS Integration Toolkit for Dynamics 365, or Scribe for data migration.SSIS (SQL Server Integration Services)\xc3\xbc ETL Processes: Strong grasp of Extract, Transform, Load (ETL) processes, particularly designing, deploying, and managing ETL packages using SSIS.\xc3\xbc Data Transformation Techniques: Expertise in using SSIS Data Flow components for transforming data, including Lookups, Conditional Splits, and Data Conversion.\xc3\xbc Custom SSIS Components: Ability to create and use custom SSIS components when out-of-the-box components dont suffice.\xc3\xbc Scripting in SSIS: Proficiency in scripting using or C# in SSIS Script Tasks and Script Components for custom logic.\xc3\xbc Performance Tuning: Knowledge of SSIS package optimization techniques to handle large datasets efficiently.SSIS Integration with CRM: Experience in configuring SSIS packages to interact with Dynamics CRM, possibly using third-party connectors like KingswaySoftDatabase Management and SQL Skills\xc3\xbc SQL Querying: Advanced skills in SQL querying, including complex joins, subqueries, and data manipulation (CRUD operations).\xc3\xbc Data Quality and Cleansing: Techniques for data quality assessment, data profiling, and cleansing before migration.\xc3\xbc Database Optimization: Skills in optimizing database performance, managing indexes, and writing efficient queries.Error Handling and Logging: Implementation of robust error handling and logging mechanisms within SSIS packagesAbout CIEL HR (Payroll Company)Ciel HR marks the return of HR visionaries to the HR Services industry, powered by technology and analytics. The Founders of Ma Foi, the pioneer of the HR services sector in India, along with some of the finest brains in the HR Services Industry have envisioned and built the firm, CielHR, to deliver the full range of Recruiting services from Executive Search, Recruitment Process Outsourcing and Staffing Permanent as well as Temporary roles through its offices in India and the Middle EastRole really excites you, kindly share your resume to aswathi.sugumaran@cielhr.com.RegardsAswathi

Ciel HR