SUMMARY

• Over 6+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Manufacturing, Financial, software and Security Management Sectors.
• Strong Experience with Microsoft SQL Server Management Studio 2017 v. 14.0.1000.169.
• Strong Knowledge on Microsoft Visual Studio in SSIS and SSRS, SQL Server Database Engine (SSMS) 2017, Informatica 10.1.1/9.1/8.6.1/8.6 (Power Center, Power Exchange, Cloud and Data Quality).
• Worked with heterogeneous data sources like Oracle, Teradata Utilities, SQL Server 2008/2005, flat files, XML files, DB2 UDB, Main Frames, COBOL files, SFDC CRM, Web Services and Lotus Notes.
• Extensive experience supportingDB2system administration, application development, resolvingDB2issues, performance tuning, monitoring data security and integrity.
• Strong analytical and conceptual knowledge in database design and development using SQL, SSIS. Extensively worked on database objects like tables, indexes, views, store procedures, triggers.
• Strong experience in Informatica tools Repository manager, Designer, Workflow manager, Workflow monitor. Ability to Work with complex mappings using different transformations like Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Excellent Documentation Skills, Team problem solving ability, Analytical and Programming skills in High speed, Quality conscious and multitasked environment.
• Excellent background in implementation of business applications and in using RDBMS and OOPS concepts.
• Has in - depth knowledge in Data analysis, Data warehousing and ETL (Extract, Transform and Load) techniques.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Worklets and Workflows for data loads.
• Worked on various MSBI transformations like lookup, fuzzy lookup, pivot, unpivot.
• Experience in identifying and resolve ETL production root cause issues. Experience in maintenance, enhancements, performance tuning of ETL code.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Extensive experience in Design, develop and test processes for loading initial data into a data warehouse. Worked extensively with slowly changing dimensions.
• Strong knowledge in Data Warehousing concepts like creating tables using star & Snowflake schemas. And maintaining the data.
• Strong Experience on RDBMS in Performance tuning methods, reducing the data redundancy, creating relations between tables.
• Strong experience in OLAP Data Modeling using Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Experienced in working with business users, business analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
• Hands-on experience on agile methodology.Ability to communicate & present design or support ideas in a team-related environment
• Excellent communication and interpersonal skills. Ability to work effectively while working as a team member as well as individually. Strong analytical and problem solving skills.

TECHNICAL SKILLS

Data Warehousing/ ETL: Informatica Power Center 10.2/10.1.1/ 9.1/8.6/8.1, Informatica Power Mart 9/8.x, (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplets Designer, Mapping Designer, Repository manager), Metadata, talend

Data Modeling: Dimensional Data Modeling, 3NF Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Physical and Logical Data Modeling, Erwin, ER Studio and Sybase Power Designer.

Databases & Tools: Sql Server Management Studio 2008, 2012, 2017.

Scheduling Tools: Informatica Workflow Manager, Repository manager, Designer, Workflow monitor

Programming Languages: SQL, PL/SQL, Perl, Unix Shell Scripting, Teradata Procedure

Environment: Testing Frameworks Visual Studio 2017, SSMS 2008, 2012, 2017 v - 14.0.1000.169, Informatica PowerCenter 10.1.1, 9.1, 8.6.1, 8.6 Selenium IDE, Coded UI Testing in .NET framework

PROFESSIONAL EXPERIENCE

Confidential, Anaheim, CA

Informatica/ ETL Developer

Responsibilities:

• Worked extensively in full System Development Life Cycle like participating in requirement gathering, business analysis, user meeting.
• Interacting with functional teams and users for finalizing the data models and reporting structures.
• Working closely with the Business Analyst, Data Modeler and Database Architect during the design and development of technical specification document.
• Imported mapplets and mappings from Informatica developer (IDQ) to Power Center.
• Used Informatica Power Center as an ETL to extract data from source like MS SQL Server, Flat files, Oracle, DB2 and Teradata and loaded to target.
• Developed the audit activity for all the cloud mappings.
• Automated/Scheduled the cloud jobs to run daily with email notifications for any failures.
• Extensively worked with the various client component of Informatica like Source.
• Analyzer, Warehouse Designer, Mapping Designer, Mapplets Designer, Repository.
• Manager, Workflow Manager, and Workflow Monitor.
• Extensively used different transformations like Lookup, Joiner, Aggregator, Filter, Sorter, Expression, Update Strategy, Source Qualifier, Rank, Router to create several mappings and mapplets.
• Implementing extracting, cleansing, transformation, integration and loading into Data marts using Informatica.
• Experienced in creating IDQ mappings using Labeler, Standardizer, Address Validator transformations
• Implementing Slowly Changing Dimension Phenomenon Type-1, Type-2 using Informatica ETL mapping.
• Created mapplets and reusable session for the performance tuning.
• Used HTML, Java Script, and CSS to design the front end of the application.
• Implemented error-processing strategy to reprocess the error data and manage notification of error data to corresponding business team.
• Experienced in creating IDQ mappings using Consolidation, Key Generator, Match, Merge, Exceptional, Labeler, Standardizer, Address Validator transformations with Informatica Developer and migrated to Informatica Power Center.
• Working with Informatica workflow monitor in running and debugging its components and monitoring the resulting executable version.
• Experienced in creating IDQ mappings using Labeler, Standardizer, Address Validator transformations with Informatica Developer and migrated to Informatica Power Center.
• Involved in fine-tuning of sources, targets, mappings and sessions for performance optimization.
• Extensively used complex SQL queries to unit test the system and to test the existing project also used to validate the data in data warehouse.
• Extensively used SQL and PL/SQL tuning techniques to improve the performance.
• Daily monitoring of the mappings dat ran the day before and fixing the issues.
• Involved in unit, system and end-to- end testing of the design.
• Working with DBA and Reporting team to generate Materialized View of the data warehouse.
• Working on call for production support.

  Environment: Informatica Power Center 10.2/ 10.1.1, Informatica Cloud, Oracle 11g, SQL Server 2008/12, flat files, DB2, Teradata, Erwin R7, SQL, PL/SQL, SQL*PLUS, Shell Scripting.

  Confidential

  Informatica/ETL Developer

  RESPONSIBILITIES:

  • Involved in analysis of source systems, business requirements and identification of business rule and responsible for developing, support and maintenance for the ETL process using Informatica PC.
  • Developed common routine mappings, Made use of mapping variables, mapping parameters and variable functions
  • Developed Informatica mappings, Reusable transformations. Developed and wrote procedures for getting the data from the Source systems to the Staging and to Data Warehouse system
  • Extensively used transformations to implement the business logic such as Sequence Generator, Normalizer, Expression, Filter, Router, Rank, Aggregator, Look Up (Target as well as Source), Update Strategy, Source Qualifier, and Joiner, designed complex mappings involving target load order and constraint-based loading Create/build and run/schedule Workflows and Work lets using the Workflow Manager
  • Extensively worked in the performance tuning of the programs, ETL Procedures and processes
  • Coded Database triggers, functions and stored procedures and written many SQL Queries. Helped coding shell scripts for various administration activities for daily backup
  • Involved in Physical schema implementation, objects like table-space, table rollback segments, created database structures, objects, and their modification as and when needed
  • Used versioning and shared folders for better control on Informatica jobs among the team and across different projects
  • Worked on slowly changing dimension Type2
  • Mapped the source and target databases by studying the specifications and analyzing the requirements
  • Involved in performance testing of jobs.
  • Troubleshoot day to day database issues
  • Managed the Metadata associated with the ETL processes used to populate the data warehouse.
  • Written Teradata BTEQ, M-LOAD, F-LOAD also used TPT in Informatica
  • Created Informatica transformations/mapplets/mappings/tasks/worklets/workflows using Power Center to load the data from source to stage and stage to core/base.
  • Made use of various Power Center Designer transformations like Source Qualifier, Connected and Unconnected Lookups, Expression, Filter, Router, Sorter, Aggregator, Joiner, Rank, Router, Sequence generator, Union and Update Strategy transformations while creating mapplets/mappings.

  ENVIRONMENT: Power Center 10.1.1/ 9.1, Oracle 11g, IDQ, SQL, PL/SQL, UNIX (AXI), Erwin, Toad, Linux (Solaris).

  Confidential

  Informatica/ ETL Developer

  RESPONSIBILITIES:

  • Coordinate MDM program activities for the Customer and Product data domains.
  • Designed and developed ETL Processes based on business rules, job control mechanism usingInformaticaPowerCenter.
  • Used data integration tools and technologies such as Informatica PowerCenter, Microsoft SSIS and RDBMS concepts and methods within SQL Server 2008/12/14.
  • PerformedInformatica, non-Informaticacode migration between environments (DEV/QA/PRD).
  • Handled huge volumes of data at Enterprise Data Warehouse about 25 Tera Bytes.
  • Worked extensively on complex mappings using source qualifier, joiner, expressions, aggregators, filters, Lookup, update strategy, stored procedure transformations, etc.
  • Migration and Development in Informatica Cloud Services (ICS) by using Bundles, Integration Templates, Task Flows, Mapping Configuration Tasks(MCT).
  • Used workflow monitor to monitor the jobs, reviewed session/workflow logs dat were generated for each session to resolve issues, usedInformaticadebugger to identify issues in mapping execution.
  • Created mainframe data maps using Power Exchange Navigator for the sources and targets.
  • Used Power Exchange Data Change option (CDC) to capture modified records.
  • Developed reusable transformations, mapplets, sessions, and worklets to make code very modular and reused it as required.
  • Created and Configured Workflows and Sessions to transport the data to target warehouse, Oracle tables usingInformaticaWorkflow Manager.
  • Tuned SQL statements,Informaticamappings, usedInformaticaparallelism options to speed up data loading to meet defined SLA.
  • Developed PL/SQL procedures for processing business logic in the database and used them a Stored Procedure Transformation.
  • Developed strategies for Incremental data extractions as well data migration to load into the Oracle (EDW). And assisted in designing Logical/Physical Data Models.
  • Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2.
  • Created the Test cases and Captured Unit Test Results, Developed and tested all theInformatica mappings, sessions and workflows involving several Tasks.

  ENVIRONMENT: Informatica Power Center 8.6.1 (ETL), Oracle 9i, SQL, PL/SQL, SQL*Loader, SQL Server, Windows, SQL Server 2008/12/14.

  Confidential

  ETL Developer

  RESPONSIBILITIES:

  • Worked withInformaticaData Quality 8.6 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
  • UsedInformaticaRepository Manager to backup and migrate Repository in development, test and production systems.
  • Worked with an agile team to develop, test, and maintain web and desktop-based business applications built on Microsoft technologies.
  • Utilized ofInformaticaIDQ to complete initial data profiling and matching/removing duplicate data.
  • Assisting in the collection and documentation of user's requirements, development of user stories, and estimates.
  • Prepared reports, manuals and other documentation on the status, operation and maintenance of software.
  • Design, develop, and unit test applications in accordance with established standards. Package and support deployment of releases.
  • Worked on Developing, refining, and tuning integrations between applications.Design, Develop and Test ETL processes in order to meet project requirements.
  • Used to be on call Support if the Project is deployed to further Phases.
  • Worked withInformaticaAdministrator to setup project folders in development, test and production environments.
  • Extracted data from various sources like MS SQL Server 2008, DB2, flat files, Excel spreadsheets, Oracle and XML files and loaded into the oracle database.
  • Tested the developed code Using system monitoring tools and automated testing frameworks.
  • UsedInformaticaVersion Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.

  ENVIRONMENT:InformaticaPower Center 8.6 (Designer, Server Manager, Repository Manager), SQL Server 2008, DB2 UDB, Erwin, SQL, Perl Scripting, UNIX, Clear Case.