Senior ETL Developer

3 weeks ago

Boston, United States Federal Home Loan Bank of Boston Full time

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 API's 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.

#LI-Hybrid

  • Senior ETL Developer with Talend

    3 weeks ago

    Boston, United States Prime Software Technologies, Inc. Full time

    Talend Senior ETL DeveloperDuration: 12 months contract Boston, MA (Hybrid Role)Need Candidate on W2 onlySeeking a Talend Senior ETL Developer to assist with the development efforts of converting an existing ETL system to the Talend ETL technology for approximately one year. The position requires the candidate to take a senior role in bringing this new...

  • Senior ETL Developer with Talend

    3 weeks ago

    Boston, United States Prime Software Technologies, Inc. Full time

    Talend Senior ETL DeveloperDuration: 12 months contract Boston, MA (Hybrid Role)Need Candidate on W2 onlySeeking a Talend Senior ETL Developer to assist with the development efforts of converting an existing ETL system to the Talend ETL technology for approximately one year. The position requires the candidate to take a senior role in bringing this new...

  • Senior ETL Developer

    2 weeks ago

    Boston, United States Insight Global Full time

    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 cloud. This person will collaborate across teams to design, develop, and optimize...

  • Talend Senior ETL Developer

    3 weeks ago

    Boston, United States Compu-Vision Consulting Full time

    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 converting an existing ETL system to the Talend ETL technology for approximately one...

  • Talend Senior ETL Developer

    4 weeks ago

    Boston, United States NavitsPartners Full time

    Job DescriptionJob DescriptionPosition: Talend Senior ETL DeveloperDuration: 12 monthsLocation: HYBRID (Tue/Wed onsite - Back Bay area, Boston )Extension: Highly possible Position Summary The Client needs a talented Talend Senior ETL Developer to assist with the development efforts of converting an existing ETL system to the Talend ETL technology for...

  • Senior ETL Developer

    2 weeks ago

    Boston, United States Federal Home Loan Bank of Boston Full time

    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...

  • Senior ETL Developer

    2 weeks ago

    Boston, United States Federal Home Loan Bank of Boston Full time

    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...

  • Senior ETL Developer

    2 weeks ago

    Boston, United States Federal Home Loan Bank of Boston Full time

    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...

  • Senior ETL Developer

    2 weeks ago

    Boston, United States Federal Home Loan Bank of Boston Full time

    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...

  • Senior ETL Developer

    2 weeks ago

    Boston, United States Federal Home Loan Bank of Boston Full time

    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...

  • Senior ETL Developer

    4 weeks ago

    Boston, Massachusetts, United States Federal Home Loan Bank of Boston Full time

    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...

  • ETL Developer

    3 weeks ago

    Boston, United States Saxon Global Full time

    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: Boston, MA (Hybrid), 2 days remote and 3 days onsite Start: ASAP Duration: 6...

  • ETL Developer

    4 days ago

    Boston, United States Center for Health Information and Analysis Full time

    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-driven health care interventions. CHIA is an independent state agency whose work...

  • Sr. Talend ETL Developer

    2 weeks ago

    Boston, United States Saxon Global Full time

    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, AWS/Azure Must be Local day one and onsite in Boston, MA Tuesday's and Wednesday's -...

  • ETL Developer

    4 days ago

    Boston, United States Center For Health Information And Analysis Full time

    Job DescriptionJob DescriptionAre 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-driven health care interventions. CHIA is an...

  • ETL Developer

    5 hours ago

    Boston, United States Center For Health Information And Analysis Full time

    Job DescriptionJob DescriptionAre 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-driven health care interventions. CHIA is an...

  • Talend ETL Developer

    4 days ago

    Boston, United States Center For Health Information And Analysis Full time

    Job DescriptionJob DescriptionAre 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 Analysis (CHIA), we provide the factual foundation...

  • Talend ETL Developer

    4 hours ago

    Boston, United States Center For Health Information And Analysis Full time

    Job DescriptionJob DescriptionAre 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 Analysis (CHIA), we provide the factual foundation...

  • Informatica ETL Developer

    2 weeks ago

    Boston, United States Saxon Global Full time

    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 Data Management Cloud) AWS is a big plus Must have Redshift or Snowflake Job Summary ...

  • Etl Developer

    1 week ago

    Boston, United States Dart Point Full time

    Responsibilities Participate in design & creation of scalable software. Write clean functional code on the front- & back-end Test & fix bugs or other coding issues. Work with development teams & product managers to create software solutions. Analyze functional business applications and design specifications for functional activities. Translate detailed...