ETL Informatica Developer

TechDigital Group; Charlotte (NC); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading tech firm in Charlotte, North Carolina is looking for an experienced ETL developer with strong skills in Informatica and Ab Initio. You will be responsible for designing, developing, and optimizing ETL processes for large databases. The ideal candidate should have a background in data warehousing and be able to perform data extraction and transformation in fast-paced environments.

Qualifications

• Minimum of 2-3 years of experience as an ETL developer.
• Strong documentation skills for technical artifacts and ETL environments.
• Experience with large database and data warehouse implementations.

Responsibilities

• Design and develop ETL workflows and routines.
• Handle data extraction, transformation, cleansing, and loading.
• Optimize ETL jobs for performance and scalability.

Skills

Rally Agile tool

ETL processes

SQL

Oracle

Linux/Unix

Tools

Informatica

Ab Initio

Job description

Responsibilities

• Experience using Rally Agile tool
• ETL developer with minimum of 2-3 years of Ab Initio/ Informatica experience
• Should have skills in designing and developing extract, transform and load ETL processes
• Create and maintain adequate documentation of project ETL design, technical artifacts and ETL environment
• Very Large Database and DW implementation experience (20+ TBs), well versed in SQL, Oracle
• Programming skills in a Linux/Unix environment, including shell scripting
• Experience and ability to deliver results quickly in a fast-paced environment on multiple projects
• Understanding and working with data models to ensure data is structured appropriately for the target system
• Creating and implementing the logic for extracting, transforming, and loading data
• Identifying and resolving issues within the ETL processes and monitoring performance to ensure optimal functionality
• Design and develop ETL workflows, graphs, mappings to process and transform data from source to target
• Optimize ETL jobs for performance and scalability
• Handle data extraction, transformation, cleansing and loading into data warehouse or data lakes
• Ensure consistency and accuracy of integrated data; identify and resolve data quality issues and ETL job failures
• Develop test scenarios, test cases and execute functional testing

Qualifications

• Strong understanding of Informatica ETL tool
• Experience with ETL tools and data warehousing concepts
• Ability to document technical artifacts and ETL environments