Senior ETL Developer - Boston, United States - Federal Home Loan Bank of Boston

Federal Home Loan Bank of Boston Boston, United States

2 weeks ago

Banking / Loans

Description

The Federal Home Loan Bank of Boston is a leading provider of wholesale funding for housing and community finance in New England serving more than 420 financial institutions across the region. The Federal Home Loan Bank of Boston is committed to making New England a better place to live and do business, and our employees are integral to our success. As a cooperative, we are owned by more than 420 banks, credit unions, insurance companies, and community development financial institutions that access tens of billions of dollars of our reliable, wholesale funding each year. Our funds are a vital resource that helps our members succeed, provide families with safe, decent affordable housing, and generate economic development that creates jobs in communities throughout our region.

Our highly skilled team of 200 is diverse, innovative, collaborative, and passionate about the work we do. We seek other professionals excited to share their knowledge, talent, and passion for our mission to join our team. We offer opportunities for career development, robust benefits, and a work-life balance.

Position Summary

This position primarily supports the Bank's strategic projects by providing both database knowledge and development both at an architecture level and a database coding / ETL level through the analysis and understanding of business and technical requirements. The position supports day-to-day change requests for new and existing processes as assigned by the supervisor.

This role will have a hybrid work schedule in our Boston office in accordance with the Bank's Hybrid Work Program.

Primary Responsibilities

· Design, develop, and implement ETL processes using Informatica PowerCenter to extract, transform, and load data from diverse sources into the Bank's data warehouse, data marts.

· Work closely with business analysts and stakeholders to understand data requirements and translate them into technical solutions.

· Create and maintain documentation for ETL processes, including source-to-target mappings, transformations, and workflows.

· Perform ETL performance tuning, optimization, and troubleshooting to ensure efficient data processing primarily using Informatica PowerCenter.

· Collaborate with database developers and administrators to ensure proper data governance and quality standards are maintained.

· Support data modeling activities and ensure alignment of ETL processes with the overall data architecture.

· Participate in testing, debugging, and quality assurance of ETL processes to meet business requirements.

· Other duties, as assigned.

Knowledge/Skills Required

· Extensive background with Informatica PowerCenter 9.1 and above designing and developing Informatica workflows using various transformations such as filters, expressions, lookups, joiners, routers, SQL overrides, etc.

· Extensive experience building complex mappings using relational database and other non-relational sources like Flat files, XML files, JSON files.

· Experience using the Informatica Meta-Data Manager tool for data lineage graphical representation.

· Experience using the Informatica REST API integration tools.

· Experience using Tidal enterprise scheduler with the informatica adapter for building integrated scheduled ETL processes.

· Experience with Informatica Intelligent Cloud Services IICS components - application integration, using SOAP/REST APIs, APIs leveraged to integrate multiple systems or databases.

· Experience Integrating data to/from on-premises database and cloud-based database solutions like snowflake using Informatica Intelligent cloud services.

· Strong knowledge of database design principles and working with data modeling tools.

· Extensive experience with database development creating and debugging stored procedures, views, advanced SQL skills sets using joins, cursors, cubes and other types of SQL functions, cross server queries, database optimization and tuning.

· Experience with creating SQL Server Reporting Services (SSRS).

· Experience with IBM ACE creating REST APIs a strong plus.

· Effectively communicate technical solutions for business requirements.

· Ability to both work as part of a team and as an individual contributor.

Education

· A Degree in Information Systems / Information Technology preferred, but not required. Relevant work experience is required.

Preferred Experience

Minimum of 5-7 Years Informatica PowerCenter development.
Minimum 3-5 years of other ETL and SQL development using SQL Server.
Experience in a financial services environment.
Experience in a highly regulated environment.

The Federal Home Loan Bank of Boston is committed to building and sustaining a diverse workforce that reflects the communities that we serve. As an Equal Opportunity Employer, we strongly encourage applicants from every ethnicity, color, religion, gender, age, national origin, disability, veteran or parental status and sexual orientation.

Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time.

ETL Developer

2 weeks ago

Pan Asia Resources Boston, United States

ETL Developer · Location: Boston, M · Job Description: ETL Developer · 5 to 6 years' experience in: · Markit EDM (ETL and Data Governance tool), Sybase or Oracle Database · Hands on Autosys Jobs scheduler, · Hands on Shell / Python / Perl scripts to move files and Stored Pr ...
ETL Developer

4 days ago

Center for Health Information and Analysis Boston, United States

Are you a skilled Software Development professional with a proven track record for designing and developing ETL code? Look no further – you could be the ideal candidate for us · At the Center for Health Information and Analysis (CHIA), we provide the factual foundation for data-d ...
ETL Developer

2 weeks ago

Saxon Global Boston, United States

Must work onsite from day 1 - 3 days per week onsite/2 remote No H1B Must Haves: Experience- 5+ years using informatica PowerCenter and Oracle database development. Experience with relational databases, preferably Oracle Title: ETL Developer Company: Boston University Location: B ...
ETL Developer

5 days ago

Center for Health Information and Analysis Boston, United States

Are you a skilled Software Development professional with a proven track record for designing and developing ETL code? Look no further you could be the ideal candidate for us · At the Center for Health Information and Analysis (CHIA), we provide the factual foundation for data-dr ...
ETL Developer

1 day ago

Center for Health Information and Analysis Boston, United States

Are you a skilled Software Development professional with a proven track record for designing and developing ETL code? Look no further - you could be the ideal candidate for us At the Center for Health Information and Analysis (CHIA), we provide the factual foundation for data-dri ...
Senior ETL Developer

3 weeks ago

Federal Home Loan Bank of Boston Boston, United States

Senior ETL Developer · Location: Boston · Job Code: 381 · # of openings: 1 · Description · The Federal Home Loan Bank of Boston is a leading provider of wholesale funding for housing and community finance in New England serving more than 420 financial institutions across the regi ...
Informatica ETL Developer

2 weeks ago

Saxon Global Boston, United States

Client: Plymouth Rock Assurance · Position: Informatica ETL Developer · Location: 4 days onsite in Boston, MA · Duration: 6 Months · Rate:$75/hr. on C2C · Visa: USC,GC and H4EAD · Candidate must Have: · IICS or IDMC (Informatica Intelligent Cloud Services OR Informatica Dat ...
Sr ETL Developer

3 weeks ago

Saxon Global Boston, United States

Company: Plymouth Rock · Title: Sr ETL Developer · Location: 695 Atlantic Ave Boston MA (relocation will work) · Location Details: MUST work onsite 4 days a week . Office is located across the street from South Station - Must be onsite between 9am-3pm, but open to a start betw ...
Senior ETL Developer

2 weeks ago

Apex Systems Boston, United States

Apex Systems is a world class technology services business that incorporates industry insights and experience to deliver solutions that fulfill our clients' digital visions. · Apex has an opportunity for an · Senior ETL Developer · . · For applicants who are interested in thi ...
Talend ETL Developer

5 days ago

Center for Health Information and Analysis Boston, United States

Are you a skilled Software Development professional with a proven track record for designing and developing ETL code, specifically using the Talend Data Fabric product suite? Look no further – you could be the ideal candidate for us · At the Center for Health Information and Anal ...
Senior ETL Developer

2 weeks ago

Federal Home Loan Bank of Boston Boston, United States

The Federal Home Loan Bank of Boston is a leading provider of wholesale funding for housing and community finance in New England serving more than 420 financial institutions across the region. The Federal Home Loan Bank of Boston is committed to making New England a better place ...
Senior ETL Developer

2 weeks ago

Insight Global Boston, United States

An employer is looking for a Senior ETL Developer to join their team in the Seaport of Boston, MA. He/she will join the Data Warehouse team of a travel company. He/she will be a key contributor to the implementation of Snowflake as the organization migrates from Oracle to the clo ...
Senior ETL Developer

2 weeks ago

Federal Home Loan Bank of Boston Boston, United States

The Federal Home Loan Bank of Boston is a leading provider of wholesale funding for housing and community finance in New England serving more than 420 financial institutions across the region. The Federal Home Loan Bank of Boston is committed to making New England a better place ...
Senior ETL Developer

3 weeks ago

RPMGlobal Boston, United States

The Federal Home Loan Bank of Boston is a leading provider of wholesale funding for housing and community finance in New England serving more than 420 financial institutions across the region. The Federal Home Loan Bank of Boston is committed to making New England a better place ...
Lead ETL Developer

5 days ago

State of Massachusetts Boston, United States

State of Massachusetts · Lead ETL Developer · Boston , · Massachusetts · Apply Now · The Executive Office of Labor and Workforce Development (EOLWD) · is responsible for seven agencies and departments under this organization. EOLWD and its agencies are committed to developi ...
Lead ETL Developer

4 weeks ago

The Commonwealth of Massachusetts Boston, United States

Job Description · Increase your chances of an interview by reading the following overview of this role before making an application. · The Executive Office of Labor and Workforce Development (EOLWD) · is responsible for seven agencies and departments under this organization. E ...
Lead ETL Developer

2 weeks ago

The Commonwealth of Massachusetts Boston, United States

Job Description · The Executive Office of Labor and Workforce Development (EOLWD) is responsible for seven agencies and departments under this organization. EOLWD and its agencies are committed to developing a world-class, highly skilled labor force to support business growth an ...
Senior ETL Developer with Talend

2 weeks ago

Prime Software Technologies, Inc. Boston, United States

Talend Senior ETL Developer · Duration: 12 months contract · Boston, MA (Hybrid Role) · Need Candidate on W2 only · Seeking a Talend Senior ETL Developer to assist with the development efforts of converting an existing ETL system to the Talend ETL technology for approximately on ...
Talend Senior ETL Developer

2 weeks ago

Compu-Vision Consulting Boston, United States

Position: Talend Senior ETL Developer · Duration: 12 months · Location: HYBRID (Tue/Wed onsite - Back Bay area, Boston ) · Extension: Highly possible · Position Summary · The Client needs talented Talend Senior ETL Developer to assist with the development efforts of conver ...
Sr. Talend ETL Developer

2 weeks ago

Saxon Global Boston, United States

Company: Comm of Mass CHIA Office · Title: Sr. Talend ETL Developer (Lead) · Location: Boston MA · Visa : NO H1 · Duration : 12+ Months · 1 Lead Talend ETL Developer - Pay Rate $90 on C2C · 1 Sr. Talend ETL Developer - Rate $70/hr. on C2C · SkillSets- Talend, Snowflake, AW ...