ETL Tech Lead

Sarian Solutions; McLean (VA); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading data solutions company in Virginia is seeking a Sr. ETL Developer. The role requires extensive experience in Informatica Power Center, SQL, and UNIX shell scripting. Candidates should have a proven track record in designing and performance tuning high-quality ETL processes in complex data environments. This position offers a competitive salary and is based in McLean, Virginia.

Qualifications

• 8+ years of experience with Informatica Power Center design and development.
• 5+ years of experience with SQL and relational databases.
• 5+ years of experience in UNIX shell scripting.
• 4+ years of experience with Autosys.
• 4+ years of experience with code management tools like ClearCase.

Responsibilities

• Design, develop, and tune ETL processes using Informatica.
• Load and manage high-volume Type2 dimensions in Datamarts.
• Supervise staff in data management tasks.

Skills

Informatica Power Center (v 8.x and higher)

SQL

UNIX shell scripting

Performance tuning of SQL and ETL processes

Autosys

Code management tools (ClearCase)

Staff supervisory experience

Job description

Role: Sr. ETL Developer

Responsibilities

• Minimum five 8 years of current and hands-on experience with Informatica Power Center (v 8.x and higher) design, development and performance tuning. This should include at least 1 year of v9.x experience.
• Minimum five 5 years of current and hands-on experience with reading and loading high-volume Type2 dimensions (Slowly Changing Dimensions) in Multi-Dimensional Datamarts (Start Schema).
• Minimum five 8 years of current and hands-on experience with SQL and Relational databases.
• Minimum five 5 years of current and hands-on UNIX shell scripting experience.
• Minimum five 5 years of current and hands-on experience in designing high performing ETLs in a complex Data Warehouse, Data Marts and Analytics Environments.
• Minimum five 5 years of current and hands-on experience with Performance Tuning of SQL and ETL Process for high volume and highcomplexity processing.
• Minimum two 4 years of current and hands-on Autosys experience.
• Minimum two 4 years of current and hands-on experience with code management tools such as ClearCase.
• Minimum three 3 years of experience in Staff supervisory role.
• Working knowledge of On-Demand connectors – SAS, RDBDS and flat files.

• Minimum five 5 years of current and hands-on experience with Informatica Power Center (v 8.x and higher) design, development and performance tuning. This should include at least 1 year of v9.x experience.
• Minimum five 5 years of current and hands-on experience with SQL and Relational databases and SQL Query performance tuning.
• Minimum five 5 years of current and hands-on UNIX shell scripting experience.
• Minimum two 2 years of current and hands-on Autosys experience.
• Minimum two 2 years of current and hands-on experience with code management tools such as ClearCase.

Qualifications

Additional Information

Will be provided on the call. Please, apply with your updated resume containing contact details...