Massachusetts Information Technology Jobs

Senior ETL Developer

Preferred Qualifications

Senior ETL Developer

LOCATION: BOSTON, MA

NOTE: We are unable to provide visa sponsorship for this role at this time. No candidates requiring visa sponsorship will be considered.

Our Team

We are building and transforming applications on Asset management, Trading and brokerage & Securities Services/Custodial Services for one of the top tier Investment banks and we are looking for top Software Engineers as independent contributors and team players.

Your Opportunity

You will be responsible for applying your extensive knowledge as a Software developer and help us in our vision to become a reality. You will bring in ability to understand business requirements/process flows/ and produce code that would help us achieve our goal.

Our Ideal Candidate

We are looking for a strong Informatica Senior Developer who thrives on research and development projects. Be a strong technical hand who works efficiently to make sure we are building the right code and services using the right coding principles.

Your Responsibilities

• Go to person for Informatica design, code development and one who leverages industry best practices to implement end-to-end ETL Data Integration solutions using Informatica

• Ability to develop complex business solution in highly demanding environment as per the industry standard practice/recommendations and provide hands on guidance to team members.

• Provide high-quality solutions to the customers and lead the effort of problem understanding, scoping, solutioning, designing and estimating

• Work with business experts to understand business needs, translate business requirements into system functionality, and ensure that results meet established needs, goals, and timelines.

• Design, development, testing and deployment of Informatica mappings and workflows

• Clearly document and communicate technical designs, solutions, and issues.

• Act as a mentor to the development team and conduct code reviews

Your Skills

• Extensive experience in Informatica development

• Create Informatica mappings with transformations likes Editor, Source Qualifier, Joiner, Router, Update Strategy, Filter & work with sessions, workflows, mapplets

• Worked with Power Center Mapping Designer, Workflow Manager, Workflow Monitor, Repository etc. including creation, testing and scheduling workflows

• Strong working experience in creation of Sessions and Workflows

• Knowledge on creation of Reusable Transformations to improve efficiency

• Ability to import / export data using data loaders.

• Strong in SQL with ability to performance tune SQL queries

• Ability to user various database utilities for data loading

• Working experience in understanding data models and creating ETL architectures.

• Prior Experience in executing at least 5-8 end to end Datawarehouse projects

• Skilled in working with virtual teams across cultures and organizational disciplines

• Secondary skills / knowledge (desirable)

• Experience in Sybase, SQL Server, DB2

• Experience in any other ETL tools like ODI, DataStage, Ab Initio

• Exposure to building cloud services is desirable

• Unix Shell Scripting

• Investment Banking domain experience

• 3 rd party scheduling tools

Your Qualifications

• BS/MS in Computer Science or related fields.

• 7 years in Informatica development.

• Strong problem solving, troubleshooting and analytical skills.

• Strong knowledge of Data Warehousing and Big Data concepts.

• Ability to quickly learn new technologies in a dynamic environment.

• Good organization, communication and interpersonal skills.

• Prior experience with Agile process

At Oracle, we don’t just value differences—we celebrate them. We’re committed to creating a workplace where all kinds of people work together. We believe innovation starts with diversity and inclusion.

https://www.oracle.com/corporate/careers/culture/diversity.html

Detailed Description and Job Requirements

An experienced consulting professional who has an understanding of solutions, industry best practices, multiple business processes or technology designs within a product/technology family. Operates independently to provide quality work products to an engagement. Performs varied and complex duties and tasks that need independent judgment, in order to implement Oracle products and technology to meet customer needs. Applies Oracle methodology, company procedures, and leading practices.

Operates independently to provide quality work products to an engagement. Performs varied and complex duties and tasks that need independent judgment, in order to implement Oracle products and technology to meet customer needs. Applies Oracle methodology, company procedures, and leading practices. Demonstrates expertise to deliver functional and technical solutions on moderately complex customer engagements. May act as the team lead on projects. Effectively consults with management of customer organizations. Participates in business development activities. Develops and configures detailed solutions for moderately complex projects.

5-7 years of experience relevant to this position including 2 years consulting experience preferred. Undergraduate degree or equivalent experience. Product or technical expertise relevant to practice focus. Ability to communicate effectively. Ability to build rapport with team members and clients. Ability to travel as needed.

Oracle is an Affirmative Action-Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability, protected veterans status, age, or any other characteristic protected by law.

Job: Consulting

Location: US-Massachusetts

Job Type: Regular Employee Hire

Organization: OFSS