Job Title: Informatica Developer

Job Type: Long-term Contract

Location: Remote (Kennesaw, GA)

Job Summary:

We are seeking a highly skilled Informatica Developer to join our team at Stellar Professionals. As an Informatica Developer, you will be responsible for designing, coding, and modifying ETL processes using Informatica PowerCenter 10.x.

Key Responsibilities:

• ETL Design and Development: Participate in ETL design of new or changing mappings and workflows with the team and prepare technical specifications.
• Informatica PowerCenter Development: Create ETL mappings, mapplets, workflows, and worklets using Informatica PowerCenter 10.x and prepare corresponding documentation.
• Data Integration: Design and build integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.).
• Source System Analysis: Perform source system analysis as required.
• Data Loading: Load data from SF Power Exchange to MongoDB database using Informatica.
• XML and Java Development: Work with XML's, XML parser, Java, and HTTP transformation within Informatica.
• Data Quality: Work with Informatica Data Quality (Analyst and Developer).
• Database Development: Develop stored procedures, database triggers, and SQL queries where needed.
• SQL Optimization: Implement best practices and tune SQL code for optimization.

Requirements:

• Experience in Informatica PowerCenter 10.x
• Strong understanding of ETL design and development
• Ability to work with XML, Java, and HTTP transformation
• Experience with Informatica Data Quality
• Strong SQL skills
• Ability to work in a team environment