SUMMARY

• 8+ years of experience in Information Technology and 2+ years at Onsite with a strong background in Data warehousing using Informatica PowerCenter/DataIntegrationHub/IDQ/EDC/AXON/BDM 10.x/9.x/8.x.
• Hands on Informatica 10.x/9.x installation, configuration, debugging, tuning and administration.
• Extensive knowledge on IDQ installation, configuration and developed profiles, score cards, mapping and workflows to prove the quality of data.
• Hands on experience in AXON and EDC installation and configurations, bulk upload, creating and scanning the resources.
• Hands on experience in the BDM environment on creating mapping and executing in Hadoop environment using spark engine.
• Proven experience as an Informatica Admin on Node, Grid and High availability configurations, LDAP authentication security,monitoring resource utilization and proactively identifying Informatica job performance and resource issues network, disk usage, memory usage, server side limitation
• Proficient in Operational and Dimensional Modeling, ETL Extract, Transform and Load processes, OLAP On - line Analytical Processing
• Highly experienced in working and managing projects in Onsite-Offshore models. Proficient in handling and meeting client expectations.
• Expertise on Service Now incident Management and Change Management process
• Hands on UNIX Shell Scripting and administrative commands including server lever activities automation
• Expert in typical Admin jobs like Migrations, FTP requests, Performance tuning, Installation of patches, hotfixes and upgrading the tool.
• Configured OS profiles in Integration services for workflows runs.

TECHNICAL SKILLS

ETL Tools: Informatica 10.2/10.1/9.6/9.1/8.6.1 (Power Center) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect),DIH,IDQ(Developer,Analyst),BDM (Big data developer,Analyst)

Data Modeling: Erwin 4.0/3.5, Star Schema Modelling, Snow Flake Modelling.

Databases: Oracle 11i/10g/9i/8i, MS SQL Server 2005/2000, DB2, Netezza,Hive

Reporting Tools: Tableau

Languages: SQL, PL/SQL, Unix Shell Script,JAVA

Operating Systems: Windows 10/8, AIX, Red hat Linux

PROFESSIONAL EXPERIENCE

Confidential

Sr. Software Engineer

Responsibilities:

• Integrating Informatica platform with Hadoop environment
• Establishing the connection setup to consume Hadoop environment data for IDQ profiling and data quality assignments
• Interact with Informatica vendor on the performance improvement in the IDQ platform
• Understand the business needs on the Data quality profiling and providing solutions
• End to End workflow creation to automate the Auto refresh process for metadata loads into EDC
• Extracting the metadata from Confidential applications and load it into EDC for metadata Management purposes
• Involved in writing shell scripts to schedule, automate the IDQ jobs.
• Involving in developing IDQ Applications jobs for ODI Sanctions migration project and changing existing code based on business needs.
• Address issues/requests from IDQ Application teams with answers for queries.
• Conduct reviews, identify gaps, and recommend and implement change to release and change management policies on a regular basis.
• Documentation of all the efforts with root cause analysis and review

Environment: Informatica DIH,AXON,EDC,IDQ 10.2x

Confidential

Informatica Lead

Responsibilities:

• Understand the business functionality and analysis of business requirements in terms of information management support services/systems.
• Interact with business community and gathered requirements based on changing needs, Informatica capacity planning and design
• Installation of Informatica power center/DIH/IDQ/BDM/AXON/EDC and setup services and client tools
• Configure and optimize all aspects of Informatica platform Server suit, including policies, control standards, procedures and dashboards.
• Integrating Informatica platform with Hadoop environment
• Involved in writing shell scripts to schedule, automate the ETL jobs.
• Administer projects, roles, user, and privileges across all three environments.
• Configure and setup LDAP security integration with Informatica
• Configured Master Node and Backup nodes under High Availability environment
• Informatica repository and domain backup/restore
• Monitor Informatica platforms Performance across all three Environments and taking necessary actions in case of File system/permission/space issues
• Involving in Supporting ETL Applications production jobs and changing existing code based on business needs.
• Perform monthly scheduled maintenance activities
• Extensively worked on multiple data management projects with onsite and offshore development Teams.
• Having hands on software upgrades in BIDW (ETL Informatica V 9x/10x) and Citrix/Windows servers which includes upgrades, patches, OS level upgrades etc
• Review code going into production for accuracy, maintain Informatica with multiple nodes
• Define standards and Processes to be followed by ETL technical Teams
• Address issues/requests from Application teams with answers for queries.
• License compliance maintenance and update as necessary
• ETL Metadata analysis for user queries and business reports
• Develop detail implementation and Roll-back plans for major releases.
• Manage schedule of production changes, forward schedule of change.
• Conduct reviews, identify gaps, and recommend and implement change to release and change management policies on a regular basis.
• UNIX shell scripting, for various functions such as maintenance, backup, and server health checks
• Documentation of all tickets/Project/Administration issues with root cause analysis and review

Environment: Informatica Power Center,DIH,AXON,EDC,IDQ,BDM 10.2 Hadoop - Hortonworks Data platform 2.5

Confidential

Sr. Informatica Developer/Administrator

Responsibilities:

• Involved in gathering requirements from the end users.
• Understand business needs and implement the same into a functional database design.
• Extensively used almost all of the transforms of Informatica for various types of data conversions and Sourced data from mainframe legacy systems
• Developed and test all the backend programs, Informatica mappings and update processes.
• Review code going into production for accuracy, maintain Informatica with multiple nodes
• Extensively Worked on Informatica Server and Client components such as Informatica Admin Console, Repository Manager, Power Exchange Navigator, Designer, Workflow Manager, and Workflow Monitor for ETL Development and Administration activities.
• Responsible for configuring the workflow tasks like EMAIL task, Command task and make it reusable for other team members.
• Worked with various teams to plan, coordinate and implement system patches and minor upgrades to Informatica to maintain integrity of systems.
• Installed Informatica 9x and configured services
• Upgraded repository from 9x to 10x
• Coordinated with Database Admin to create appropriate indexes for faster execution of jobs.
• Performed user and security administration.
• Experience in UNIX shell scripting, for various functions such as maintenance, backup, and configuration.
• Involved in installing Informatica client tools, changing license details.
• Analysis and design of ETL processes.
• Involved in ETL design, development, Testing and Implementations.

Environment: Informatica Power Center 9x/10x, IDQ, Oracle 10g, Mainframes, DB2, MS SQL Server 2005, Toad, PL/SQL, SQL, XML, AIX