We provide IT Staff Augmentation Services!

Sql Developer Resume

SUMMARY:

  • Proficient in the development of projects using Informatica 10.0/9.x/8.x/7.x, Oracle, Teradata,Unix,Python and Tableau.
  • Experience in all the phases of Data warehouse life cycle involving requirements gathering/analysis, design, development, validation & testing of Data warehouses using ETL, Data Modeling, & Reporting tools.
  • Analyzing the client’s data using Tableau and Python and building the analytics frameworks for better managed flow of project and development activities
  • Aid in developing style guide for development of Tableau visualizations, design of components, naming of items, data source creation and naming.
  • Extensively worked with Teradata version V15.10 and used utilities like BTEQ, Fast Export, Fast Load, TPT, Multi Load to export and load data to/from different source systems including flat files.
  • Good Knowledge of Teradata Architecture and proficient in performance analysis, partitioning and SQL query tuning using EXPLAIN PLAN and Run stats.
  • Excellent Experience with different indexes (PI, SI, PPI (MLPPI, SLPPI)) and collect statistics.
  • Experienced working on Teradata SET/MULTISET tables.
  • Experience in handling Large volume data both in Oracle and Teradata and worked on performance Issues when needed.
  • Experience in using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant.
  • Strong Data warehousing ETL experience in Informatica power center client tools (Power center designer, workflow manager, workflow monitor & Repository Manager) and Power Exchange.
  • Experience in designing dashboards with the use of visualization tools like Tableau.
  • Restricting data for particular users with the help of User filters in Tableau.
  • Good in data warehouse concepts/data warehouse architecture and best practices.
  • Worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
  • Experience in Performance tuning of targets, sources, mappings and sessions.
  • Experience in working with UNIX Shell scripts and Batch scripts and necessary Test Plans to ensure the successful execution of the data loading process.
  • Experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, Excel, XML, Cobol, Oracle, SQL Server and Teradata.
  • Exposure in Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Fact and Dimensional tables, Physical and Logical data modeling using ER-Win.
  • Good knowledge on Sales & Marketing, Telecom, Retail & Manufacturing, Banking & Finance, Insurance, and Health care domains.
  • Discussed extensively with developers, data architecture team, Business Analysts before designing a model that can fulfill all business needs.
  • Clarified client requirements, business needs and project objectives, at each level of project implementation.
  • Created and executed Test Plan, Test Scripts and Test Cases based on Design document and User Requirement document for testing purposes.
  • Excellent knowledge of software development life cycle activities including analysis, design, development, unit testing, regression testing, production deployment and Maintenance.
  • Worked on various Scheduling tools like Auto Sys, Control-M, Tidal.
  • Experienced in creating metadata entries for frame work tables.
  • Excellent communication and interpersonal skills, good analytical reasoning and ability to learn quickly, high adaptability to new technologies and tools.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Developer

Responsibilities:

  • Experienced working on Teradata SET/MULTISET tables.
  • Experience in handling Large volume data both in Oracle and Teradata and worked on performance Issues when needed.
  • Experience in using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant.
  • Strong Data warehousing ETL experience in Informatica power center client tools (Power center designer, workflow manager, workflow monitor & Repository Manager) and Power Exchange.
  • Experience in designing dashboards with the use of visualization tools like Tableau.
  • Restricting data for particular users with the help of User filters in Tableau.
  • Good in data warehouse concepts/data warehouse architecture and best practices.
  • Worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
  • Experience in Performance tuning of targets, sources, mappings and sessions.
  • Experience in working with UNIX Shell scripts and Batch scripts and necessary Test Plans to ensure the successful execution of the data loading process.
  • Experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, Excel, XML, Cobol, Oracle, SQL Server and Teradata.
  • Exposure in Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Fact and Dimensional tables, Physical and Logical data modeling using ER-Win.
  • Good knowledge on Sales & Marketing, Telecom, Retail & Manufacturing, Banking & Finance, Insurance, and Health care domains.
  • Discussed extensively with developers, data architecture team, Business Analysts before designing a model that can fulfill all business needs.
  • Clarified client requirements, business needs and project objectives, at each level of project implementation.
  • Created and executed Test Plan, Test Scripts and Test Cases based on Design document and User Requirement document for testing purposes.
  • Excellent knowledge of software development life cycle activities including analysis, design, development, unit testing, regression testing, production deployment and Maintenance.
  • Worked on various Scheduling tools like Auto Sys, Control-M, Tidal.
  • Experienced in creating metadata entries for frame work tables.

Hire Now