Informatica Developer (with Qlik Support)

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).