SUMMARY:

• 9 Years of experience in IT industry with strong background in SDLC, Data Integration Tools (ETL) and Databases/queries.
• Primary skills and experience working with Informatica Power Center, Teradata, Oracle, Autosys and Informatica Admin Activities.
• Secondary Skills with DB2, Netezza, IDR, DVO, TDM, PWX, MDM, Webservices, Talend for Bigdata
• All together have covered complete SDLC (Software development Life cycle) from requirement gathering to production support.
• Experience in data warehousing techniques for Data Analysis, Data Profiling, Data Cleansing, Transformation, Consolidation, Integration, Data Import, Data Export using various source (Oracle, MS SQL Server, DB2, Teradata, XML and Flat files) and target.
• Experienced in developing Packages, procedures, functions, Partitions and views.
• Worked on Informatica Data Quality ( IDQ) for profiling, Analysis, data quality, Reference tables, mapps and others.
• Worked on Star Schema and Dimensional (Dim - fact) Modeling, and loading those.
• Experience Performance Tuning, Performance Monitoring and Query Optimization using Teradata Explain and Table partitioning.
• Experience working with Teradata utilities Multiload/Fastload/TPUMP/BTEQ to load data from flat files/database to the Teradata database.
• Extensive Experience in Finance, Retail, Pharmacy and Healthcare domains
• Over 3+ Experience working in Agile Methodology.
• Good experience in Unix scripting and known to Python
• Knowledge of reporting tools BO,MSRS, Cognos, Tableau and Cucumber.
• Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare Estimation of work including Analysis, code, Test plans, Test scripts, Test cases for manual testing.
• Worked with team of 4-6 Associates as part of the on shore-offshore model as team lead (TL) for 4+ years
• Good Exposure to Big data/Hadoop technology
• Working Knowledge of Oracle Data Integrator (ODI), Datastage, SQL Server Integration Services (SSIS)
• Excellent Troubleshooting, Analytical, Interpersonal skills and open to take up challenges.

TECHNICAL SKILLS:

Operating Systems: AIX, Linux, Sun Solaris, Windows 2000/XP

RDBMS: Oracle, Teradata, DB2, Netezza

Languages: SQL, PL/SQL, Unix, PythonT ools and Utilities: Informatica Tools, AUTOSYS (IXP), CA Desk, HPOV, CA SCM, SVN, Cognos, BO, Microstrategy, SSIS, ODI, Datastage, Control M

WORK EXPERIENCE:

Confidential, Reston, VA

Informatica Developer

Responsibilities:

• Gathering requirements, understand and sharing the details with support team and users.
• Developed PL/SQL Packages, Procedures and Functions accordance with the business requirements for loading data into database tables.
• Worked on Slowly Changing Dimensions Type 2 and Type 1
• Used and created different reusable components from Reusable User Defined Variable to Maplets.
• Used Pre/Post SQLs to truncate/drop/Create Index.
• Loaded ODS tables and EDW tables.
• Created Mapplets for Audit tables load and mappings/session/Wfs extensively using exp, Joiner, Lookup, Normalizer, Filter, Router, Transactional Control, Update Strategy, Source Qualifier, Sequence Generator and UDT Transformations.
• Also In session used pre-post sql for Source and Target and Pre-post cmd for session
• Involved in Development, unit, performance and integration testing for the jobs
• Migrate the developed component to higher environment and coordinate with testers
• Worked on Creating the JIL files, Jilling it to create the jobs and run commands to process the jobs as required.
• Worked on EDW frame work to load the Data to NZ DB using NZ scripts and Informaica
• Worked on Informatica Data Replicator (IDR) tool to replicate the data from IDS to EDW
• In IDR have used Config, Tasks (extractor/applier/sendfile) and scheduler
• Used SVN version control tool for code check-in to higher environments.
• Worked on Agile Methodology (Rally)

Environment: /Tools/Technologies: Linux, Autosys, Informatica PC, IDR, Toad, Netezza, Oracle

Informatica Admin/IDQ & Talend Developer

Responsibilities:

• Support the Informatica Grid environments
• Support newly introduced Informatica TDM and DVO utilities
• Supported Power Exchange (PWX) for DB2, cdc and data files.
• Look for PWX starter tasks, restart tokens, task logs, Task recycle order and monitor for any issues connecting from Informatica server
• Supported the Informatica Analyst project, B2B (DT studio) and webservices (to get the run stats for session/wfs)
• Work on any on the services failures using the admin console and using the infa commands.
• Work on different adhoc requests using different infa commands or metadata table queries.
• Monitor the Informatica Health and Automate the critical Alerts
• Work on regular Admin activities as per request (Creating Connection String, Native Access Groups, Assigning the IS, File changes, Permission/Owner changes, Seq Reset, ..)
• Creating the Deployment group in Lower environment and migrating them to Production.
• Have worked on IDQ for Reference table, Profiling and Address Doctor.
• Trouble shooting the long running jobs, Crashes, Service restarts, Performance improvement suggestion to Application Team, Any configuration Changes in Admin Console as per improving the system
• Involved in migration of the mapps from IDQ to power center
• Applied the rules and profiled the source and target table's data using IDQ.
• Work on the Cognos/Microstrategy admin activities and monitoring for scheduled Control M jobs
• Worked on Talend POC to check on the performance and flexibilities as developer.
• Extensively created mappings in Talend using its most of transformations like tMap, tJoin, tReplicate, tParallelize, tConvertType, tflowtoIterate, tAggregate, tSortRow, tFlowMeter, tLogCatcher, tRowGenerator, tNormalize, tDenormalize, tSetGlobalVar, tHashInput, tHashOutput, tJava, tJavarow, tAggregateRow, tLogCatcher, tFilter etc.
• Extensive experience in using Talend features such as context variables, triggers, connectors for Database and flat files like tMySqlInput, tMySqlConnection, tOracle, tMSSqlInput, TMSSqlOutput, tMSSqlrow, tFileCopy, tFileInputDelimited, tFileExists.

Environment: /Tools/Technologies: AIX, Linux, Mainframe, Informatica Family (PC, Analyst, B2B, TDM, DVO, PWX, Webservices), Microstrategy, Cognos, Talend for Bigdata, Control M

Informatica/Talend Developer

• Involve with BA and Architect to decide on the overall new design
• Worked on Agile Methodology with 2 Week sprint
• Created the HLD and then LLD and get it approved with TL and then the Architect
• Preparing documentation for requirements, design, install and Unit testing
• Developed the code using creating reusable components
• Created Mapplets/worlet also mappings/session/Wfs extensively using exp, Joiner, Lookup, Normalizer, Filter, Router, Transactional Control, Update Strategy, Source Qualifier, Sequence Generator and UDT Transformations.
• Also In session used pre-post sql for Source and Target and Pre-post cmd for session .
• Prepared the final Handover Document
• Worked on IDQ for Profiling the Tables/Columns
• Worked on Talend and Informatica to load the data.
• Extensively created mappings in Talend using its most of transformations like tMap, tJoin, tReplicate, tParallelize, tConvertType, tflowtoIterate, tAggregate, tSortRow, tFlowMeter, tLogCatcher, tRowGenerator, tNormalize, tDenormalize, tSetGlobalVar, tHashInput, tHashOutput, tJava, tJavarow, tAggregateRow, tWarn, tLogCatcher, tMysqlScd, tFilter, tGlobalmap, tDie etc.
• Extensive experience in using Talend features such as context variables, triggers, connectors for Database and flat files like tMySqlInput, tMySqlConnection, tOracle, tMSSqlInput, TMSSqlOutput, tMSSqlrow, tFileCopy, tFileInputDelimited, tFileExists.
• Used B2B/DT studio extensively for creating the parser, serializer and mappers projects for different unstructured data files.

Environment: /Tools/Technologies: AQT (DB2), UNIX, Informatica, Talend for Bigdata

Informatica Developer/IDQ Developer

Responsibilities:

• Involve in the discussion with Business to clarify the requirement
• Involve in the discussion with testers to get the scenarios checked
• Created the HLD and then LLD and get it approved with TL and then the Architect
• Preparing documentation for requirements, design, install and Unit testing
• Keeping in touch with other development team to make sure we are in right direction and checking the progress time to time
• Develop the mapping and workflows based on requirement
• Involved in Development, unit, performance and integration testing for the jobs
• Creating the Implementation plans and reviewing with team before the implementation date
• Used Informatica MDM to select the golden record and load to Address Target
• Involved in migration of the mapps from IDQ to power center
• Applied the rules and profiled the source and target table's data using IDQ.

Environment: /Tools/Technologies: AQT (DB2), UNIX, Informatica

Data Analyst

Responsibilities:

• Meet with Business to get the requirements, improvements and suggestion
• Meet with the Source System teams to get the changes and replicate to ETL side as required
• Gathering requirements, understand and sharing the details with development team
• Data profiling, Data modeling and then creating the Technical Specs
• Preparing documentation for requirements, design, install and Unit testing
• Keeping in touch with development team to make sure we are in right direction and checking the progress time to time
• Involved in Development, unit, performance and integration testing for the jobs
• Develop test cases and review the Unit testing.
• Creating the Implementation plans and reviewing with team before the implementation date.
• Knowledge of US Financial and Credit and Risk team with in it.

Environment: /Tools/Technologies: AQT (DB2), UNIX, Datastage

Application Support/Informatica-Teradata Developer

• Designed the ETL processes using Informatica to load data from Mainframe DB2, Oracle, SQL Server, Flat Files, XML Files and Excel files to target Teradata warehouse database.
• Designed Reusable Transformations, Mapplets, reusable Tasks and designed Worklets as per the dependencies of various sessions and parent-child tables.
• Worked on Teradata utilities BTEQ, MLOAD and TPUMP and tuned SQL.
• Created Oracle stored procedure, package and triggers. Worked on analytical query to format report. Created materialized view to store summarized data.
• Investigate, debug and fix problems with Informatica Mappings and Workflows.
• Implemented SCD - Type I & II in different mappings as per the requirements.
• Worked extensively on the HIPPA 4010 transactions and HIPPA 5010 transactions as the source data like 834,835, 277,276 and more.
• Involved in analyzing the ICD 9 and ICD 10 for the data mapping from ICD 9 - ICD 10 and ICD 10 - ICD 9 in source and target level.
• Production support for the migrated code for 2 months

Environment: /Tools/Technologies: Informatica Power Center 8.6, Oracle 11g, UNIX, SQL, Autosys, Teradata, Utilities BTEQ, FLOAD, HPOV.

Confidential

Application Support

Responsibilities:

• Gathering requirements, understand and sharing the details with support team and users.
• Developed PL/SQL Packages, Procedures and Functions accordance with the business requirements for loading data into database tables.
• Worked on Slowly Changing Dimensions Type 2, Type 3 and Type 1 .
• Handled system utilization issues, performance statistics, capacity planning and recovery of databases.
• Monitoring day-to-day Process for different Data Loads and resolving Issues.
• Provide post-production support and Performance tuning in Informatica and DB side.
• Provide status reports to the Core Team and Stakeholders including progress, milestones and issues.
• Keeping track of the scheduled jobs of the Confidential DWH through scheduling tools Autosys & ESP Tool and Ticketing tools HPOV & CA
• Troubleshooting problems in Informatica, Teradata, Unix and Oracle code.
• Worked with Teradata utilities (Fload/Mload/BETQ) to load files into Teradata tables
• Doing data-fixes on request or on necessary basis depending upon the job failures.
• Involved in training and mentoring of new joiners in process and technical areas.
• Worked in different, most critical & secure subject areas like CDMA, Marketing, Pharmacy where we need to work with extra precision & alert
• Used CA SCM tool to promote the development work into the production
• Communicate efficiently with clients in weekly meetings and whenever it was necessary for the schedule updates during outages & environment migrations.
• Migrated few ETL jobs from existing Informatica to ODI (Oracle Data Integrator)
• Used the MDM concept to find the best record and update it as per Data quality rule
• Also partly involved in Informatica Admin Activities
• Co-ordinated with different support teams and development teams.

Environment: /Tools/Technologies: Oracle 10g, PL/SQL, Teradarta, Sun Solaris 5.10, INFORMATICA,ODI, CA Service Desk, HPOV, SCM, PWX