SUMMARY

• As an experienced IT professional wif over 8+ years of experience in requirement gathering, Design, Development.
• Work as Sr. developer for Data Governance and ETL technologies. Proven experience wif Data Modeling, Data Governance, ETL Design, Data Quality. Excellent customer facing experience.
• Work wif AGILE and Onsite - Offshore model.
• Experience in Data Modeling, Data Governance, ETL Design, Data Quality
• Has excellent experience in Data Governance tool set - Informatica EDC & AXON, Informatica IDQ, Developer tool and Analyst tool.
• Experience wif INFORMATICA EIC/EDC & AXON- Installation, Administration and development.
• Excellent hands-on experience wif INFORMATICA EIC/EDC 10.5 & AXON 7.2
• Experience implementing composite services, data mapping and informatica BDM performance tuning
• Experience wif ETL Data Extraction and HADOOP integration using informatica BDM platform
• Extensive experience in creating Business Glossary and integration wif enterprise level applications wif INFORMATICA EIC/EDC 10.5 & AXON 7.2
• Experience wif an appliance-based RDBMS i.e. Oracle, SQL Server, Teradata and Netezza 6.0/7.1
• Has Unix Shell scripting experience
• Understanding of Data governance concepts, Stewardship, process, and capabilities
• Knowledge in Java/J2EEE/Web services and able to integrate teh wif 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 wif INFORMATICA EIC/EDC 10.5 & AXON 7.2 technical capabilities
• Implement INFORMATICA EIC/EDC 10.5 & AXON 7.2 recommendations & best practices
• Demonstrates expertise wif informatica BDM 10.2 data integration into downstream applications, systems and consumers using various options, and be able to come up wif teh 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 wif project leadership and development teams to implement functional and non-functional requirements.
• Experience in to view teh changes in teh target databases tables in snowflake
• Experience in build teh Logical and Physical data model for snowflake as per teh changes required
• Has Java programming skills wif 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 teh definition, selection, and implementation of enterprise tools, technologies, and processes
• Drives architectural consensus wif teh team while maintaining awareness wif 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.
• Has 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 wif INFORMATICA EIC/EDC & AXON- Installation, Administration and development.
• Hands-on experience wif INFORMATICA EIC/EDC 10.5 & AXON 7.2
• Excellent planning, requirements gathering, design, develop, test and maintenance of teh 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 wif 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 wif 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 teh databases in teh 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 teh data from EDC to AXON using data onboarding rules
• Experience in integrating INFORMATICA EDC, AXON and IDQ wif each other.
• Worked on to create different facets like glossaries, systems, datasets, policies, processes and data quality in Informatica AXON 7.2.
• Gather teh requirements for creating Business Glossary, business terms, policies, business rules
• Experience in SQL, UNIX, Shell Scripting, Data Relationships, Data extraction Validation
• Worked on teh bulk upload, bulk update, bulk delete, and publish of teh objects in AXON 7.2
• Experience in data migration process from teh DEV to PROD in AXON.
• Experience o DQ rules in IDQ and integrate wif AXON 7.2
• Solid experience wif Informatica IDQ -Data Quality suite (Developer, Analyst).
• Design IDQ Mapplets, Rules, Rule Specifications, Profiling and Scorecards.
• Design teh 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 wif EIC, AXON, IDQ, BDM 10.2 and BDQ.
• Extensively work wif 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 wif Informatica stack - Power Center, IDQ, MDM, DEI/BDM and EDC10.4+AXON 7.0
• Hands-on experience wif 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 wif enterprise level applications wif INFORMATICA EDC 10.4 & AXON 6.2/7.0. Work wif Version management, GIT, ANSIBLE, Jenkins and CI/CD process.
• Solid experience wif Informatica IDQ -Data Quality suite (Developer, Analyst). Design IDQ Mappings.
• Design IDQ Workflows. Work wif IDQ Transformations to Cleanse, Scrub and Standardizing teh data
• Profiling Data Sources using IDQ developer analyst .
• To view teh changes in teh target databases tables in snowflake
• Build teh Logical and Physical data model for snowflake as per teh 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 teh 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 wif UNIX/TERADATA environment
• Experience wif data governance (stewardship, lineage, and quality) in an integrated enterprise architecture
• Work wif Installation, Administration, users and user group creation for EIC/EC 10.2 and AXON 5.4
• Work wif Installation, Administration, Upgrades and patch management wif INFORMATICA BDM 10.2
• Develop ETL mappings, Workflows using INFORMATICA BDM 10.2
• Work wif BLAZE, SPARK and HIVE modes for teh ETL transformations using INFORMATICA BDM 10.2
• Done performance tuning for INFORMATICA BDM 10.2 mappings and fixed teh 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:

• Has extensive experience in INFORMATICA EIC/EC 10.2 and INFORMATICA BDM 10.1
• Coordinating wif 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 teh code from one environment to another environment
• Experienced in Administration tasks like, installation, upgradation, deployments, users adding, Outages & monitoring teh 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 halping resolves issues to teh client
• Prepared teh work estimates, and managing teh 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 wif Analytics DS Data Governance tool. Crate POC & PEM -Product Evaluation Matrix.
• Proven track record implementing successful Data Governance initiatives
• Experience wif Data Governance, Data Quality, data management principals, processes and systems.
• Well worked wif INFORMATICA AXON & EIC/EDC. Solve teh issues wif integration, Development
• Well worked wif INFORMATICA AXON & EIC/EDC Installation, Configuration and Logging
• Gather teh requirements for creating Business Glossary, business terms, policies, business rules
• Work wif Source to Target mappings using Informatica BDM.
• Work wif INFORMATICA EIC/EDC. Create Mapping specifications, Rule specifications in teh 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 wif IDQ. Well versed wif 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 wif Informatica MDM recommendations & best practices.
• Work wif Informatica Metadata manager. Create Business Glossary in teh Analyst client and integrate wif Metadata manager.
• Translate business needs into ETL mappings utilizing IDQ.
• Work wif Informatica Metadata Manager. Work wif Impact and Lineage analysis using metadata manager
• Used Redshift Spectrum wif Lake Formation. Has 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 wif project leadership and development teams to implement functional and non-functional requirements. Experience wif large scale MDM systems, SAP BODS/BW, Oracle and TERADATA.
• Guides teh project team in order to make teh best use of Informatica MDM tool suites data quality, integration and Match-Merge capabilities. Work wif IDD and IDD configurations.
• Has Java programming skills wif adequate knowledge of object-oriented technology. Hands on experience designing and developing MDM solutions using Informatica MDM platform
• Experience wif Informatica MDM multi domain implementation. Work wif MDM Tokenization, Match, merge, un-merge, MDM SIF and user exits. Extensive experience in creating messaging and web services on MDM platform
• Experience wif 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 teh Informatica MDM wif other applications.
• Design and implement physical MDM wif 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 teh 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 wif SAP BODS ETL tool
• Applied Informatica MDM tokenization, Match & Merge method for Data deduplication.
• Applied Auto & Manual merge and Un-merge on teh records using MDM. Design ETL using SAP BODS.
• Analyzed teh business, gatheird user requirements for teh 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 wif 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 wif 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.