Informatica Developer

Please find the Job Position Details;

Job ID: Heads Up


Client: Freddie Mac (175330-BH)


Position: Informatica Developer


Location: Mclean, VA (Onsite)


Duration: 6+ Months (with possible extension)

Job Description:


Job Summary


Freddie Mac is seeking an experienced Informatica Developer to support enterprise data integration and analytics initiatives within the organization. The role involves building and maintaining scalable ETL pipelines , integrating multiple data sources, and enabling reliable data delivery across enterprise data platforms.


The ideal candidate will have strong experience in Informatica development, SQL-based data transformations, and modern cloud data platforms including Snowflake and AWS.

Key Responsibilities

• Design, develop, and maintain ETL workflows and mappings using Informatica PowerCenter or Informatica Intelligent Cloud Services.
• Build and optimize data integration pipelines to process large volumes of structured and semi-structured data.
• Develop complex SQL queries and stored procedures for data transformation and validation.
• Integrate enterprise data sources including relational databases, NoSQL systems, and cloud data platforms.
• Support data ingestion and transformation into cloud-based data warehouses such as Snowflake.
• Work with AWS data services such as Amazon S3, AWS Glue, and Amazon Redshift where applicable.
• Implement data validation, error handling, and monitoring processes to ensure high data quality.
• Develop integrations with NoSQL databases such as MongoDB.
• Collaborate with data engineers, analysts, and business stakeholders to deliver reliable data solutions.
• Troubleshoot ETL failures and optimize job performance.

Required Skills

• Strong hands-on experience with Informatica PowerCenter or Informatica Intelligent Cloud Services.
• Solid experience in ETL design, development, and optimization .
• Advanced proficiency in SQL and relational databases .
• Experience integrating data with cloud data platforms such as Snowflake.
• Experience working with AWS data ecosystem (S3, Glue, Redshift, Lambda).
• Experience working with NoSQL databases such as MongoDB.
• Strong understanding of data warehousing concepts and data modeling .
• Experience troubleshooting and optimizing ETL workflows.

Preferred Skills

• Experience with cloud-based ETL and data integration .
• Familiarity with CI/CD pipelines for data workflows .
• Knowledge of data governance and metadata management tools .
• Experience in financial services or enterprise-scale data environments .

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.
• 6-8+ years of experience in data integration, ETL development, and data warehousing .
• Experience working in large enterprise data environments .