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)