We provide IT Staff Augmentation Services!

Sql- Etl- Developer Resume

St Louis, MO

SUMMARY

  • 14 plus years of extensive Software Development Life Cycle experience.
  • Extensive experience in Data Analysis, Testing and Validations
  • Experience in ETL process using Teradata, Informatica, Syncsort, Alteryx
  • Solid Development experience with SQL/PL/SQL (procedures / functions) and Oracle Forms/Reports.
  • Experience in Data Warehousing, Batch processing, Performance Tuning, Data Modeling, Explain plan, Tkprof, Sqlloader, Utl File, Import - Export utilities, and Unix Shell scripting.
  • Experience in export, import and SQL*Loader utilities and worked on high volume OLTP, OLAP databases.
  • Created complex functions, stored procedures, pkgs and triggers using PL/SQL.
  • Created Interfaces using PL/SQL to do the data transactions between different Systems.
  • Created Oracle Forms & Reports using 6i/9i/10g & Crystal Reports9/10/Business Objects XIR2/BIRT, DOMO.
  • Experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation and Post Implementation surveys.
  • Worked on design, development, implementation testing of applications, unit and system testing on database.
  • Experience with Informatica Power Center in all phases of Analysis, Design, Development, Implementation
  • Supported Data Warehousing applications using Informatica Power Center 10.x/9.x
  • Experience in Star and Snowflake schema addressing Slowly Changing Dimensions (SCDs).
  • Strong DBA skills and extensive experience with Unix shell scripting, unit testing, logical and physical database design, performance tuning, database security maintenance and Shell scripts for batch processing.
  • Good Knowledge in AWS, Data Lake, AWS Athena, and working on Cloud Environment.
  • Worked as team using Agile-Scrum Methodology to achieve the goals.

TECHNICAL SKILLS

  • Sun Solaris, Linux, HP-UX, Windows NT /98 /2000/, MS-DOS
  • Oracle 8i/9i/10g/11g/12c, Teradata 15, SQL Server 2005/2008, Ms Access
  • P L/SQL 8i/9i/10g/11gSQL Server 2005/2008/2016 Oracle Forms & Reports 6i/9i/10g/11g Discoverer, Designer
  • OBIEE, Oracle Answers, Dashboard, IBots
  • SQL Server 2005 ReportsCrystal Reports 9/10, Business Objects XIR2,DOMO
  • Oracle Application Server 10g, Web Logic serverOracle Apex, HRMS/Payroll (11i)
  • Explain plan, TkProf,
  • Informatica, Syncsort, Alteryx
  • Oracle Enterprise ManagerSQL*Plus, SQL*LoaderToad 9.0,SQL Developer, Pl/Sql DeveloperInformatics, MS Visio, Subversion, Reflection
  • Erwin, Unix Shell ScriptingVBA, VB 6.0, VB.Net,++, Perl, Pro*C, JavaOracle SCM, JavaScript, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential - St. Louis, MO

SQL- ETL- Developer

Responsibilities:

  • Worked on data analysis, Unit testing and created interfaces using SQL/PLSQL.
  • Worked with different teams to review the business rules and user requirements.
  • Worked with Business Analysts, Testers and Release management, etc.
  • Designed and developed custom tables, procedures, and functions.
  • Used Oracle Explain Plan to do the performance tuning of the SQ/PLSQL
  • Worked with users and business group to create the functional requirements.
  • Extensively worked with DOMO Dashboard/Reports with beast mode and drill down capabilities.
  • Worked on Informatica Power Center ETL tool to load data from different sources.
  • Written complex SQL to extract, transform and load data to destination tables.
  • Designed and developed complex ETL mappings by making use of different transformations
  • Used transformations, Joiner, Update Strategy, Connected Lookup, Expression, Router, Filter.
  • Worked on Slowly Changing Dimensions Type 1, Type 2 and Type 3
  • Worked on documentation for gap analysis and technical design to move data between systems.
  • Extensively used ETL to load data from flat files to Oracle on Cloud environment.
  • Extensively worked in the performance tuning of programs, ETL procedures and processes.
  • Error checking and testing of the ETL procedures and programs using Informatica session log
  • Testing and Debugging of Informatica Mappings, Mapplets, Sessions, Tasks, Worklets and Workflows
  • Worked on data integration, data profiling, Analyzed and customized many processes by using SQL/PLSQL.

Environment: SQL/PL/SQL, Oracle 11g, Informatica PowerCenter 10x, DOMO Reports with Redshift/MySQL, AWS, Linux, Unix Shell, ALM Ticket Tracker, SQL/PL/SQL Developer, Putty, Explain Plan, SQL*Plus, Confluence, BIRT Reports (4.4)

Confidential - St. Louis, MO

SQL-ETL Developer

Responsibilities:

  • Worked on data analysis and created interfaces using SQL/PLSQL.
  • Worked with different teams to review the business rules and user requirements.
  • Created ETL Jobs using Teradata to get data from various systems.
  • Created Load tables, Dimension and Fact tables, Indexes, etc.
  • Worked with Business Analysts, Testers and Release management, etc.
  • Worked on data validation and testing the data quality.
  • Designed and developed custom tables, views packages, procedures, and functions.
  • Worked on logical database design and data modeling.
  • Extensive testing done on the programs to achieve accuracy & timely processing of data.
  • Worked with users and business group to create the functional requirements.
  • Heavily optimized the code for high performance.
  • Explain Plan, Skew Factor, collect stats, etc. were used for SQL tuning.

Environment: Teradata 15.10, Unix Shell, JIRA Ticket Tracker, SVN, TOAD, SQL, Putty, Core FTP, Explain Plan, SQL Assistant 16.20 etc.

Confidential - St. Louis, MO

SQL-ETL- Developer

Responsibilities:

  • Worked on SQL/PL/SQL statements and procedures.
  • Worked with different teams to review the business rules and user requirements.
  • Created ETL Jobs using Informatica to get data from various systems.
  • Worked with Business Analysts, Testers and Release management, etc.
  • Experience in Slowly Changing Dimensions Type 1, Type 2 and Type 3
  • Worked on data integration, data catalogs, data profiling.
  • Designed and developed custom tables, views packages, procedures, and functions.
  • Worked on logical database design and data modeling.
  • Worked on mapping and technical design document
  • Worked with various teams to do the gap analysis
  • Used transformations, Joiner, Update Strategy, Connected Lookup, Expression, Router, Filter.
  • Involved in the development of Informatica mappings and tuned for better performance.
  • Worked as team using Agile Scrum methodology to achieve the goals
  • Extensive testing done on the programs to achieve accuracy & timely processing of data.
  • Analyzed and customized many processes and reports by using SQL/PL/SQL.
  • Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level
  • Worked with users and business group to create the functional requirements.
  • Heavily optimized the code for high performance.
  • Used Oracle Explain Plan to do the performance tuning of the SQL.

Environment: Oracle 11g, Informatica PowerCenter 9/10, Teradata, Unix Shell, JIRA Ticket Tracker, SQL/PL/SQL Developer, Putty, Core FTP, Explain Plan, SQL*Plus, Bitbucket, Materialized Views, TOAD (11.6)

Hire Now