Informatica Power Center expert - Atlanta (Dunwoody) GA - Georgia IT Inc.
Dunwoody, GA
About the Job
Informatica Power Center expert
Location: Atlanta (Dunwoody) GA
Duration: till end of year and longer
Status: URGENT
Rate: DOE
U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time
Responsibilities/Duties
Skills:
Location: Atlanta (Dunwoody) GA
Duration: till end of year and longer
Status: URGENT
Rate: DOE
U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time
Responsibilities/Duties
- 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
Skills:
- 10+ years of working experiences with ETL Informatica PowerCenter Tool
- 5+ years of experience in writing and executing PL/SQL programming
- 5+ 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
- Ability to conform with established coding standards
- UNIX Shell Scripting
- SDLC Methodology
- Written and verbal communication
- Preferred Skills/Experience
Source : Georgia IT Inc.