Senior Data Movement Engineer - Hybrid

company banner
ConsultNet, LLC
Engineer, SQL, Informatica, Computer, Systems, IT
Full Time

Job Description

Job Description

Title: Sr Data Movement Engineer
Location: Greater New Haven County Area
Duration: Full Time

Core Responsibilities
  • Complete full life cycle of ETL/ELT development to address business needs or resolve issues including design, mappings, data transformations, scheduling and testing.
  • Translate data movement requirements into technical ETL design.
  • Develop ETL/ELT workflows and mappings to extract, transform, and load data into target environments.
  • Develop data extraction and transmissions to external vendors.
  • Develop test plans and perform unit testing.
  • Create supporting documentation for new ETL processes.
  • Work closely with data analysts to gain understanding of business processes and corporate data.
  • Determine impacts to data warehouse structures and information flows due to changes in business or technical requirements.
  • Contribute to architectural decisions to support business processes.
  • Provide production support for data solutions.
  • Complete root cause analysis and contribute to remediation planning and implementation.
  • Perform data quality analysis, report data quality issues and propose solutions for data quality management.
  • Learn and expand upon internal controls and participate in customer support.
  • Perform design and code reviews in support of organizational standards.
  • Mentor less experienced team members.
  • Prepare effort estimation including researching and estimating costs of software development, unit testing. May provide estimates for upgrades of vendor packages upgrades and integration with existing systems.
  • On Call and/or after hours work required.

Skill Qualifications
  • Minimum of 8 years of relevant experience in data warehousing, business intelligence tools, and the analysis of data
  • Minimum of 5 years of SQL query development, preferably across multiple database management platforms, and working with dimensional and star schema data warehouse implementations
  • Proficiency in ETL/ELT concepts and tools (Informatica, Talend, Boomi, IICS and PowerCenter preferred)
  • Working knowledge of data warehousing concepts, structures and ETL best practices
  • Experience using query tools (e.g.. AQT, MS Query)
  • Ability to problem solve using analytical thinking skills
  • Must work well independently - must be inquisitive and seek answers to complex questions without being prompted
  • Strong organizational and time management skills
  • Strong communication skills including verbal and written to communicate effectively with clients and management
  • Strong project management skills to ensure that projects get done on time and within budget
  • Effectively participates in teams and moves the team toward completion of goals
  • Ability to resolve conflicts
Preferred :
  • Some experience with cloud database technologies preferred
  • Some experience with data visualization tools (e.g. Tableau) desirable

Education and Experience Qualifications

  • BA or BS in Computer Science, Information Systems or related field.
  • 10+ years experience

Be a part of the ConsultNet difference. As a leading national provider of IT staffing and solutions, ConsultNet delivers exceptional services to startup, midmarket and Fortune 1000 companies across North America. Since 1996, we've partnered with clients to create rewarding opportunities for our consultants, successfully building teams that have surefire results. In the past two years alone, we have placed more than 1,500 consultants in contract, contract-to-hire, or direct placement opportunities. We understand communication is key to finding the right job that matches your skills and career goals. For us, it's not just the work that we do; it's how we do the work. Our breadth of offerings extends to multiple IT positions in major markets throughout the country, see more at -

Company Information

Our experience and deep relationships inspire flexible, strategic staffing solutions.

Founded in 1996, ConsultNet was built to equip our clients to excel in IT—through expert consultants, project leadership and custom solutions.

With business in 45 states, ConsultNet serves multiple industries including:

finance, manufacturing, healthcare, digital media, advertising and the federal sector

In the last two years, we placed 1,500 consultants and served 300 clients, with contract, contract-to-hire, direct staffing and project-based teams.

As principled pioneers, we serve as an invaluable resource that drives business results.

Go Farther with ConsultNet

Dice Id : cxcnetut
Position Id : 21-01938
Originally Posted : 4 months ago

Similar Positions at ConsultNet, LLC

Sr. Tester - Hybrid
  • New Haven, CT
  • 20 hours ago
Data Governance Lead
  • New Haven, CT
  • 20 hours ago
Data Integration Analyst - Hybrid
  • Waltham, MA
  • 20 hours ago
Data Engineer II
  • Danbury, CT
  • 20 hours ago
Data Engineer (Clinical EMR)
  • Danbury, CT
  • 20 hours ago
Senior Data Engineer
  • Iselin, NJ
  • 20 hours ago
Data Quality Analyst (SQL/Python)
  • New York, NY
  • 20 hours ago
Data Analyst
  • New York, NY
  • 20 hours ago
Azure Data Engineer
  • Red Bank, NJ
  • 20 hours ago
Sr. DevSecOps Engineer (remote)
  • Braintree, MA
  • 20 hours ago