Lead Consultant - U.S. Recruitment and Hiring Specialist.
Mastech Digital Inc. (NYSE : MHH) is a minority-owned, publicly traded IT staffing and digital transformation services company. Headquartered in Pittsburgh, PA, and established in 1986, we serve clients nationwide through 11 U.S. offices.
Location : Westalke, TX
Duration : Full-Tme / W2
Job Description :
This role will be working in a newly formed squad created to untangle the data requirements related to the way we pays its advisors and wholesalers. Very important work and the highest executive visibility.
MUST HAVES :
- Strong SQL for querying and data validation
- Oracle
- AWS
- ETL experience with Java SpringBatch (for the ETL data transformation).
Note :
The ETL work is done in Java (so Python is only a nice to have). Must have Java for ETL which makes this role difficult to source on.PythonSnowflakeAlso note : Informatica ETL experience is not helpful at all to us in this role. Its fine if someone has it, but the experience we need is on the Java ETL side.
The Expertise and Skills You Bring
Bachelor's or Master's Degree in a technology related field (e.g. Engineering, Computer Science, etc.) required with 5+ years of working experience4+ years of Java development utilizing Spring frameworks. Experience writing batch jobs with Spring Batch is a must2+ years of experience developing applications that run in AWS, with focus on AWS Batch, S3, IAM3+ years working with SQL (ANSI SQL, Oracle, Snowflake)2+ years of Python developmentExperience with Unix shell scripting (bash, ksh) and scheduling / orchestration tools (Control-M)Strong data modeling skills with experience working with 3NF and Star Schema data modelsProven data analysis skills; not afraid to work in a complex data ecosystemHands-on experience on SQL query optimization and tuning to improve performance is desirableExperience with DevOps, Continuous Integration and Continuous Delivery (Jenkins, Terraform, CloudFormation)Experience in Agile methodologies (Kanban and SCRUM)Experience building and deploying containerized applications using DockerWork experience in the financial services industry is a plusProven track record to handle ambiguity and work in a fast-paced environment, either independently or in a collaborative mannerGood interpersonal skills to work with multiple teams within the business unit and across the organizationSeniority level
Mid-Senior levelEmployment type
Full-timeJob function
Information TechnologyIT Services and IT Consulting, Banking, and Financial ServicesBenefits
Medical insuranceVision insuranceDisability insurance#J-18808-Ljbffr