Data Warehouse Engineer Resume Samples

Description :

1. CSOSA is a Federal agency that provided supervision of adults on probation and supervised release in the District.
2. Analyzed business requirements and was involved in designing the data models for the data warehouse using ERWIN.
3. Created database objects like Stored Procedures, Functions, Packages, Triggers, Indexes, and Views using T-SQL in Development and Production environment for SQL Server 2012 as per the requirement.
4. Used SQL Server Integration Services (SSIS) to create ETL packages to validate, extract, transform, and load data into the database.
5. Created SSIS design template packages for Source load, Type-1, Type-2 dimensions & Fact SSIS packages to use across the Project.
6. Extracted data from different sources (text-based files, Excel spreadsheets CSV files, and Access) to SQL Server databases using SSIS.
7. Scheduled the packages and jobs to keep extracting the data from OLTP at specific time intervals using SSIS and SQL Server Agent.

Experience

7-10 Years

Level

Management

Education

Computer Science

Description :

1. Developed and onboarded ETL job flows for 7 financial institutions' transaction/card member data.
2. Created Mid-Month and Month-End reporting for 9 financial institutions. Worked closely with relationship managers to gather the outline to deliver the best quality reporting to the client.
3. Utilized Pentaho Report designer and published many internal reports for many different departments.
4. Migrated and built many ETL jobs to feed a Hadoop-based infrastructure that would also become the source for a new data warehouse.
5. Worked across multiple business and technology platforms to capture product requirements for the Business Intelligence team.
6. Generated reports using SQL Server Reporting Services (SSRS) and deployed on the report server to make them available for the users.
7. Designed reports using Cascading parameters, Parameterized Reports, and Report Models using SQL Server Reporting Services (SSRS) based on Business requirements.

Experience

2-5 Years

Level

Junior

Education

Computer Science

Description :

1. Designed/implemented Extract, Transfer, and Load (ETL) process updating central data warehouse from mainframe and transactional databases.
2. Modeled processes and data structures. Developed weekly snapshot processes for unemployment compensation data based on historical needs and fraud investigators.
3. Designed and implemented data warehousing dimension standards/processes for managing slowly changing dimensions.
4. Designed/tested flattened table and data cube structures and ETL processes to support them. Designed/Implemented performance metrics.
5. Worked on CMR project, designed/developed work queues for managing audio unemployment compensation requests/background maintenance utilities. Modeled processes/data structures.
6. Worked closely with Data warehouse, report development, and architecture team/s.
7. Designed, built, tested, and maintained data structures such as data marts, Data warehouses, cubes, and data pipelines in Azure.

Experience

2-5 Years

Level

Executive

Education

Computer Science

Description :

1. Gathered the requirements both functional and technical and documentation. Worked with the business analysts in requirement analysis to implement the ETL process Created Data dictionary using ERWIN modeler.
2. Involved in Low-level Design for the scripts of the database sequences, constraints, triggers, and stored procedures.
3. Used loading techniques like Slowly Changing Dimensions and Incremental Loading using parameter files and mapping variables.
4. Used the Power Center client tools Designer, Workflow Manager, and Workflow Monitor Worked with various Active transformations like Filter, Sorter, Aggregator, Router, and Joiner transformations.
5. Developed batch files to automate the task of executing the different workflows and sessions associated with the mappings.
6. Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
7. Used a designer debugger to test the data flow and fix the mappings. Tuned Informatica Mappings and Sessions for optimum performance Implemented integration of Datamart with Weblogic Server for creating connection pools and Data Sources of Oracle, and SQL drivers.
8. Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level, and Target Level Worked with the Joiner transformation using Normal Join, Master outer join, Detail Outer Join, and Full Outer Join Worked with Connected look-up and unconnected lookup and configured the same for implementing complex logic.

Experience

2-5 Years

Level

Executive

Education

Computer Science

Description :

1. Redesigned and created new ETL procedures to meet enhancement business requirements Scheduled and ad hoc reports using Cognos Report Studio and/or T-SQL to meet user requests.
2. Identified and resolved hot spot of E.piphany campaign BI using T-SQL and BCP. Analyzing and resolving resource conflicts between Crystal Report and Cognos.
3. Designed Mappings using Informatica Designer to load incrementally. Created re-usable transformations and applets. Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
4. Worked with Session Logs, and Workflow Logs for Error handling and Troubleshooting in the DEV environment Involved in Unit Testing, User Acceptance Testing (UAT) to check whether the data loads into the target are accurate, which was extracted from different source systems according to the user requirements.
5. Designed, built, tested, and maintained data pipeline and ELT/ETL process for structured, and semi-structured data.
6. Implemented MS SQL best practices involved with OLTP and Data warehouse environments.
7. Designed ETLs for data sources that can automatically run and reliably maintain data in the data warehouse.

Experience

2-5 Years

Level

Executive

Education

Computer Science

Description :

1. Redesigned and implemented EA's Pogo data warehouse, besides contributing to design and development of various phases of EA's Mobile business data warehouse.
2. Provided end-to-end view of the user behavior enabling business users to identify high value customers, enabling targeted campaigns and narrowing down on profitable marketing channels.
3. Provided game statistics and usages for the benefit of game development teams to enhance game features for future releases.
4. Completed redesign and data modeling of Pogo data warehouse, design inputs to Mobile data warehouse Business Requirements gathering from end users, analysis of various source systems, data profiling of source data ETL architecture including strategies to access source data from variety of source systems, eliminating pitfalls and points of failure in the previous architecture to ensure stability of the ETL on an ongoing basis.
5. Designed, Tested and Implemented of ETL programs using Informatica and batch/shell scripts.
6. Created and scheduled reports using Microstrategy Implementing Big Data environment on Hadoop for Mobile data.
7. Migrated and consolidated Informatica environments to reduce licensing costs Ongoing support and enhancements on newer business requests as needed.

Experience

2-5 Years

Level

Junior

Education

Bachelor's In IT

Description :

1. Worked as a member of the Information Technology (IT) department to implement and support the business systems for the Foundation by providing problem resolution, enhancement, and data implementation services to meet guest needs and business opportunities.
2. Implemented strategies for data acquisitions, archive recovery, and implementation of a database.
3. Acted as a technical liaison between Colonial Williamsburg business units, consultants, and vendors to contribute to the development and integration of technical solutions that are affordable and achieve business objectives.
4. Administered database systems to maintain health, performance, integrity, and security. Provided technical assistance in the implementation and integration of software infrastructure applications across Colonial Williamsburg.
5. Recommended ways to improve overall performance, reliability, and quality of the ELT/ETL process.
6. Optimized database performance using DMVs, execution plan, SQL profiler, and other SQL monitoring and debugging tools.
7. Researched opportunities for data acquisition and new uses for existing data. Remained current with development in data architecture, data analytics, and the data science industry.

Experience

2-5 Years

Level

Executive

Education

Bachelor's In IT

Description :

1. Reported help customers in promoting devices with higher service and usage uptake, enforce appropriate policies for better resource allocation and increase data utilization, enforce appropriate policies for better user experience and fair usage improving service offerings.
2. Extracted, Loaded and Transformed data into data mart Created standard filters, calculations, prompts, and conditions for reports Developed ETL mappings and workflows for source system's data extraction and data transformations.
3. Created derived tables and shortcut joins in designer to optimize the performance. Designed Database tables, created Packages by using Stored Procedures, Functions, Exceptions.
4. Generated reports using SQL procedures.  Logical and detail-oriented approach to work. Kept a strong client focus in executing all functions of the job. Communicated effectively and responds to internal emails and inquiries within reasonable timeframes.
5. Made improvements to the processes and scripts surrounding the data warehouse and ETLs as directed for performance, reliability and ease of maintenance.
6. Traced possible data discrepancies through any report/external logic, data transformations and the source of the data to identify the root cause of the issue.
7. Collaborated with stakeholders to ensure the established data definitions match their expectations.

Experience

2-5 Years

Level

Executive

Education

Bachelor's In IT

Description :

1. Collaborated with a greater engineering team in an agile environment. Managed tasks completely, including prioritization, working with stakeholders for design and specs, communicating status to all, completing the work, and documenting what you've done.
2. Participated in code reviews and daily interactions to ensure our warehouse meets our high standards.
3. Led in designing and revising data models for data warehouse, metadata, and data dictionaries across the enterprise.
4. Met and collaborated with business users on requirements and objectives. Led in reviewing and revising database designs and scripts on an ongoing basis.
5. Led in documenting meta-data about Data Warehouse Systems according to computer industry standards and knowledge of database management systems.
6. Managed data loads, security, storage, and performance strategies and implementations. Served as technical team lead in the development of business intelligence reports and analysis, providing mentoring, guidance, and troubleshooting to analysis team members in solving complex reporting and analytical problems.
7. Devised ER diagrams and identifies unique foreign keys, entities, attributes, relationships, and business rules for the data warehouse.

Experience

2-5 Years

Level

Executive

Education

Bachelor's In IT

Description :

1. Managed and created all Data Warehouse loads using SAP Business Objects and Microsoft SQL Server.
2. Developed new fact tables and dimensions for Data Warehouse. Develop and manage ETL processes.
3. Created reports using SAP Business Objects. Troubleshoot issues with data and reports. Work with business users to prioritize and complete all projects.
4. Analyzed, designed, and implemented clinical and claims data flows with emphasis on advanced care organizations and population health management.
5. Created Applications and automated processes using Visual Studio 2015, C#, and SQL Server tools.
6. Used Visual Studio, SSIS, SSAS, SSRS, and TFS to migrate a shared development server to a full-featured continuous integration environment including full-process instrumentation.
7. Designed, developed, and maintained data flows involving various data formats like file feeds, and XML feeds to Web Services.

Experience

2-5 Years

Level

Executive

Education

Bachelor's In IT