Report

Data Analyst - SQL/Informatica

Salary

₹12 - 20 LPA

Min Experience

3 years

Location

Bengaluru, Karnataka, India

JobType

full-time

About the job

Info This job is sourced from a job board

About the role

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

(ref:hirist.tech)

sql

informatica

aws

abinitio

database

sql/nosql