SUMMARY:

• As an experienced IT professional with over 7+ years of experience in requirement gathering, Design, Development. Work as Sr. developer for Data Governance and ETL technologies. Proven experience with Data Modeling, Data Governance, ETL Design, Data Quality. Excellent customer facing experience. Work with AGILE and Onsite - Offshore model.
• Experience in Data Modeling, Data Governance, ETL Design, Data Quality
• Have excellent experience in Data Governance tool set - Informatica EDC & AXON, Analytics DS, Collibra
• Involved in the projects like Data modeling, building web services and Data Governance activities.
• Experience with INFORMATICA EIC/EDC & AXON- Installation, Administration and development.
• Excellent hands-on experience with INFORMATICA EIC/EDC 10.2 & AXON 5.4
• Well worked with INFORMATICA BDM 10.2 ETL design. Work with HADOOP eco system.
• Experience implementing composite services, data mapping and informatica BDM performance tuning
• Experience with ETL Data Extraction and HADOOP integration using informatica BDM platform
• Expertise in informatica BDM architecture. Create informatica BDM 10.2 mappings and Workflows
• Brings in hands-on technical experience with INFORMATICA EIC/EDC 10.2 & AXON 5.4 technical capabilities
• Implement INFORMATICA EIC/EDC 10.2 & AXON 5.4 recommendations & best practices
• Demonstrates expertise with informatica BDM 10.2 data integration into downstream applications, systems and consumers using various options, and be able to come up with the best suitable option based on project needs
• Analyze current business practices, processes and procedures, perform assessments and identify future business opportunities for leveraging informatica BDM 10.2 platform capabilities.
• Translate business needs into master data solutions utilizing process flows and data flow techniques.
• Understand business requirements and create technical design and specifications.
• Collaborate with project leadership and developmen

PROFESSIONAL EXPERIENCE:

Confidential

Sr.Developer

Responsibilities:

• Excellent SDLC Skills - Planning, Requirement gathering, Design, Development, Testing and maintenance of reporting environment. Analyze current business practices, processes and procedures, perform assessments and identify future business opportunities for leveraging informatica BDM 10.2 platform capabilities. Excellent experience with EIC, AXON, IDQ, BDM 10.2 and BDQ. Extensively work with Analytix DS and Collibra Data Governance tools. Create POC & PEM -Product Evaluation Matrix. Implement Informatica IDQ, Data Governance. Install, Configure and Implement Informatica EDC 10.4, AXON 7.0 Done Installations, Upgrades, Patch management, security management and user management with informatica stack - Power Center, IDQ, MDM, DEI/BDM and EDC10.4+AXON 7.0 Hands-on experience with INFORMATICA EDC 10.4 & AXON 6.2/7.0- Installation, Administration and Development.
• Implement best practices of Data Governance using INFORMATICA EDC 10.4 & AXON 6.2/7.0 Implement INFORMATICA EDC 10.4 & AXON 6.2 recommendations & best practices Design Business Glossary and integration with enterprise level applications with INFORMATICA EDC 10.4 & AXON 6.2/7.0. Work with Version management, GIT, ANSIBLE, Jenkins and CI/CD process. Solid experience with Informatica IDQ -Data Quality suite (Developer, Analyst). Design IDQ Mappings. Design IDQ Workflows. Work with IDQ Transformations to Cleanse, Scrub and Standardizing the data Profiling Data Sources using IDQ developer analyst Informatica PowerCenter tools such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager. Working on transformations like Source Qualifier, Expression, Aggregator, Router, Filter,
• Update Strategy, Lookup, Sorter, Normalize, Union, Stored Procedure, and Sequence Generator, Slowly Changing Dimensions. Scheduling and Creating Workflows, sessions involved in the Performance Tuning of Mappings Sessions. SQL, UNIX, Shell Scripting, Data Relationships, Data extraction Validation. Debugging, troubleshooting, monitoring and performance tuning in SQL queries. Having Experience in Informatica Infrastructure administration. Having production support experience on Informatica PowerCenter, IDQ & MDM -Admin with UNIX/TERADATA environment Experience with data governance (stewardship, lineage, and quality) in an integrated enterprise architecture Work with Installation, Administration, users and user group creation for EIC/EC 10.2 and AXON 5.4 Work with Installation, Administration, Upgrades and patch management with INFORMATICA BDM 10.2 Develop ETL mappings, Workflows using INFORMATICA BDM 10.2 Work with BLAZE, SPARK and HIVE modes for the ETL transformations using INFORMATICA BDM 10.2 Done performance tuning for INFORMATICA BDM 10.2 mappings and fixed the issuesEnvironment: Informatica 10.2, EIC 10.2, AXON 5.4, Informatica MDM 10.2, Oracle SOA

Confidential

Sr.Developer

Responsibilities:

• Have extensive experience in INFORMATICA EIC/EC 10.2 and INFORMATICA BDM 10.1 Coordinating with clients, interfacing teams, database Administrators to get a detailed understanding of existing functionality and system requirements supporting informatica admin activties in all environment and migrating the code from one evironment to another environment Experienced in Administration tasks like, installation, upgradation, deployments, users adding, Outages & monitoring the applications in all environments. Daily support in resolving issues and CRs implementation for around 50 applications Working as Onshore Lead and managing offshore team for coordinating issues and helping resolves issues to the client Prepared the work estimates, and managing the resources at onshore Prepared Business required documents, Prepared test plan documents, test cases, Test scripts for
• Development & Migration project and tested accordingly Design, implementation and management of security access roles and privileges for all types of metadata consumers. Design and development of Metadata Repository backup/recovery strategy. Development of processes and guidelines for Metadata management - change management, metadata access and sharing. This will include processes and capabilities for versioning all forms of metadata. Configuration of Landing, Staging and Loading processes, Trust and Validation rules, Match and Merge process Created Unix scripts to Execute Batch jobs and Batch Groups Extensively work with Analytix DS Data Governance tool. Crate POC & PEM -Product Evaluation Matrix. Proven track record implementing successful Data Governance initiatives Experience with Data Governance, Data Quality, data management principles, processes and systems. Well worked with INFORMATICA AXON & EIC/EDC. Solve the issues with integration, Development Well worked with INFORMATICA AXON & EIC/EDC Installation, Configuration and Logging Gather the requirements for creating Business Glossary, business terms, policies, business rules Work with Source to Target mappings using Informatica BDM. Work with INFORMATICA EIC/EDC. Create Mapping specifications, Rule specifications in the Informatica analyst client.Environment: Informatica 9.6.1/10.0, INFORMATICA AXON 5.X & EIC/EDC 10.0, PL/SQL, Redhat Linux, WebLogic 10.3.2, Sun JDK, MQ 7.01, Putty, Teradata 16.1, Cloudera HADOOP- JIRA Project Management Tool, ORACLE12C, java, AutoSys and ERWIN 9.1.

Confidential

Sr.Developer

Responsibilities:

• Excellent SDLC Skills - Planning, Requirement gathering, Design, Development, Testing and maintenance of reporting environment. Done performance tuning with IDQ. Well versed with UML, Usecase, Data Flow diagrams. Adopt Acord data model standards. Design Tableau Visualizations, Dashboards. Administer Tableau server. Ensures multi domain data modeling efforts are in-tune with Informatica MDM recommendations & best practices. Work with Informatica Metadata manager. Create Business Glossary in the Analyst client and integrate with Metadata manager. Translate business needs into ETL mappings utilizing IDQ. Work with Informatica Metadata Manager. Work with Impact and Lineage analysis using metadata manager Used Redshift Spectrum with Lake Formation. Have Unix Shell scripting, T-SQL experience Design NOSQL Data model for HBASE, CASSANDRA and MONGO DB. Understand business requirements and create technical design and specifications. Collaborate with project leadership and development teams to implement functional and non-functional requirements. Experience with large scale MDM systems, SAP BODS/BW, Oracle and TERADATA. Guides the project team in order to make the best use of Informatica MDM tool suites data quality, integration and Match-Merge capabilities. Work with IDD and IDD configurations. Have Java programming skills with adequate knowledge of object-oriented technology. Hands on experience designing and developing MDM solutions using Informatica MDM platform Experience with Informatica MDM multi domain implementation. Work with MDM Tokenization, Match, merge, un-merge, MDM SIF and user exits. Extensive experience in creating messaging and web services on MDM platform Experience with an appliance-based RDBMS i.e.
• Oracle, SQL Server and Netezza. Understanding of MDM concepts, process, algorithms and capabilities Knowledge in Java/J2EEE/Web services and able to integrate the Informatica MDM with other applications. Design and implement physical MDM with Customer Master, Sales master. Designs modifications to existing software while minimizing customization, designs reusable components, and elimination of redundancy in designs throughout their team's environment Responsible for multiple large projects in leading the definition, selection, and implementation of enterprise tools, technologies, and processes. Schedule ETL jobs using UC4 scheduling tool. Knowledge on Web based development technology (e.g. Html, DHTML, VB script, Jscript, Asp 3.0, Interdev) and XML Webservices (XML, SOAP, XSL, XSD, WSDL, DTD). Experience with SAP BODS ETL tool Applied Informatica MDM tokenization, Match & Merge method for Data deduplication. Applied Auto & Manual merge and Un-merge on the records using MDM. Design ETL using SAP BODS. Analyzed the business, gathered user requirements for the creation of Corporate Enterprise Data warehouse. Designed Modelling, Loading Strategy for ETL flow for new projects.

Confidential

Admin/Developer

Responsibilities:

• Excellent SDLC Skills - Planning, Requirement gathering, Design, Development, Testing and maintenance of reporting environment. Analyzing the requirement given by client and Responsible for design and development of Data Warehouse project leveraging Informatica Power Center ETL tool Extensively

  worked in the performance tuning of SQL, ETL and other processes to optimize session performance. Worked extensively on transformations like Lookups, Aggregator, Update Strategy, Sequence generator, Joiner transformations Created Test plan documents and test scripts and tested SIT/UAT Environment. Demonstrated experience with design and implementation of Informatica (IDQ v9.1), Data Quality applications for the business and technology users across the entire full development life-cycle. Knowledge of IDQ 9.1 standards, guidelines and best practices. Knowledge of Data Profiling guidelines and best practice Carrying out User Acceptance Testing of the codes. Played key role in Development environment Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer. Worked with Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of Informatica Power center. Providing daily status updates to the Onsite coordinator. Applied Auto & Manual merge and Un merge on the records. Analyzed the business, gathered user requirements for the creation of Corporate Enterprise

  Data warehouse. Designed Modelling, Loading Strategy for ETL flow for new projects. Expertise in End to END project Implementation from Requirement gathering phase to Production deployments Highly proficient in using complex Stored Procedures, Triggers, Index, Views, User Functions, SQL joins, Relational Database Systems following Data Integrity and normalization