Senior ETL Developer

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


  • ETL Developer

    2 weeks ago


    Boston, Massachusetts, United States Matal Full time

    Responsibilities Analyze and evaluate detailed business functional and high-level technical requirements. Assume responsibility by ensuring that design/code reviews are scheduled and executed. Provide feedback and recommend solutions. Ensure that design standards and documentation are followed and certify that code meets quality standards. Contribute to the...


  • Boston, Massachusetts, United States Marchon Partners Full time

    Marchon's healthcare client is seeking a Senior Project Manager to lead a health data warehouse project.The initiative is to rebuild an existing data warehouse using new ETL, Business Intelligence, and database platforms with an eye towards cost containment and improved technical performance.This key role will leading implementation and reporting to the...


  • Boston, Massachusetts, United States Selby Jennings Full time

    3+ years of professional experience in software engineering, with a strong preference for a focus on quantitative applications.Expertise in Python and Pandas, coupled with proficiency in related scientific libraries such as NumPy, SciPy, statsmodels, and scikit-learn.Hands-on experience in developing mission-critical production systems, with a solid...


  • Boston, Massachusetts, United States Selby Jennings Full time

    Essential Qualifications:Possess 5-7 years of professional experience in software engineering, with a specific emphasis on quantitative applications.Demonstrate expert proficiency in Python and Pandas, coupled with a high level of competence in related scientific libraries such as NumPy, SciPy, statsmodels, and scikit-learn.Showcase hands-on experience in...

  • Lead .NET Developer

    1 month ago


    Boston, Massachusetts, United States JPS TECH SOLUTIONS Full time

    Role -Lead .NET Developer Location -Boston MA Position type - Contract No of positions - 2Job DescriptionThe .NET developer will be part of a fast-paced agile software development team. Responsibilities include review analyze and modify n-tier applications including encoding testing debugging and documenting programs by participating actively in all phases...


  • Boston, Massachusetts, United States Selby Jennings Full time

    Essential:5-7 Years of Professional Experience: Demonstrated proficiency with 5-7 years of professional experience in software engineering, preferably emphasizing quantitative applications.Expert Knowledge of Python and Pandas: Mastery of Python and Pandas, coupled with proficiency in related scientific libraries like NumPy, SciPy, statsmodels, and...


  • Boston, Massachusetts, United States Motion Recruitment Full time

    My client is a dynamic and innovative company operating in the education sector. They're on a mission to revolutionize the way K-12 students learn by providing interactive and engaging online learning experiences. Their platform combines cutting-edge technology with pedagogical expertise to create a seamless and effective learning environment for students...


  • Boston, Massachusetts, United States Metaplane, Inc Full time

    We're a Boston-based, remote-friendly company founded by MIT and HubSpot alums.We're backed by leading investors such as Y Combinator, Flybridge, and notable angel investors, including the founders of HubSpot, Okta, and Lookout.The role will be responsible for all aspects of our backend, including our suite of integrations, machine learning pipeline, and...


  • Boston, Massachusetts, United States Fidelity Investments Full time

    Job Description:Position Description:Applicants are permitted to work remotely from an at-home worksite anywhere in the United StatesBuilds RESTful Application Programing Interfaces (APIs) using Spring Boot, Java, and Python. Develops, innovates, and advocates to improve technical design. Implements single and multi-tenant data solutions and Cloud database...


  • Boston, Massachusetts, United States Selby Jennings Full time

    Proficiency in Microsoft-based technologies, including robust SQL, C#, and WPF expertise, is essential.A minimum of 7 years of Application Development experience is highly preferred; significant relevant experience will be considered in lieu of a degree.Familiarity with Git or other source code control systems is mandatory.A solid grasp and prior experience...


  • Boston, Massachusetts, United States Soro Technologies Full time

    Responsibilities Implement Azure services such as Azure App Service Azure Functions Azure SQL Database Azure Storage and Azure CDN to ensure optimal performance and availability. Integrate third-party systems extensions and APIs with Adobe Commerce/Magento to enhance the eCommerce functionality. Customize and extend the Adobe Commerce/Magento platform using...


  • Boston, Massachusetts, United States Selby Jennings Full time

    M&A Senior Associate will be responsible for:Executing transactions for clients in the Industrials Sector.Perform analysis on potential mergers and acquisitions of companies in the Architecture, Construction, and Engineering space.Be creative in the support of senior leadership with innovative ideas and visual analyses.M&A Senior Associate should have the...

  • C++ Developer

    1 month ago


    Boston, Massachusetts, United States Fathom Information Design Full time

    Our development team is comprised of people who have a range of backgrounds—from traditional software engineering to creative coding to application architecture. As a C++ developer you'll work with complicated data sets, iterate on tools, and find high performance ways to bring data to life across devices. You also have an appreciation for design and value...


  • Boston, Massachusetts, United States Selby Jennings Full time

    Responsibilities:Developing and maintaining Python libraries crucial for supporting investment research production processes.Designing and implementing software solutions to enhance our data science technology stack.Creating financial data APIs and numerical APIs.Utilizing cloud and distributed computing technologies.Implementing performance enhancements in...

  • Senior Full Stack

    3 weeks ago


    Boston, Massachusetts, United States Motion Recruitment Full time

    Are you looking to join a dynamic and rapidly growing fintech startup committed to revolutionizing the financial services industry through innovative technology solutions? If so, my client is seeking a Senior Full Stack engineer to join their dedicated team in creating cutting-edge products that empower customers.As a Senior Full Stack Engineer on the team,...


  • Boston, Massachusetts, United States Nisum Full time

    Nisum is a leading global digital commerce firm headquartered in California, with services spanning digital strategy and transformation, insights and analytics, blockchain, business agility, and custom software development. Founded in 2000 with the customer-centric motto "Building Success Together," Nisum has grown to over 1,800 professionals across the...


  • Boston, Massachusetts, United States Proclinical Full time

    Senior Director, Regulatory Affairs - Permanent - RemoteProclinical Staffing is seeking a Senior Director, Regulatory Affairs to join a leading health information technology and clinical research organization. This is a permanent role with the opportunity to work remotely.Primary ResponsibilitiesIn this role, you will provide leadership and advice on the...


  • Boston, Massachusetts, United States Wasabi Technologies Full time

    Role Description: Salesforce Developer Role Purpose: As a Senior Developer, your role involves leading the design and development of custom software applications to meet crucial business needs. You'll collaborate closely with the VP of IT, System Engineers, Project Managers, Product Team, and Business Analysts to create and maintain systems as planned. Your...


  • Boston, Massachusetts, United States Motion Recruitment Full time

    My client is looking to hire a Senior Frontend engineer to join their team. They're a dynamic and innovative company and leader in the sports betting industry. They provide cutting-edge technology solutions that enhance the betting experience for millions of users worldwide. Their platform offers a wide range of sports events, real-time odds, and secure...


  • Boston, Massachusetts, United States Motion Recruitment Full time

    My client is a pioneering 3D printing company at the forefront of revolutionizing industries such as aerospace, consumer products, and healthcare. Their cutting-edge technology is reshaping manufacturing processes and pushing the boundaries of what's possible. They're seeking a Senior Full Stack Engineer to join their growing team.As a Senior Fullstack...