Informatica Developer

Description:

Business Initiative/Purpose: (Goal, Business Impact, Accomplishments from the work)

• Specialized ETL work for Finance teams..

Bachelor Degree: (Required, Preferred or Not Required)

• Preferred.

Role Responsibilities: (what they will be doing)

• Design, develop, and implement ETL workflows using Informatica PowerCenter.
• Create and maintain mappings, workflows, sessions, and transformations
• Develop data integration solutions to extract, transform, and load data from multiple sources.
• Perform data analysis, validation, and troubleshooting of ETL processes.
• Optimize ETL performance and implement tuning strategies.
• Develop and maintain Unix shell scripts for job automation, scheduling, and monitoring.
• Work with SQL queries, stored procedures, and database objects for data processing.
• Support production deployments, issue resolution, and maintenance activities.
• Collaborate with business analysts and stakeholders to understand requirements.
• Ensure data quality, integrity, and compliance with standards.
• Participate in SDLC phases: requirements, design, development, testing, and deployment.

Must Have Skills/Prior Experiences: (Vendor should not submit any candidate that does not have these skills/prior experience.)

• Informatica PowerCenter / Informatica Cloud (IICS).
• Strong knowledge of ETL development and data warehousing concepts.
• Proficiency in SQL (Oracle, SQL Server, DB2, etc.).
• Hands-on experience with Unix/Linux and Shell scripting.
• Experience in data modeling and database design.
• Knowledge of workflow scheduling tools (e.g., Control-M, Autosys).
• Understanding of performance tuning and optimization techniques.
• Experience working with multiple data sources (XML, flat files, RDBMS).

Plus/Nice to Have Skills/Prior Experiences:(Hiring Manager DOES NOT require these skills/ prior experience. However candidates with any of these will be looked at first.)

• Familiarity with Agile methodologies.
• Experience with version control and release management.

Soft Skills:

• Strong analytical and problem-solving skills.
• Good communication and collaboration abilities.
• Attention to detail and accuracy.
• Ability to work independently and within teams.

EEO

“Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.”