NR Consulting ยท 15 hours ago
Data Movement Engineer (Talend)
United States
Full-time
Remote
Senior Level
5+ years expNR Consulting is seeking a Data Movement Engineer to assist in the modernization of its core data platforms. This role involves supporting the current ETL environment and building new ETL/ELT workflows and data pipelines as the company transitions to a cloud environment, while also providing technical leadership and mentoring to team members.
ConsultingInformation TechnologyStaffing Agency
Responsibilities
Complete full life cycle of ETL/ELT development including design, mappings, transformations, scheduling, and testing
Translate data movement requirements into technical ETL design
Design, develop, and maintain robust ETL workflows using Talend, Informatica (IICS, PowerCenter), and BODI
Develop data extraction and transmissions to external vendors
Develop test plans and perform unit testing
Determine impacts to data warehouse structures and information flows due to changes in business or technical requirements
Perform design and code reviews in support of organizational standards
Contribute to architectural decisions to support business processes
Perform data quality analysis, report data quality issues and propose solutions for data quality management
Analyze and interpret existing BODI code to support migration or integration efforts
Optimize data extraction, transformation, and loading processes for reliability, performance, and scalability
Develop and optimize complex SQL queries
Ensure ETL jobs are well-documented, version-controlled, and aligned with data architecture standards
Provide production support for ETL and data solutions, including troubleshooting and resolving pipeline issues
Monitor ETL jobs and proactively address failures or performance issues
Lead root cause analysis and resolution of data-related production incidents
Collaborate with other teams to implement fixes and preventive measures
Identify recurring issues and propose long-term solutions
Suggest process and technical improvements to reduce incidents
Perform data quality analysis, report issues, and propose solutions
Implement data validation, cleansing, and reconciliation logic within ETL processes
Support data lineage and impact analysis for downstream systems
Lead the design, development, and maintenance of ETL processes using Talend and other tools
Provide technical leadership, code reviews, and mentorship to junior ETL developers
Coordinate with business stakeholders, data architects, and application teams to gather requirements and deliver solutions
Communicate issue status, impact, and resolution timelines effectively
Contribute to architectural decisions to support business processes
Create supporting documentation for new ETL processes, data flows, and technical specifications
Maintain comprehensive documentation for ETL processes, data mappings, and job schedules
Prepare effort estimations and contribute to architectural decisions
Provide regular updates and reports on ETL performance, issue trends, and improvement initiatives
Experience writing design documents and operational runbooks
On-call and/or after-hours work required
Qualification
Required
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 (Snowflake, SQL Server, DB2)
Expert-level proficiency in Talend Management Console and Talend Open Studio
Must work well independently; inquisitive and seek answers to complex questions without being prompted
Strong understanding of BODI (Business Objects Data Integrator) code and architecture
Proficiency in ETL/ELT concepts and tools (Informatica IICS, Talend, Boomi, PowerCenter)
Working knowledge of data warehousing concepts, dimensional modeling, and ETL best practices
Experience using query tools (e.g., AQT, DBeaver, MS Query)
Familiarity with job scheduling tools (ESP, Airflow, Autosys) and version control systems (Git)
Experience in production support environments
Effectively participates in teams and moves the team toward completion of goals
Experience with ticketing systems (e.g., ServiceNow)
Experience working with IBM DB2 in ETL workflows
Ability to solve problems using analytical thinking skills
Strong communication, organizational and time management skills
Strong project management skills to ensure timely delivery
Some experience with cloud database technologies
Bachelor's degree in computer science, Information Systems, or related field
5+ years of experience in ETL development and data integration
Company
NR Consulting
NR Consulting is an information technology consulting firm that offers contingent hiring, direct hires, and managed IT services.
1001-5000 employees
H1B Sponsorship
NR Consulting has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2022 (1)
Funding
Current Stage
Late StageLeadership Team
Sharabh Goyal
Founder & CEO
Company data provided by crunchbase