Responsibilities: - Profile & Analyze Source Data (Mainframe Extracts, Oracle tables & UNIX flat files) usage using Ab Initio Data Quality Environment (DQE).- Analyzing and evaluating data sources, data volume, and business rules.- Automation, job scheduling, dependencies, monitoring.- Extraction, transformation and load of data using the ETL tools.- Configure/Script Business rules and transformation rules in Ab Initio Data quality tool.- Design, development of Reports and dashboards.- Understanding the data model, designing the model for EDW, mapping the data and running the ETL jobs.- Ensure appropriate level of Unit Test and System Test of all the deliverables- Defect fixes for System Test, Operational Acceptance Test and Production Primary Skills: - ETL development, Ab Initio (DQE, BRE, Express-IT), UNIX, SQLSecondary Skills: - Shell Scripting, Perl Scripting, Versioning ControlOther Skills Required: - Good to have Knowledge of Retail Banking and Cards domains (consumer and commercial card lifecycles)- Experience in Design and implementation of complex ETL processes.- Knowledge of any of ETL tools like Ab initio DQE/Informatica/ETLValidator- Configure business rules in AbInitio- Proficient in writing complex SQL queries.- Good Understanding of traditional RDBMS systems like SQL Server, Oracle, Teradata, etc.- Excellent problem solving, debugging, performance tuning skills- Proficient in Linux/Unix /Windows shell scripting- Excellent communication skills- Analysis and resolution of the DQ issues reportedKindly update your profile for immediate discussion and validation.Please click on the Apply Now Button and send current resume
