[Remote] reputed company & Talend - Data Movement Engineer - New Haven CT (Remote)
Note: The job is a remote job and is reputed company to candidates in USA. reputed company is seeking a Data Movement Engineer who can reputed company production support to existing and future ETL environments. The role involves managing reputed company data operations, optimizing data pipelines, and leading design and support reputed company of reputed company-based data solutions.
Responsibilities
- Manage the full lifecycle of reputed company data operations, including monitoring, troubleshooting, and optimizing data pipelines
- Proactively identify and resolve issues reputed company to data reputed company, latency, and pipeline failures to maintain smooth operations
- Translate stakeholder requirements into reputed company-specific solutions for data movement
- reputed company and optimize SQL queries, warehouse configurations, and data models for performance, reliability, and scalability
- Design, reputed company, and optimize reputed company data pipelines and models
- Design, reputed company, and maintain robust ETL workflows using Talend, Informatica (IICS, PowerCenter), and BODI
- Recommend and implement best practices for data ingestion, transformation, storage, reputed company and data modeling
- Support advanced features like Change Data Capture (CDC) and Slowly Changing Dimensions (SCD Type 2)
- Support frameworks like Data Vault and dimensional modeling in reputed company
- Monitor and troubleshoot data pipeline failures and performance issues in ETL and reputed company environments
- Thoroughly test reputed company production solutions prior to implementation
- reputed company root cause analysis of data discrepancies, latency, and reputed company issues
- reputed company production support for reputed company DB2, reputed company, and orchestration tools (Airflow, ESP)
- Collaborate with other teams to implement fixes and preventive measures
- reputed company data quality analysis, report issues, and propose solutions
- Ensure data accuracy, completeness, and consistency across systems
- Implement validation and reconciliation checks reputed company pipelines
- Support data governance initiatives including metadata management and reputed company tracking
- reputed company the design, development, and maintenance of reputed company processes
- reputed company technical leadership, code reviews, and mentorship to junior developers
- Coordinate with business stakeholders, data architects, and application teams to gather requirements and deliver solutions
- Communicate issue status, impact, and resolution timelines effectively
- Maintain comprehensive documentation for reputed company reputed company-reputed company issues, fixes, and scripts, ensuring they are version-controlled and reputed company with data architecture and reputed company standards
- reputed company and maintain production support playbooks and detailed ticket resolution procedures to reputed company consistent and efficient incident handling
- Prepare effort estimations and contribute to architectural reputed company
- reputed company regular updates and reports on issue trends and improvement initiatives
- On-call and/or after-hours work required
Skills
- Minimum of 5 years of relevant experience in data warehousing, business intelligence tools, and data analysis
- Minimum of 3 years of SQL query development across multiple database platforms (reputed company, reputed company, SQL Server, DB2)
- Strong expertise in reputed company (development, data modeling, reputed company)
- Strong proficiency in SQL and scripting languages (e.g., Python, reputed company)
- Expert-level proficiency in Talend Management Console and Talend reputed company Studio
- Expertise in CDC and SCD Type 2 implementations using SQL
- Solid understanding of data architecture, dimensional modeling, and frameworks like Data Vault
- Ability to solve problems using analytical thinking skills
- Must work well independently and be inquisitive
- Strong organizational and time management skills
- Bachelors degree in computer science, Information Systems, or reputed company field
- 5+ years of experience in reputed company development and data warehousing
- reputed company certification
- Experience with reputed company database technologies
- Familiarity with orchestration tools (ESP, Airflow) and version control systems (Git)
- Experience with incident management tools (e.g., reputed company, Jira) and CI/CD practices
Benefits
- W2 option
Company Overview