Data Analyst - SQL/Informatica

Job Description

Data Analysis And Assessment Conduct thorough data analysis of source systems to understand data structures, quality, and dependencies. Identify data quality issues and develop strategies to cleanse and standardize data before migration. Create data profiling reports to identify potential data migration challenges. Migration Design And Architecture Design comprehensive data migration plans, including data mapping, transformation rules, and loading procedures. Develop data migration architecture considering source and target systems, data volumes, and performance requirements. Select appropriate methods and patterns based on project needs. Data Mapping And Transformation Create detailed data mapping documents to define how data will be transformed and translated between source and target systems. Develop data cleansing and transformation logic to ensure data quality in the target system. Design data validation rules to identify and address data inconsistencies. Testing And Validation Work with the Testers to develop and execute comprehensive data migration test plans, including unit testing, integration testing, and user acceptance testing. Work with the testing and development teams to resolve defects. Stakeholder Management Collaborate with business stakeholders to understand data requirements and migration objectives. Communicate data migration plans and progress updates to relevant stakeholders. Address concerns and provide technical guidance throughout the migration process. Required Skills And Qualifications Knowledge related to computer technology, network infrastructure, systems and applications, security, and storage Intermediate knowledge and experience with Microsoft Office Suite with proficiency in Excel Intermediate knowledge and experience in Informatica ILM, AWS, Abinitio and Database [SQL/NoSQL] Concepts. Ability to collaborate, engage and manage resources outside of the Data centricity Team. General conceptual understanding of programming and DB querying. Ability to work collaboratively with cross-functional teams. Prior knowledge of Agile project management tools,such as Jira. Ability to work effectively with internal and external IT support, senior leadership, project teams and individuals Ability to perform in a dynamic project management environment. (ref:hirist.tech) Show more Show less