ETL Consultant Resume Samples

ETL Consultant will design the data storage systems for the company and test and troubleshoot it before it can go live. The major job duties typically seen on the ETL Consultant Resume are – creating and designing the data warehouse and related extraction; transforming and loading data functions, testing the design to ensure the smooth running of systems; analyze and design what is needed using the best ETL process and determining the best course of action.

The role requires someone with extensive technical knowledge and a good set of communication skills. To be considered for this role one must have a bachelor’s degree in computer science or information technology. Apart from education credentials, the applicant should also be technically capable of some common coding languages that are used in ETL development. Proficiency in data warehouse techniques such as ODS, EDW, ROLAP, and MOLAP is also mandatory.

ETL Consultant Resume example

ETL Consultant Resume

Headline : Over 2+ years of IT experience in ETL consulting with extensive ETL, BI, Data Warehousing, Web-based , Client/server, Healthcare domains experience. Extensive testing ETL experience using (Informatica PowerCenter (Source Analyzer, Warehouse Designer, Repository Admin console, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server) Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.

Skills : SQL, Coding, MS office.

Description :

    1. Anticipated to be many accounts focused on the hosting and management of Medicare Advantage plans on behalf of other Blues plans.
    2. Generated value for the enterprise by expanding its business nationally through partnership models with other organizations Validate the development items within the Center of Excellence for Arkansas.
    3. Worked on Business Areas- Risk Adjustment, Stars, Medical Management and DDDS ETL Consultant Roles and Responsibilities: Involved in writing Test plans, Test cases and responsible for executing the Test Scripts.
    4. Responsible for designing, developing test plans use cases and executing test scripts.
    5. Performed Smoke, Integration, Functional, Regression, and system testing.
    6. Involved in the complete life cycle (SDLC) of the project in Design, Development, Implementation, Testing and Support and Production Maintenance Assisted the Project Manager in developing project plans, estimating the testing efforts, tracking progress and analyzing workloads.
    7. Reviewed the entire application and develop requirements.
    8. Worked extensively with the users and with different levels of management to identify requirements, Use Cases and to Develop Functional Specifications.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Master's


Jr. ETL Consultant Resume

Objective : About 10 years of Data warehouse/ETL Experience including development and analysis. Highly Proficient in developing ETL and Data integration solutions using Informatica (Power Center /Power Exchange), Oracle, Netezza, and Sql Server. Expertise in Unix/Linux Shell Scripting ANSI SQL, Job Scheduler and database performance tuning.

Skills : Informatica, SQL, Unix, Data Warehousing.

Description :

    1. Involve in the design and development of the ETL feeds for the Data warehouse (DW) which in several Terabytes.
    2. Implement ICERTIS products and ensure it meets customer needs.
    3. Drive system configuration and deployment activities across multiple engagements.
    4. Build and foster internal consulting capability within the implementation team.
    5. Engage with the business team(s) to define solutions to address key implementation objectives.
    6. Conceptualize and formulate best of breed solutions in close collaboration with the business that effectively address key implementation objectives within the bounds of scope, schedule, and effort.
    7. Contribute to ICERTIS product road-map through active feedback from customers and implementation experience.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
MS


Sr. ETL Consultant Resume

Summary : Over 8+years of progressively responsible IT ETL Consultant experienced Professional with in-depth knowledge of system management, analysis, design, development, testing, production implementation and maintenance of the project. Extensive experience in Report Development/Administration, along with advanced SQL coding.

Skills : Sql Server, SSIS, SSRS, SSAS, Transact-SQL, PL/SQL, MySQL, Power View, MDX, DAX, Data Warehousing, Jd Edwards.

Description :

    1. Involved in designing and manufactures industrial gas turbines for on and offshore electrical power generation, for marine propulsion and for producing, processing and transporting natural gas and oil.
    2. Reported the Consolidation initiative, which supports the corporate strategic direction to consolidate geography data marts and to create a new capability for reporting with standard reports, definitions, and tools.
    3. Coordinated source data feeds to Data Warehouse; planning and implementing data integration processes for multiple source systems Study the existing source databases and interact with decision-makers for analyzing their business plans.
    4. Conducted user interviews to understand and document the current "as-is" systems flows and support processes, in an effort to design the future "to-be" processes.
    5. Conducted review sessions and code walkthroughs.
    6. Worked on creating staging Tables, Constraints, Indexes, and Views.
    7. Worked on creation of stored procedures, functions and packages.
    8. Created SQL scripts in for data validation.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Bachelor

ETL Consultant I Resume

Objective : A senior ETL Consultant Architect and senior administrator with very strong professional background in Data warehouse domain and over 11 years of industry experience in the software engineering, processes and methodologies, and management specializing in: Expertise and working experience in establishing the process, methodology standards at all phases of an Enterprise Data warehouse.

Skills : Sql Server, SSIS, SSRS, SSAS, Transact-SQL, PL/SQL, MySQL, Power View, MDX, DAX, Data Warehousing, Jd Edwards, Power BI, Power Pivot.

Description :

    1. Deliver business intelligence and data warehouse solutions for a diverse set of internal customers.
    2. Assist with reviewing and confirming the technical feasibility of integration development objects based on integration principals and best practices.
    3. Recommend solutions to address solution gaps and assist with estimate development.
    4. Develop of overall solution approach; design, develop, maintain and support ETL/ETL integrations; create technical documentation and build instructions to onsite and offsite global teams and assist with deploying and validating the technical solutions.
    5. Design and develop data warehouse platforms that conform to consistent methodologies, standards and industry best practices;
    6. Participate in designing an overall logical and physical data warehouse and data-mart data model and data architectures to support business requirements;
    7. Develop and maintain SQL, PL/SQL codes for Oracle database;
    8. Interface with integration and robotic process automation centers of excellence to ensure development follows standards;
    9. Supervise activities of consultants; mentor junior level solution designers and developers.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor

ETL Consultant II Resume

Headline : 7 Years of ETL Consultant experience in all phases of the Data Warehouse Lifecycle including Requirements Gathering, System Analysis, Design, Development, and Validation of Data Marts and Data warehouses using ETL, Data Modeling and Reporting tools. and extensive experience in Data Integration using SQL and ETL tool Informatica PowerCenter [] Experience in designing and developing ETL Solutions, Informatica Workflows to support operational management of data solutions and adhering the industry best practices.

Skills : Sql Server, SSIS, SSRS, SSAS, Transact-SQL, PL/SQL, MySQL.

Description :

    1. Created data model structure and ER modeling with all related entities and relationships with each entity based on the rules provided by the business manager.
    2. Analyzed the current architecture to propose an ETL design solution DWH and coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design and maintenance.
    3. Involved in understanding requirements and in modeling activities of the attributes identified from different source systems, which are in Oracle, Teradata.
    4. Data is Staged, Validated and finally loaded the data into Data Warehouse using Informatica.
    5. Used Type2 mapping to update a slowly changing dimension table to keep full history.
    6. Provided report delivery using standard subscriptions and URL access.
    7. Reviewed user requirements and prepared technical specifications.
    8. Implemented performance tuning and supported system transformation.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Certification

ETL Consultant III Resume

Summary : Over 8 years of ETL Consultant IT Experience in analysis, design, development, implementation and troubleshooting of Data warehouse/Data Services applications and nearly 6 years of Experience in Informatica Power Center , 3 years of Experience in Datastage and Talend.

Skills : ETL, Informatica, SSIS.

Description :

    1. Built environment which creating and supporting state of the art IT systems for public health.
    2. Responsible for developing Platform as a service for 13 states for AFIX implementation.
    3. Plans recommend and architects solutions around large data Business intelligence solutions for the Interoperability of Healthcare data.
    4. Implemented in the areas of coding, configuration and query writing of BI solutions.
    5. Played as administrator for setting up development environments for Talend, Jasper soft, Postgres for AFIX development and documenting install plan at client locations.
    6. Worked on Talend ETL for building ODS/OLAP tables and responsible for preparing mapping documents.
    7. Responsible for creating test data for reports demos.
    8. Responsible for deploying ETL code using GIT into multiple environments.
    9. Developed ODS/OLAP data model in Erwin and also created a source to target mapping documents.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
B.Tech

Asst. ETL Consultant Resume

Objective : 8+ years of ETL Consultant career reflecting experience in the field of Information Technology as a DataStage/ETL Developer in Enterprise Data Warehousing (EDW),

Skills : MS Office, Management, SQL Server.

Description :

    1. Lead solution design and be responsible for the quality, on-time delivery.
    2. Lead functional part of the work with specific software solution on consulting projects.
    3. Conduct functional requirements gathering and documentation.
    4. Coordinate with Senior Technical Consultant to ensure timely completion of technical requirements.
    5. Work on the reporting solution to generate reports.
    6. Work with specific software solution on consulting projects.
    7. Develop competencies in various SAS solutions
    8. Develop competencies in SAS programming and Data Integration
    9. Participate in solution design and reporting
    10. Provide requirements for data integration and ETL.
    11. Work with client business users and IT stakeholders to provide post-implementation maintenance and support.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor's

Associate ETL Consultant Resume

Headline : 7+ years of total IT ETL Consultant experience and strong background in Data Modeling, OLAP, ETL Design, Analysis, Development, Testing, Performance Tuning, Troubleshooting and error handling in the field of Data Warehousing in ! ETL process using ODI [] Experience with the entire Software Development Life Cycle SDLC viz.

Skills : MS Office, Coding, Organising.

Description :

    1. Involved in an ETL conversion project from Java this involves four teams, EDI, ETL, Java, and Gemstone respectively.
    2. Booked partners send booking requests either via Xml or through Pegasus (Java application).
    3. Requested XML from EDI is processed through ODI and loaded into EBOOK schema.
    4. Generated via ODI and sent it to the Gemstone team, which generated Booking confirmation XML in their OSCAR application.
    5. Processed confirmation XML from the queue and stored it in EDS schema to generate response XML to the EDI team.
    6. Analyzed requirements from Business Analysts and studied the existing functionality of the Java application.
    7. Designed and modeled the Request and Response schemas with the close coordination of the Data Modeler.
    8. Drafted the Technical specification documents along with the architecture diagram in Visio.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Lead ETL Consultant Resume

Summary : 8+ years of experience in Information Technology including Data Warehouse/Data Mart development using ETL/ Informatica Power Center. Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.

Skills : Management, Coding.

Description :

    1. Holds company with primary businesses that include deposit, credit, trust and investment services.
    2. Builds a Data warehouse for operational and strategic reporting (MODS).
    3. Designs develop and maintain an enterprise data warehouse.
    4. Integrates different source systems and Emerging Markets into a homogeneous environment to build Enterprise Data Warehouse.
    5. Interacts with Business Analysts to understand the requirements.
    6. Analyzes the requirements and preparing design.
    7. Involves in ETL designing and coding.
    8. Loads data from Oracle database, SQL Server and Flat files to Teradata Data Warehouse.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Bachelor

ETL Consultant Resume

Headline : ETL Consultant responsible for creating, enhancing and troubleshooting Reports in both Active Reports and BI Publisher as well as help support the development team in their support of the agency's custom SOA based web applications using the technologies mentioned above, as well as ETL utilities, scripts and SQL stored procedures.

Skills : Development, Management.

Description :

    1. Leads design and development efforts, as well as system configuration and development, unit testing, and ETL / BI testing efforts.
    2. Manages defects and change requests.
    3. Leads ETL and BI workshops and discussions.
    4. Responsible for status meetings and status reporting.
    5. Responsible for project delivery, risk, and issue resolution management.
    6. Participates in proposal response for technical areas.
    7. Strives to constantly improve the application development and maintenance processes and tools.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelor