Data Analyst – Data Mapping for Opentext InfoArchive
On-site · Bangalore, Hyderabad, Chennai, Pune, Noida10–18 yrsfulltime
The Data Analyst for Data Mapping plays a vital role in bridging operational data sources with Air Canada’s Opentext InfoArchive platform hosted on AWS. This position focuses on analyzing, mapping, and validating data flows to ensure seamless integration and accurate migration from diverse systems into InfoArchive.
The role
What you'll do
- Analyze source system data structures, formats, and semantics, and develop detailed mapping documentation
- Evaluate source data quality and completeness, identifying gaps, inconsistencies, or anomalies prior to migration
- Collaborate with business and technical teams to define archiving needs, regulatory requirements, and retention policies
- Work with data engineers and developers to design, build, and test ETL processes
- Create test cases and perform validation activities to ensure accuracy, completeness, and integrity of migrated data
- Maintain comprehensive documentation of mapping logic, transformation rules, and data lineage
- Troubleshoot mapping or integration issues by working with cross-functional teams and leveraging InfoArchive best practices and support resources
- Recommend process improvements, tooling enhancements, and mapping standards to optimize InfoArchive integration and address stakeholder feedback
You bring
Requirements
- Proven experience in data analysis, data mapping, or data integration projects
- Proficiency in SQL and data profiling tools
- Strong understanding of relational and non-relational database systems
- Knowledge of data archiving concepts and regulatory compliance practices
- Must have 5+ years’ experience with OpenText InfoArchive
- Experience working with AWS
Skills
SQLdata profiling toolsOpentext InfoArchivedata formats and archival standardsscripting skills (e.g., Python, Bash)AWSdata archiving conceptsregulatory compliance practices