Note: The job is a remote job and is open to candidates in USA. Infinite Tek Inc. is seeking a Senior ETL Consultant to support enterprise data integration, data warehousing, and analytics initiatives. The role focuses on analyzing requirements, mapping source-to-target data, validating ETL transformations, identifying data quality issues, supporting testing and production operations, and collaborating with technical and business stakeholders.
Responsibilities
- Analyze business and technical requirements for data integration and ETL initiatives
- Perform detailed source-to-target data analysis and mapping
- Work with business analysts, data engineers, architects, and business stakeholders to define data requirements
- Analyze data from multiple source systems to understand data structures, relationships, dependencies, and quality
- Develop and maintain source-to-target mapping documents, data dictionaries, transformation rules, and technical specifications
- Support the design, development, testing, and validation of ETL workflows and data pipelines
- Write complex SQL queries for data analysis, reconciliation, profiling, and validation
- Perform data profiling to identify data quality issues, anomalies, duplicates, missing values, and inconsistencies
- Validate ETL transformations and ensure data loaded into target systems meets defined business rules
- Perform data reconciliation between source systems, staging environments, data warehouses, and reporting platforms
- Troubleshoot ETL failures and data discrepancies and work with development teams to identify root causes
- Support system integration testing (SIT), user acceptance testing (UAT), and production validation
- Document data lineage, transformation logic, data flows, and dependencies
- Participate in data governance and data quality initiatives
- Assist with production support and resolution of data-related issues
- Work within Agile/Scrum environments and participate in requirements, planning, and technical review sessions
Skills
- 10+ years of banking experience is required
Company Overview
Company H1B Sponsorship