ETL Developer (Informatica PC) Citizens only
Share
Job Location:
Charlotte, VT - USA
Monthly Salary:
Not Disclosed
Posted on:
8 hours ago
Vacancies:
1 Vacancy
Job Summary
Location: Charlotte Nc
MUST BE US CITIZEN!
ITAR REQUIRMENT
100% ON-SITE
Must-Have: INFORMATICA
Knowledge of PL/SQL is Must with hands-on experience.
Understanding the Business Requirements & ETL specification Document
Extraction Transformation and Loading (ETL) of data by using Informatica PC
Designed various mappings for extracting data from various sources involving flat files and relational tables.
Good Concept of Data warehouse to be available. Created mappings using the transformations such as the Source qualifier Aggregator Expression Router Filter Sequence Generator and Update Strategy.
Checked and tuned the performance of Informatica Mappings. Testing and maintaining of Informatica Mappings
Resolving if any issues in transformations and mappings with the help of technical specifications.
Checked and tuned the performance of Informatica Mappings.
Resolve and debugging any development issues.
Involved in Creating Sessions Workflows Using Workflow Manager Involved in testing the mappings (UNIT testing) and preparation of test cases.
Ensuring proper Dependencies of loads (Incremental and Complete loads).
Responsibility of / Expectations from the Role
1 Demonstrate Good understanding of requirement gathering
2 Provide standard/near-standard Unit testing on Mapping Development
3 Communication to gather requirements or analyses an issue from Data Lead
4 Work independently Follow standard template approach in Migration Project
5 Co-ordinate with multiple stakeholders in case of issues
MUST BE US CITIZEN!
ITAR REQUIRMENT
100% ON-SITE
Must-Have: INFORMATICA
Knowledge of PL/SQL is Must with hands-on experience.
Understanding the Business Requirements & ETL specification Document
Extraction Transformation and Loading (ETL) of data by using Informatica PC
Designed various mappings for extracting data from various sources involving flat files and relational tables.
Good Concept of Data warehouse to be available. Created mappings using the transformations such as the Source qualifier Aggregator Expression Router Filter Sequence Generator and Update Strategy.
Checked and tuned the performance of Informatica Mappings. Testing and maintaining of Informatica Mappings
Resolving if any issues in transformations and mappings with the help of technical specifications.
Checked and tuned the performance of Informatica Mappings.
Resolve and debugging any development issues.
Involved in Creating Sessions Workflows Using Workflow Manager Involved in testing the mappings (UNIT testing) and preparation of test cases.
Ensuring proper Dependencies of loads (Incremental and Complete loads).
Responsibility of / Expectations from the Role
1 Demonstrate Good understanding of requirement gathering
2 Provide standard/near-standard Unit testing on Mapping Development
3 Communication to gather requirements or analyses an issue from Data Lead
4 Work independently Follow standard template approach in Migration Project
5 Co-ordinate with multiple stakeholders in case of issues
Key Skills
- Anti Money Laundering
- Entry Level Sales
- Asset
- Application Engineering
- Electrical & Instrumentation
