Us Citizen
Security Clearance
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Need New H1B (OPT/CPT Fresh Grads)
W2-Contract
1099-Contract
Contract to Hire
UG :-
PG :-
No of position :- ( )
Post :- 27th Jan 2022
Job Title : ETL Informatica Developer
Location : Atlanta, GA (Remote)
Duration : Full Time
Job Description
· Create Informatica mappings with PL/SQL store procedures/functions to incorporate critical business functionality to load data.
· Used connected, unconnect lookup, static and dynamic cache to implement business logic and improve the performance.
· Develop procedures and functions using PL/SQL and develop critical reports.
· Develop PL/SQL functions/procedures/cursors/packages/database triggers to implement business logic.
· Work with relational databases like DB2.
· Detail table design and index selection in for TeraData databases using SQL.
· Develop mappings with XML as target and formatting the target data according to the requirement.
· Work with logical, physical, conceptual, star, snow flake schema data models.
· Extract data from flat files, DB2 and to load the data into the SalesForce database.
· Create and used debugger sessions to debug sessions and create breakpoints for better analysis of mappings.
· Work with various data sources--relational, flat file (fix width, delimitate) and XML.
· Involve in all phases of SDLC from requirements gathering, architecture design, development, testing, and data migration.
Christy Rachel
IT Recruiter
Direct Phone: +1 (609-423-6916)
Email: christy@hanatek.org
LinkedIn: linkedin.com/in/christy-rachel-77a467196
Address: 55 Madison Avenue, Suite 400, Morristown, NJ 07960
URL: www.hanatek.io
Go Green! Think Green before printing!