Job Duties:

Unica Group, Inc in Mechanicsburg, PA seeks Sr. Informatica Developer. Responsible for the development of ETL (Extract, Transform and Load) code. Design/Develop ETL Interface using Informatica tool. In addition, implement an Informatica based ETL solution fulfilling stringent performance requirements. Develop/Implement the coding of Informatica mappings for different stages of ETL. 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. Support installation, upgrades, and testing of Informatica components. Perform data profiling, data standardization, data transformations, data loads. Perform detailed data profiling and end-to-end data management analysis to understand data issues, and to identify potential options to resolve issues. Support phases of the project lifecycle including requirements gathering, analysis, design, development, testing, deployment, support, and documentation. Analyze, document and define data management processes, both batch and real-time. Evaluate data management and data governance practices to provide options and recommendations. Create clear deliverable materials for a range of recipients including technical teams, business teams, project leads and executives.
Travel: Must be willing to travel and relocate to unanticipated client locations in the U.S. Telecommuting from home allowed from anywhere in the United States when not needed at client site.

Job Requirements:

Must possess a Bachelor’s Degree in Computer Science, Information Systems, Information Technology, or a related field and 5 years of experience in the job offered or a related role. Must also possess experience with (i) ETL development and process from diverse data sources; (ii) data modeling concepts; (iii) development, maintenance, and enhancement of Informatica Mappings, Work- flows, and processes; (iv) Datawarehouse; and (v) 5 years’ experience with PL/SQL, Autosys, and UNIX (shell scripting).

Please Send request and resume at:

Unica Group, Inc., Attn: Rajeev G Pangarkar, CEO, 5002 Lenker St #202, Mechanicsburg, PA 17050; (Refer to: Job # 102)