Acceptance Testing, Data Analysis, Data Management, Data Profiling, Data Quality, Database Extract Transform and Load (ETL), Problem Solving Skills, Production Support, Reconciliation, Reporting Dashboards, Root Cause Analysis, SQL (Structured Query Language), Service Level Agreement (SLA), Snowflake Schema, Time Management, Traceability
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
Snowflake, Talend, Cloud (AWS/Azure), API
SQL, Snowflake, Data Analysis, Reporting, Data Validation, Data Lineage, ETL tools experience