IT Developer

India

6 years experience

Birthday:

Nationality:
Indian

51145265

University education

Timeframe
Degree / faculty / university
Study areas

2005-082009-05

completed

Bachelor of Technology (BTech)
Computer Science

, India

  • Document_Study_011.pdf
  • Document_Study_012.pdf

Professional experience

Timeframe
Occupation / company
Tasks

2015-02Till now

ETL/Bigdata Developer

, India

▪ 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

2014-022015-01

ETL Developer

, India

▪ 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

  • Document_Experience_011.pdf

2010-082014-01

ETL Developer/ Manual Tester

, India

▪ 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

  • Document_Experience_021.pdf

Training and development

Timeframe
Degree / institute
Content

Further training

2014-092014-09

completed

Informatica Certified Specialist- Data Integration 9.x (Certificate No. 004-000231)

, India

  • Document_Education_011.pdf

Further training

2010-042010-04

completed

ISTQB certified tester (Certificate No. ITB -CTFL0028407)

, India

Language ability

Language
Level
Exam / certificate
German
Advanced (B1)

Certificate of examination in level B1

English
Fluent (C1)

Other certificate

  • Document_Language_011.pdf

Telugu
Mother tongue

Hindi
Mother tongue

Other skills

Key professional skills
Driver licenses
Interests, hobbies, personal

ETL tools : Informatica PowerCenter (8x and 9x), Informatica Data Quality, Informatica Power Exchange
Hadoop framework tools: YARN, Sqoop, Hive, Spark
Operating Systems : UNIX, Windows
Database : Oracle, DB2, Teradata
Language : SQL, PL/SQL, Shell Scripting, Python
Project Support Tools : Autosys (Scheduler), HP Quality Center, JIRA
Microsoft Office: Excel, Word, Power point
Project Methodologies : Rapid SDLC, Agile

Start recruiting