Informatica Developer

Job Summary

Stratacent in looking for a highly experienced Informatica Developer with 8+ years of expertise in ETL development, data integration, and data warehousing. The ideal candidate will have a strong background in Informatica PowerCenter, cloud data platforms, and SQL, and will be responsible for designing and implementing robust ETL solutions to support enterprise data initiatives.

Key Responsibilities

• Design, develop, and maintain ETL workflows using Informatica PowerCenter.
• Collaborate with data architects, analysts, and business stakeholders to understand data requirements and translate them into technical solutions.
• Optimize ETL processes for performance, scalability, and reliability.
• Perform data profiling, cleansing, and transformation to ensure data quality and integrity.
• Develop and maintain technical documentation, including data mappings, workflows, and job schedules.
• Troubleshoot and resolve ETL issues in development, test, and production environments.
• Work with relational databases such as Oracle, SQL Server, Teradata, or Snowflake.
• Support data migration, integration, and modernization projects, including cloud adoption.

Required Skills & Qualifications

• Bachelor's or Master's degree in Computer Science, Information Systems, or related field.
• 8+ years of hands-on experience with Informatica PowerCenter
• IICS experience is preferred.
• Strong SQL skills and experience with PL/SQL, T-SQL, or equivalent.
• Experience with data warehousing concepts, star/snowflake schemas, and dimensional modeling.
• Familiarity with cloud platforms (AWS, Azure, GCP) and cloud data services (e.g., Snowflake, Redshift, BigQuery).
• Experience with job scheduling tools (e.g., Autosys, Control-M).
• Excellent analytical, problem-solving, and communication skills.

Preferred Qualifications

• Informatica certifications (e.g., Informatica PowerCenter Developer, IICS).
• Experience with data governance, data lineage, and metadata management.
• Knowledge of Agile methodologies and DevOps practices.
• Exposure to Python, Shell scripting, or API integration is a plus.

About Us

Stratacent is an IT Managed Services firm, headquartered in Jersey City, NJ, with two global delivery centres in New York City area and New Delhi area plus offices in London, Canada and Pune, India.

We are a leading IT services provider focusing in Financial Services, Insurance, Healthcare and Life Sciences. We help our customers in their digital transformation journey and provide solutions around cloud infrastructure, containers, AI, Client & Analytics and Automation.

We have partnerships with SAS, Automation Anywhere, Snowflake, Azure, AWS and GCP.

(To learn more

www.stratacent.com ).

Benefits

• Health Insurance
• Vision Plan
• Dental Plan
• Paid Time Off
• 401k
• Continuous Learning Program

Stratacent is an equal opportunity employer. As such, to the extent defined by federal, state, and municipal law, Stratacent will not discriminate against any employee or applicant for employment on the basis of race, color, creed, religion, age, sex, national origin, ancestry, handicap, or any other factor protected by law.