ARCHIVED
This job listing has been archived and is no longer accepting applications.
MisuJob - AI Job Search Platform MisuJob
Login Sign Up

Lead ETL Developer Informatica

AtriaGroupLLC

Dallas, TX, United States contract

Posted: December 16, 2013

Interested in this position?

Create a free account to apply with AI-powered matching

Register to Apply

Quick Summary

Lead ETL Developer Informatica is responsible for developing ETL routines using Informatica as the data integration platform, converting data integration and transformation requirements into ETL routines, and testing the ETL jobs for data validation.

Required Skills

Informatica ETL Development SQL Data Validation Data Reconciliation Data Profiling Performance Tuning Unix Shell Scripting SDLC Test Planning

Job Description

Lead ETL Developer Informatica

Job Description:

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

Apply today!

Why Apply Through MisuJob?

AI-Powered Job Matching: MisuJob uses advanced artificial intelligence to analyze your skills, experience, and career goals. Our matching algorithm compares your profile against thousands of job requirements to find positions where you have the highest chance of success. This saves you hours of manual job searching and ensures you only see relevant opportunities.

One-Click Applications: Once you create your profile, applying to jobs is effortless. Your resume and cover letter are automatically tailored to highlight the most relevant experience for each position. You can apply to multiple jobs in minutes, not hours.

Career Intelligence: Beyond job matching, MisuJob provides valuable career insights. See how your skills compare to market demands, identify skill gaps to address, and understand salary benchmarks for your experience level. Make data-driven decisions about your career path.

Frequently Asked Questions

How do I apply for this position?

Click the "Register to Apply" button above to create a free MisuJob account. Once registered, you can apply with one click and track your application status in your dashboard.

Is MisuJob free for job seekers?

Yes, MisuJob is completely free for job seekers. Create your profile, get matched with jobs, and apply without any cost. We help you find your dream job without any hidden fees.

How does AI matching work?

Our AI analyzes your resume, skills, and experience to understand your professional profile. It then compares this against job requirements using natural language processing to calculate a match percentage. Higher matches mean better fit for the role.

Can I apply to jobs in other countries?

Absolutely. MisuJob features jobs from companies worldwide, including remote positions. Filter by location or look for remote opportunities to find jobs that match your preferences.

Ready to Apply?

Join thousands of job seekers using MisuJob's AI to find and apply to their dream jobs automatically.

Create Free Account Sign In
← Browse all jobs
Register to Apply