ETL Architect Resume Samples

Description :

1. Driven application T2 (Traction) for incident management and tracking actions raised against incidents.
2. Captured in T2 application will be analyzed by S&OR analysts by retrieving data in reports.
3. Responsible for data is presented to users in terms of the dashboard, standard reports, and Search & Save and Ad hoc reports.
4. Built to feed data to the dashboard.
5. Understood and analyzed the ETL requirements from the business.
6. Developed the Datamart dimension model.
7. Created ETL TDD (Technical design doc).
8. Planned to configure, and deploy code in various environments.

Experience

7-10 Years

Level

Management

Education

Bachelor's

Description :

1. Integrated Procurement Environment (IPE) Kroger is a retail giant in the USA.
2. Responsible for various departments inside the organization for procuring various goods that would be sold.
3. Used different formats for storing procurement related data.
4. Dealt with this and integrated data cross all formats for a unified data format.
5. Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
6. Worked on data analysis to find the data duplication and existed data pattern using a data profiling tool, IDE.
7. Generated few complex business-reports/graphs using IDQ, which was being used for understanding, acting and reporting.
8. Extensively worked on column profiling, scorecard and address validators.
9. Responsible for Business Analysis and Requirements Collection.

Experience

10+ Years

Level

Senior

Education

B. Tech.

Description :

1. Completed one major development related to RBS within 4 months.
2. Created and altered metadata, creating the Database design for new enhancement, creating and altering mappings, testing and deployment.
3. Created and testing deployment scripts.
4. Worked on RBS development, worked regularly on support calls to debug, change, test and implement complex pl/sql code.
5. Automated the whole reconciliation process.
6. Identified major issues in existing MIS system, like too many measures/metrics in a fact, wrong hierarchy in levels of Dimensions, too many unwanted layers of L's and T's in ETL, mismanaged and inconsistent surrogate keys in those layers of L's and T's.
7. Created the business case for the new MIS2 project.

Experience

2-5 Years

Level

Junior

Education

Certification

Description :

1. Worked with Enterprise Architecture Team to find the gaps in Actimize system from approach that meet overall enterprise architecture requirements.
2. Led and mentored the efforts of data quality completeness initiative for Informatica based ETL architecture.
3. Performed deep assessment of the Actimize system in order to find whether ETL best practices were followed or not and submitted the recommendations of improvement.
4. Designed architecture solutions for Hornet Data warehouse requirements to develop ETL solution.
5. Initiated Design of ETL architecture solution from already existing ETL processes which are required to be analyzed as a part of the quality assessments.
6. Evaluated current data warehouse/ETL environment for usage in spend analytics solution deployment and provide gap assessment.
7. Responsible for ETL Database into Physical Data Models using ER/ Studio Tool.

Experience

2-5 Years

Level

Junior

Education

Master's

Description :

1. Helped Avago business users in multiple ways to analyze the business critical scenarios.
2. Enabled out of box OBIA Finance and SCOM (supply chain and Order Management) reports To accommodate the growing number of business users and their analytics requirements, Wipro has decided to send a key profile with Techno-Business background from India.
3. Experienced in Informatica-OBIEE and required business function knowledge, an employee can help to accelerate the project requirement gathering and analysis and to deliver the project on time.
4. Implemented OPLA(Project Life Cycle Analytics) package for Product life cycle management user.
5. Developed customized report based on OPLA package Responsibility.
6. Worked as ETL architect and Data warehousing architect in this project 2.
7. Worked with business user to define requirements.

Experience

2-5 Years

Level

Junior

Education

Bachelor's

Description :

1. Helps financial services firms mitigate reputational, internal and regulatory risks.
2. Responsible for the data to this application is fed from clearing firms like NFS, DTCC and Pershing after transforming the data using ETL.
3. Consolidates the different clearing firms and build a Broker-Dealer Warehouse (BDW) and data marts.
4. Sanitizes the data in non-prod environments using prod data for all the application testing in non-prod environments.
5. Responsible for architectural design of ETLs, different ETL load patterns and complex mappings to load the data.
6. Develops solution in highly demanding environment and provide hands-on guidance to other team members.
7. Designs, develops, and implements interactive visualizations by processing and analyzing large datasets.
8. Designs and builds new data aggregations for ongoing data analysis and statistical modeling.

Experience

7-10 Years

Level

Management

Education

Bachelors

Description :

1. Worked with the business analysts to understand the functional requirements and transformed them into high level technical requirements and performed feasibility analysis.
2. Provided solutions to the architectural problems with the data integration into the system and provided guidance on the data model adjustments and enhancements.
3. Involved in analysis, design and development of the database and ETL solutions.
4. Developed technical specifications that included Flow Diagrams and Process flows.
5. Documented the requirement changes and technical design changes as required and discussed with management on the proposed changes.
6. Worked on performance optimization to reduce the time taken for loading.
7. Handled 5 member team for sap-Edw integration project and 3 member team for price catalog project.

Experience

2-5 Years

Level

Junior

Education

Masters

Description :

1. Analyzes, assesses, documents and designs scalable and sustainable data architecture and data transformation processes within a large analytics pipeline

2. Works with stakeholders to understand the limitations and constraints of current data architecture (models, transformations, pipelines).

3. Designs, develops and maintains analytics data model

4. Develops subject matter expertise in both the data and the process/analytic domains

5. Oversees or reviews the implementation of improvements to the data architecture, providing feedback and guidance to product developers, data scientists, and product owners.

6. Facilitates design discussions and assist with decision making & guidance during development.

7. Responsible for overall etl design and implementation - define and maintain environments, coding standards and migrations, data movement strategies from source through the data warehouse.

Experience

5-7 Years

Level

Executive

Education

Bachelors

Description :

1. Created Dts packages to load large cubes and create incremental laod jobs.
2. Automation of error reporting and building of validation systems.
3. sp Optimization and code review AAAE (American Association of Airport Executives), Washington, DC ETL Architect AAAE: AAAE is the Association for all airports of US and IAEE is the association of all Airports of the world.
4. The AMIS application takes care of the reporting needs of AAAE.
5. AMIS takes data from transactional systems and reports on membership data across different dimensions like Airports, regions, Managers, time and also membership type.
6. Developed the DTS jobs which took data from the different systems like the Solomon transactional system, the billing system and the membership system and created the staging dimension and fact tables.
7. Besides the development responsibilities I also handled the responsibilities for providing production support to the AMIS application, maintaining security for the AMIS production server and also configuring and maintaining database maintenance plans.
8. Re-indexing databases and running DBCC checks.
9. Defined and developed a database backup and restore plan, a disaster recovery plan.

Experience

0-2 Years

Level

Entry Level

Education

Engineering

Description :

1. Creates and enhances data solutions enabling seamless delivery of data and is responsible for collecting, parsing, managing and analyzing large sets of data across different domains for analysis.
2. Uses different Data warehousing concepts to build a Data warehouse for internal departments of the organization.
3. Designs and develops data pipelines, data ingestion and ETL processes that are scalable, repeatable and secure for stakeholder needs.
4. Builds Data architecture to support data management strategies to support business intelligence efforts for various stakeholders.
5. Leads the design of the logical data model and implements the physical database structure and constructs and implements operational data stores and data marts.
6. Supports deployed data applications and analytical models by being a trusted advisor to Data Scientists and other data consumers by identifying data problems and guiding issue resolution Data Pipeline Management.
7. Develops real-time and batch ETL data processes aligned with business needs, manages and augments data pipeline from raw OLTP databases to data solution structures.

Experience

0-2 Years

Level

Entry Level

Education

Engineering