ETL Consultant Resume Samples

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.

Experience

5-7 Years

Level

Executive

Education

Master's

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.

Experience

2-5 Years

Level

Junior

Education

MS

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.

Experience

10+ Years

Level

Senior

Education

Bachelor

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.

Experience

2-5 Years

Level

Junior

Education

Bachelor

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.

Experience

5-7 Years

Level

Executive

Education

Certification

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.

Experience

7-10 Years

Level

Management

Education

B.Tech

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.

Experience

2-5 Years

Level

Junior

Education

Bachelor's

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.

Experience

5-7 Years

Level

Executive

Education

Bachelors

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.

Experience

10+ Years

Level

Senior

Education

Bachelor

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.

Experience

5-7 Years

Level

Executive

Education

Bachelor