SUMMARY

• 7 years and 5 months of experience in teh IT industry in teh areas of Analysis, Development, Enhancement and Supporting Informatica, Data Integration Hub, Tableau and Oracle Endeca Tools
• Result - oriented Software Engineer comfortable switching between architecture,design and Implementation
• Interaction wif Customer to gather requirements, Data Collection, Data Analysis, Data Wrangling as part of Analysis.
• Developed mappings/reusable objects/transformation/mapplets by using mapping designer, mapplet designer in Informatica Power Center 10.x
• Possess work experience in Informatica PowerExchange
• Having noledge on Informatica Intelligent Cloud Services(IICS)
• Possess good noledge in Snowflake and Amazon Web Services
• Experienced at working in teams or self-directed environments
• Worked in Agile process and has good noledge in Jira and Confluence.
• Developed Data Marts to build teh self-service dashboards using Tableau to deliver teh operational reports to Business
• Created Hyper(Extract) files for Tableau Dashboards for quick responsiveness
• Applied Performance tuning on Large Volume Data Set Tableau Reports
• Good analytical and critical thinking skills, capable of learning new technologies quickly
• Reliable, responsible, hard working and good team player

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 10.x, Data Integration Hub 10.x, PowerExchange 10.x

REPORTING TOOL: Tableau 2019.x

Databases: PL/SQL, SQL, PostgreSQL, Oracle 11g/12g

SCRIPT LANGUAGE: Unix Shell Scripting

CLOUD: Amazon Web Services, Snowflake

PROFESSIONAL EXPERIENCE

Confidential, FRANKLIN, TN

SENIOR INFORMATICA CONSULTANT

Responsibilities:

• Designing and developing of high available applications using Informatica PowerCenter, Data Integration Hub (DIH) and Tableau for Business Intelligence Reports
• Define coding standards/norms/best practices for teh application teams and assist them in clearing teh challenges which may come across various phases of teh project
• Assist development/application teams in scheduling Informatica jobs through automation scripts and Third Party Schedulers
• Review code developed by other Developers and provide input to and drive programming standards
• Working directly wif Client-side Business Analyst to gather teh requirements and coordinating wif teh offshore team to meet teh client requirements
• Extensively working wifPL/SQL, performance tuning ofOracle
• Experienced wif InformaticaPowerExchange for Loading/Retrieving data from mainframe systems
• Having noledge in migration activities from lower(Dev) to higher(Prod) environments
• Installation of EBFs (Emergency Bug Fixes) provided by Informatica to address teh tool related issues
• Provided automation ideas to perform repository back-ups periodically and purge unnecessary log files/temp files through custom built scripts
• Handle database outages/UNIX server outages wif in teh defined window and TEMPeffectively communicate to development/application teams to ensure smooth execution of teh delivery
• Analyze and provide data metrics to management in order to halp prioritize areas for data quality improvement
• Build/Test Mappings and Workflows to implement data stewardship and exception processing
• Built Tableau dashboards to show up teh daily sales as per teh client requirement
• Perform both record-level and large-scale manual additions, adjustments and corrections to continuously ensure overall data quality and integrity
• Optimization of huge data loads by making few tweaks to teh existing designs
• Providing different data insights to technical team for optimal design and development
• Working wif data architect and providing suggestions for Data Modelling
• Working wif Solution architects and Business Users for migrating existing on-premise Data warehouse to Cloud based Data warehouse
• Participate in improvement of master data management process and support transactional systems and processes
• Worked in Agile methodology and leading a team of 5 members

Confidential

INFORMATICA DEVELOPER

Responsibilities:

• Participated in design, development, testing, automation, and support of manufacturing domains
• Providing accurate work estimates and work to deliver on time
• Provides assistance in root cause analysis for service interruptions
• Participate in managing code and configurations for multiple environments, release management process, maintaining environment configurations and controls, and code integrity
• Tuned performance of mappings by following Informatica best practices and applied several methods to get best performance by decreasing teh run time of workflows
• Identified Bottlenecks in ETL Processes, improved teh Performance of teh production loads and data access using Database Tuning, Index Usage
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration, and user acceptance testing
• Coordinated wif onshore & offshore development team to build teh deliverables and track/report teh status to project management on weekly basis

Confidential

Endeca DEVELOPER

Responsibilities:

• Developed code using Oracle Endeca, Oracle, Unix shell scripts, PL/SQL and scheduling tools
• Worked on both Clover ETL and studio of Endeca
• Good working noledge on Oracle Endeca Information Discovery, Oracle Endeca Guided Search, Oracle Integrator Designer, Endeca Developer Studio
• Have been involved in Customization of Oracle Endeca Latitude Studio
• Worked on Oracle Endeca Text Enrichment
• Worked on Testing and Validation of Endeca Reports
• Working noledge in SQL
• Comprehensive problem solving abilities wif good Communication and Interpersonal Skills
• Proficient noledge of applicable development domain