Emile E.

Emile E.

ETL Test lead

East Brunswick , United States

Experience: 15 Years

Emile

East Brunswick , United States

ETL Test lead

115200 USD / Year

  • Immediate: Available

15 Years

Now you can Instantly Chat with Emile!

About Me

ETL Test lead

  • Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentations in ALM.

  • Invloved in business requirements gathering and understandin...

  • Invloved in business requirements gathering and understanding them from a data perspective.

  • Performed back end testing on Ambari Hadoop by writing HQL quires.

  • Performed back end testing on Ambari Hadoop by writing Pig Scripts.

  • Strong ability in developing advanced HQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements, including identifying the tables and columns from which data is extracted.

  • Writing Pig scripts to implement/automate complex testing strategy

  • Proficient in Informatica power center.

Show More

Positions

Portfolio Projects

ETL Test lead

Company

ETL Test lead

Description

  • Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentations in ALM.
  • Invloved in business requirements gathering and understanding them from a data perspective.
  • Performed back end testing on Ambari Hadoop by writing HQL quires.
  • Performed back end testing on Ambari Hadoop by writing Pig Scripts.
  • Strong ability in developing advanced HQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements, including identifying the tables and columns from which data is extracted.
  • Writing Pig scripts to implement/automate complex testing strategy
  • Proficient in Informatica power center.

Show More Show Less

Skills

Hadoop

Tools

Informatica

Sr. DWH/ ETL tester

Company

Sr. DWH/ ETL tester

Description

Roles & Responsibilities.

  • Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentations in TFS.
  • Performed back-end testing on the DB2 database by writing SQL queries.
  • Prepared ETL test data using TOAD for both positive and negative scenarios
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
  • Performed back-end testing on the SQL server database by writing SQL queries.
  • Prepared ETL test data using Excel and for both positive and negative scenarios
  • Written Complex SQL queries to validate the data conditions for ETL.
  • Verified that data is transformed correctly per various business requirements and rules.
  • Verified that all Reports/Dashboards are presenting proper data/information per specified requirements and user access permission.
  • Writing complex SQL queries for data validation, verifying SSIS Packages

Proficient in Informatica PowerCenter Client Tools.

Show More Show Less

Tools

ETL

SR. Support Analyst for Clinical Data Software

Company

SR. Support Analyst for Clinical Data Software

Description

Tested ERT’s EDC, EDMD, and EDMR applications.

  • Created SQL queries to correct the data in the clinical table.
  • Helped clients with their edit checks and consistency checks coding.
  • Identified and documented work orders for developers to ensure a timely repair.
  • Performed back-end testing using Toad
  • Verified resolved work orders each new release
  • Wrote PL/SQL scripts to implement/automate complex testing strategy

Identified and document defect reports to developers to ensure a timely defect repair

Show More Show Less

Skills

SQL

Tools

Pl/sql

QA Analyst/Programmer

Company

QA Analyst/Programmer

Description

Handled back-end testing for new and enhanced web applications, API testing using JAVA 1.5 and installation testing for IBI’s report caster.

  • Developed detailed test cases, scripts and scenarios for newly developed or enhanced web functionality.

Confirmed that the delivered software met customer expectations in concepts as well as function.

Show More Show Less

Tools

java

Tech Support Analyst

Company

Tech Support Analyst

Description

Provided tech support to internal clients.

  • Created service tickets for tier three engineers.
  • Installed and configured customers’ home networks

Show More Show Less

Tools

Windows 10

QA Analyst/Programmer for Web MD

Company

QA Analyst/Programmer for Web MD

Description

Responsible for meeting customer expectations through the analysis of customer business requirements.

  • Created data driven test using WinRunner.
  • Performed functional and regression testing for new and enhanced web applications.
  • Performed functionality testing, system testing, integration testing, regression testing, data flow tests and GUI testing for new and enhanced web applications to ensure coding completeness and accuracy

Show More Show Less

Skills

Load Runner

Tools

Guidewire

Data Analyst/Programmer

Company

Data Analyst/Programmer

Description

Created automated test programs using Winrunner and Team test. Tested Oracle applications CAI Interface with Clear Cross’s GLS (Export Trade Management system). Designed, implemented and maintained test plans in Client/Server and Internet applications.

  • Performed back-end testing using SQL Plus.
  • Created Korn Shell scripts to test SAP interface with Clear Cross’s GLS export trade management system. Tested multiple SAP interfaces to and from systems

Show More Show Less

Skills

Oracle

Tools

shell script

ETL Test Lead

Company

ETL Test Lead

Description

New York Life, Clinton ,NJ 05/2018 to Present

ETL Test lead

  • Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentations in ALM.

  • Invloved in business requirements gathering and understanding them from a data perspective.

  • Performed back end testing on Ambari Hadoop by writing HQL quires.

  • Performed back end testing on Ambari Hadoop by writing Pig Scripts.

  • Strong ability in developing advanced HQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements, including identifying the tables and columns from which data is extracted.

  • Writing Pig scripts to implement/automate complex testing strategy

  • Proficient in Informatica power center.

Show More Show Less

Skills

Hadoop

Tools

Toad