SUMMARY

• me have 8 years of experience in Data Warehouse and Business Intelligence systems Administration, design, development and maintenance which include requirements gathering, Business Analysis, system architecture, preparing estimation, resources management, Logical & Physical Data Modelling, design, development and testing of ETL, data migration, data analysis, data profiling, source to target data reconciliation, data issues analysis and fix, job failures root cause analysis and fix, jobs scheduling, Performance tuning of Data Warehouse and ETL data load, Documentation of requirements, design, development & testing phases, team management, code review, analysis of existing system, impact analysis, integration testing, defects analysis and fix.
• Have 4 Years ofInformatica Administration experience usingInformatica Powercenter, Informatica data quality 9.x/8.6.2 which includes Installation, up - gradation, migration, configuration,maintenance, jobs scheduling, systems monitoring was a constant to insure uninterrupted data and batch job scheduling processing, technical support and troubleshooting ofInformaticaETL Server implementations in shared and dedicated environments, user access maintenance, folders creation, connections creation, code deployment, query metadata from repository, code change management, repository backup…etc.
• Have 2 years of Informatica Data Quality experience which includes data profiling, build score cards, data quality rules development, Address validations, matching of data using Biagram distance, Hamming distance, Reverse hamming distance, Edit distance, and Jaro distance algorithms, Consolidation of data, standardization of data and labelling.
• Have 6 years of experience on design & development of Informatica PowerCenter ETL code which includes mappings, mapplets, reusable transformations, shared objects, sessions and workflows. Also worked on advanced concepts like SQL transformation, dynamic lookup, Normalizer, Reusable sessions using parameters, Event Raise and Event Wait,..etc.
• Worked on data load performance tuning which includes eliminating source and target bottlenecks(Partitioning, indexing), optimizing the mapping(using cache, persistent cache in lookup’s, sorted input for aggregator and joiner, incremental aggregation, index and data cache size optimization), eliminate session bottlenecks(DTM buffer size, commit interval) and optimize the server(Available space, CPU utilization).
• Designed and documented ETL standards document.
• Worked on SQL/PL SQL to created various stored procedures.
• Worked on Oracle, Teradata, SQL Server, MySQL and DB2 databases.
• Worked on Healthcare, Finance, Manufacturing and Banking domains.
• Worked on Unix shell scripting and crontab scheduling.
• Worked on Autosys, Control-M and DAC to schedule jobs.
• Exposed to SSIS, OBIEE and Business Objects.
• Currently me’m working as Informatica Administrator & Sr Developer. Below is a list of important software products and tools dat me have worked wif.

TECHNICAL SKILLS

Operating Systems: Windows, UNIX

Software Products/Tools: Informatica PowerCenter(8.x,9.x), Informatica data quality, Informatica Cloud, SSIS, OBIEE, Qlikview, Tableau, Business Objects, Hyperion Essbase 7.1.5, SSRS, Oracle, Teradata, AWS, SQL Server, MySQL, DB2, Autosys, Control-M, TOAD, SQL Developer, WinSCP, Cascade, Test director, Ultraedit, Edit Plus, Remedy, CASD, Clearcase, C, C++, Java, HTML.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Informatica Administrator& Sr IDQ Developer

Environment: Informatica PowerCenter 9.x, Informatica Data Quality 9.x, Oracle, SQL Server, Teradata, Unix, Autosys, MKS Integrity, Qlikview.

Responsibilities:

• Installed and configured PowerCenter on UNIX platform.
• Upgraded to Informatica PowerCenter 9.6 from version 9.1.
• Installed Hot fixes, utilities, and patches released from Informatica Corporation.
• Configured Repository service, Integration service, Model Repository, Metadata Manager Service, Data Analyzer and Web Service Hub.
• Configured the ETL frame work and processes using Informatica 9, to run on the Domain, Integration Services and Nodes, on a Highly Available Grid ETL Infrastructure. Hands on knowledge on Integration Services Architecture and its components such as Load Balancer, DTM processing, Grids, code pages and data movement modes etc.
• Migration of changes, enhancements, upgrades, etc. through the various environments. worked on (EAI) Enterprise Application integration team to design, develop and maintain application solutions.
• Worked on creation of DB connections and Application connections in informatica.
• Created and maintained Users, Groups, Roles and Privileges.
• Analyzed the data quality rules defined by the business/functional teams and propose the optimization of these rules if applicable, then designed and developed these rules wif IDQ.
• Developed Informatica Data Quality (IDQ) mappings and mapplets.
• Worked on Data Profiling, Score Card and Data Quality rules.
• Worked on Informatica PowerCenter ETL development wif embedded IDQ mapplets.
• Worked on Push Down Optimization to optimize Oracle loads.
• Extensively worked on Informatica Performance tuning to find potential bottlenecks in the Source, Informatica and Target systems.
• Experience in installing, upgrading and supporting Sterling Integrator release 5.1 or greater on UNIX and Sterling Secure Proxy
• Writing batch scripts to FTP and IP address configurations
• Extensively worked on UNIX shell scripts on automation (Auto restart of servers, Disk space utilization, Informatica Server monitoring and UNIX file system maintenance and cleanup, and infacmd and pmrep operations).
• Creation and maintenance of Informatica users and privileges.
• Worked on Informatica Mapping Architect for Visio to automate Mappings, Sessions and Workflow generation.
• Created Oracle procedures at appropriate places.
• Prepared design documents.
• Performed code review.
• Created various UNIX shell scripts to automate the jobs.
• Developed reusable Informatica mappings, tasks, workflows.
• Developed reusable tasks using different parameter files.
• Created many reusable transformations and maplets to optimize the work.
• Analysed root cause of identified defects and proposed solutions to fix wifout impacting the required functionality.
• Performed Unit testing, Integration testing and Performance testing.
• Identified the bottlenecks and tuned the performance of ETL code.
• Tuned performance of sources and targets by creating appropriate indexes, stats update, partitioning.
• Analysed the data issues and proposed the solutions to fix.
• Analysed the impact of potential solutions on the existing system.

Confidential, Minneapolis, MN

Informatica Administrator

Environment: Informatica PowerCenter 9.x, Informatica cloud, DataStage, Teradata, AWS, Oracle 10g, Unix, SSIS, SSRS, Control-M.

Responsibilities:

• Worked on Informatica PowerCenter Administration which includes Installation, up-gradation, migration, configuration,maintenance, jobs scheduling, technical support and troubleshooting ofInformaticaETL Server implementations in shared and dedicated environments, user access maintenance, folders creation, code deployment, query metadata from repository, code change management, repository backup…etc.
• Build & Migrated 11g Oracle databases into AWS RDS systems
• Upgraded to Informatica PowerCenter 9 from version 8.6.
• Installed Hot fixes, utilities, and patches released from Informatica Corporation.
• Installed and configured Metadata Manager Service, Data Analyzer and Web Service Hub.
• Extensively worked on Informatica environment Performance tuning.
• Knowledge on Microsoft Active Directory and comfortable wif infrastructure of Active Director utilizing standard practices and protocols.
• Extensively worked on UNIX shell scripts on automation (Auto restart of servers, Disk space utilization, Informatica Server monitoring and UNIX file system maintenance and cleanup, and infacmd and pmrep operations).
• Configured OS Profiles and LDAP Authentication.
• Prepared reusable ETL code and unix scripts.
• Creation and maintenance of Informatica users and privileges.
• Coordinated between client and ETL developers.
• Worked on Informatica Templates to standardize the process and maintain consistency across different teams.
• Worked on UNIX shell scripts to handle Job Control Process.
• Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
• Analysed and solved the production issues.

Confidential, Columbus, IN

DWH Developer

Environment: Business Intelligence(Informatica 8.x/9.x, OBIEE, Oracle 10g, Unix)

Responsibilities:

• Interacted wif client, understood the Requirements and prepared Requirements Specification document.
• Prepared the Project Estimate and Project plan documents.
• Prepared HLD and LLD solution design documents.
• Developed reusable Informatica mappings, tasks, workflows.
• Developed reusable tasks using different parameter files.
• Created many reusable transformations and maplets to optimize the work.
• Customized the out of box reports and dashboards.
• Designed and developed new repository.
• Designed and developed various new OBIEE reports and dashboards.
• Created various UNIX shell scripts to automate the jobs.
• Worked in Unit testing, Integration testing and User Acceptance Testing.
• Guided and mentored the team.

Confidential, Columbus, IN

DWH Developer

Environment: Business Intelligence(Informatica 8.x, OBIEE, Business Objects, Oracle 10g, Unix)

Responsibilities:

• Interacted wif client, understood the Requirements and prepared Requirements Specification document.
• Prepared the Project Estimate and Project plan documents.
• Prepare HLD and LLD solution design documents.
• Developed reusable Informatica mappings, tasks, workflows.
• Developed reusable tasks using different parameter files.
• Created many reusable transformations and maplets to optimize the work.
• Worked on BO reports and dashboards.
• Created various UNIX shell scripts to automate the jobs.
• Worked in Unit testing, Integration testing and User Acceptance Testing.
• Trained and mentored team to deliver quality code wifin time lines.
• Reviewed the work done by team members and guided them in right way.
• Worked for performance improvement.

Confidential, Columbus, IN

ETL Developer

Environment: Informatica 8.x, Hyperion Essbase, Business Objects, Oracle 9i, Unix

Responsibilities:

• Prepared the Requirement document and Design documents (HLD and LLD) by understanding the requirement.
• Developed various mappings, tasks and workflows in informatica.
• Involved in Unit Testing and Integration Testing.
• Involved in IQA and EQA.
• Involved in the migration of the code.
• Worked for performance improvement.

Confidential, Columbus, IN

ETL Support Analyst

Environment: Informatica 8.x, Hyperion Essbase, Business Objects, Oracle 9i, Unix

Responsibilities:

• Supported for various scheduled ETL jobs.
• Supported to load data into Essbase cubes from different sources.
• Analyzed the job failures and fixed them effectively wifout impacting the business wifin SLA.
• Had created many data consistency reports to ensure the accuracy of incremental data load.
• Analysed and fixed the data issues which we got from end users.
• Taken care of administrator activities for Informatica and Essbase.
• Pro actively Identified improvement required areas and implemented as enhancement CR's.
• Involved in EQA review of the solution design for the development projects.
• Migrated the new projects to live environment and stabilized them.