Business Intelligence Senior Analyst Resume

SUMMARY

ETL Informatica Developer with 7 years of ETL and data integration experience in developing ETL Mappings, Mapplets, Workflows, Worklets, and scripts using Informatica PowerCenter 10.x/9.x.

TECHNICAL SKILLS

Programming Languages: ETL(Informatica), IICS, SQL, Python

Operating System: Linux, Windows

UNIX: Secure CRT, WS FTP Pro

Database: DB2, Oracle, Microsoft SQL Server

Automation: IBM Tivoli Scheduler, UC4

Version Control: GIT

PROFESSIONAL EXPERIENCE

Application Development Senior Analyst

Confidential

Responsibilities:

Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
Designed and developed end - to-end ETL process from various source systems to Staging area, from staging to Data Marts.
Developed various mappings using the transformations such as Source Qualifier, Joiner, Filter, Router, Normalizer, SQL, Lookup (Connected & Un Connected), Expression, Update Strategy, Aggregate etc.
Available in Informatica according to complexity of the development using Informatica Power Center.
Analyzed the new functionalities in Informatica Cloud to identify the better optimistic way to develop/migrate the integrations from Informatica PowerCenter to Informatica Cloud.
Developed Cloud mappings for Data Replication and Data Synchronization using Informatica Cloud.

Business Intelligence Senior Analyst

Confidential

Responsibilities:

Developed ETLs that extracted the data from various sources (vendor flat-files and databases) to the hub ODS and DW tables (SCD-1 and SCD-2), via stage - incremental load.
Developed validation ETLs that validated the data in the staging tables before getting them processed further. Used transformations lookups, joiners, filters & routers, to achieve the needful.
Developed new batch scripts to perform various tasks - copy the vendor files from the FTP path, to keep a check on the files’ volume if empty, to archive the vendor files, to rename the files as expected by the ETLs to read, to reuse the previous files if new files are not available.
Created new batch jobs in Tivoli Scheduler, to schedule and set dependencies on the ETLs created.
Modified existing ETLs to enhance existing refresh process - used sorted inputs before aggregator and lookups to enhance performance.
Automated a few processes which helped Business to override their manual work effort.
Created users, groups and roles in Admin console and assigned privileges to the same.
Created the folders and assigned permissions to developers for folders depending upon environments.
Created and maintained Relational and ODBC connections in DEV, UAT and PROD environments.
Migrated Informatica objects across different environments like DEV, INT, UAT and PROD.
Deployed from one repository to another repository using Labels, Queries and Deployment groups.
Provided production support to various manuals and deployment.
Monitored system integrity through daily system checks, to ensure a high standard of service is provided to clients.
Escalated issues and remediation steps effectively and in a timely manner.
Performed troubleshooting analysis and resolution of critical applications and batch processes.
Coordinated with vendors to troubleshoot and resolve issues.
Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
Created and implemented Continuous improvement fix for the code in production which improved the performance of the SLA driven batches, helped business and reduced incidents.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship