ETL Informatica Developer-Amelia OH - Georgia IT Inc.
Amelia, OH
About the Job
ETL Informatica Developer
Location: - Amelia OH
Duration: 12 Months
Rate: Open
USC / GC /EAD Only
Job Description
Required Skills
Location: - Amelia OH
Duration: 12 Months
Rate: Open
USC / GC /EAD Only
Job Description
- Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications and Performs source system analysis as required
- Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter and prepare corresponding documentation.
- Design and develop database objects like Tables, Procedures, Functions, Indexes and Views using SQL Server, Oracle
- Build, maintain, and enhance all objects packages/functions in PL/SQL to support application process
- Provide Support for QA Testing
- Assist and resolve production issues
- Tune and optimize ETL batch jobs for performance and throughput
Required Skills
- 8+ years of working experiences with ETL Informatica PowerCenter Tool
- 8+ years of experience in writing and executing PL/SQL programming
- 8+ years of experience with Unix Shell Scripting
- Understanding of dimensional data models (STAR Schema)
- Design, Code, and Test Informatica ETLs
- Coding SQL Stored Procedures and Triggers in SQL Server/Oracle
- Ability to performance tune SQL code and Informatica components
- UNIX Shell Scripting
- Ability to conform with established coding standards
Source : Georgia IT Inc.