Candidate Must have over 12 years of overall experience in IT
Key Responsibilities
· Analyze and trace end-to-end data flows across source systems, ingestion, enrichment, and downstream data products.
· Perform advanced SQL-based data profiling, reconciliation, validation, troubleshooting, and root-cause analysis.
· Develop detailed source-to-target mappings, data requirements, transformation rules, business definitions, and acceptance criteria.
· Design reusable and scalable enterprise data products that support multiple business use cases and downstream consumers.
· Identify data quality issues, mapping discrepancies, dependencies, and upstream/downstream impacts.
· Support data integration, migration, modernization, and new source-system onboarding initiatives.
· Create and maintain technical documentation, data dictionaries, data lineage, mapping specifications, and validation plans.
· Collaborate with Product, Engineering, Architecture, QA, business teams, and source-system stakeholders.
· Support UAT, production validation, and data-related issue resolution.
· Explore emerging technologies, including semantic layers, Snowflake Cortex, AI-assisted development, and AI-ready data products.
Mandatory Technical Skills
· SQL & Data Analysis: Advanced SQL, complex joins, data profiling, reconciliation, data validation, and root-cause analysis.
· Snowflake: Working knowledge of databases, schemas, tables, views, roles, and enterprise data environments.
· Source-to-Target Mapping & Data Integration: Strong experience with field-level mappings, transformation rules, data lineage, keys, relationships, and multiple data sources.
· Enterprise Data Product Design: Experience designing reusable data products, data models, common business rules, and scalable data structures.
· Data Validation & Testing: Source-to-target reconciliation, record-count validation, duplicate detection, data quality checks, UAT, and production validation.
· Technical Documentation: Strong experience with data dictionaries, technical specifications, business rules, lineage, and mapping documents. Familiarity with Jira, Confluence, SharePoint, or similar tools.
