Find Jobs
Hire Freelancers

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

₹250000-500000 INR

Geschlossen
Veröffentlicht vor mehr als 2 Jahren

₹250000-500000 INR

Bezahlt bei Lieferung
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
Projekt-ID: 31149244

Über das Projekt

1 Vorschlag
Remote Projekt
Aktiv vor 3 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
1 Freelancer bieten im Durchschnitt ₹455.000 INR für diesen Auftrag
Avatar des Nutzers
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 in 210 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von INDIA
India
0,0
0
Mitglied seit Aug. 13, 2021

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.