Data Engineer Resume Peoria IL - Hire IT People

SUMMARY

Having 7 years of IT experience as anPL/SQL Developer,Oracle Developer, Development & Support of Oracle Database 9i,10g and 11g in Production, staging and Development environments.
Involved in all phases of SDLC (Software Development Life Cycle).
Proficient working experience with SQL, PL/SQL,Database objects likeStored Procedures, Functions, Packages, Triggersand using the latest features to optimize performance likeBulk Binds, Inline viewsandGlobal Temporary Tables.
Very good experience in Oracle tools likeSQL*Plus, SQL*Loader, SQL DeveloperusingTOADin secure databases.
Very good knowledge of SQL, PL/SQLespecially writing queries withJoins, Sub - Queries, Rollups, Cubes, Set Operators.
Expertise in implementing ETL (Extract, Transform & Load) for supporting Data Extraction, Data Transformation and Data Loading.
Experience in migration of source code using version control systems - GIT.
Excellent Team Player to work in conjunction with testers (QA and offshore), developers and other team members in validation and testing of complex project scenarios and in maintenance of Quality Standards of products.
Expertise in handling errors using Exceptions withRAISEapplication clause.
Knowledge ofMaterialized Views.
Managing security by creating and grantingRolesandPrivilegesto users.
Experience in developing externalTables, Views, Joins, Cluster indexesandCursors.
Proficient in advance features of Oracle 9i for PL/SQL programming like UsingCursor Variables, Ref Cursors, Nested TablesandDynamic SQL.
Experience in creation of tablePartitioningby range, list, hash, composite methods andIndexesfor managing large tables.
Proficient in Query/application tuning using optimizerHints,Explain plan, SQL Trace, TKPROF.
Developed newReportswhich are used to extract data from different systems and criteria.
Automated the process through theUNIX Shell Scriptingand auto sys job scheduling.

TECHNICAL SKILLS

Operating Systems: UNIX, LINUX, Sun Solaris 5.8/5.9/5.10 , Windows NT/95/98/2000/XP

Databases: Oracle 12C / Oracle 11g/Oracle 10g, Oracle 9i, Ms Access

Utilities: SQL*Loader, Explain Plan, FTP, SFTP, SCP

Tools: TOAD, SQL Developer, Erwin, SQL Navigator, SQL*Loader, SQL*Plus, MS-FrontPage, MS Office Suite, iSql Plus, (REPORTS 6i/9i/10g/11g, FORMS 6i/9i/10g/11g).

ETL Tools: Informatica power-center 8.6.x, Data stage

Languages/Editor: SQL, PL/SQL, UNIX Shell Programming, VI Editor

PROFESSIONAL EXPERIENCE

Confidential, Peoria IL

Data Engineer

Responsibilities:

Responsible for writing SQL queries to extract the data from the dealer systems.
Responsible for On-boarding dealers’ data into Helios production / QA environments.
Responsible for installing CAT ETL tool, data mapping and extract the data.
Responsible for validating data quality through Scorecards.
Responsible for validating element and Cross-domain issues with the dealers.
Assist dealers to understand data mapping’s and extract the data as per DICE document standards.
Responsible for requirement gathering, analyze the dealer’s ERP merging (DCN conversion, division changes, SoS changes and store number changes…) and implement in Helios QA / Helios Production.
Responsible for submitting exceptions, list price validation, Quality gate and data gap analysis.

Environment: Hive, SQL, Azure DevOps, Unix, Python, MFT Server, AWS, Oracle 12C, DBS, SQL Server, SSIS, SAP, XAPT and CAT ETL.

Confidential

Jr Data Analyst

Responsibilities:

Responsible for creating family sharing metrics for US and Canada locations.
Responsible for calculating data usage for OnStar applications.
Involved in creation of Tables, Join Condition, Nested Queries, Views, Sequences and Synonyms for the business application development.
Developed Database Triggers, Packages, Functions and Stored Procedures using PL/SQ Land maintained the scripts for various data feeds.
Created Indexes for faster retrieval of the customer information and enhance the database performance.
Created dynamic SQL to support dynamic nature of front-end applications.
Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
Used the UNIX for Automatic Scheduling of jobs. Involved in Unit Testing of newly created PL/SQL blocks of code.
To conserve the resources used the anonymous blocks within the IF statements.
Wrote complex queries to generate reports as per client request as a part of production support.

Environment: Oracle12C, Windows XP, PL/SQL, SQL*PLUS, SQL Developer, UNIX, HIVE and Spark

We provide IT Staff Augmentation Services!

Data Engineer Resume

Peoria, IL

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship