Find Jobs
Hire Freelancers

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

₹250000-500000 INR

Closed
Posted over 2 years ago

₹250000-500000 INR

Paid on delivery
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
Project ID: 31149244

About the project

1 proposal
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
1 freelancer is bidding on average ₹455,000 INR for this job
User Avatar
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 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
India
0.0
0
Member since Aug 13, 2021

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.