• Enough IT experience in insurance domain in agile methodology as an ETL developer for large scale data warehouses using Informatica Power Center 9.X/10.X, Informatica power exchange, Oracle 12C R1 (SQL), Unix shell scripting, Autosys, Rally, HP Alm etc.
• Proficient in writing SQL Queries in Oracle, DB2 Server. Worked with DDL, DML ,TCL, DTL statements.
• Experienced at Creating effective Test data and development through Unit test cases to ensure successful execution of the data.
• Experienced in Error handling, Troubleshooting using errors encountered and problem fixing in database server.
• Knowledge in implementation of Entity-relationship modelling & normalization , dimensionsal modelling (facts/dimensions/star/snowflake schema etc) along with proper constraints and cardinalities.
• Good knowledge in Data Warehousing and Business Intelligence concepts.
• Worked with Single row/Aggregate/Analytical functions. Also, Worked with joins, set operators and sub queries. Worked with Indexes, views, synonyms, sequence generator, stored procedures etc.
• Involved in performance tuning of SQL queries.
• Involved in data/code migration in database (export/import) to/from various objects like csv, excel, text files etc. Also, Migrated data among different schemas in database server.
• Familiar with basic UNIX commands needed for Data warehousing projects.
Plz check my profile for more info.