ETL Test Lead || Windsor, CT || Onsite
Vbeyond Corporation
- Job
- 28954
- Posted
- Location
- Windsor, CT
- Work type
- Full Time
- Tax terms
- C2C
- Experience
- Experience open
- Openings
- 1 opening
Opens your email app with a message to the employer, its subject naming this job. Attach your resume and send it from your own email.
Skills
- SQL
- SQL Server
- Snowflake
- ETL
- Data Modeling
- Tableau
- Power BI
- Looker
- Agile
- Requirements
About the job
Key Responsibilities
Project & Delivery Management
- Lead end-to-end delivery of elements projects from requirements understanding through production deployment.
- Define project plans, milestones, risks, dependencies, and resource allocations.
- Understand and document complex data lineage across multiple layers (Source Systems, Landing/Staging Layers, Integration/Transform Layers, Data Warehouse, Data Marts, Semantic/Reporting Layer, Power BI/Tableau dashboards)
- Perform impact analysis and trace data flow from source to dashboard.
- Analyze and validate business rules, transformation logic, mappings, and aggregations across layers.
- Create source-to-target mappings and data validation strategies.
- Lead ETL testing teams, data reconciliation, and root cause analysis activities.
- Write complex SQL queries and understand existing code base in the form Stored procedures for data analysis, profiling, and defect investigation.
- Mentor team members on SQL, ETL testing, and data validation techniques.
- Drive Agile ceremonies, sprint planning, and release management activities.
- Provide regular status updates to leadership and stakeholders.
- Define strategies for validating dashboards from source tables, data reconciliation, validation of the data between layers and Dashboards Automation solutioning.
Stakeholder Management
- Understand data requirements from business and translate them into testable requirements
- Act as the primary point of contact between QE , Business and Dev Team
Technical Skills
- Cloud Data Platforms: Snowflake
- ETL/ELT Tools: Matillion, DBT
- Databases: SQL Server
- SQL Expertise: Advanced SQL, Advanced Stored Procedures, CTEs, Window Functions, Query Optimization,
- BI & Reporting: Power BI,
- Data Modeling: Star Schema, Snowflake Schema, Dimensional Modeling
- Data Engineering Concepts: Data Lineage, Data Governance, Data Quality, Data Reconciliation
- Strong understanding of Data Modeling concepts (Star Schema, Snowflake Schema, Dimensional Modeling).
- Hands-on experience with BI & Reporting tools such as Power BI, Tableau, or Looker.
- Familiarity with AI-enabled data solutions and automation frameworks.
Management Skills
- Strong stakeholder management and communication skills.
- Ability to manage distributed offshore teams.
- Risk management, estimation, planning, and budget tracking expertise.