ETL Engineer/Data Engineer Resume

TECHNICAL SKILLS

Programming Languages: SQL, PL - SQL, TSQL, R, Python

Other Tools: JIRA, Service Now, MS Visio, GitHub, Toad, Pl-SQL Developer, Oracle Forms and Reports Developer, Azure DevOps

BI Tools: SSIS, Informatica, Snowflake, SSAS (Tabular and Multidimensional), Tableau, Power BI, Excel, SAP Lumira

Web Technologies: XML, HTML, CSS, JSP

Key Strengths: Requirement Gathering, Incident & Team Management, Database Design, Data Modeling, Business Process Modeling, ETL Process, Data Warehousing, Big Data Integration, Test Data Management

PROFESSIONAL EXPERIENCE

Confidential

ETL Engineer/Data Engineer

Responsibilities:

Developed and maintained ETL mappings to extract the data from multiple source systems that comprise databases like Oracle, SQL Server, flat files to the Staging area, Data Warehouse and then to the Data Marts using SSIS
Maintained SQL scripts and complex queries for analysis and extraction
Performed and presented Data analysis, Data Cleaning, Wrangling and prediction modeling for complex data and files
Translated data requirements between front-line consulting staff and technical resources by creating reports and dashboards using Power BI, SQL, and Tableau
Managed deployments to QA/UAT/PROD and resolved production issues raised in ETL solutions within given SLA timelines
Worked on JIRA & Azure DevOps for creating User Stories and worked in daily agile Scrum meeting, Scrum review and retrospective
Managed a team of 6 members, prepared project plans, and tracked project deliveries for ETL and reporting projects

Confidential

ETL Engineer

Responsibilities:

Created technical design documents, ETL mapping, unit/system/integration test plans, and end-user system documents
Developed Tableau visualizations and dashboards using Tableau Desktop and developed Tableau workbooks from multiple data sources using Data Blending
Worked in R and PL/SQL programming to implement business user requirements and business rules
Extracted data from various source systems like XML, flat-files, CSV, Oracle and loaded into MS SQL server using SSIS, done analysis and created star and snowflake schema and data cubes using SSAS and created reports using SSRS
Collaborated with different business stakeholders to identify opportunities for process improvements, recommend system modifications, and developed policies for data governance

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship