ETL Developer

Job Title: ETL Developer- W2 only
Location- Local to Mechanicsburg, PA – onsite day one
Duration: Long term contract

Position – 2

Required Skills  Skill: Informatica Power Center and SQL.
Preferred Skills ETL, Informatics, BO, Crystal and SQL

Responsibilities Job Description –

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