Qa Tester, Etl And Mediation Zone Developer Resume
Miami, FloridA
SUMMARY:
- Confidential is a graduated Engineer in Automation and IT professional with more than 3 years of experience working in Telecom domain.
- She is specialized on SQL, Amazon Redshift, Informatica and Mediation Zone.
- Confidential is a team player with good problems - solving skills and fast learning abilities used to fulfill strict deadlines.
TECHNICAL SKILLS:
Programming/Languages: Python, C/C++, java, Pig, SQL, Shell scripting
Databases: AWS-Redshift, MS SQL Server, PostgreSQL
Cloud: AWS/EMR/EC2/S3/Data Pipeline, Informatica Cloud
MapReduce: Pig-Python
Tools: Jenkins, GIT-Putty, Hue, Mediation zone, Aginity
Business Intelligence: Tableau/ Excel
Version Control: Stash, Bitbucket
Scrum methodology: Testing & QA, FPGA Design, Knowledge of microcontrollers Analog Electronics Instrumentation
Hardware tools: Proteus, Labview, Matlab, Altera, MPLAB, PIC C VHDL, Assembly Language
Office Tools: MS Word, Excel, PowerPoint, Outlook
Operating Systems: Windows 7/Vista/Server 2008/ Windows 8/Linux
PROFESSIONAL EXPERIENCE:
Confidential, Miami, Florida
QA tester, ETL and mediation zone developer
Responsibilities:
- Troubleshooting and escalating data related issues and validating data to improve data quality.
- Keep defect log and tracking up to date.
- Create Dbfit pages for automated regression and comprehensive tests.
- As a Lead developer of the mediation team I manage the priorities of the assigned tasks to the team.
- Create workflows using Mediation Zone tool to adapt the sources files to the Amazon Redshift format.
- In charged of mediation zone server and scheduling workflows, manage permissions to different level of users.
- Develop ETL workflows using Informatica Cloud (S3 to Redshift).
- Develop data ingestion procedure using Pig/MapReduce and python also EMR in AWS Data Pipeline as part of the ETL process.
- Define the source to target data mappings, business rules and data definitions based on data dictionaries.
- Write shell scripts in UNIX to fix special characters not supported by AWS-Redshift and change files format.
- Work with T-SQL to create queries, tables, user functions, views, indexes, user profiles, and maintaining data integrity
- Preparing the technical documents (like incoming data format standards document, data dictionaries, etc.) for each new source.
- Use of Airflow tool to automate the ETL process.
- Support the production jobs.
Confidential
Researcher and electronic designer
Responsibilities:
- Design a LED lighting signage for indication of good contact in the defibrillator paddles, and the ready charge indication.
- Development protocol for two indications using only one wire to turn on the ready charge LEDs indicators and impedance indicators.
- Selection of the microcontroller to be used for the design.
- Development of a circuit design and programming of the selected microcontroller.
- The study was performed in the impedance measurement to guarantee good contact between the patient and the defibrillator paddles.
Confidential
Engineer intern
Responsibilities:
- Implementation for the design of a parallel USB adapter.
- Design and implementation of a parallel USB adapter.
- Selection of the microcontroller to be used for the design.
- Development of a circuit design and programming of the selected microcontroller.
- Development of an application programmed in C ++ to test this adapter.
Confidential
Engineer intern
Responsibilities:
- Design and implementation of the weather station in terminals at the airport. Design of a data acquisition system for collecting the measurements.
- Programming of the microcontroller.
- Implementation of a dashboard desktop application using Labview, python and MySQL Server .