IT-Entwickler/in

▪ Analysing Business requirements and Source System data
▪ Making sure all Positions/Transactions sourced are reconciled back to Ledger data
▪ Proof of Concepts for Complex ETL and Hadoop Architectures, Optimization of ETL Design and Implementation
▪ Emergency code fixes, Change Requests (CR’s) Impact Analysis, Automating flow
▪ Requirements, bugs, CR’s tracking through JIRA and HP Quality Center, Code Versioning in SVN Tortoise
▪ Working on ETL tools:- Informatica PowerCenter 9.x, Message Queues, and Database languages:- Oracle, SQL, PL/SQL, other:- UNIX shell scripts
▪ Working on Hadoop Frameworks:- YARN, Sqoop, Hive, Spark, other:- UNIX shell scripts
▪ Deploying ETL code, Autosys (JIL) scripts, and Database objects
▪ Coordination with Business team and visited Dublin, Ireland to understand the Orchestration model, Project design
▪ Performing QA testing, Solving SIT, UAT and Production obstacles and issues
▪ Technical documentation- Deployment Plan, Run books, Control Plan, functional specifications, Training content etc.
▪ Delivering Trainings on Informatica within the Bank and to new project members
▪ Managing deliverables and time using MS Excel and Outlook

▪ Data migration from various source systems like Oracle, Mainframes, and ETL Design and implementation
▪ Designed and implemented Slowly Changing Dimensions and Facts
▪ Analyzed Business requirements and Source Systems data
▪ Performance-Analyses and -Tuning of existing and new ETL flows and databases
▪ Implemented Change Requests, and tracked CR’s and defects in HP Quality Center
▪ Worked on ETL tools - Informatica Power Center 9.x, and Database languages:- Oracle, SQL, Teradata, Others:- Unix shell scripts
▪ Coordination of work with Onsite team in Barclays ABSA (South Africa) and offshore India team
▪ Trainings to new team members
▪ Performed QA, Solved SIT, UAT obstacles and issues
▪ Technical documentation- Run books, Release documents

▪ Analysed Business requirements and Source Systems data
▪ Developed and Maintained existing data warehouse-architectures and processes
▪ Worked on waterfall model and worked with ETL counterparts in Onsite (US)
▪ Proof of Concepts, ETL Design and implementation
▪ Dimensions and Fact data load
▪ Worked on ETL tools and languages- Teradata, DB2 SQL, Informatica Power Center 9.x and Power Exchange 9.x.1, Abnitio 1.14, UNIX shell scripts
▪ Performed QA, Solved SIT, UAT and Production obstacles and issues
▪ Manual Testing of Credit Card Web Pages, Test Plan, Test Case Preparation and Logging and Managing Defects in HP QualityCenter
▪ Technical design documents

Prüfungs-Zertifikat auf Niveau B1

Anderes Zertifikat

–

–