Find Jobs
Hire Freelancers

Informatica Powercenter ETL Developer needed to work as a consultant on a temporary basis

₹250000-500000 INR

Zaprt
Objavljeno pred več kot 2 letoma

₹250000-500000 INR

Plačilo ob dostavi
Looking for a Informatica ETL Developer needed to work as a consultant on a temporary basis for 6-8 months from India only and ready to work in 1pm to 10 pm IST shift Experience Requirements: 1. 3-5 years’ of experience in ETL development using Informatica PowerCenter with Oracle database technologies. 2. 3+ years of experience in development, maintenance, and enhancement of Informatica Mappings, Work-flows, and processes with thorough knowledge of star/snowflake schemas. 3. Two (2) to four (4) years RDBMS development, SQL skills, using Oracle Development Tools like SQL, PL/SQL will be preferred. 4. Experience with developing complex SQL queries and SQL optimization. 5. Informatica Professional Certification is preferred. 6. Development experience must be full Life Cycle experience including business requirements gathering, data sourcing, testing/data reconciliation, and deployment within Business Intelligence/Data Warehousing Architecture. 7. Experience with Oracle ERP, Siebel would be a plus. 8. Experience using MS SQL Server would be a plus. 9. Experience with Informatica Administration would be a plus. Required Skills 1. Expertise designing, developing, and maintaining Informatica Applications. /Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer, and mapplet designer. 2. Ability to design and develop complex Informatica mappings, sessions, workflows and identify areas of optimizations. 3. Working knowledge of Oracle database features such as materialized views, bitmap indexes, IOTs, external tables, etc. especially as it pertains to ETL. 4. Proficient in data analysis, defect identifications and resolutions. 5. Strong professional verbal and written communication skills. 6. Ability to work with little supervision and within changing priorities. 7. Ability to analyze requirements and troubleshoot problems
ID projekta: 31149244

Več o projektu

1 ponudba
Projekt na daljavo
Aktivno pred 3 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
1 freelancer je oddal ponudbo s povprečno vrednostjo ₹455.000 INR za to delo
Avatar uporabnika
Hello Sir/Ma'am, I have 7 years of hands-on experience on Informatica powercenter and IICS with multiple MNC companies. During this 7 years, I worked on end-to-end process like --Communicated with business customers to discuss the issues and requirements. --Designed and customized data models for Data warehouse-supporting data from multiple sources on real time. --Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database. --Identified problems in existing production data. Doing extensive troubleshoot the problems to find root cause and give solution to fix the problems permanently. --Implemented various Performance Tuning techniques like Partitioning, Push down optimization, improve transformation performance etc. --Performed unit testing at various levels of the ETL and actively involved in team code reviews. --Creating reusable transformation and mapplet to use them in different mappings. --Writing SQL and UNIX script to create new report or modify report script as per data requested by clients. --Troubleshooting on performance tuning via SQL profiler and performance tuning adviser. --Having good exposer in deployment --I would be available for 1pm to 10 pm IST
₹455.000 INR v 210 dneh
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava INDIA
India
0,0
0
Član(ica) od avg. 13, 2021

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.