The Role
Design, build, and maintain enterprise ETL pipelines using Informatica; support production stability, troubleshoot failures, ensure data quality, and collaborate with stakeholders. Provide optimization, documentation, and exposure to cloud platforms (Snowflake, AWS, dbt).
Summary Generated by Built In
Job Summary & Responsibilities
Bachelor's Degree in Computer Science, Information Systems, or related field
SUMMARY: The Pipeline & Integration Engineer is responsible for developing, maintaining, and supporting enterprise ETL pipelines and data integration workflows, primarily using Informatica currently(PowerCenter / IDMC), but may require Snowflake/dbt skills in future. This role plays a key part in delivering reliable data pipelines by implementing ETL transformations, supporting production stability, and ensuring data quality, while collaborating with senior engineers and technical leads.
ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties and special projects may be assigned.
- ETL Development & Implementation:
- Designs, develops, and maintains ETL pipelines using Informatica and related tools.
- Builds mappings, workflows, and sessions to support data ingestion and transformation.
- Implements transformations including joins, aggregations, parameterization, and error handling.
- Ensures ETL jobs are restartable, efficient, and aligned with SLAs and dependencies.
- Minimal scripting in Python and orchestration for API integrations, event driven patterns
- Production Support & Stability:
- Monitors and supports production ETL pipelines and scheduled jobs.
- Troubleshoots ETL failures, analyze logs, and identify root causes.
- Resolves defects and data issues within defined timelines.
- Contributes to improving pipeline reliability and reducing recurring issues.
- Data Integration & Data Warehouse:
- Designs and maintains data flows across staging, ODS, and data warehouse layers.
- Develops and maintains data interfaces across systems and applications.
- Supports data acquisition strategies and integration patterns.
- Data Pipeline Optimization & Quality:
- Optimizes ETL processes for performance and scalability.
- Implements validation checks, reconciliation processes, and data quality controls.
- Ensures compliance with data governance and audit requirements.
- Collaboration & Coordination:
- Works with business analysts and stakeholders to refine data requirements.
- Coordinates with QA, scheduling, and downstream consumers for deployment and execution.
- Participates in Agile or hybrid delivery models.
- Standards, Documentation & Governance:
- Follows coding standards, naming conventions, and documentation practices.
- Participates in code reviews and design walkthroughs.
- Maintains documentation for pipelines and interfaces.
- Modern Data Platform Exposure:
- Gains exposure to cloud and modern platforms such as Snowflake, AWS, dbt, and streaming technologies.
- Supports hybrid architecture environments combining legacy ETL and modern platforms.
- Compliance & Risk:
- Support audit, reconciliation, and data lineage requirements.
- Adheres to and complies with applicable, federal and state laws, regulations and guidance, including those related to anti-money laundering (i.e. Bank Secrecy Act, US PATRIOT Act, etc.).
- Adheres to Bank policies and procedures and completes required training.
- Identifies and reports suspicious activity.
EDUCATION
Bachelor's Degree in Computer Science, Information Systems, or related field
EXPERIENCE
- 4+ years of experience in ETL / data engineering / data integrationrequired
- Hands-on experience with Informatica (PowerCenter / IDMC)required
- Strong SQL and relational database experiencerequired
- Exposure to modern data platforms tools such as Snowflake, AWS, dbt, or other cloud-based data environments, and their orchestration toolsrequired
- Familiarity with Agile or hybrid delivery modelspreferred
- Hands-on experience with Informatica ETL tools, including mappings, workflows, and sessions
- Experience supporting production data pipelines with defined SLAs and dependencies
- Exposure to modern data platforms such as Snowflake, AWS, dbt, and cloud-based data environments
KNOWLEDGE, SKILLS AND ABILITIES
- Understanding of ETL/ELT and data pipeline design, required.
- Understanding of data governance, security, and regulatory requirements in banking environments, preferred.
- Understanding of data quality, reconciliation, and audit requirements, preferred.
- Strong understanding of ETL/ELT concepts, data integration, and pipeline orchestration.
- Solid knowledge of data warehouse architecture, including staging, ODS, and enterprise data warehouse layers.
- Strong SQL skills and experience querying relational databases.
- Ability to troubleshoot ETL failures, analyze logs, and identify root causes.
- Understanding of data quality, reconciliation, and audit requirements.
- Ability to follow and contribute to coding standards, documentation, and best practices.
- Strong analytical and problem-solving skills.
- Strong attention to detail and operational discipline.
- Ability to collaborate with cross-functional teams including QA, business analysts, and downstream consumers.
- Familiarity with Agile or hybrid delivery models.
- Understanding of data governance, security, and regulatory requirements in banking environments.
ADDITIONAL INFORMATION
- Candidates residing in locations within BankUnited's footprint may be given preference.
Skills Required
- Bachelor's Degree in Computer Science, Information Systems, or related field
- 4+ years of experience in ETL / data engineering / data integration
- Hands-on experience with Informatica (PowerCenter / IDMC)
- Strong SQL and relational database experience
- Exposure to Snowflake, AWS, dbt, or other cloud-based data environments and orchestration tools
- Minimal scripting in Python and orchestration for API integrations/event-driven patterns
- Experience supporting production data pipelines with defined SLAs and dependencies
- Familiarity with Agile or hybrid delivery models
- Understanding of data governance, security, and regulatory requirements in banking environments
- Understanding of data quality, reconciliation, and audit requirements
BankUnited Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about BankUnited and has not been reviewed or approved by BankUnited.
-
Healthcare Strength — Healthcare coverage is positioned as comprehensive, with medical, dental, and vision options plus disability and life insurance. Wellness programming is described as robust, including incentives, screenings, and on-site fitness facilities at the corporate center.
-
Retirement Support — Retirement support includes a 401(k) plan with a company match and relatively quick eligibility after one month. Auto-enrollment and auto-increase features are described, which can help employees build savings consistently.
-
Leave & Time Off Breadth — Time-off offerings are described as broad, including a sizable PTO range by level and paid holidays. Additional time-off programs such as volunteer time and flexible/hybrid/remote arrangements are also described for eligible positions.
BankUnited Insights
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
BankUnited, Inc., with total consolidated assets of $35.2 billion at March 31, 2021, is a bank holding company with one wholly owned subsidiary, BankUnited. BankUnited, a national banking association headquartered in Miami Lakes, Florida, provides a full range of banking services to individual and corporate customers through banking centers in Florida and New York. The Bank also provides certain commercial lending and deposit products on a national platform. Here at BankUnited, we endeavor to provide, through experienced lending and relationship banking teams, personalized customer service and offer a full range of traditional banking products and services to both commercial and retail customers.
