Informatica Developer

Position: Informatica Developer
Location: McLean, Virginia
Duration: Contract
Job ID: 175330

Job Overview:
The organization is seeking an experienced Informatica Developer to support enterprise data integration and analytics initiatives. This role involves designing, building, and maintaining scalable ETL pipelines, integrating multiple data sources, and ensuring reliable data delivery across enterprise platforms. The ideal candidate will have expertise in Informatica development, SQL-based data transformations, and modern cloud data platforms such as Snowflake and AWS.

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.

Qualifications:

• 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.
• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.
• 6 to 8+ years of experience in data integration, ETL development, and data warehousing.

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.

About PTR Global: PTR Global is a leading provider of information technology and workforce solutions. PTR Global has become one of the largest providers in its industry, with over 5000 professionals providing services across the U.S. and Canada. For more information visit ;br>
At PTR Global, we understand the importance of your privacy and security. We NEVER ASK job applicants to:

• Pay any fee to be considered for, submitted to, or selected for any opportunity.
• Purchase any product, service, or gift cards from us or for us as part of an application, interview, or selection process.
• Provide sensitive financial information such as credit card numbers or banking information. Successfully placed or hired candidates would only be asked for banking details after accepting an offer from us during our official onboarding processes as part of payroll setup.

Pay Range: $50 - $60/hour on W2

The specific compensation for this position will be determined by several factors, including the scope, complexity, and location of the role, as well as the cost of labor in the market; the skills, education, training, credentials, and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits, including medical, dental, vision, and 401K contributions, as well as PTO, sick leave, and other benefits mandated by applicable state or localities where you reside or work.

If you receive a suspicious message, email, or phone call claiming to be from PTR Global do not respond or click on any links. Instead, contact us directly at +1 . To report any concerns, please email us at