SUMMARY

• 9.10 years of IT professional experience in Requirements Gathering, Analysis, Design, Development, Testing, and Implementation and Support of ETL Data Warehousing arena business application systems.
• Primary competency of Informatica Power Center 10.x/9.x/8.x/, Teradata 13/14, Oracle,DB2,SQL SERVER,Sybase,PLSQL,Unix Shell Scripting, Ctrl M with good understanding of Banking domain in Financial services industry.
• Experience in working under Cloudera Hadoop ecosystem for Big data Plaform with Hive,Impala,SPark,Sqoop,Oozie Workflows.
• Expertise in OLTP/OLAP System Study, Analysis and E - R modeling, Implementation of dimensional modeling, ETL process mapping using the top-down, bottom-up approaches and hybrid model approaches.
• Experience in preparing the technical design, Project development Standardization, Change Control and Test case documents.
• Strong skills of Informatica Power center - Designer, Workflow manager, Workflow monitor, various Informatica designer transformations like Source Qualifier, connected and Unconnected lookups, Expression, Filter, Router, Joiner, Aggregator, Sequence generator, Normalizer, Update Strategy transformations and so on.
• Hands on work experience on Data Quality(IDQ) tool for data validation/cleansing/profiling using informatica developer, Informatica Analyst tool. Skills of working on logical data objects, Physical Data Objects,Reference Tables,Mapplet,Rules creation,Profiling,Parser transformations, Token parsing, Address Validator.
• Experience in Building Business Rules, Integrate IDQ Business Rules with Informatica Power Center Mappings, Implemented Bad Record Exception Handling using Informatica Data Quality (IDQ). Workflow and Human Task management Development using IDQ.
• Experience in Informatica MDM Hub, Hierarchy Manager, Informatica Data Director IDD, designing of Cleanse functions and Match rules, MDM User Exits.
• Hands on experience in design and configuration of landing tables, staging tables, base objects,hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation
• Good Understanding and Knowledge in retrieving data by writing SQL Queries.
• Experience in Developing Control M jobs and Production Scheduling as per the functional / business requirement.
• Experience in Improving Teradata performance and optimization on long running jobs to reduce CPU consumption.
• Experience in optimizing to database driven approach for better performance by developing generic Stored procedure for operations like surrogate key generation, Change data capture process and leveraging FULL Push down optimization of informatica power center feature.
• Experienced in Working with Teradata loading utilities like TPT, Multi Load, Fast Load and BTEQ.
• Experience in designing and development of EBCDIC VSAM Files, Cobol Copybooks from Mainframe systems.
• Skills of Ab initio - GDE, knowledge on various Ab initio components and knowledge on IBM data stage ETL tool.
• Expertise in tuning the performance of production mappings,workflows and determining the performance bottlenecks Experience in creating presession and post session scripts to ensure timely accurate processing and ensuring balancing of job runs.
• Involved, assisted, facilitated in ETL Prod Support as part of L2, L3 Support Team, resolving the Production Incidents based on the Priority and business criticality.
• Apart of ETL Development, have ventured and took ownership of QA, UAT and Prod Code Migration, ITSM process Preparedness for UAT and Production Release, solving the issues and defects raised by the QA Team and Business Users
• Ability to work on multiple projects/tasks simultaneously to meet deadlines and experienced in taking knowledge transitions from other vendors.
• Highly motivated individual and team player with excellent communication, interpersonal skills and an attitude to learn the new cutting edge technologies.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.x,9.x,8.x,IDQ Developer 10.x,9.x,MDM 10.x/9.x,Abinitio,Unix Shell Scripting

RDBMS: Teradata 13/14, Oracle 12c/11g/10g/9i, PL/SQL, Sybase, DB2, SQL Server

Domain: Banking and Financial Services

Reporting tool: Knowledge in Cognos BI 8.4 /10

Other Tools: SQL Assistant, Putty 2, VISIO, SQL Plus, PL/SQL Developer, TOAD, Tortoise SVN, ILM TDM, POWER Exchange

Scheduling Tool: Control M, CA7

Special Technology: Cloudera Hadoop,Hive,impala,Spark,Sqoop,Oozie Workflows.

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL Developer

Responsibilities:

• Interacting with Business users/analyst to analyze the business requirement and understand to business specifications. Building of analysis document and pre development data discovery skeleton results enabling the data lineage from source to target based on the requirement received.
• Creation of ETL (extraction, trasformation, loading) source to target design specifications and development of ETL based applications as per the business requirement gathered for suspicious transactions detection system application's data processing.
• Perform data profiling and data quality analysis.
• Designing and development of data load process using big data technologies like Hive, spark, sqoop,Impala.Establishing a set of rules and algorithms that require proficiency in hadoop platform and database management system.
• Creation of testing strategies, data preparation readiness, plans and building of test case specifications .Conduction of Unit testing and integration testing of developed/enhanced code in database management system and hadoop platform as applicable.
• Creation and automation of various business reports using UNIX shell scripting, Oracle PL/SQL.
• Configuring code to enable source to target mapping functions to operate efficiently as per industry standards and best practices. Conducting internal reviews and adhering the code for Confidential defined Standards.
• Enhancement and tuning of existing mapping, workflow and Mantas scenarios using Informatica mapping designer, workflow manager, workflow monitor, UNIX shell scripting, Oracle PL/SQL, Mantas utilities.
• Conducting production deployment activities like creation of package for code migration to various environments, promotion of code, drafting and completion of change requests using the Urban code deploy tool, Artifactory, git,Service Now and Cyber Ark as applicable.
• Troubleshooting data processing live production environment issues encountered on daily, weekly, monthly data loading batches, finding root cause analysis, resolving incidents and providing aid for technical issues encountered in AML applications on the technologies Informatica mapping designer, workflow manager, workflow monitor, Hadoop Cloudera HDFS, UNIX, Oracle PL/SQL, CA7 monitoring tool.
• Conducting status calls with MIS (Management Information Systems),line of business and other partners and keep them updated on the process.Attending daily and weekly meetings with the client’s onshore-offshore counter-parts. Updating the work status for onshore-offshore clients.

Confidential

ETL Lead Developer

Responsibilities:

• Accountable for Business Requirement evaluation & analysis, determining project Sprint scope, handling build and testing activities.
• Providing estimates of modules to fit into the team sprint, Story pointing, Subtasks creation and completion for agile execution.
• Perform data profiling and data quality analysis.
• Create Mapplets for Address Data Cleansing and standardize the data using Informatica Data Quality, Integrate IDQ Mapplets with Informatica Power Center Mappings.
• Design and configuration of landing tables, staging tables, base objects,hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries,packages,Trust and Validation rules, Match Path, Match Column, Matchrules, Merge properties and Batch Group creation.
• Design and delivering the core components of ICDW including the required ETL/ELT Informatica and Teradata environments
• Used Full PDO feature of informatica and leveraged database engine as a part of performance tuning by ELT Design.
• Review and certify the code developed within the team and deftly ensured timely deliveries of work items to the Client and implementation of ETL Standards and Best Practices.
• Control M jobs development and configuring of Production Job folders Scheduling as per the business calendar and requirement.
• Had taken measures to convert all the staging jobs from TPT Loads to TPT Streams, this resulted in jobs not having to wait for Teradata Utility Slots thereby reducing the Execution times by a considerable extent and reaching the SLA well in time
• Preparation of necessary artifacts including informatica components and teradata scripts for code migration to higher environments.
• Resolving the SIT and UAT defects raised by the testing team within the timelines and resolving the defects in ALM.
• Production long running jobs execution time improvements by successful implementation of LRF Load Strategy for Staging Loads in Teradata.
• Assisting in ETL Prod Support with L1, L2, L3 Support Team, resolving the Production Incidents based on the Priority, trouble shooting.
• Lead co-coordinator for UAT and Production release implementation, Post Migration and Post load data validation completion and hand over to production Support for BAU Mode (Business As Usual Mode).