SUMMARY

• Over 10 years of IT experience with strong background in software development in designing and developing Business Intelligence solutions and Decision support system using Informatica power center, DVO,PMPC,IDQ, MDM, IICS and Power Exchange.
• Worked with various clients in the Health Care, Higher Ed, Food &Nutrition and Financial.
• Experience with advanced ETL techniques including Slowly Changing Dimensions, reusability, data validation and profiling, change data Capture (CDC), error processing etc.
• Experienced in creating entity relational & dimensional relational data models using Kimball Methodology i.e., Star Schema and Snowflake Schema.
• Proficient in Requirement Analysis, Technical Design Specification creation, Development, Testing, Star Schema Design and implementations.
• Experienced with creating ETL specifications as per the customer requirements and Unit Test Cases for ETL code and doing peer code reviews.
• Highly proficient in using Informatica Power Center to move Data from multiple heterogeneous sources like Oracle, SQL Server, Sybase, SAP and flat files into a BI specific target area such as Staging area, Warehouse and Data Marts.
• Certified Confidential Analyst specialist & master, Confidential Administrator specialist.
• Heavily used Informatica SAP Power Exchange Adaptor and Power Exchange Adaptor for Adabas Legacy system.
• Coordinated with the SAP team in Using LSMW a SAP R/3 based tool for transfer of data from legacy systems to SAP system.
• Good experience in UNIX and Perl scripts for automation of ETL process and Informatica pre & post session operations.
• Expertise in developing SQL and PL/SQL codes through various procedures, functions and packages to implement the business logic.
• Well Versed with different SQL Development Tools like TOAD, DB Visualizer, Oracle SQL Developer, Oracle SQL Data Modeler.
• Very well versed with most SDLC methodology (Waterfall, Agile)
• Knowledge on ETL for consuming data from big data sources and to load Hive Data Warehouse.
• Highly Skilled in SQl Query Tuning and Informatica Performance tuning.
• Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems and vice - versa.
• Ability to quickly master new concepts and applications

TECHNICAL SKILLS

ETL Tools: Informatica 10.x,9.x/8.x, Informatica Power Exchange 8.xInformatica (DVO,PMPC,MDM,IDQ, IDE), Data Stage, SSIS.

Methodologies: E-R Modeling, Star schema, Snowflake schema.

Programming Languages: SQL, PL/SQL.

Databases: Oracle, MS SQL Server, Teradata DB2.

Reporting Tools: MicroStrategy, Business Objects, Cognos Report.

Data Modeling: Erwin 4.2.2, Oracle SQL Data Modeler.

Operating Systems: Windows XP/NT/2000, UNIX.

Database utility tool: Toad, Oracle SQL Developer, SQL* PLUS, LSMW, DBVisualizer.

Scheduler: Informatica scheduler, Autosys, Tidal, ControlM

Big Data/Hadoop Ecosystem: HDFS, Hive, Sqoop, Hue.

PROFESSIONAL EXPERIENCE

Confidential

Informatica / Cloud Application Developer

Responsibilities:

• Extensively used Informatica Cloud and PowerCenter Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected and unconnected Lookup, Expression, Router, Filter, Normalizer, Aggregator, SQL, Transaction Control and Sequence Generator transformations Webservices, Java and HTTP.
• Upgraded Informatica PowerCenter from 9.6 to latest version 10.4.
• Used informatica data validation option for upgrade testing and migration testing.
• Installed and configured Informatica Proactive Monitoring for PowerCenter
• Used informatica salesforce transformation to import salesforce objects to Designer.
• Created Informatica mappings to load currency exchange rates from oanda in to JDE.
• Implemented new generation data model for sales and marketing Datamart’s.
• Extensively used informatica cloud data replication task to load salesforce objects to staging tables.
• Develop impactful reports, Dossiers and dashboards using Confidential Developer and Web.
• Worked on active directory and usher pro integration to populate employee data on usher pro.
• Used Informatica cloud (IICS)to load Sales force objects into AWS S3 buckets.
• Created Gulp jobs to load data from AWS S3 bucket to Redshift Data Lake.
• Worked on helpdesk tickets and resolve within the SLA and maintain documentation to help in cross training across the team.
• Implementation of Confidential Cloud features through entire lifecycle of feature development. This includes input on design specifications, implementation of functionality, testing, analyzing and optimizing the implementation that support expanding Confidential ’s platform capabilities.
• Design, implement and optimize Confidential platform deployment mechanisms working on infrastructures such as: physical hardware, AWS Cloud and Azure Cloud systems
• Troubleshoot and triage issues related to software and hardware components and Confidential Product Suite implementation.
• Certified Confidential Analyst specialist & master, Confidential Administrator specialist.
• Spin up new environment for the customer using Jenkins CI/CD pipeline - Builds to deploy EC2 instances using CloudFormation.
• Set and Monitor CloudWatch alerts for server configuration measurement like CPU, Memory Utilization, Webserver and MSTR iServer status to ensure timely and undisturbed service to the customer.
• Participated in peer code reviews, knowledge sharing, Scrum meetings and mentoring.
• Provided Expert Services for stress testing, sizing, configuration audits, on-site implementation of best practices, performance tuning, ETL routines, Data modelling, among others

Environment: Informatica Cloud, Power Center 10.4/10.2/9.6 , DVO, PMPC, SQL Server2016, Amazon Redshift, SQL, Confidential web, Confidential Developer, GitHub, AWS S3, Jenkins, Flat Files (fixed and delimited), XML Files.

Confidential

Senior ETL /Application Developer

Responsibilities:

• Technology Lead, Onsite Coordinator
• Participated in all phases of the Development Life Cycle
• Worked on all the Unix/Informatica setups required for Informatica upgrade.
• Involved in requirement gathering from data stewards, data model design, for the MDM hub configuration for applications.
• Creating the landing, staging and base object tables in MDM hub console based on the data model design.
• Developed BDM mappings to do the initial data loads into MDM landing area based on the business and data quality and cleanse rules.
• Responsible for Requirements gathering, Technical System Design, Development, Testing, Code Review, Code migration, UAT, Job scheduling, Offshore Coordination
• Developed complex inbound/outbound mappings and reject strategies based on the business rules to load the IDL (initial data loads) and incremental loads using IDQ.
• Developed re-usable components (Address Validation, Parsing, Standardization, etc.) based on the business requirements using IDQ.
• Actively participate in understanding business requirements, analysis and designing Data Migration/Integration Process from Business Analyst
• Interacted with Data Architecture group, PM, Project team to finalize the TSD design strategies. Created various diagrams as part of the Project deliverable and physical database design.
• Use Informatica Power Center and Unix Scripts through Control-M tool to extract, transform and load data
• Responsible for code migration, Code review, test plans, test scenarios, test cases as part of Unit/Integrations testing
• Automate the Production jobs using Informatica Workflows & Shell script through Autosys.
• Designed and developed high performance ETL design plans, Staging and Target tables design to load large volumes of data (Flat file to table, Table to Table, table to Flat file) utilizing Informatica Power Center, Parameter File
• Performance Tuning on the Targets, Sources, Mappings and Sessions used Techniques like reusable Transformations, reusable Caches and partitioning etc.
• Developed test plans, test scenarios, test cases as part of Unit/Integrations testing
• Responsible for setting up Production Jobs and created Production Operational Document
• Leading a team of 2 developer at Onsite and 6 developers at offshore.

Environment: Informatica PowerCenter, MDM, IDQ, Unix, Teradata, Autosys, TOAD, MS Office