Senior ETL Developer
2 weeks ago
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 timeResponsibilities 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...
-
Senior Project Manager
4 weeks ago
Boston, Massachusetts, United States Marchon Partners Full timeMarchon'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...
-
Senior Software Engineer
4 weeks ago
Boston, Massachusetts, United States Selby Jennings Full time3+ 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...
-
Senior Software Engineer
4 weeks ago
Boston, Massachusetts, United States Selby Jennings Full timeEssential 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 timeRole -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...
-
Senior Software Engineer
3 weeks ago
Boston, Massachusetts, United States Selby Jennings Full timeEssential: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...
-
Senior Frontend Developer/Angular/Boston
1 month ago
Boston, Massachusetts, United States Motion Recruitment Full timeMy 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...
-
Senior Software Engineer, Backend
1 month ago
Boston, Massachusetts, United States Metaplane, Inc Full timeWe'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...
-
Principal Software Engineer/Developer
4 weeks ago
Boston, Massachusetts, United States Fidelity Investments Full timeJob 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...
-
Senior Software Developer
4 weeks ago
Boston, Massachusetts, United States Selby Jennings Full timeProficiency 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...
-
Senior Azure Developer
4 weeks ago
Boston, Massachusetts, United States Soro Technologies Full timeResponsibilities 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...
-
M&A Senior Associate
5 days ago
Boston, Massachusetts, United States Selby Jennings Full timeM&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 timeOur 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...
-
Senior Quantitative Developer
3 weeks ago
Boston, Massachusetts, United States Selby Jennings Full timeResponsibilities: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 timeAre 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,...
-
Senior Front-End Developer
3 weeks ago
Boston, Massachusetts, United States Nisum Full timeNisum 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...
-
Senior Director, Regulatory Affairs
2 weeks ago
Boston, Massachusetts, United States Proclinical Full timeSenior 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...
-
Salesforce Developer
2 days ago
Boston, Massachusetts, United States Wasabi Technologies Full timeRole 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...
-
Senior Frontend Engineer
1 month ago
Boston, Massachusetts, United States Motion Recruitment Full timeMy 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...
-
Senior Full Stack Engineer
1 month ago
Boston, Massachusetts, United States Motion Recruitment Full timeMy 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...