Job Description-
· Data Analysis & Transformation
· Handle multi-format data ingestion including CSV, JSON, TXT, and Parquet files
· Interpret and document upstream-to-downstream data transformations across systems
· Source-to-Target Mapping (MapDocs)
· Create, maintain, and enhance Source-to-Target Mapping documents (STMs / MapDocs)
· Define detailed transformation logic, data rules, and field-level mappings
· Ensure traceability between source upstream systems and target platforms (Snowflake)
· Data Quality & Profiling
· Perform data profiling to evaluate:
· Completeness
· Accuracy
· Consistency
· Data distribution patterns
· Design and implement data quality (DQ) checks to ensure integrity and reliability
· Proactively identify, track, and resolve data quality issues and anomalies
· Data Validation & Reconciliation
· Execute end-to-end data validation between source systems and Snowflake
· Perform data reconciliation to ensure data consistency across layers
· Support defect analysis, root cause identification, and resolution tracking
· Reporting & Monitoring
· Develop and maintain reports and dashboards for operational and business insights
· Monitor data pipelines to ensure timely delivery aligned with SLA/OLA commitments
· Collaborate with ETL developers and data engineering teams for ingestion and transformation processes
· Support UAT, production releases, and post-deployment validation activities
· Partner with business stakeholders to:
· Clarify requirements
· Validate data accuracy
· Ensure reporting reliability
· Data Governance & Lineage
· Maintain data lineage documentation for audit, compliance, and governance
· Ensure transparency of data movement across systems and transformations
· Support governance standards and documentation practices
Skills Required:
Snowflake, Talend, Cloud (AWS/Azure), API, SQL, Snowflake, Data Analysis, Reporting, Data Validation, Data Lineage, ETL tools experience