Senior Informatica Developer

Veriipro; Owings Mills (MD); On-site; USD 90,000 - 120,000; Full time

Job summary

Veriipro is looking for an experienced Senior Informatica Developer to design, develop, and optimize complex ETL solutions. The ideal candidate will have a strong expertise in Informatica PowerCenter, SQL, and Unix, with a focus on ensuring data quality and adhering to best practices.

The successful applicant will collaborate with data architects and other stakeholders, analyze mappings, troubleshoot issues, and mentor junior staff. This position offers an opportunity to work on data performance and integration within diverse enterprise environments.

Qualifications

• Strong experience with Informatica PowerCenter and ETL development.
• Proficient in SQL, Unix/Linux scripting, and data manipulation.
• Experience with job scheduling tools like Autosys.

Responsibilities

• Design, develop, and optimize complex ETL workflows.
• Analyze source-to-target mappings and implement data transformation rules.
• Optimize ETL performance and troubleshoot production issues.
• Develop and tune SQL queries for large-scale datasets.
• Create and maintain Unix scripts for automation.
• Integrate ETL jobs with Autosys or other schedulers.
• Ensure data quality and validation across systems.
• Conduct ETL design reviews and enforce best practices.

Skills

Informatica PowerCenter

SQL

Unix/Linux scripting

ETL development

Data quality

Troubleshooting

Analytical skills

Tools

Autosys

Job description

We are seeking an experienced Senior Informatica Developer to design, develop, and optimize complex ETL solutions. The ideal candidate will have strong expertise in Informatica PowerCenter, SQL, Unix, and enterprise scheduling tools, with a focus on data quality, performance, and best practices.

Roles and Responsibilities

• Design, develop, and optimize complex ETL workflows using Informatica PowerCenter.
• Analyze source-to-target mappings and implement data transformation rules.
• Optimize ETL performance and troubleshoot production issues.
• Develop and tune SQL queries for large-scale datasets.
• Create and maintain Unix scripts for automation and workflow management.
• Integrate ETL jobs with Autosys or other enterprise schedulers.
• Ensure data quality, reconciliation, and validation across systems.
• Conduct ETL design reviews and enforce best practices.
• Collaborate with data architects, business teams, and stakeholders.
• Support deployments, production releases, and change management.
• Mentor junior developers and review technical deliverables.

Required Skills / Qualifications

• Strong experience with Informatica PowerCenter and ETL development.
• Proficient in SQL, Unix/Linux scripting, and data manipulation.
• Experience with Autosys or other job scheduling tools.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent collaboration, communication, and mentoring abilities.