· 10 years of experience performing tier 1 to 4 production support and maintenance of business-critical software applications based on a variety of technologies such as SQL, Oracle, Qlik Sense and Qlik view environments and N-printing. Configuration, maintenance and troubleshooting of Qlik Sense and QlikView environments.
· Exposure on upgrading Qlik Sense on all versions. Exposure on upgrading QlikView to 12.20 Creation of older and securing them with AD groups in QlikView.
· Installation of ODBC drivers such as SQL, Oracle, etc.
· Daily support of jobs running investigation of long runs and failures
· Maintenance support, environment stabilization, upgrades, licensing issue
· Produce and maintain operations manuals/run books for the operation support in line with corporate standards.
· Experience in Qlik Antiunity Platform environment setup/configurations and integration with other services.
· Familiar with Replicate and Attunity for efficient data movement and transformation.
· Provide technology guidance and best practices for the Platform to the Customer.
· Qlik Replicate: Proficient in configuring and managing Qlik Replicate for real-time data replication and synchronization.
· Data Integration: Experience with Change Data Capture (CDC) and ETL processes to ensure efficient data flow between systems.
· Cloud Platforms: Familiarity with deploying Qlik solutions on cloud environments (AWS, Azure, GCP).
· Performance Tuning: Skilled in optimizing Qlik applications for improved performance and scalability.
· Monitoring and Troubleshooting: Expertise in monitoring Qlik infrastructure and resolving issues to ensure high availability.
· Scripting and Automation: Developed Python scripts to automate repetitive tasks, improving operational efficiency and reducing errors by 50%.
· API Integration: Created scripts for integrating with various APIs, enabling automated data retrieval and processing for analytics.
· Data Processing: Implemented data processing pipelines using Python libraries (e.g., Pandas, NumPy) to transform and analyze large datasets.
· Performance Tuning and Optimization
· Conducted performance tuning on mappings, sessions, and workflows to minimize processing time and improve throughput.
· Identified and resolved performance bottlenecks by optimizing SQL queries, partitioning data, and fine-tuning session configurations.
· Implemented session and workflow parameterization for dynamic data loading and environment-specific configurations.
· Data Integration and Connectivity
· Integrated data from various heterogeneous data sources, including relational databases (Oracle, SQL Server, DB2), flat files, XML, and web services.
· Worked with source control tools and versioning to maintain code integrity and track changes across development cycles.
· Developed and maintained database connection objects and configured source/target connections in the Informatica repository.
· Informatica PowerExchange & Cloud Integration
· Implemented data integration solutions using Informatica PowerExchange to extract data from mainframes, ERP systems, and external systems.
· Utilized Informatica Cloud services for hybrid data integration, migration, and cloud data warehouse solutions (e.g., AWS Redshift, Snowflake).
· Error Handling and Debugging
· Implemented robust error handling and logging mechanisms within ETL processes to capture, troubleshoot, and resolve data load issues.
· Used Informatica session logs and workflow logs for debugging and improving overall ETL process reliability.
· Team Collaboration and Documentation
· Collaborated with cross-functional teams (business analysts, data architects, DBAs) to design and implement data integration solutions aligned with business requirements.
· Documented ETL processes, mapping specifications, and transformation logic for knowledge sharing and future reference.
· Version Control and Deployment
· Utilized Informatica Repository Manager for version control, deployment, and migration of ETL objects across different environments (Dev, QA, Production).
· Developed deployment strategies for promoting Informatica mappings and workflows from development to production environments.
· Designed and developed ETL processes using Informatica PowerCenter to extract, transform, and load data into Qlik data models for reporting and analysis.
· Integrated disparate data sources (e.g., relational databases, flat files, and web services) into Qlik by leveraging Informatica’s robust data transformation capabilities.
· Ensured data consistency and quality before loading into Qlik for real-time dashboards and visualizations.