Informatica Developer

Informatica Developer at

TEKGENCE INC

Informatica Developer at

TEKGENCE INC

in Pittsburgh, Pennsylvania Posted in 2 days ago.

Type:

full-time

Job Description:

Job Title:

Informatica Developer Job Location:

Pittsburgh, PA -

Onsite Type:

Contract Job Description:

Role Descriptions:

An Informatica Developer designs| develops| tests| and maintains ETL (Extract| Transform| Load) processes and data integration solutions using Informatica PowerCenter or Cloud (IICS). They create complex mappings| workflows| and SQL scripts to move data into data warehouses| ensuring data quality| performance tuning| and troubleshooting. Freelancer map 2Key Responsibilities ETL Development Design| develop| and maintain Informatica mappings| mapplets| and workflows using transformations (e.g.| Source Qualifier| Expression| Lookup| Aggregator).Data Integration Extract data from various sources (SQL| Oracle| flat files) and load it into target data warehouse systems. Performance Tuning Monitor and optimize ETL jobs| SQL queries| and session performance to ensure efficient data processing. Data Quality Validation Perform data validation| cleansing| and unit testing to ensure data integrity. Collaboration Work with business analysts and technical teams to translate business requirements into technical specifications. Documentation Maintain technical documentation for ETL processes| data mappings| and system workflows. NYC Government Jobs (.gov)NYC Government Jobs (.gov) 5Required Skills and Qualifications Informatica Expertise Strong experience with Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS).Database Knowledge Advanced SQL skills and experience with relational databases (Oracle| SQL Server| Teradata| Snowflake). Technical Skills Knowledge of UNIX Linux shell scripting and job scheduling tools. Data Warehousing Solid understanding of data modeling| data warehousing concepts (Star Schema| Snowflake Schema)| and ETL design. Analytical Skills Strong problem-solving and debugging skills.