SUMMARY:

• Over 14 years of experience in Informatica Administration, Development, data warehouse designing and data modeling.
• Informatica Certified Administrator.
• Informatica Certified Developer.
• Proven track record to improve ETL performance and reduce failure points.
• Handled all phases of SDLC including requirements gathering, analysis, design, development, unit testing, on - going maintenance and production support.
• Hands on experience on RDBMS systems including Oracle, Microsoft SQL server and DB2.
• Informatica and SQL server Subject Matter Expert (SME).
• Masters degree from University of Texas, Arlington.
• Created successful data models using Relational & Dimensional modeling and ER diagrams.
• Experience in data analysis, data profiling, data standardization and data cleansing.
• Hands on experience developing new solutions, prototypes, templates and proof of concepts.
• Knowledge of Service Oriented Architecture and principles.
• Lead six sigma projects and participated in multiple quality & process improvement projects.
• Experience in leading project teams using Agile methodologies.
• Extensive experience in healthcare, clinical, care management, finance and telecom domain.

TECHNICAL SKILLS:

ETL: Informatica power center 10.x / 9.x / 8.x, Informatica Developer, Informatica Analyst, Informatica Administrator, Data masking, Informatica Power exchange, Informatica Data Services (IDS), Informatica Data Quality (IDQ), Informatica Metadata manager, SQL Server Integration Services (SSIS), DTS

Tools: /Applications SQL server management studio, Oracle SQL Developer, Toad, Tortoise SVN, Subversion, ER studio, MS Visio, Visual studio, PuTTY, WinSCP, JIRA, Tectia SSH, Visual Source Safe, Team Foundation Server, EA Sparks, MS Office

RDBMS: MS SQL Server, Oracle, IBM DB2, MS Access

Scripting: PowerShell, UNIX Shell Scripting (Bash Shell, Korn Shell), Python

Languages: C#, Java, T-SQL, PL/SQL, XQuery, XML

Operating Systems: Windows, DOS, UNIX, Linux, Solaris

Schedulers: Informatica scheduler, Tidal scheduler, CronTab, Control-M

Project methodologies: Waterfall, Agile (Scrum, Kanban)

WORK EXPERIENCE:

Confidential

Informatica Administrator

Responsibilities:

• Performed Informatica PowerCenter upgrade to 10.1.
• Installed and configured PowerCenter 9.6.1
• Applied hotfixes and EBF patches.
• Migrated Informatica code including mappings, sessions, workflows, scripts and source files to different environments.
• Managed Informatica users and privileges.
• Experience in shell scripting.
• Experience and detailed knowledge of integrating and aggregating large data sets into high-volume data warehouse applications.
• Monitored ETL jobs and decreased production issues by more than 80%.
• Optimized ETL processes and decreased nightly batch processing time by more than an hour.
• Provided on-call support to resolve production issues on time and meet SLAs.
• Experience with Informatica cloud integration and data management.
• Designed data warehouse and data marts using Relational and Dimensional modeling.
• Developed Python scripts.
• Supported multiple lines of business and IT initiatives.
• Excellent knowledge in data analysis, data cleansing and data validation.
• Experience with native & LDAP authentication and change data capture.
• Enforced coding standards, best practices and formalized code reviews.

Informatica Administrator

Responsibilities:

• Responsible for end to end implementation and operations of Enterprise Data Warehouse using Informatica, Oracle 11g, Microsoft SQL Server 2012 and DB2.
• Installed, configured, upgraded, and applied EBF’s on Informatica suite including Informatica PowerCenter and PowerExchange.
• Migrated Informatica code between different repositories.
• Leadership experience in coordinating between multiple technical teams, stakeholders and senior management.
• Developed Informatica code with good performance for highly complex business logic.
• Experience in XML, WSDL and XQuery coding for data transformation, retrieval and delivery.
• Modeled databases for reporting and transaction processing.
• Performed data analysis, data profiling and data cleansing using SQL and Informatica.
• Worked extensively on performance tuning of Informatica workflows and SQL scripts.
• Experience in advanced T-SQL and PL/SQL with ability to write complex queries.
• Hands on expertise with Informatica Data Services (IDS) and Informatica Data Quality (IDQ).
• Created technical specifications using Informatica Analyst tool and excel spread sheets.
• Experience in Disaster Recovery Planning, Execution and Testing.
• Developed architectural diagram documenting interdependencies between various applications, sources and datasets.
• Supported SAP Business Objects reports with Informatica PowerCenter and IDS.

Environment: Informatica Power Center, Solaris, Windows, Oracle, DB2, SQL server, ER Studio, SAP Business object, Informatica developer, Informatica Data Services, Informatica analyst, Web services, Visio, JIRA, Tableau

Informatica Technical Lead Administrator / Developer

Responsibilities:

• Supported day-to-day activities of the Enterprise Data Warehouse.
• Installed and configured Informatica PowerCenter 8.6 and 9.1
• Experience in Change Data Capture (CDC) implementation using Informatica PowerCenter and Informatica PowerExchange.
• Fine-tuned Informatica transformations and workflows for better performance.
• Developed solutions for multiple complex Care Management requirements and guided team to develop code with higher coding standards and performance.
• Developed Entity Resolution algorithms using Informatica and SQL, to identify members from different source systems and tie them together as one person.
• Mentored Informatica and SQL developers.
• Created Informatica mappings using transformations like Source qualifier, Expression, Aggregator, lookup, Router, Filter, Update Strategy, Joiner, Stored procedure, XML generator and XML parser transformations.
• Migrated Informatica code and managed security and permissions.
• Designed, created and modified SQL database objects.
• Developed data models from technical and functional specifications.
• Hands on experience on OLTP and OLAP applications.
• Provided 24x7 on-call support.
• Represented Informatica and SQL server on Enterprise architecture board.
• Developed SSIS packages to load data into warehouse and benchmark the performance.
• Extracted data from Mainframes IMS databases and VSAM files using Power Exchange CDC.
• Used Informatica Metadata Manager to show data lineage.
• Collaborated with remote offshore team, created requirement documents, verified coding standards and conducted code reviews.
• Developed Informatica data services (IDS) in Developer tool for SOA applications.
• Knowledge of Informatica Data quality (IDQ).
• Developed PowerShell scripts and batch scripts for file processing and cleansing.
• Developed basic applications using C# and .Net
• Experience in integrating vendor systems with in-house applications while maintaining system integrity and compliance with HIPAA regulations.

Environment: Informatica Power Center, Power Exchange, SQL server, Metadata manager, Solaris, Windows, Oracle, DB2, ER Studio, Informatica developer, Informatica Data Services, Informatica analyst, Web services, VSS, Visio, TFS, SSIS, SSRS, Tidal

Sr. Informatica Developer

Responsibilities:

• Created data extractions, transformations and load processes for enterprise data warehouse, data marts and enterprise applications using Informatica and SQL scripts.
• Developed complex Informatica mappings and workflows.
• Profiled clinical data and modeled database tables to generate reports on them.
• Performed Informatica administrator activities.
• Worked on Informatica PowerExchange for Change Data Capture (CDC).
• Experience with Master Data Management.
• Migrated code to Informatica QA and production environments.
• Mentored junior programmers in SQL Server 2005/2000 and Informatica.
• Extensively used T-SQL DML, DDL, DCL, TCL statements.
• Created and implemented stored procedures, user-defined functions and transactions.
• Liaison between development team, test team and project managers.
• Provided support for development and deployment of database models based on business requirements and mapped entities to existing data sources.

Environment: Informatica Power Center, Power Exchange, SQL server, ER Studio, Web services, Visio, SSIS, SSRS, VSS, Windows

ETL Developer

Responsibilities:

• Responsible for developing ETL processes using Informatica Power Center.
• Created reusable mapplets, transformations and user defined functions.
• Prepared mapping specification for Informatica mapping.
• Scripted PMCMD, PMREP command line utilities to interact with Informatica server.
• Dimensional modeling using star and snowflake schemas and implemented Slowly Changing Dimensions.
• Extensively created SQL stored procedures to implement business logic.
• Optimized SQL scripts for better performance.
• Extracted and Transformed data using DTS in SQL Server 2000 and SSIS in SQL Server 2005.

ETL Developer

Responsibilities:

• Created SQL Scripts, tables, views using Microsoft T-SQL and Oracle PL/SQL.
• Designed and developed stored procedures, Triggers, User Defined functions.
• Experience in fine tuning the SQL queries using SQL Query Analyzer.
• Developed complex queries using joins and sub-queries for extracting data from multiple tables.
• Experience in Database Backup, Restore and Disaster Recovery procedures.
• Created Informatica mappings, sessions and work flows.
• Expertise in working with Informatica and client tools like Repository Manager, Designer, Workflow Manger and Workflow monitor.
• Used Informatica to extract data from various sources including SQL server, Oracle, Mainframes and flat files.
• Documented disaster recovery plan and restart procedure of critical workflows.