PROFESSIONAL SUMMARY:

• Over 9+ years of IT experience in various stages of SDLC includes Design,
• Development, Maintenance and Testing in Finance, Retail and Insurance sectors.
• Experience in enterprise RDMS D Confidential modeling techniques - Confidential, Dimensional modelingLogical and Physical d Confidential models.
• Experience in Informatica tools like PowerCenter, D Confidential Quality (IDQ) and Master D Confidential Management (MDM)
• Experience in D Confidential analysis, Cleansing, Standardization, visualization, integration, and reporting using BI tools.
• Experience in D Confidential ingestion into Big-d Confidential platform using Hadoop, Hive, No SQL and MapReduce.
• Experience in various D Confidential Sources - Big D Confidential, Terad Confidential, DB2, Oracle, &Mainframe.
• Experience in writing and maintaining SQL Scripts, PL/SQL and Stored programs.
• Experience in writing and managing UNIX shell scripts, C, Python and Perl scripts.
• Experience in scheduling ETL jobs with Control-M scheduler
• Extensively worked on ETL Performance tuning and debugging issues.
• Experience in creating End-to-end ETL design documents for d Confidential flow.
• Excellent Team Player with strong written, communication, and interpersonal skills.
• Experience in Client/Server application development.

SKILL SET:

RDMS d Confidential BASES: Oracle 9i/10g, DB2, SQL server 2008, Terad Confidential, Neteeza.

Big d Confidential tools: Hadoop, NO SQL, MapReduce, Oozie, Spark, Hive, Pig

Confidential base modeling: Oracle SQL Developer D Confidential Modeler, Toad D Confidential Modeler

etl tools: Informatica - PowerCenter 9.x, Power Exchange, IDQ, MDM, CONTROL-M scheduler.

Reporting tools: Micro-strategy, Web-Focus, Tableau and Excel reporting

Software languages: SQL, MySQL, PL/SQL, JavaScript, UNIX scripting, C, C++ Programming, HTML, and Python

WORK EXPERIENCE:

Confidential - Phoenix, AZ

IT Application Developer/ Specialist

Responsibilities:

• Identify, analyze and interpret trends or patterns in complex d Confidential sets.
• To maintain the consistency and quality of the d Confidential worked with D Confidential Governance, D Confidential profiling and D Confidential quality team that required managing the master d Confidential from all the business units as well as from IT and ensuring d Confidential quality standards across the enterprise.
• Create ETL processes and reports using Informatica suite (PowerCenter, IDQ, analyst, MDM) and other integration tools like SSIS, SSRS.
• Performing d Confidential management projects and fulfilling adhoc requests according to user specifications by utilizing d Confidential management software programs and tools like Toad, Excel and SQL.
• Involved in extensive D Confidential validation by writing several complexes SQL queries and involved in back-end testing and worked with d Confidential quality issues.
• Worked on Technical documentation process like preparing High Level Design Documents, Low Level Design Documents and Source to Target mapping sheets
• Developed complex mappings using Informatica to load Dimension and Fact tables as per D Confidential modeling techniques.
• Preparation and Review of Unit Test cases and Executing Unit test cases and documenting the results.
• Extensively used INFA PowerCenter Objects- Source & target designers, transformations, sessions, worklets, and workflows.
• Developed and tested ETL mappings based on used cases and tuned for better performance.
• Written and maintained UNIX shell scripts and SQL scripts.
• Helped SIT team & Business users in UAT and resolved issues and documented root cause and resolution in QA.

Environment: Informatica 9.6, Oracle, Perl Scripting, Unix Scripting, Confidential scheduler, Ruby Programming, Business Objects, Informatica Analyst, Informatica IDQ, UCD, LiquidBase, Confidential Infosphere

Confidential - Phoenix, AZ

ETL Application Architect

Responsibilities:

• Design the high level process and the tools required for ingestion, extraction and transformation
• Involved in ETL, D Confidential Integration and Migration from Heterogeneous source platform to d Confidential lake(cornerstone)
• Develop generic wrapper and automation scripts for maintenance and
• Develop complex Oozie XMLs to schedule HQL batches and SPARK jobs
• Create/implement Hive tables with Batch mode execution with incremental logic
• Develop programs to parse the raw d Confidential, populate staging tables and store the refined d Confidential in partitioned tables
• Configure event engine nodes for extraction polling via status nodes
• Configure SFTP profiles and file patterns for file uploads
• Prepare Ad-hoc Hive queries for d Confidential analysis to meet the business requirements.
• Implement test scripts to support test driven development and continuous integration.
• Documented all the solution architecture, Security interaction and detailed design documents.
• Manage ETL packages and ensured availability of the application to the Business users
• Support the application migration to production and provide support to teams during the post warranty period.

Environment: Hadoop 1.3, Hive 1.12, Spark, Pig, Oozie, Sqoop, informatica 9.6, Tableau, Magellan

Confidential - Phoenix, AZ

ETL Application Architect

Responsibilities:

• Involved and gathered business requirements and documented scope of the project and deliverables.
• Worked with Business users to understand reporting requirements and documents metric calculations information.
• Worked with technical teams for ETL platform setup and D Confidential model design and implementation.
• Designed ETL mappings to transform the raw d Confidential into desired format to report for Business users based on requirements.
• Extensively used INFA PowerCenter Objects- Source & target designers, transformations, sessions, worklets, and workflows.
• Developed and tested ETL mappings based on used cases and tuned for better performance.
• Written and maintained UNIX shell scripts and SQL scripts.
• Helped SIT team & Business users in UAT and resolved issues and documented root cause and resolution in QA.
• Prepared implemented plan and executed successfully with no issues.

Environment: UNIX, Windows, Informatica 9.6.1, Db2, netezza, Web-Focus, MS office, IDQ

Confidential - Phoenix, AZ

Lead ETL Developer

Responsibilities:

• Worked with Business users &analysts to understand the processes and requirements and translated them into technical requirements.
• Worked source team to analyze the application d Confidential and how it captures and stored at back end application d Confidential base and created d Confidential dictionary document.
• Analyzed d Confidential sources and developed plans to perform d Confidential cleansing, standardization and matching using Informatica IDQ.
• Designed, developed, and tested ETL mappings & mapplets for d Confidential quality using IDQ and imported to Informatica PowerCenter tool to reuse the D Confidential Quality checkpoint logic which reduced development time.
• Designed and documented ETL architecture changes and created end-to-end ETL design document and presented to project team for approval.
• Worked with Informatica PowerCenter tools - Source analyzer, Target designer, Transformation designer, mapping designer, workflow manager and workflow monitor.
• Designed and developed Informatica mappings and sessions based on business user requirements and business rules to load d Confidential from source Xml, flat files into DB2.
• Worked with various transformations to solve slowly changing dimensional problems using PowerCenter designer tools.
• Developed and scheduled workflows using task developer, worklet designer and workflow designer in workflow manager and monitored results in workflow monitor.
• Increased the performance of ETL d Confidential load using Informatica performance techniques- tuning at source, transformation, target, session, and workflow levels.
• Developed file handling and validation scripts using UNIX shell scripts and created PMCMD, UNIX scripts for workflow automation.
• Scheduled the ETL loads using Control M and configured the dependency jobs.
• Resolved critical and high priority incidents within time frame.
• Designed and developed reusable objects in Informatica shared folder and maintained updated with the new requirements and changes.
• Performed development testing and unit testing at each level of ETL developments.
• Supported the quality assurance team in testing and validating the ETL objects.
• Presented ETL d Confidential flow in show & tell sessions and made changes based on feedbacks.

Environment: UNIX, Informatica PowerCenter 9.6.1/9.1, Informatica 9.1, Toad D Confidential Modeler, Oracle, Terad Confidential, Neteeza, DB2, XML, Web-focus, Control-M, MS Office, Citrix, PMF, Agile methodology and SharePoint.

Confidential - Phoenix, AZ

ETL Migration Consultant

Responsibilities:

• Designed and developed ETL d Confidential mappings to extract multiple d Confidential sources and transform into useful information and load into D Confidential Warehouse and D Confidential Marts.
• Cleansed, Standardized and eliminated duplicate and inconsistent d Confidential . Enhanced D Confidential Integration across enterprise to help multiple business units.
• Improved existing ETL mapping performance for d Confidential extraction process using Informatica standard performance tuning techniques.
• Designed and developed Error handling and Audit controls for financial d Confidential . Successfully lead and implemented multiple projects.
• Involved in D Confidential Model designing using 3rd Normal form, Validated Logical and Physical d Confidential models and provided suggestions.
• Extensively used INFA PowerCenter tools- Source Qualifier, Filter, Expression, Router, Update, Sorter, Joiner, Normalizer, Lookups, Aggregator, Sessions, Task, worklets, and workflow.
• Developed d Confidential quality check points using IDQ to cleanse, standardize, and match different versions of Customer d Confidential in different application sources d Confidential .
• Created Comparison logics, consolidation logics, and duplicate removal logics to standardize the Customer & Employee master d Confidential sets using Informatica IDQ.
• Designed and developed audit controls for regulatory reporting and to support Production issue resolutions.
• Increased performance of D Confidential loads using techniques like removing bottlenecks, Optimizing Source, Target, Transformations, Mappings, Sessions, and using pipeline partitions.
• Written and maintained UNIX scripts and SQL programs.
• Designed and developed historical d Confidential purge process for individual markets based on Business requirements.
• Involved in creation of Micro-strategy reports, dashboards, drill maps, custom groups & consolidations and user security filters.
• Worked with Admin teams to configure connection strings, ControlM job scheduler, Server setup, and INFA & UNIX folder creations.
• Lead and managed 4 members ETL tech team to support development and testing end-to-end project completion process.
• Supported User Assistance Testing (UAT) by providing documents, solving bug fixes and updating QA with root cause & resolutions.
• Prepared production support documents, gave project overview presentation and explained critical tasks those needs monitoring.

Environment: UNIX, Windows, Toad D Confidential Modeler, Informatica PowerCenter 9.1, Informatica IDQ 9.1, Pega, Terad Confidential, DB2, XML, Flat file, Informatica Administrator 9.1, Micro-strategy, Control-M, Agile, MS office, SharePoint.

Confidential

Senior ETL Developer

Responsibilities:

• Attended sprint planning meetings and involved in product backlog.
• Analyzed Legacy source systems and worked extensively on d Confidential profiling to calculate the quality d Confidential and documented.
• Worked with Informatica D Confidential Quality 9.1 for d Confidential analysis, d Confidential cleansing, d Confidential matching, d Confidential conversion, exception handling and reporting.
• Identified and eliminated duplicates in d Confidential sets through IDQ 9.1 components of edit distance, jaro distance and mixed field matcher, it enables the creation of a single view of vendors, customers and employees’ d Confidential sets.
• Involved in implementing the Land process of loading customer, product, and vendor d Confidential set into Informatica MDM 9.1
• Developed Base objects, Staging tables, foreign key relationships, static & dynamic lookups, queries, packages.
• Worked on d Confidential cleansing and standardization using the cleanse functions in Informatica MDM
• Developed trust and validation rules and setting up the match/merge rules sets to get the right master records.
• Configured match rule set property by enabling search by rules in MDM according to Business rules.
• Created transformations, mapplets and mappings using Informatica 9.1 PowerCenter to move d Confidential from multiple sources into targets.
• Created ETL transformations like source qualifier, lookup, joiner, expression, update, SQL, and normalizer using Informatica PowerCenter Designer.
• Designed and developed D Confidential Migration approach to extract Legacy D Confidential sources.
• Designed and Documented d Confidential migration steps - Project Scope, Identify D Confidential & Requirements, Assess Source D Confidential, D Confidential Quality Remediation, Prepare D Confidential Load, Trail D Confidential Loads, Validation Results, Load Target Systems and Go-Live preparation.
• Supported SIT and UAT phases and resolved defects.
• Implemented ETL Objects successfully.

Environment: UNIX, Windows, Informatica PowerCenter 9.1, Informatica IDQ, Informatica MDM 9.1, SAP, flat files, Legacy D Confidential sources.

Confidential

Sr. Analyst Programmer

Responsibilities:

• Gathered and analyzed business requirements and prepared ETL design documents as per the standards.
• Design and developed d Confidential models for customer, sales, employee d Confidential marts.
• Designed, developed, implemented and maintained Informatica PowerCenter and IDQ 8.6.1 application for matching and merging process.
• Designed, tested, and deployed d Confidential quality processes in D Confidential Quality Workbench as Plans.
• Worked with Informatica plug-in enabling PowerCenter to run d Confidential quality plans for standardization, cleansing, and matching operations.
• Created plans in IDQ and imported to PowerCenter, reused for different d Confidential sets to validate & standardization.
• Developed IDQ transformations like Duplicate record, Filter, Expression, Key Generator, Joiner, Lookup, Match, Merge, Normalizer, Rank, Router, and Standardizer transformations to cleanse the D Confidential Quality.
• Build ETL solutions using PowerCenter 8.6.1 to extract and transform d Confidential from Legacy mainframe systems.
• Implemented ETL solutions with great ETL process and Error handling techniques.
• Enhanced d Confidential quality and integrated different d Confidential sources into single version of truth using Master d Confidential management techniques.
• Wrote and deployed stored procedures, tuned and managed SQL scripts.

Environment: Informatica PowerCenter 8.6.1, Informatica IDQ 8.6.1 Oracle 10g, Oracle SQL Developer D Confidential Modeler, flat files, Micro-Strategy, UNIX, Windows.

Confidential

ETL Developer

Responsibilities:

• Designed and developed import and export process on transactional system.
• Implemented ETL process to extract d Confidential from transactional system and transform into business required information and stored into D Confidential base.
• Supported and provided resolution for emergency production issues and defects.
• Addressed issues of D Confidential integrity and troubleshoots d Confidential issues.
• Documented D Confidential flow process.

Environment: Informatica 8.6, Oracle, Oracle SQL Developer D Confidential Modeler, Excel reporting, DB2, flat files, web-services, MS-office, SharePoint, UNIX, Windows.7