Job Description :
Nagarro is looking for an experienced ETL developer who possess knowledge and practical experience of working with heavy data migrations involving other SQL/ NoSQL database systems such as Oracle 11g, Access DB, Mongo DB, Postgre SQL and Dynamic 365 CRM migration. The contractor will be responsible for data migration, data cleansing, data standardization, data modeling and mapping, and loading of the legacy system and external systems data. You will be working in tandem with the other teams, preparing documentations and specifications as required.
Listed below are the key responsibilities and skills required for this position: -
Responsibilities
Historical Data Migration and Maintenance – The contractor will be responsible for data migration, data cleansing, data standardization, data modelling and mapping, and loading of the legacy system and external systems data. The data for migration will reside in sources such as Oracle 11g, Access DB, SQL Server DB, ACRIS (Oracle) and other data types such as CSV, XML files containing data for the defined data sources.
Excellent knowledge of data extraction, transformation and loading tools such as SSIS, Informatica and KingswaySoft
Strong experience in Business Process Modeling (BPM)
Ability to analyze existing database schema DDL/instance layout and determine impacts migrating to new target schema/instance environment
Knowledge of SQL Server Integration Services (SSIS) data migration for migrating data from various data sources such as Access Application, Palantir data extract, digitized street files, media files, Microsoft Excel workbook
Exposure to create complex SSRS reports to represent service delivery analytics
Experience of Adhoc reporting using integration with Power BI for interactive reports and dashboards
Ensure performance, security, and availability of databases
Prepare documentations and specifications
Collaborate with other team members and stakeholders
Implementation and release of database changes as submitted by the development team
Skills and Qualifications
Strong proficiency in SQL server database management
Experience of other SQL/ NoSQL database systems preferably Mongo DB, Oracle, Access DB, ACRIS (Oracle)
Be familiar with Agile Development practices and tools such as JIRA, TFS
Able to provide estimations for development tasks
Proficient understanding of code version tools such as Git & SVN
Be experienced with best practices for enterprise data management. Have good problem-solving abilities, think laterally, be calm under pressure and have attention to detail