Job Title – Informatica Developer (with Qlik Support)

Location: Pune

Shift: 6:30 am- 3:30 pm IST

Experience: 5 years

Primary Skills:

Communication

• Strong verbal/written communication with clients and stakeholders.
• Ability to understand ETL & reporting requirements and explain technical concepts in business terms.

Requirement Gathering

• Skilled in collecting and analyzing business needs and converting them into technical specs.
• Good understanding of end-to-end data flow, transformation logic, and dependencies.
• Ability to define functional & technical requirements for ETL and BI integrations.

Informatica (Core Skill):

ETL Workflow Design & Development

• Hands-on experience in building mappings, sessions, and workflows.
• Expertise in complex transformations (Lookup, Joiner, Aggregator, Router, Update Strategy, etc.).
• Ability to develop scalable, maintainable ETL pipelines.

Advanced ETL Troubleshooting

• Strong debugging skills for job failures, log analysis, data mismatches, logic errors, and connectivity issues.
• Good understanding of incremental loads, CDC, and orchestration.

Performance Optimization

• Experience tuning mappings, sessions, workflows using partitioning, pushdown optimization, and tuning transformations.
• Skilled in identifying bottlenecks via logs/performance metrics.

ETL Deployment & Script Management

• Experience promoting ETL code across Dev/Test/Prod.
• Capable of preparing deployment scripts and performing validations.
• Ensures data accuracy across environments.

SQL

• Strong in writing optimized SQL queries for ETL logic/validation.
• Expertise with joins, aggregations, window functions, and analytical queries.
• Skilled in debugging and analyzing data inconsistencies.

Qlik Support (QlikView / Qlik Sense)

Dashboard & Data Model Support

• Ability to troubleshoot issues related to data loads, reload scripts, QVDs, and data models.
• Experience validating QVD generation and analyzing reload logs.
• Resolves ETL-to-dashboard data mismatches.

Task & Server Monitoring

• Experience monitoring QMC tasks, reload schedules, task dependencies.
• Handles task failures, script errors, access issues, and reload performance.

Cross-Team Collaboration

• Works closely with BI developers, analysts, and business teams.
• Participates in RCA for BI/ETL data discrepancies.

Good to Have Skills

• Basic scripting knowledge: Shell / Python / PowerShell.
• Experience with job schedulers: Control-M, Autosys, Cron.
• Familiarity with ticketing tools (ServiceNow, JIRA).
• Understanding of cloud data platforms (optional).