ETL \ DATA WAREHOUSE DEVELOPER Resume Raliegh, NC - Hire IT People

SUMMARY:

Detail - oriented, efficient and organized professional with 6-year experience in ETL, Data warehouse and SQL development.
Organized, take-charge professional with willingness to fill in as needed, eagerness to quickly self-learn new technologies, exceptional follow through abilities and detail orientation; a drive and dependable performance to doing things right.
Possess strong analytical and problem-solving skills, with the ability to make well thought out decisions.
Excellent communication skills in data management, listening and assessing required Business needs.

SKILLS:

SQL Server Tools: MS SQL Server 2008R2 -2017/7.0, Oracle, MS Access, MSSQL Server Reporting Services 2008R2 -2015 (SSRS), MSSQL Server Analysis Services 2008R2 - 2015(SSAS), MSSQL Server Integration Services 2008R2 - 2015 (SSIS), Data Transformation Services(DTS), Oracle 9i/10g, OLTP, OLAP, SQL ServerManagement studio (SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, SQL Profiler. JiRA, Service NOW, Samanage, RESR, C#, SalesForce, Tableau, SSDT, Source Control, Team Foundation server.

PROFESSIONAL EXPERIENCE:

ETL \ DATA WAREHOUSE DEVELOPER

Confidential, Raliegh, NC

Responsibilities:

Design and Create a Data Warehouse to meet the need of the company
Designing databases and ensuring their stability, reliability, and performance.
Design, create, and implement database systems based on the end user's requirements.
Impove application's performances.
Prepare documentations for database applications.
Develop database schemas, tables and dictionaries.
Ensure the data quality and integrity in databases.
Fix any issues related to database performance and provide corrective measures.
Create complex functions, scripts, stored procedures and triggers to support application development.
Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications Including developing of SSIS packages using SSDT and scheduling jobs in the SSIDDB.
Provide support to all ETL schedule and maintain compliance to same and develop and maintain various standards to perform ETL codes and maintain an effective project life cycle on all ETL processes.
Coordinate with ETL team to implement all ETL procedures for all new projects and maintain effective awareness of all production activities according to required standards and provide support to all existing applications.
Create Change or Issue (incident) request to resolve issues with applications using SAMANAGE,JIRA and or SERVICE NOW

ETL DEVELOPER

Confidential, Greenville, SC

Responsibilities:

Install, upgrade and configure SQL Servers from SQL Server 2005 to SQL Server 2017 R2enterprise edition and enabling SSIS/SSRS/SSAS on Client machines, Development, Production servers. Create stored procedures, views, triggers and constrains to implement the database consistency and integrity.
Implement indexes such as clustered index, non - clustered index, covering index appropriately on data structures to achieve faster data retrieval.
Create SSIS package to extract, transform and load (ETL) data from different sources into destination target, like data warehouse, Flat file, Excel, OLE DB, using SQL Server Integration Services.
Schedule SSIS packages Created as Agent jobs using SSMS.
Perform tuning at source, transformation, target, and workflow levels.
Analyze and executed the test cases for various phases of testing - integration, regression and user
Develop and maintained ETL (Data Extraction, Transformation and Loading) mappings using SSIS to extract the data from multiple source systems that comprise databases like SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts.
Create stored procedures using SQL Server management Studio to carry out required task.
Prepare Change Orders for monthly Deployments to Production Environment.
Create, INSERT and UPDATE tables within the development environments and push for deployment into Production environment.
Capture business information needs from stake holders and translated into requirements and functional specifications. Evaluated and recommended best form of delivery - report manager reportrefreshable Excel spreadsheets, or SSAS Cube.
Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
Experience in working with SSAS in creating cubes, 7.0, Oracle, MS Access, data source views, named queries, dimensions and deploying of analysis services projects.
Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad- hoc analytic research and automated reporting.
Involve in designing cubes in SSAS environment using Snowflake and Star Schemas.

We provide IT Staff Augmentation Services!

Etl \ Data Warehouse Developer Resume

Raliegh, NC

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship