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.