List of ETL Work Done As a Remotely, AnyWhere in The World !!!

Description:

IBM Infosphere Datastage / Informatica / Abintio ETL Specialist

– Interviewer | Solution / Logic / Session Provider | Reviewer | Consultant

1. Execute .bat file or call sql file in connector stage w.r.t. different approach.
2. Kill the job which have run state for a 2-3 days.
3. Guidance, ETL approaches for Architecture role.
4. Copy Workflow and run + Build, History record copy to .dat file.
5. Build, If ID >= 90 than flag “N” until new name and repeat same for every new name.
6. Guidance, ETL Data Warehousing Testing role.
7. Build, 100 ETL jobs w.r.t. Simple, Medium, Complex and Very Complex .
8. Migrate, ETL to Azure Data Factory (ADF) – Convert Date Time Server Routine to Oracle SQL Query + null handle.
9. Create job, important of transformer stage, column functionality, broken issue etc.
10. Identify issue on DB or ETL + null handle+ datatype
11. Remove join warnings + prepared SQL query based on condition to populate in dataset w.r.t ETL jobs
12. Set null if input column value zero + add or remove column in transformer + Convert String to Date with OUTPUT format YYYYMMDD.
13. Removed warnings from jobs i.e. null handling and executed job successfully through script.
14. Removed Warnings of Null Field length of Char Fields and implicit conversation of Decimal Fields + Sequential File not showing column or field name. + Analysis on Major ETL job contain join,lookup,data set, transformer etc. stages why particular fields showing empty records.
15. Modify Formula of particular field in Major ETL job + Analysis on Major ETL job why particular field not giving correct result even formula used.
16. Modify fields on transformer and suggestions on business fields. Also, Advice on i e. dataset remove.
17. Convert SQL to ETL job which contains 3 inner join, conditions, group by .
18. Covert SQL to ETL job which contains 3 decode, 3 joins and where clauses.
19. Failure job successfully run and 6 transformer condition apply based on requirement.
20. Build logic to calculate no. of property mortgaged w.r.t. customer and type of property mortgaged
21. Build logic to identify home loan, non Vefa based on set finished property Y or N w r.t. loan amount condition
22. Overview of Store Procedure design and Explanation on Datastage.
23. Implement Datastage job using funnel, transformer function, join stage , Fork-join etc. + resolve issue incase failure job.
24. Guidance, Hierchical Stage for Convert CSV to Json
25. Guidance, Hierchical Stage for extract data from SharePoint List.
26. Interviewer, Abintio JD for USA opportunity in company for 1 candidate.
27. Interviewer, Data Analytic JD for Indian Opportunity in company for 1 candidate.
28. Interviewer, Datastage + Informatica JD for Indian Opportunity in company for 3 candidate.
29. Interviewer, Teradata + Informatica JD for Indian Opportunity in company for 7 candidate.

Client’s Reviews

Rating:Clients

• 5.0 : 1 Malaysia
• 5.0 : 1 USA
• 5.0 : 1 India

Clients :Task

• 1 Malaysia : 3
• 3 India : 18
• 1 India(I) : 11
• 2 USA : 3
• 1 USA(I): 1
• 1 Australia : 1

Tech : Worked

• Datastage 11.7:28
• Informatica 10.4.0:8
• Abintio:1

REQ : Provided

• Task Solution:4
• 30 min / 1 hr. Session : 17
• 30 min / 1 hr(I) Interviewer : 12
• Consultant : 4

Total:

• 9 Clients
• 25 Work Done
• 12 Interview Taken
• 4 Guidance
• 24 Datastage
• 1 Informatica
• 1 Abintio (I)
• 7 Informatica (I)
• 4 Datastage (I)
• 3 time 5.0 Rating
• 7 Free+8 Free (I)
• 18 Paid+4 Paid (I)