Oracle Senior ETL Developer in Boston, Massachusetts
Senior ETL Developer
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.
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.
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.
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
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
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.
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 Type: Regular Employee Hire
- Oracle Jobs