Job Description :
ROLE: ETL Lead Developer
Location: Mechanicsburg PA

Expert in the design, development, testing, and implementation of programs, scripts, and processes to extract, transform, clean, and load data from diverse source systems into a centralized data repository using industry best practices

Expert in generating UNIX shell scripts/ Windows scripts for automation of ETL process and data transfer requirements.

Knowledge of Informatica’s Data Transformation studio to parse XML files.

Good knowledge if Oracle query writing, PL/SQL functions and procedures

Good knowledge of batch job scheduler

Collaborative working with both technical and business stakeholders through all phases of the SDLC, including business requirements gathering, project design, development, testing, and implementation.

Good Understanding and configuration experience of Informatica Power Center Components, experience in Legacy modernization.