SUMMARY:

• Have 8+ years of experience in IT industry with diverse roles in analysing the business requirements, providing solutions and performing impact analysis.
• Strong Knowledge in Business Intelligence, Data warehousing, Dimensional Modelling, Star Schema, Snowflake Schema and OLAP concepts.
• Preparing High level designs and Low level designs for development perspective.
• Strong exposure in SQL, PL/SQL and UNIX commands
• Extensive experience in development of ETL components in Informatica 8.5/9.x versions, involved in analysing, tuning and developing complex ETL mappings.
• Worked on Target Designer, Mapping Designer, Mapplet Designer, Workflow Manager and Workflow Monitor. Expert skills in Data extraction, transformation, loading with heterogeneous source systems like Flat files, Excel, XML, Netezza and Oracle database.
• Was also involved in Informatica Admin activities such as bouncing Informatica services, migrating the ETL codes across multiple repositories.
• Proficient with Oracle, Netezza database and also involved in Tuning the SQL code and creating complex functions and procedures
• Was also extensively involved in analysing and fixing the production issues/bugs/ defects, enhancements and Quality Management.
• Good exposure to reporting tools such as Tableau, Business Objects and Qlikview.
• Ability to work with a team distributed over locations, capable of meeting stringent deadlines and work under pressure.
• Excellent Communication and interpersonal skills, professional ability to work independently and as well as within a team.

TECHNOLOGY:

Methods: Windows 7/XP/2000

ETL Tools: Informatica Power Center 7.x,8.x,9.x,10.x SQL Developer, Toad, SQL, Performance Tuning, SunOS

Reporting Tools: Business Objects, Qlikview, Tableau, LINUX

DB: Oracle, Netezza, My SQL

Scheduler: DAC, Crontab, Control M

Migration: Kintana

PROFESSIONAL EXPERIENCE:

Confidential

Computer Programmer

Responsibilities:

• Closely worked with the Business Analyst to understand the business requirements
• Analyzing the production issues and provides the root cause and solution.
• Log the issues and project deliverable in Jira and update the activities frequently
• Closely work with the Admin team to resolve the issue related to Informatica, Netezza Database, oracle 12 C and other tools
• Service now is the ticketing tool to raise the request for the above admin problems.
• Responsible in code review, QA activities and Validation of workflows in Informatica.
• Extensively used PL/SQL developer and MS excel in data validation
• Co - ordinate with the Off shore team and report any issue in loading and extraction of data from IP datamart sources
• Responsible for design, development and enhancement of the Informatica mappings and mapplets.
• Responsible for creating mapping design document and ETL Unit test case for the mapping and executing the test case created by another team member.
• Responsible for tuning the ETL code, re apply the logic using different set of transformations, using SQL overrides, partitions, increasing block size, data cache size and target based commit interval.
• Responsible for creating the Data mod scripts to fix the bugs, as well as update the data for enhanced or modified tables.
• Responsible for creating the Deployment groups and code migration across various environments that includes Production.
• Responsible to add Task i.e. workflows and create Jobs in Control M and also involved in Monitoring the Non-Prod jobs through Control M
• Developed Simple Tableau reports to compare the data between Netezza and Oracle
• Created Qlikview reports on Netezza and Oracle driving views and analyzed the source side bottle necks
• Analyzed the IP analytics Qlikview reports data loaders and assisted in tuning the performance of the same.

Confidential

Computer Programmer

Responsibilities:

• Closely worked with the Business Analyst to understand the business requirements
• Analyzing the production issues and provides the root cause and solution.
• Responsible in code review, QA activities and Validation of workflows in Informatica.
• Extensively used PL/SQL developer and Toad in data validation
• Co-ordinate with the Off shore team and report any issue in loading and extraction of data from QCT sources
• Responsible for design, development and enhancement of the Informatica mappings and mapplets.
• Responsible for creating mapping design document and ETL Unit test case for the mapping and executing the test case created by other team member.
• Responsible for tuning the ETL code, re apply the logic using different set of transformations, using SQL overrides, partitions, increasing block size, data cache size and target based commit interval.
• Responsible for creating the Data mod scripts to fix the bugs, as well as update the data for enhanced or modified tables.
• Also created Queries used to generate the data Quality Alerts
• Responsible for creating the Deployment groups and code migration from DEV/DV2 to TST/TS2 environment.
• Responsible to add Task i.e. workflows and create Jobs in Control M and also involved in Monitoring the Non-Prod jobs through Control M
• Attended Tableau developer training session conducted by Tableau in 2017
• Developed Simple Tableau reports using the sources
• Created custom Qlikview report for analyzing the Production issues related to Netezza target and Oracle source system

Confidential

Computer Programmer

Responsibilities:

• Monitoring the below of BI L2 supporting applications
• Availability of the front end reporting tools /pages
• Informatica jobs, Cron jobs.
• BMC remedy ticketing tool
• Responding to the user request and alert mails from application alert groups.
• Analyzing the issues in Informatica Jobs, UNIX cron Jobs, Front end reports and providing root cause to the appropriate team.
• Un-Scheduling, scheduling, restarting the ETL and UNIX jobs.
• Notifying the Unavailability of application front end pages or URL's to the Business Users.
• Working with DBA and Unix Support team to fix the issues.
• Providing the required data to the Business users by executing the equivalent reporting queries during down time or issue with the reporting tool or front end pages
• Provide the requested files such as Logs, configuration files, scripts to other support teams.
• Bouncing the Informatica Services, Tomcat Services, Power Analyzer services.
• Admin activities in Informatica through Admin Console such as OS Profiles configuration, creation of User, User Groups and enabling or disabling informatica services etc..
• Migrating Informatica objects across Repositories, PL /SQL code, scripts across UNIX servers.(Such as Prod, QA,Dev)
• Migrating WAR files of TomCat Server from QA to Production Linux Servers.
• Configuring the cron Jobs in UNIX server, changing the credentials of Interface accounts, group accounts of Unix/Linux frequently.
• Documenting the L2 issues, creating or Updating the SOP's used in L2 and CM support process and tracking RMT tickets to provide weekly status.

Confidential

Computer Programmer

Responsibilities:

• Closely worked with the Business Analyst to understand the business requirements and assisted in analyzing the OUT of the Box ETL coding.
• Responsible for design, development and enhancement of the Informatica mappings and mapplets.
• Responsible for creating mapping design document and ETL Unit test case for the mapping and executing the test case created by other team member.
• Enhanced performance for Informatica session using SQL overrides, partitions, increasing block size, data cache size and target based commit interval.
• Responsible for creating the DDL scripts for the Custom tables created according to the requirement and also for enhanced tables.
• Responsible for migrating the ETL code i.e workflows, sessions and mappings from DEV to UAT environment.
• Extensively used PL/SQL developer and Toad in data validation.
• Responsible to add Task i.e. workflows and create Subject areas and Execution plan in DAC and run the same.
• Coordinate with the off shore team and report any issue in loading and extraction of data from the OLTP or OLAP sources.
• Participated regularly in meeting with the team members for analysis and prevention of defects
• Attended the Application training on OBIEE as a part of the project requirement.

Confidential

Computer Programmer

Responsibilities:

• Responsible for design, development and support activities in Informatica
• Involved in creating complex mappings using Unconnected Lookup, Sorter, and Aggregator.
• Lookup and Router transformations for populating target table in efficient manner and Testing and Validation of workflows in informatica.
• Performed manual, Unit, Integration, System, Load, Performance, Stress and Acceptance Testing
• Coordinate with the Off shore team and report any issue in loading and extraction of data from EDI sources