PROFESSIONAL SUMMARY:

• Experience with special emphasis on fetching, parsing, scraping, storing, analyzing and visualizing several gigabytes of data from diverse sources.
• Database platform frameworks - T-SQL, Teradata/Aster/Sql Server, Apache Hive, PySpark and SparkSQL.
• Experienced with AWS technologies like AWS data pipeline, lambda, redshift, DynamoDb and Kinesis.
• Experience in Architecting data models (ErWin), reverse engineering and performance optimization.
• Designed, developed and maintained data integration processes in an RDBMS environment with various source systems like Netezza, Teradata, XML and JSON for data access and analysis.
• Experienced in developing scalable and distributed data solutions.
• Lead the architectural design of large data lakes to store both structured and unstructured data.
• Implemented SQOOP for large dataset transfer between Hadoop and RDBMs.
• Worked in various Heterogeneous Source Systems like Oracle, DB2 UDB, Teradata, MS SQL Server, Flat files.
• Expertise in Digital Analytics and Analytical software like Tableau, Power BI, OBI and Adobe analytics.
• Experienced in Informatica Data Quality (IDQ)/ XMAP tool for data analysis and handling frequently changing XSD schemas.
• Involved in Informatica MDM HUB development support and have a good technical knowledge on Informatica MDM products
• Created various active and passive transformations like Source Qualifier (with complex SQL overrides), unconnected and connected Lookups (with SQL overrides), Router, Normalizer, Aggregator, Filter, Joiner, Expression and standard/reusable logic using Informatica.
• Extracted data from XML files and loaded into various target-staging tables.
• Involved in designing and development of pre and post session routines and batch execution routine scripts using Shell and Batch.
• Worked with Teradata 12 utilities like BTEQ, Fast Load, Multi Load and Query man.
• Good command on troubleshooting, bug fixing with the help of error logs generated.
• Worked extensively with ETL tools in creating mappings, jobs and running them successfully on different platforms and scheduling the jobs in CTRL M, Zena, Autosys and Cron.
• Understanding, flexible, and adept at working in high paced agile environments, adapting quickly to different business organization’s needs.

TECHNICAL SKILLS

Business Intelligence tools: Informatica Power Center 9.5.1/6.x, IDQ, MDM, Datastage, Business Objects, TOAD, SAS

Defect Management Tools: Quality Center, Clear Quest, Rally, Jira

Programming Languages: SQL, Unix/Linux, Python

Databases: Oracle, SQL Server, DB2, Terradata,MySQL, SQL Netezza.

Platforms: Windows 98/NT/2000/XP, UNIX, Linux, Vista

Applications: MS Office Suite, MS Visio, MS Project, Rational, SharePoint

Business Process Tools: Business objects (Crystal, AO), Tableau, QV

Data Modeling Tools: Erwin, Rational rose, Database modeler

Reporting Tools: Business Objects, Tableau, Microstratergy, Crystal Reports.

Testing Tools: QTP, Load Runner, Rational Robot

PROFESSIONAL EXPERIENCE

Confidential, Dallas TX

Informatica Lead

Responsibilities:

• Designed, developed and maintained data integration processes in an RDBMS environment with various source systems like Netezza, Teradata, XML and JSON for data access and analysis.
• Experienced in developing scalable and distributed data solutions.
• Lead the architectural design of large data lakes to store both structured and unstructured data.
• Implemented SQOOP for large dataset transfer between Hadoop and RDBMs.
• Worked in various Heterogeneous Source Systems like Oracle, DB2 UDB, Teradata, MS SQL Server, Flat files.
• Expertise in Digital Analytics and Analytical software like Tableau, Power BI, OBI and Adobe analytics.
• Provided innovative solutions to business challenges.
• Worked with diverse clients to provide actionable intelligence.
• Experienced in Informatica Data Quality (IDQ)/ XMAP tool for data analysis and handling frequently changing XSD schemas.
• Created various active and passive transformations like Source Qualifier (with complex SQL overrides), unconnected and connected Lookups (with SQL overrides), Router, Normalizer, Aggregator, Filter, Joiner, Expression and standard/reusable logic using Informatica.
• Extracted data from XML files and loaded into various target-staging tables.
• Involved in designing and development of pre and post session routines and batch execution routine scripts using Shell and Batch.
• Created and published packages in Framework Manager from various data sources. Generated different kinds of reports in ReportNet, created templates and multilingual reports.
• Knowledge on developing Dashboards Reports inCognos8 and 10
• Used debugger and breakpoints to view transformations output and debug mappings using verbose logging.Enterprise Data warehouse experience:
• Drove the strategic vision, Design & architect of a centralized data warehouse for Call tracking (Clicks, calls and actions) search engine marketing and optimization.
• Conducted Road shows to educate the end users on the importance of Data-Warehouse for pulling reports and creating ad-hoc dashboards.
• Responsible for delivery and services of BI & Analytics, Data Governance, data democratization and their integration into overall internal and external ecosystem.
• Ensure that data systems contain highest degree of accuracy and validity to support enterprise reporting an analytical need.
• Conducted meticulous GAP analysis while successfully re-engineering key business processes to increase operational efficiency and alignment of business unit objectives.

Confidential, Salt Lake City, Utah

Informatica Lead

Responsibilities:

• Developed and executed annual digital marketing strategy, including all web, SEM, email, social media and producing the results to the advertising campaign teams from the warehouse with the help of internal reports.
• Designed and developed reusable parameter driven patterns for common development. (Audit control /error handling)
• Build highly detailed, metrics-driven models to predict performance of media, set forecasts and budgets and provide scenario analysis.
• Designed and Developed Slowly Changing Dimension Mappings of type I, type II (version, flag and time stamp).
• Expertise in implementing complex business using Informatica rules by creating re-usable transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup, Router, Rank, Joiner, Update Strategy, Unstructured data transformation, XML-parser, Web Service transformation), and developing complex Mappings/Mapplets.
• Implementation of MDM business solution for eliminating Duplicate customers and maintaining the Master data.
• Led upgrade of MDM hub project.
• Design and Implementation of MDM release and deployment procedures for full and incremental releases and automating the change list promotions.
• Good experience on Address Doctor, Matching, DE-duping, Cleansing and standardization.
• Excellent expertise in creating XSDs.
• Exposure to Informatica B2B Data Exchange.
• Designed Mappings using B2B Data Transformation Studio.
• Worked with the B2B Operation console to create the partners, configure the Partner management, Event Monitors and the Events.
• Setting up an environment for B2B to write to the JMS queue.
• Written X-Queries for testing and also for extracting quote data stored in XML.
• Rotation basis on-call support to production system to resolve any production issues.
• Developed mappings/ sessions using Workflow Manager for data loading with ODBC and FTP connections.
• Created a Batch script to pass database connections, parameter entries for source and target.
• Excellent expertise on Informatica MDM Hub configurations - Data modeling & Data Mappings (Landing, staging and Base Objects), Data validation, Match and Merge rules, writing and customizing user exits .
• Involved in ETL loads (Enable/disabled) through Informatica Admin Console during all themonthly releases.
• Golden records record generation using MDM by setting trust rules
• Running reports on Business Objects for business.
• Created functional specification documents based on the business requirement documents.
• Organized JAD Sessions to resolve issues and conflicts, and to arrive at quick agreements regarding the system architecture design
• Developed complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.

Environment: Informatica 9.x, DataStage, IDQ, informatica MDM 9.6, Oracle 11g, Netezza, Unix, XML, Tableau, BO, Rally, Xmap

Confidential, Iowa city, IA

Sr. Informatica Developer

Responsibilities:

• Interact with business analysts to gather requirements.
• Analysis and design of domain problems and provide solutions.
• Develop and improve workflows and business processes with areas to improve customer service, decrease operational costs and improve overall quality.
• Created ETL process using Informatica 9.1/9.5 with various source and target systems like ORACLE, Siebel, flat file and legacy systems.
• Implemented End-to-End different data warehousing projects Enterprise Data Warehouse, Mutual fund Billing Projects and Revenue reports generation projects.
• Created various active and passive transformations like Source Qualifier (with complex SQL overrides), unconnected and connected Lookups (with SQL overrides), Router, Normalizer, Aggregator, Filter, Joiner, Expression and standard/reusable logic using Informatica.
• Developed, tested Procedures, Cursors, Functions and Packages using PL/SQL for Data manipulation.
• Extracted data from XML files and loaded into various target-staging tables.
• Involved in designing and development of pre and post session routines and batch execution routine scripts using Shell and Bash.
• Used debugger and breakpoints to view transformations output and debug mappings.
• Tuned multiple mappings to enhance performance after the mapping’s functionality was validated.
• Created ETL process to generate XML files from DB2 Base tables using XML parsers/Generators in Informatica.
• Extensively worked on the Database Triggers, DB2 Functions and Database Constraints.
• Worked on configuring the Java class path in the session properties while using third-party Java packages, built-in Java packages, and custom Java packages in a Java transformation.
• Worked with Informaticatools IDQ (Data Analyst, Developer) with various data profiling techniques to cleanse, match/remove duplicate data.
• Strong experience in developing DQ components like Data Objects, Quick Profiles, Custom Profiles, and creating and executing scorecards.
• Used session partitions, dynamic cache memory, and index cache to improve the performance.
• Used Workflow Manager to create various tasks like reusable sessions, event wait tasks, event raise, email to run with the logic embedded in the mappings and command tasks.
• Involved in repository management using admin console and repository manager for creating repositories for development and testing environments. Was Responsible for taking repository backup before migrations for major projects.
• Involved in addition and configuration of repositories, adding user groups, users to the repository, assigning privileges to the users, creating project specific and shared folders.
• Minimum experience in across verticals in the Data warehouse implementation with ETL Tool Pentaho Kettle.
• Independently perform complex troubleshooting, root-cause analysis, and solution development.
• Manage and administer system performance including on-going optimization and tuning of Informatica environment.
• Developed and enhanced Informatica real time web services to retrieve client information on-the-go.
• Used over 11 SQL transformations in one mapping with various real time web service calls to retrieve database data to support ongoing policy data capture.
• Tuning Informatica Mappings and Sessions for optimum performance using Multi-threading, session partitions and parallel processing. Used various partitioning schemes in order to improve the overall session performances. Implemented Informatica Best Practices.
• Worked on the performance tuning of databases (dropping & re-building indexes, partitioning on tables).
• Prepare management and status reports as required.
• Participate in systems testing, develop procedures/controls and provide recommendations for ongoing improvement of updated process.
• Assist personnel (both internal and external) by answering questions, supplying information and training.
• Collaborate with the team in implementing complex application systems, write technical specifications, document code and design using various technologies.

Environment: Informatica 9.x, DataStage, IDQ, informatica MDM 9.6, Oracle 11g, Netezza, Unix, XML, Tableau, BO, JIRA/RALLY, Xmap