Abinitio:
· Ab Initio Skills: Graph Development, Ab Initio standard environment parameters, GD(PDL,MFS Concepts)E, EME basics, SDLC, Data Analysis
· Database: SQL Proficient, DB Load / Unload Utilities expert, relevant experience in Oracle, DB2, Teradata (Preferred)
· UNIX: Shell Scripting (must), Unix utilities like sed, awk, perl, python
Informatica IICS:
· Good Exp in designing and developing ETL mappings using IICS.
· Should be familiar with bulk loading concepts, Change Data Capture (CDC),Data Profiling and Data validation concepts .
· Should have prior experience working with different types of data sources/targets.
· Understanding configuration, migration and deployment of ETL mappings.
Teradata:
- Assist in the design, development, and testing of Teradata databases and ETL processes to support data integration and reporting
- Collaborate with data analysts and other team members to understand data requirements and provide solutions
DataStage:
· Overall experience of 5 years in DW/ BI technologies and minimum 5 years development experience in ETL DataStage 8.x/ 9.x tool.
· Worked extensively in parallel jobs, sequences and preferably in routines.Good conceptual knowledge on data- warehouse and various methodologies.