Data Engineer jobs

Lead ETL Developer Informatica

Atria Group LLC (agency)Dallas, TXContract7+ years experience

Pay not listed

2 things to check before you apply.

On Atria Group LLC’s own careers site (SmartRecruiters), checked open today.

  • To check: Posted by the employer 12 years agoLong-open jobs are sometimes already filled. Ask when they plan to hire.
  • To check: No pay range listedAsk for the pay range before you interview.
  • Checked: On the company's own careers siteSmartRecruiters board
  • Checked: Checked open todaySmartRecruiters board
  • Checked: No reposts foundSmartRecruiters board
  • Trust score 60 / 100 · Check details
See all 6 checksShow fewer
How we check

What you’ll do

  • Develop Informatica ETL routines and mappings for OLTP and BI systems, including facts and SCD1/2 dimensions.
  • Create test cases and scripts, test ETL jobs, and validate data against integration and transformation requirements.
  • Reconcile source and target data, investigate rejects, and profile data to identify business-rule or database-integrity issues.
  • Schedule ETL jobs and use scripts to maintain the correct data-flow sequence.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • Around 7–8 years of experience in the listed work areas
  • ETL development using Informatica 9.1/9.5, including detailed knowledge of its features for data transformation
  • Experience with data warehousing and data migration projects involving large-scale data transformation
  • Knowledge of ETL development procedures
  • Experience tuning ETL mappings for performance
  • Knowledge of SDLC and quality processes for data integration projects, including preparing and reviewing test plans, test cases, and test scripts

Education

  • BS

Skills

  • Knowledge of data profiling techniques using SQL and an ETL tool
  • Extremely good SQL skills
  • Very good knowledge of database structures and systems, and proficiency writing complex SQL routines
  • Knowledge of ETL schedulers and basic Unix shell scripting

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Full job description

From Atria Group LLC’s careers site

Company Description

Job Description

Lead ETL Developer Informatica

Job Description:

Show full descriptionShow less

This position is responsible for solving data integration challenges using Informatica as the data integration platform. He/she will be involved in understanding the data integration and transformational requirements as laid by the business requirement / data architect and convert those into ETL routines using Informatica. He/She would be responsible for the development of routines, preparing test cases and testing the ETL jobs for the data validation. He/she will be responsible for checking the accuracy of the mappings through reconciling the source, target systems and any rejects. Should provide guidance to the junior members of the team.

Primary Responsibilities:

  • Develop ETL routines with Informatica 9.1/9.5
  • Develop test cases for the ETL mappings and prepare test scripts in line with the data integration/transformation requirements
  • To script SQL queries in the source and target system in order to ensure data validation/data reconciliation
  • Develop ETL routines for OLTP and BI systems and develop mappings for facts and scd1/2 dimensions
  • Profile the data with tool and SQL queries to identify the data which does not conform to business rule and database integrity
  • Scheduling of the ETL jobs through scheduler and scripts to ensure the correct data flow sequence
  • Performance tuning of the mapping as per the batch load timings

Requirements for position:

Education: BS

Around 7-8 years of experience in following work areas:

  • ETL development using Informatica 9.1/9.5 and detailed knowledge of different features of the tool to handle data transformation requirement
  • Should have worked in data warehousing and data migration project with large scale data transformation, knowledge of ETL development procedures
  • Knowledge of data profiling techniques for data analysis using SQL and ETL tool
  • Extremely good at SQL
  • Very good knowledge of the database structures/systems and proficient in writing complex SQL routines
  • Experience of performance tuning of ETL mappings
  • Knowledge of ETL schedulers and basic knowledge of Unix shell scripting
  • Knowledge of SDLC and quality processes to be followed in a data integration project – prepare test plan , test cases and test scripts and reviews

Additional Information

Apply today!

Something wrong with this job? Report it · This flag looks wrong

Similar jobs nearby

Data Engineer

Royal Electric · Dallas, TX

$93k–$119k/yrFull-time

StrongLast seen open yesterdayPosted 1 month ago

Data Engineer

Texas Instruments · Dallas, TX

Pay not listedOn-site

Looks good2 to checkChecked open todayPosted 4 months ago

Data Architect

Inspire11 · Dallas, TX +1 place

$10,000/moOn-site

Looks goodOpen 9 monthsChecked open todayPosted 9 months ago

Principal Data Engineer

CG Infinity · Houston, TX +1 place

Full-time

StrongPay not listedChecked open todayPosted 20 days ago

Senior Data Engineer

Cetera Financial Group · Dallas, TX

StrongPay not listedChecked open todayPosted 1 month ago

See more like this