Senior Data Integration Engineer

Company Description Cliff IT Solutions is a leading provider of Identity Management and Security governance solutions for onsite and cloud applications. Our services help organizations reduce risk and maximize profitability through end-to-end integration of enterprise Identity access management products and cloud-based applications. We focus on delivering high-quality products from initiation through execution, supported by our expertise in cutting-edge technologies. At Cliff IT, teamwork and collaboration are at the heart of our operations, fostering strong partnerships with stakeholders and clients. We are dedicated to helping our clients improve information systems and application security while staying connected to the ever-changing market landscape.

Role Description

This is a full-time on-site role for a Sr. Azure Data Engineer with Informatica & Teradata expertise, located in the Greater Minneapolis-St. Paul Area. The Sr. Azure Data Engineer will be responsible for designing and implementing data engineering solutions, including data modeling, ETL processes, and data warehousing. Day-to-day tasks include building and maintaining data pipelines, performing data analytics, and collaborating with cross-functional teams to support business intelligence activities.

Qualifications

Strong Data Engineering and Data Modeling skills

Proficiency in Extract Transform Load (ETL) processes and Data Warehousing

Experience in Data Analytics and generating actionable insights

Familiarity with cloud-based solutions, particularly Azure

Excellent problem-solving abilities and attention to detail

Bachelor's or Master's degree in Computer Science, Information Technology, or a related field

Experience with Informatica and Teradata is highly desirable

Strong collaboration and communication skills

Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.

[4+] years of hands-on experience as a Teradata Developer with strong SQL proficiency.

[4+] years of extensive experience with Informatica PowerCenter (versions [9.X, 10.X]) including Designer, Workflow Manager, Workflow Monitor, and Repository Manager.

Solid understanding of data warehousing concepts, Kimball methodology, and dimensional modeling (Star Schema, Snowflake Schema).

Expertise in writing and optimizing complex SQL queries, stored procedures, functions, and views in Teradata.

Experience with Teradata utilities such as BTEQ, FastLoad, MultiLoad, TPT (Teradata Parallel Transporter), and FastExport.

Proven ability to design and implement efficient and scalable ETL solutions.

Strong analytical and problem-solving skills with attention to detail.

Excellent communication (written and verbal) and interpersonal skills.

Ability to work independently and collaboratively in a fast-paced environment.

Knowledge of scripting languages (e.G., Shell Scripting, Python) for automation.

Experience with cloud platform Azure and data warehousing in the cloud.

Familiarity with data visualization tools (e.G., Tableau, Power BI) and reporting concepts.

Experience in an Agile / Scrum development environment.