Title: ETL Informatica PowerCenter Developer

Location: Mechanicsburg, PA (Looking local to PA)

Fulltime with Apexon

Required Skills Skill: Informatica Power Center and SQL.

Preferred Skills ETL, Informatics, BO, Crystal and SQL

Responsibilities Job Description –

• Responsible for the development of informatica ETL (Extract, Transform and Load) code
• Move staging table to the target table
• Design, code, unit test ETL packages, triggers, and stored procedures, views, SQL transactions
• Understand and comply with development standards and SDLC to ensure consistency across the project
• Design and develop Informatica PowerCenter mappings including transformations, mappings, mapplets, workflows, workflow monitor
• Utilize Informatica repository manager, designer, workflow manager & workflow monitor, to manage and administer ETL jobs
• Design, schedule, execute and monitor ETL jobs, including necessary exception handling & balance and control measures
• Perform troubleshooting, debugging, and performance tuning.
• Create, test and refine SQL queries to support data profiling and data management
• Expected Deliverable(s) Complete the assignments on time with quality.

Job Type: Full-time

Pay: $86,869.62 - $104,617.17 per year

Benefits:

• 401(k) matching
• Dental insurance
• Health insurance
• Life insurance
• Paid time off
• Vision insurance

Compensation package:

• Yearly pay

Experience level:

• 6 years

Schedule:

• 8 hour shift
• Day shift
• Monday to Friday

Experience:

• Informatica Powercenter: 7 years (Preferred)
• Data warehouse: 7 years (Preferred)

Work Location: In person