Home / Data Platforms / ETL Development
01 / Data Platforms
ETL Development & Administration.
Informatica PowerCenter · IBM InfoSphere DataStage · Data Integration · ETL Automation
Informatica PowerCenter belongs to earlier employment, notably Alfa-Bank and Sberbank; responsibility-level attribution is under review. DataStage work is separately associated with Nordea/Luxoft. These roles are not presented as one project.
01 / Earlier banking roles
Informatica PowerCenter
Enterprise ETL platform setup, workflow design, automation, monitoring and integrations.
Platform Installation, Configuration & Administration
- Installed, configured, and administered Informatica PowerCenter on IBM AIX servers.
- Managed Informatica environments, repository configuration, and ETL runtime settings.
- Administered Informatica services required for ETL execution.
- Configured parameter files, environment variables, and runtime settings.
- Used Informatica Repository Manager to administer repositories and ETL objects.
ETL Workflow Development & Data Mart Loading
- Developed and maintained ETL workflows, sessions, and worklets in Workflow Manager.
- Configured automated extraction, transformation, and loading into enterprise data marts.
- Managed session configurations, workflow parameters, variables, and execution dependencies.
- Maintained dynamic parameter files across environments.
- Modified workflows in response to business requirements.
- Worked with ETL mappings and transformations in Informatica Designer.
Command-Line Administration & Automation
- Used Informatica pmcmd utilities to control ETL execution.
- Automated workflow execution and operational tasks with UNIX shell scripts and command-line tools.
- Developed IBM AIX shell scripts extending standard PowerCenter functionality.
- Integrated custom scripts into ETL processing and operational workflows.
ETL Monitoring, Troubleshooting & Performance
- Monitored workflows and sessions with Informatica Workflow Monitor.
- Investigated failed, suspended, and long-running ETL sessions.
- Analyzed workflow logs, session errors, and data load failures.
- Troubleshot parameters, runtime errors, and execution dependencies.
- Supported reliable scheduled data mart loading and operational monitoring.
Notifications, SMTP & SMS Gateway Integration
- Configured SMTP integration for automated email notifications and operational alerting.
- Developed Perl scripts to integrate ETL operations with an external SMS gateway.
- Implemented automated text-message alerts to support ETL monitoring and incident response.
- Extended Informatica capabilities through shell scripting and external integrations.
PowerCenter Tools
- Informatica Designer — mappings and transformation logic.
- Workflow Manager — workflows, sessions, worklets, and dependencies.
- Workflow Monitor — runtime monitoring and troubleshooting.
- Repository Manager — repository and object administration.
- pmcmd — command-line execution and automation.
02 / Nordea and Luxoft
IBM InfoSphere DataStage
ETL Development & Administration
Enterprise ETL and data integration platform experience. Sequential and parallel jobs, execution monitoring and data validation are established; further development, administration and troubleshooting details will be added separately.
03 / Technology index
Core technical competencies
Informatica PowerCenterIBM InfoSphere DataStageData IntegrationETL Workflow DevelopmentData Mart LoadingWorkflow AutomationDesignerWorkflow ManagerWorkflow MonitorRepository ManagerpmcmdMappingsWorkflowsSessionsWorkletsParameter FilesIBM AIXUNIX ShellPerlSMTPSMS GatewayOperational Alerting