Senior ETL Developer

2 weeks ago

Boston, United States RPMGlobal 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.

#J-18808-Ljbffr

  • Senior ETL Developer with Talend

    1 week 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

    1 week 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

    3 days 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

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

  • Senior ETL Developer

    2 weeks ago

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

    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 region. The Federal Home Loan Bank of Boston is committed to making New England a better...

  • Talend Senior ETL Developer

    2 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

    1 week 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 days 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

    13 hours 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

    3 days 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, 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...

  • Senior ETL Developer

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

  • Talend Senior ETL Developer

    4 days ago

    Boston, United States US Tech Solutions Full time

    Using the Talend ETL toolset, to create new and maintain existing ETL jobs. Design and implement ETL for extracting and transforming data from diverse sources, such as: Snowflake, PostgreSQL, and SQL Server databases. Design and develop database tables necessary along with the necessary constraints as per the requirement. Collaborate with Team members to...

  • Talend Senior ETL Developer

    1 week ago

    Boston, United States US Tech Solutions Full time

    Using the Talend ETL toolset, to create new and maintain existing ETL jobs. Design and implement ETL for extracting and transforming data from diverse sources, such as: Snowflake, PostgreSQL, and SQL Server databases. Design and develop database tables necessary along with the necessary constraints as per the requirement. Collaborate with Team members to...

  • Talend Senior ETL Developer

    1 week ago

    Boston, United States US Tech Solutions Full time

    Using the Talend ETL toolset, to create new and maintain existing ETL jobs. Design and implement ETL for extracting and transforming data from diverse sources, such as: Snowflake, PostgreSQL, and SQL Server databases. Design and develop database tables necessary along with the necessary constraints as per the requirement. Collaborate with Team members to...

  • Talend Senior ETL Developer

    2 weeks ago

    Boston, United States US Tech Solutions Full time

    Using the Talend ETL toolset, to create new and maintain existing ETL jobs. Design and implement ETL for extracting and transforming data from diverse sources, such as: Snowflake, PostgreSQL, and SQL Server databases. Design and develop database tables necessary along with the necessary constraints as per the requirement. Collaborate with Team members to...

  • ETL Developer

    2 weeks ago

    Boston, United States Pan Asia Resources Full time

    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 Procedures Experience Design, develop and test ETL mappings & workflows Design, develop...

  • Sr. Talend ETL Developer

    2 weeks ago

    Boston, United States Global Network Technologies Full time

    Job DescriptionJob DescriptionJob Title: Sr. Talend ETL DeveloperLocation requirements/Schedule: HybridLocation/s: : 501 Boylston Street, Suite 5100, Boston, MA 02116 Local CandidatesStart Date: ASAPBonus/Benefits: NOType of contract: C2C, W2, Contract to Hire C2HDuration: 6+ months Contract to hireVisa: USC, GCHow many interviews: 2Interview Process:...