Job Description :
Informatica Developer
6 Months
Chicago, IL
Basic Qualifications :
1. Informatica development - Expert
2. PL/SQL – Expert
Additional Skills :
OBIEE – HUGE plus, not required.
Job Description :
Expert in Informatica and PL/SQL
Job Description:
Participate in project that will take existing Oracle transactional data and ETL into enterprise data warehouse and data mart. The data mart is the source of enterprise reporting using OBIEE.
Participate in solution design activities including requirements gathering, ETL design & development
Develop detail ETL programs for the project.
Clearly document and communicate technical designs, solutions, and issues.
Help to support and maintain production environment as needed.
Adhere to and enforce software development methodology and standards, which include functional and technical designs, code reviews, unit & integration testing, source control and packaging of code
Collaborate with the quality assurance team in developing testing plans and streamlining testing activities
Required Skills:
Expert in Informatica for ETL development, data warehousing and ETL theory
Expert in Oracle PL/SQL, SQL, and SQL tuning
Data architecture experience: familiar with relational and dimensional data model, able to design solution based on existing data models.
A strong sense of ownership
An ability to work independently without strict oversight and without being handed a task-list of discrete steps. Should be able to take a loosely-defined assignment and produce robust programs.
An ability to accurately estimate and plan his/her design, development, and testing work.
The ability to work collaboratively with team members from IT (BA, PM, integration developer) and the business (business leads and SMEs)
An ability to quickly learn our specific environments, IT processes, and technical change management procedures, and then begin to productively complete design and development activities within two weeks of his/her start date.
Experience developing custom-built software using state-of-the-art software engineering principles and practices. This includes professional coding practices (modularity, documentation including code comments, high level designs, data flow diagrams, unit testing) as well as experience in different development methodologies (waterfall and agile At least 5 years of this experience should be ETL development experience.
Additional Desired Skills (Nice to Have)
Oracle APEX development experience