SUMMARY

• As an experienced IT professional with over 8+ 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, Informatica IDQ, Developer tool and Analyst tool.
• Experience with INFORMATICA EIC/EDC & AXON- Installation, Administration and development.
• Excellent hands-on experience with INFORMATICA EIC/EDC 10.5 & AXON 7.2
• Experience implementing composite services, data mapping and informatica BDM performance tuning
• Experience with ETL Data Extraction and HADOOP integration using informatica BDM platform
• Extensive experience in creating Business Glossary and integration with enterprise level applications with INFORMATICA EIC/EDC 10.5 & AXON 7.2
• Experience with an appliance-based RDBMS i.e. Oracle, SQL Server, Teradata and Netezza 6.0/7.1
• Have Unix Shell scripting experience
• Understanding of Data governance concepts, Stewardship, process, and capabilities
• Knowledge in Java/J2EEE/Web services and able to integrate the with Data governance tool knowledge of EAI, SOA and ETL data integration methods.
• Demonstrated ability to design and implement Data governance tool set using INFORMATICA EIC/EDC 10.5 & AXON 7.2
• Understanding of Data Quality and Governance issues around INFORMATICA EIC/EDC 10.5 & AXON 7.2 implementation
• Expertise in informatica BDM architecture. Create informatica BDM 10.2 mappings and Workflows
• Brings in hands-on technical experience with INFORMATICA EIC/EDC 10.5 & AXON 7.2 technical capabilities
• Implement INFORMATICA EIC/EDC 10.5 & AXON 7.2 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 development teams to implement functional and non-functional requirements.
• Experience in to view the changes in the target databases tables in snowflake
• Experience in build the Logical and Physical data model for snowflake as per the changes required
• Have Java programming skills with adequate knowledge of object-oriented technology. Hands on experience designing and developing informatica BDM solutions
• 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
• Drives architectural consensus with the team while maintaining awareness with other teams
• Expert level of technical knowledge on Data architecture and data integration
• Exposure to and conceptual understanding of Data integration tools and technologies
• Knowledge on Web based development technology- Html, DHTML, VB script, Jscript, XML Webservices, SOAP
• High level expertise on web services for data integration.
• Strong Architectural knowledge in Data Management and Data Warehouse/Business Intelligence design and development. Implemented and lead projects at all stages of SDLC. Managed offshore onsite resources.
• Good working knowledge of Agile Development
• Proficient in SEI-CMM standards of quality assurance. Good knowledge of GISB, SOX, HIPAA standards.
• Excellent documentation skills for Database Design Document, Technical design document.
• Engaged by several clients to understand and reengineer their business processes

TECHNICAL SKILLS

Operating Systems: UNIX, RHEL, HP-UX, IBM-AIX, WINDOWS XP/NT/ 2000/98/95

ETL Tools: Informatica Power Center 7.x/8.x/9.x, Power Exchange, Microsoft DTS and SSIS.

Analysis/Reporting Tools: Microsoft Analysis Services, Microsoft Reporting Services and Business Objects.

Application Servers: Oracle 9iAS, Web logic, Web sphere, IIS, Apache, Tomcat.

Data Modeling: ER Studio, All-Fusion Erwin, Visio.

Scripting Languages: Java Script, VB Script, Power Shell and UNIX Shell Scripting.

Data Cleansing: Trillium, First logic.

DataModelling/Methodologies: Logical/Physical/Dimensional, Star/Snowflake, ETL, OLAP, Complete Software Development Cycle.

Databases: Oracle 10g/9i/8i, MS SQL Server 7.0/ 2000/2005/2008/2012 , DB2,MS Access, Excel.

DB Tools: SQL*Plus, SQL* Loader, TOAD.

Languages: C, C++, Java, SQL, PL/SQL, T-SQL, HTML, DHTML, XML, UNIX, Shell Scripting, Visual basic, XML.

Scheduling Tools: Cisco Tidal Enterprise Scheduler, Informatica Scheduler

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Sr. Developer

Responsibilities:

• Experienced in Informatica Data Governance professional and skilled in Data Cataloging, Data Governance, Metadata Management, and Data Quality implementations.
• Have extensive experience in Data Governance tool set - Informatica EDC & AXON, Analytics DS, Collibra
• Involve in Data modeling,, building web services and Data Governance activities.
• Experience with INFORMATICA EIC/EDC & AXON- Installation, Administration and development.
• Hands-on experience with INFORMATICA EIC/EDC 10.5 & AXON 7.2
• Excellent planning, requirements gathering, design, develop, test and maintenance of the different environments like DEV, QA and PROD.
• Implement Informatica IDQ, Data Governance. Install, Configure and Implement Informatica EDC 10.5, AXON 7.2 and IDQ 10.5
• Hands-on experience with INFORMATICA EDC 10.4 & AXON7.2- Installation, Administration and Development. Implement best practices of Data Governance using INFORMATICA EDC 10.5 & AXON 7.2
• Experience in Informatica Data Governance Tools set of AXON 7.2, EDC 10.5, IDQ, Developer tool and Analyst tool.
• Integrated EDC with Axon, allowing IT and Business to share technical and business knowledge seamlessly. Demonstrated end-to-end data lineage and performed impact analysis.
• Worked on to create different resources in EDC across all the databases in the organizations like MS SQL, Oracle, IBM DB2, Snowflake, Mongo db., and PowerCenter using EDC admin.
• Worked on to create a data domains and data domain groups based on column/data rules in EDC admin.
• Experience in onboarding the data from EDC to AXON using data onboarding rules
• Experience in integrating INFORMATICA EDC, AXON and IDQ with each other.
• Worked on to create different facets like glossaries, systems, datasets, policies, processes and data quality in Informatica AXON 7.2.
• Gather the requirements for creating Business Glossary, business terms, policies, business rules
• Experience in SQL, UNIX, Shell Scripting, Data Relationships, Data extraction Validation
• Worked on the bulk upload, bulk update, bulk delete, and publish of the objects in AXON 7.2
• Experience in data migration process from the DEV to PROD in AXON.
• Experience o DQ rules in IDQ and integrate with AXON 7.2
• Solid experience with Informatica IDQ -Data Quality suite (Developer, Analyst).
• Design IDQ Mapplets, Rules, Rule Specifications, Profiling and Scorecards.
• Design the DQ parameters/dimensions like Completeness, Conformity, Consistency, Accuracy and Uniqueness using IDQ Developer and Analyst tool.
• Experience in creating a Local and Standards DQ rules in AXON 7.2

Environment: Informatica EDC 10.5, AXON 7.2, Informatica IDQ 10.5, Oracle SOA, TFS, PL/SQL, Redhat Linux 7.2, ANSIBLE, JENKINS, Putty, JIRA Project Management Tool, Microsoft SQL.

Confidential, Plano, TX

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 Analytics DS and Collabra Data Governance tools. Create POC & PEM -Product Evaluation Matrix.
• Implement Informatica IDQ, Data Governance. Install, Configure and Implement Informatica EDC 10.5, AXON 7.2
• 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 .
• To view the changes in the target databases tables in snowflake
• Build the Logical and Physical data model for snowflake as per the changes required
• 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 issues

Environment: Informatica 10.2, EIC 10.2, AXON 5.4, Informatica MDM 10.2, Oracle SOA, TFS, PL/SQL, Redhat Linux 5.5, ANSIBLE, JENKINS, WebLogic 10.3.2, Sun JDK, MQ, Putty, Netezza 6.0/7.1, JIRA Project Management Tool, ORACLE 12C, java, UC4 Scheduling Tool and ERWIN

Confidential, Pleasanton, CA

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 activities in all environment and migrating the code from one environment 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 Analytics 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

ETL 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.
• 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
• Used IDQ transformations to achieve Data Quality. Extensively used Informatica Developer tool and Analyst tool
• Work with IDQ related tasks such as Data analysis, Data cleansing, Data matching, Exception handling, Create DQ Scorecards. Expert at ERWIN for developing Data models for OLTP/OLAP
• Work with IDQ transformations related to Data Cleansing, Exception Handling, Null values Handling, Data de-duplication, Data Validation, Data Scrubbing using Informatica Developer tool.
• Effectively used Labeler, Parser, Standardizer, Case Converter, Match, Address Validator, Comparison, Consolidation, Marge, Bad record Exception transformations in IDQ.