Data Engineer with Python

at Mastech Digital
Location Glendale, AZ
Date Posted May 17, 2020
Category Default
Job Type Full-time
Contractor

Description

Mastech Digital provides digital and mainstream technology staff as well as Digital Transformation Services for leading American Corporations. We are currently seeking a Data Engineer with Python for our client in the IT-Services domain. We value our professionals, providing comprehensive benefits, exciting challenges, and the opportunity for growth. This is a Contract position and the client is looking for someone to start immediately.

Duration: 8+ Months Contract

Location: Glendale, AZ

Role: Data Engineer with Python

Primary Skills: Python

Role Description: The Data Engineer with Python would need to have at least 8+ years of experience. In this role as the Data Integration Developer, you will be responsible for the design, build, and deployment of the project's data integration component. 

You will design, analyze modify, debug and evaluate complex programs for application areas. You will provide continuous software application evolution to drive and enable greater business value and increased productivity through more-rapid delivery of high-quality applications. You will be responsible for cost-effective delivery of software applications, including the optimal selection of implementation technologies, practices and skills for application delivery success.

You will -  

• Receive no instruction on routine work and general instructions on new projects or assignments.

• Design, code, modifies, debugs and evaluates programs for business functional areas. 

• Formulates logic for new systems, devises logic procedures, prepares flowcharting, and data analysis through the application of professional programming concepts. 

• Codes, tests and delivers application enhancements and project build deliverables. 

• Determines how existing complex applications, legacy systems, databases, Web interfaces and/or hardware logic, which may be currently operating on multiple platforms, work together to meet the new and emerging enterprise requirements.

• Develops methods to efficiently reuse existing components. 

• Recommends and implements changes in development, maintenance and system standards. 

• Holds and participates in code walkthroughs to ensure that all code is production ready and complies with all standards including but not limited to: architectural, PCI, Model Audit Rule and internal audit standards. 

• Develops design specifications and parameters for assigned applications or components of larger integrated solutions that are in compliance with products' architectural blueprints.

• Ensures that code is to set quality standards including: SDLC, Architecture, PCI compliance, Model Audit Rule compliance and internal audit guidelines. 

• Develops complex test plans in conjunction with the Q/A Lead. 

• Reviews results of testing. 

• Develops fixes for bugs discovered. 

• Develops conversion and system implementation plans. 

• Gathers, analyzes, prepares and summarizes recommendations for approval of system and programming documentation. 

• May assist in development of product user manuals 

• Participates in component and data architecture design, software product evaluation and buy vs. build recommendations for moderate to high complexity solutions. 

Work in an office environment sitting at a desk, table or computer workstation for long periods of time. May travel by car, plane or other forms of transportation to attend business meetings or conferences. Approximately 50-80 percent of time spent on the job involves the use of a personal computer.

Responsibilities:

• Works closely with the business and IT teams to create scalable data integrations processes.

• Designs, builds and maintains data integration processes in development, QA and production.

• Design, build and maintain Extract Transform & Load (ETL) processes and design data models.

• Works with System owners to resolve source data issues and refine transformation rules. 

• Ensures performance metrics are met and tracked.

• Performs data analysis for both Source and Target tables/columns.

• Provides technical documentation of Source and Target mappings.

• Supports the development and design of the internal data integration frame work. 

• Participates in design and development reviews.

• Works with System owners to resolve source data issues and refine transformation rules. 

• Ensures performance metrics are met and tracked.

• Writes and maintains unit tests.

• Conduct QA Reviews. 

• Works with data modelers & DBAs in implementing the dimensional & 3NF Physical data models for Insurance data warehouse.

• Contribute to collaborative, multi-disciplinary project team efforts in an agile environment.

Knowledge, Skills & Abilities:

Required:

• Bachelor's degree in related area (Computer Science, Information Systems, Engineering) or an equivalent combination of education and experience.

• 8+ years Design, testing and applications development experience of processes for Data Warehouse and Data Integration.

• Experience in creating extracting and transformation data using Python. 

• Experience in using Informatica or other ETL tools. 

• Experience in different AWS Cloud services such as S3, AWS EC2. 

• Experience in loading data and analytics in Snowflake. 

• Experience in Rest and SOAP API connections and data integrations using APIs.

• Familiar ODI or OIC data integration tools. 

• Familiar with Kafka Queues and event base integrations. 

• Familiarity in extracting data from and to flat file and relational data sources.

• Highly proficient in handling large volumes of data in Insurance and Financial domains

• Skilled with tuning data pipeline, identifying and resolving performance bottlenecks in various levels.

• Experience in SQL and NoSQL databases.   

• Practiced in data profiling and data quality assurance with ETL tools. 

• Experience in writing Shell Scripting 

• Proficient in creating and writing technical documentation 

• System Knowledge - Understands business and customer requirements that drive the analysis and design of technical solutions.

• Excellent communication skills, highly motivated, ability to work independently and in a team.

• At ease in high stress environments requiring superior ability to effectively handle multi-task levels of responsibility.

Preferred:

• Understanding of industry practices and AAA NCNU policies and procedures relating to work assignments.

• Strong background in working with data warehouses and data marts based on the IIA-IIW insurance framework.

• Knowledge of Enterprise Application Integration EAI methodologies.

Education: Bachelor’s degree in Computer Science, Electrical/Electronic Engineering, Information Technology or another related field or Equivalent.

Experience: Minimum 8+ years

Relocation: This position will not cover relocation expenses

Travel: No

Local Preferred: Yes

Recruiter Name: Neha Malav

Recruiter Phone: 877-884-8834 (Ext: 2202)

Equal Employment Opportunity

Only registered members can apply for jobs.