Data Integration Developer

Envision Employment Solutions is currently looking for a skilled ** Data Integration Developer** to join our team and support enterprise data integration initiatives. The ideal candidate will have strong hands-on experience with Informatica PowerCenter as an ** ETL** tool, along with solid expertise in ** SQL** and ** PL/SQL **, working on enterprise relational databases.

Responsibilities:

• Design, develop, test, support processes for extracting, transforming and loading data from source systems to DWH and Data Marts.
• Design the processes to meet service level agreements for data timeliness and frequency.
• Analyze and optimize current solutions, physical model optimization, query tuning.
• Mentoring junior members of the team in data integration development best practices.
• Analyze and improve query and solution performance, optimize physical model.
• Developing project deliverable documentation.
• Must be familiar with Online Data Processing Tools.

Requirements

• Bachelor’s degree in Computer Science, Information System or a related field.

• 2+ years of experience as a Data Integration Developer or ETL Developer.

• Hands-on experience with Informatica PowerCenter.

• Strong experience in SQL and PL/SQL.

• Experience working with enterprise relational databases, especially Oracle Database.

• Good understanding of data warehousing and ETL concepts.

• Prefer to have experience in enterprise or banking environments.

• Knowledge of performance tuning techniques.

• Familiarity with Unix/Linux environments.

• Experience in Agile development teams.