ETL Developer

Mastech Digital, Inc. Cleveland , OH 44114

Posted 7 days ago

Location:Cleveland, OHJob Code:186415Posted:Mar 12, 2019Description:

Mastech Digital provides digital and mainstream technology staff as well as Digital Transformation Services for leading American Corporations. We are currently seeking an ETL Developer for our client in the Banking domain. We value our professionals, providing comprehensive benefits, exciting challenges, and the opportunity for growth. This is a Permanent position and the client is looking for someone to start immediately.

Duration: Full-time

Location: Cleveland, OH

Compensation: Market Rates

Role: ETL Developer

Primary Skills:
ETL

Role Description: The ETL Developer would need to have at least 6+ years of experience. In this role as the Informatica ETL Developer, you will be responsible for development, testing, documenting, and explaining the data movement processes within the context of a data warehouse.

You will also work closely and cooperatively with business users (i.e., non-technical subject matter experts) and technical team members. You will use modern tools and standards when documenting business rules, data models and data flows.

Responsibilities:

  • Interact with the Development Lead, Solution Architect, and other Team Members to understand business requirements and provide expert knowledge by ensuring delivery of business needs in a timely and cost-effective manner.

  • Conduct analysis and is also involved in designing, programming and testing.

  • Assist in developing project plans and cost estimations.

  • Data collection, data staging, data movement, data quality and archiving strategies.

  • Provide end-user support including business queries and requests.

  • Provides reviews of the deliverables and identifies gaps and areas of improvement.

  • Plans and conducts ETL Unit and development tests.

  • Fulfill and design the development for logical data models as well as physical data models.

Required Skills:

  • Proficient in Informatica, with a good knowledge of ETL development

  • Familiarity with data warehousing

  • Familiarity with database stored procedures

  • Expert SQL skills

  • Able to put forward ideas for consideration and work toward irrespective of whether your ideas are adopted

  • Must have excellent problem-solving skills, and work cooperatively and collaboratively to bring issues to successful resolution

  • Very detailed oriented and quality focused; able to follow clear methodologies for troubleshooting and development

Nice to Have Skills:

  • Familiarity with Microsoft SQL Server

  • Familiarity with Teradata

  • Familiarity with Oracle

  • Familiarity with Agile development

Skill Set:

  • 6 and above years of design, develop, monitor, and performance tune database tables, views, indexes, stored procedures and functions experience
  • Advanced
  • 6 and above years of ETL Tool (Informatica) experience
  • Advanced
  • 6 and above years of SQL experience
  • Advanced
  • 1 and above years of Teradata experience
  • Basic

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

Experience: Minimum 6+ years

Relocation: This position will cover relocation expenses

Travel: N/A

Local Preferred: Yes

Recruiter Name: Abdul Ashim

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

Equal Employment Opportunity


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
ETL Developer

Onpoint Consulting, Inc

Posted 2 weeks ago

VIEW JOBS 2/28/2019 12:00:00 AM 2019-05-29T00:00 OnPoint , a wholly-owned subsidiary of Sapient Government Services, is a vibrant, energetic, and growing ISO-certified technology and management consulting partner that provides critical thinking, strategic analysis, and thought leadership in a collaborative environment in an enduring effort to improve performance, lower costs, and achieve results for clients. We are guided by our principles: Clarity. Action. Results—for each client engagement we work to gain clarity, move into action, and achieve results. OnPoint specializes in delivering solutions in Information Assurance, Network Operations, Project Management and Systems Development. JOB DESCRIPTION Summary/Objective OnPoint has an opening for an ETL Developer to join the Dept. of State Enterprise Reporting contract. This position will be located in the Ballston area. Essential Functions The Extract, Transform, and Load (ETL) Developer with ETLs tool and Oracle PL/SQL knowledge, will support a large enterprise reporting team. Large volume, complex transactional data stores must be transformed to support high-performance business intelligence applications via dimensional models. Analysis and design of source to target requirements required. Competencies Develop and document data requirements from business requirements Perform source system data analysis to understand data relationships and quality Design and document logical and physical data models in data modeling tool Generate Data Definition Language (DDL) scripts from modeling tool Design and document source to target data mappings Design, develop, and test ETL routines Design, develop, and test SAP HANA calculation views Participate in data team peer reviews Provide content for data related software development lifecycle documentation Provide ad hoc query support for ad hoc query requests Participate in program, project, and functional team meetings Provide timely and accurate input for status reporting Work Environment Business Casual/Gov Site Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently is required to stand; walk; use hands to finger, handle or feel; and reach with hands and arms. Position Type/Expected Hours of Work Monday-Friday Travel Some local travel may be required Required Education and Experience Education: Bachelor's degree required or equivalent experience Security clearance: Active Secret or Top-Secret Some travel may be required within the Metro DC area 5+ years of experience working with complex data warehouse projects 3+ years of experience designing ETL processes to populate the data warehouse preferably with a COTS ETL tool Additional Eligibility Qualifications Experience with SAP BusinessObjects Data Services ETL tool Experience with SAP HANA Experience with SAP BusinessObjects Business Intelligence tool suite Experience participating in end user and technical requirement sessions Prior experience with Department of State systems and/or processes a plus Work Authorization/Security Clearance Candidates must have at least an active Secret clearance. Ability to obtain a Top Secret clearance is desired. AAP/EEO Statement As part of our dedication to an inclusive and diverse workforce, OnPoint is committed to Equal Employment Opportunity without regard for race, color, national origin, ethnicity, gender, protected veteran status, disability, sexual orientation, gender identity, or religion. We are also committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or an accommodation due to a disability, you may contact us at hr@onpointcorp.com or you may call us at 703-841-5500. Onpoint Consulting, Inc Cleveland OH

ETL Developer

Mastech Digital, Inc.