What are the responsibilities and job description for the Data Engineer 2 position at WEX, Inc.?
About the Team/Role
As a Data Engineer, you will play a pivotal role in the design, development, and maintenance of our database systems. Leveraging your expertise in SQL programming and database management, you will contribute to the optimization of data storage, retrieval, and manipulation processes, ensuring efficiency, accuracy, and scalability.
You will collaborate closely with cross-functional teams to understand business requirements and translate them into robust database solutions. Additionally, you will provide mentorship and guidance to other developers, fostering a culture of learning and growth within the organization.
How you'll make an impact
Hands-on development in the implementation of Informatica IICS and Informatica Power Center
Work directly and collaboratively with Architect, Informatica Admin, and Development Analysts
Client-facing with technical and business stakeholders
Develop and maintain effective working relationships with team members
Demonstrate the ability to adapt and work with team members of various experience level
Sound knowledge of Data Warehouses and LakeHouse concepts and practical implementation experience.
Excellent Data Analysis and Data Profiling skills using IICS or any profiling tools to solve business critical issues.
Ability to manage tasks independently.
Financial Domain experience will be a great plus.
Experience you'll bring
Bachelor's in Computer Science or Equivalent with five years of experience in Data Engineering and Data Warehousing or Master's with three years worth of experience in Data Engineering and Data Warehousing.
Hands-on experience with database technologies such as Microsoft SQL Server (SSIS, SSAS, SSRS), Oracle, or Snowflake
Informatica cloud (IICS)-Expert-level working knowledge in Integration Service and CDI, Mass ingestion, streaming with IICs, and integration with APIs using IICS.
7 Years of experience in IICS / Informatica
Expert-level working Knowledge of RDBMS (Oracle & Postgresql ) and Snowflake Data Cloud.
At least 7 years of working experience in RDBMS and Snowflake will be a plus.
Experience in API-based integration and real-time integration.
Familiarity with AWS is needed.
Interfacing with other systems, such as Salesforce using IICS is a must.
Knowledge of other Informatica products is always a plus
Good communication skills.
Ability to interact with Business Teams and come up with an integration Architecture.
Work with a team of developers to deliver the integration solutions.
Equal Opportunity Employer/Vets/Disability
Salary : $86,000 - $114,000