Job Title: Senior RedPoint ETL Developer
Experience:
Job Summary
RedPoint ETL Developer with 7+ years of IT experience
The ideal candidate will have strong hands-on experience with RedPoint Data Management (RPDM), SQL, data transformation, data quality, and enterprise data integration. The candidate will be responsible for building reliable and scalable data pipelines, integrating data from multiple sources, troubleshooting complex data issues, and ensuring data accuracy and performance.
The role requires close collaboration with business analysts, data architects, application developers, and other technical stakeholders to deliver high-quality data solutions aligned with business requirements.
Key Responsibilities
- Design, develop, configure, and maintain ETL workflows using RedPoint ETL tools.
- Build and manage data integration pipelines to extract, transform, cleanse, validate, and load data from multiple source systems.
- Develop complex SQL queries and perform data extraction, transformation, validation, and reconciliation.
- Implement data quality, data cleansing, deduplication, matching, and data standardization processes.
- Work with relational databases, flat files, and other structured data sources to support enterprise data integration.
- Optimize ETL workflows and SQL queries to improve processing performance, scalability, and reliability.
- Troubleshoot ETL failures, data inconsistencies, processing errors, and production issues.
- Implement error handling, logging, workflow monitoring, restart, and recovery mechanisms.
- Support data migration, source-to-target mapping, data reconciliation, and validation activities.
- Collaborate with business and technical teams to translate functional requirements into technical specifications and ETL solutions.
- Perform unit testing, integration testing, and support user acceptance testing.
- Maintain technical documentation, data mapping specifications, workflow designs, and deployment procedures.
- Support code reviews, release management, production deployments, and ongoing maintenance.
- Follow established development standards, data governance practices, and security requirements.
Mandatory Technical Skills
RedPoint ETL:
Strong hands-on experience with RedPoint Data Management (RPDM) and ETL workflow development.SQL:
Proficiency in writing complex SQL queries, joins, subqueries, aggregations, and data validation scripts.ETL Development:
Strong understanding of extraction, transformation, loading, data pipelines, and integration patterns.Data Quality:
Experience with data cleansing, standardization, deduplication, matching, and reconciliation.Database Concepts:
Knowledge of relational databases, data modelling, data structures, and source-to-target mapping.Troubleshooting:
Ability to analyze ETL failures, identify root causes, and resolve data processing issues.Testing:
Experience in unit testing, integration testing, and data validation.Documentation:
Ability to prepare technical specifications, workflow documentation, and deployment guides.
Preferred Skills
- Experience with RedPoint Interaction (RPI) or other RedPoint products, where relevant to the project.
- Exposure to data warehousing concepts and dimensional modelling.
- Experience with databases such as SQL Server, Oracle, Teradata, or other relational database platforms.
- Familiarity with scripting languages such as Python, PowerShell, or shell scripting.
- Exposure to cloud-based data platforms and data integration solutions.
- Experience with enterprise data migration and large-volume data processing.
- Knowledge of scheduling, workflow orchestration, monitoring, and production support.
- Experience working in Agile/Scrum environments and using version control tools such as Git.
Experience & Qualifications
- Minimum
7+ years of overall IT experience
, with substantial hands-on ETL development experience. - Demonstrated project experience developing and supporting ETL solutions using RedPoint.
- Strong analytical, debugging, and problem-solving skills.
- Ability to work independently and collaborate effectively with cross-functional teams.
- Good communication skills and the ability to work in a delivery-oriented environment.
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline preferred.
Expected Candidate Profile
The ideal candidate is a hands-on RedPoint ETL specialist who can independently develop and optimize ETL workflows, work confidently with SQL and enterprise data sources, resolve complex data issues, and deliver robust data integration solutions in a production environment.
