Job Description
Request ID: 101237-1
Title: Data Engineer
Locations: Plano, TX
Duration: 6 montsPay Range: $40 - $43/Hour on W2/C2C
Job Responsibilities:- Perform Source-to-Target Verification to ensure data accuracy and completeness throughout ETL processes.
- Validate data movement across extract, transform, and load (ETL) phases by comparing source and target systems.
- Perform row count validation, column-level comparisons, and data reconciliation between:
- Flat files
- APIs
- Relational databases
- Data warehouse systems
- Validate data transformation logic, including:
- Business rules
- Data type conversions
- Aggregations
- Filtering logic
- Execute data quality and integrity checks to identify:
- Null values
- Duplicate records
- Data truncation issues
- Primary key and foreign key constraint violations
- Create and maintain:
- Test plans
- Test scenarios
- Test cases
- Defect reports
- Analyze Source-to-Target Mapping (STM) documents and validate ETL workflows against business requirements.
- Perform Business Intelligence (BI) report and dashboard validation using tools like:
- Ensure reports accurately represent data stored in enterprise data warehouses.
Required Technical Skills:- Strong proficiency in SQL including:
- Complex joins
- Subqueries
- Group By
- Aggregations
- Data comparison queries
- Strong understanding of Data Warehousing concepts, including:
- Fact and dimension tables
- Star schema
- Snowflake schema
- Dimensional modeling
- Hands-on experience with ETL tools such as:
- Informatica PowerCenter
- AWS Glue
- Talend
- Azure Data Factory (ADF)
- SSIS
- Experience with scripting and automation using:
- Python
- Shell scripting
- PowerShell
- Ability to understand and analyze:
- Data models
- Entity Relationship Diagrams (ERDs)
- Database normalization and denormalization concepts
Essential Skills:- Strong ETL QA testing experience with focus on:
- Data completeness
- Data accuracy
- Data transformation validation
- Data reconciliation
- Strong knowledge of Data Warehouse and BI Testing.
- Experience using data profiling and automation techniques for ETL validation.
Desirable Skills:- ETL Testing
- Data Warehouse Testing
- BI Testing
- Data Validation & Reconciliation
- SQL
- Data Warehouse Architecture
- ETL Tools
Appreciate your quick response and please feel free to reach me out for any query you may have.
Thanks
Numbers & Facts
| Location | Jacksonville, FL |
| Salary | $40–$43 Per Hour |
Skills
Amazon Web Services (AWS)unmatched
Analysis Skillsunmatched
Application Programming Interface (API)unmatched
Automationunmatched
Business Intelligenceunmatched
Data Modelingunmatched
Data Profilingunmatched
Data Qualityunmatched
Data Warehousingunmatched
Database Extract Transform and Load (ETL)unmatched
Dimensional Modelingunmatched
Entity Relationship Diagram (ERD)unmatched
Informaticaunmatched
Information Technology & Information Systemsunmatched
Microsoft Windows Azureunmatched
Power BIunmatched
Python Programming/Scripting Languageunmatched
Quality Assuranceunmatched
Reconciliationunmatched
Relational Databases (RDBMS)unmatched
Reporting Dashboardsunmatched
SQL (Structured Query Language)unmatched
SQL Server Integration Services (SSIS)unmatched
Scripting (Scripting Languages)unmatched
Snowflake Schemaunmatched
Star Schemaunmatched
Tableauunmatched
Test Caseunmatched
Test Plan/Scheduleunmatched
Test Scenariounmatched
Testingunmatched
Unix Shell Programmingunmatched
Windows PowerShellunmatched
Level up your application
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesImprove your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder