Informatica Developer

Responsibilities
·
Perform data warehouse solution design activities including requirements gathering, and design & development
· Support and maintain the Oracle data warehouse environment, including PL/SQL, Informatica PowerCenter, Informatica Change Data Capture, Oracle Warehouse Builder, Oracle APEX
· Help to support and maintain the production environment as needed.
· Work with subject matter experts within business units to develop an understanding how data supports their business activities and needs
· Work with solution architects and business analysts in translating solution requirements into state-of-the-art technical designs
· Review the work of other team members – including contractors – that work on enhancing and supporting the data warehouse
· Adhere to and enforce client software development methodology and standards, which include functional and technical designs, code reviews, unit & integration testing, source control and packaging of code
· Clearly document and communicate technical designs, solutions, and issues
· Assist in the training and development of other team members, contribute toward the continuous improvement of the BI team and Integration team, and help to build the capabilities of the IT department
· Collaborate with the quality assurance team in developing testing plans and streamlining testing activities
· Interact cross-functionally with a wide variety of IT and business stakeholders

Qualifications
Education
Bachelor’s degree in Computer Science or related field

Years of Experience
· 8+ years of experience in application development using Informatica
· 8+ years of experience with Oracle databases and Oracle PL/SQL

Required Skills
Expert in Informatica for ETL development, data warehousing and ETL theory
Expert in Oracle PL/SQL, SQL, and SQL tuning