PL/SQL Developer Resume

SUMMARY:

Around 11+ years of technical and project consulting experience with ETL Applications, Card Services, Retail, Equities and Mortgage Domain, Worked in all aspects of the Project Life Cycle.
Responsibilities handled include requirement study, functional study, system analysis, system design, programming, testing, training and implementation support.
8 years of experience in ETL Tools Informatica PowerCenter 10.x/9.x/8.x, Ab initio 2.x, 3.x
3 years of experience with Data Profiling/Data Quality using Informatica Analyst and Informatica Data Quality (IDQ).
Experienced in preparing design documents, mapping process documents, Unit Test Plans for Data Warehousing projects ensuring the data meets the business requirement and for better maintenance.
Experience in managing onshore offshore activities for analysis, design, development and testing of ETL Applications.
Experience in Sprint Planning, Sprint Review, Daily Scrum calls, Product Backlog review, Kanban, Jira Task Management using Jira Agile Process.
Extensively used Team City Devops Tools using power shell to build reusable tasks for building multiple ETL Application environments using Release, Data Copy, Setup, Data Extract tasks.
Experience in setup and migration of Data warehouse applications to AWS Cloud using Amazon S3, Redshift, RDS, Dynamo DB
Experience in building Real Time ETL application using Websphere MQ, Tibco queues and Topics,Web services using REST API, SOAP API, RPC call.
Good Knowledge on Big data process (Hadoop) frame work.
Experience in developing application high level flowcharts, Block diagrams using Visio, Data Models using Erwin.
Expertise in Database Design, Partitioning Framework, Development of SQL, PL/SQL, Stored Procedures, functions, prod database performance bottlenecks issue analysis and fix, Query tuning for better performance using SQL Server, Oracle, DB2, Teradata
Good exposure in writing BTEQ scripts and loading data into Teradata using FASTLOAD, MLOAD and TPUMP utilities.
Experienced in writing Unix Shell Scripts for the automation of ETL processes and using schedulers like Autosys, Ctrl - M, Tivoli Work Scheduler.

PROFESSIONAL EXPERIENCE:

Confidential

PL/SQL Developer

Responsibilities:

8 years of experience in ETL Tools Informatica PowerCenter 10.x/9.x/8.x, Ab initio 2.x, 3.x
3 years of experience with Data Profiling/Data Quality using Informatica Analyst and Informatica Data Quality (IDQ).
Experienced in preparing design documents, mapping process documents, Unit Test Plans for Data Warehousing projects ensuring the data meets the business requirement and for better maintenance.
Experience in managing onshore offshore activities for analysis, design, development and testing of ETL Applications.
Experience in Sprint Planning, Sprint Review, Daily Scrum calls, Product Backlog review, Kanban, Jira Task Management using Jira Agile Process.
Extensively used Team City Devops Tools using power shell to build reusable tasks for building multiple ETL Application environments using Release, Data Copy, Setup, Data Extract tasks.
Experience in setup and migration of Data warehouse applications to AWS Cloud using Amazon S3, Redshift, RDS, Dynamo DB
Experience in building Real Time ETL application using Websphere MQ, Tibco queues and Topics,Web services using REST API, SOAP API, RPC call.
Good Knowledge on Big data process (Hadoop) frame work.
Experience in developing application high level flowcharts, Block diagrams using Visio, Data Models using Erwin.
Expertise in Database Design, Partitioning Framework, Development of SQL, PL/SQL, Stored Procedures, functions, prod database performance bottlenecks issue analysis and fix, Query tuning for better performance using SQL Server, Oracle, DB2, Teradata

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship