Etl Developer Informatica

SRINIVAS MAREDDY(Srini)

NJ/ NY Metro 919-***-**** ********@*******.*** * US Citizen

** **** ***** ** ********** in system analysis, design, coding and testing of various business applications in Big Data /Hadoop/MDM/Data Lake and Client Server /Data Warehousing.

Informatica Power Mart 7x/ 6.x/5.1/4.7.x, Power Center 10x/9x/8x/7x/5.1/1.7.x Power exchange.

Experience in Finance, Distribution/Banking/Mortgage, Telecommunication, Utility and Life/Health/Disability Insurance/Retirement (401k) Sectors.

Extensive knowledge in Database Development, Data Analysis /Analytics and Business Analysis process.

Technical Expertise

●Database: Oracle 11 g/10/9i/8.x/7.x, DB2 UDB 8x/9x, DB2 Mainframe, Sybase, MySQL, SQL Server 7.3/2000/2008, Teradata 12.0, PostgreSQL 12.3, Access and IMS / VSAM.

●Operating Systems: Sun Solaris, Linux, SCO-UNIX, IBM AIX, OS/390, MVS/ESA, Windows NT and MS-DOS

●Languages: PL/SQL (8.X/2.X), SQL*Plus, JAVA, Python, JSP, ASP, COBOL, JCL, XML, Perl and Unix Shell Scripting

●Tools: Informatica Power Center 10.5 and Informatica Cloud, Business Objects XI, SSIS, MicroStrategy 7/7i,SSIS, Git,Bitbucket,Jenkins,Hive, Presto, pgAdmin4,Serena Dimensions, NeoXam DataHub 6.1(EDM), Jira Dashboard/issue tracker.

Data Analysis/Data profiling and Problem solving.

Knowledge in Big Data/Hadoop/ DMX-Syncsort.

Knowledge in AWS/Cloud platform.

Expertise in Informatica/ ETL /Data warehousing.

Production Support and Development

Database Programming

Experience in Financial, Distribution/ Banking/Mortgage, Telecommunication, Utility and Life/Health/Disability Investments/Insurance/Retirement (401k) Sectors.

Experience in Offshore-onsite model .

Unix and Shell scripting.

Mentor and Senior Developer.

ITIL V3 Foundation certificate.

Certified Scrum Master/ Scaled Agilest.

Education

Bachelor of Engineering in Mechanical from Gulbarga University

Advance Diploma in Software from APTECH/ RDBMS/ Java.

ITIL V3 Foundation certificate.

Certified Scrum Master/ Scaled Agilest.

DMX/Syncsort training

NeoXam DataHub training (Enterprise data management )

Internal trainings and certifications :

Training and Certification on Complying with HIPAA, Emergency Preparedness and Response, HIPAA Privacy and Security Refresher, Workplace Violence Prevention Training, Software Compliance Awareness, Overcoming Ethical Obstacles, Code of Business Conduct and Ethics, Anti-Money Laundering, Busting Business Ethics Myths.

Social Media Policy Employee Acknowledgement, Security Awareness Refresher, Responsibility & Honesty, Respect @ Work Employee, Records Management Awareness, Privacy in Your Hands, Power of Inclusion Employee, Operational Excellence – Awareness, There's No Right Way to Say the Wrong Thing, Enterprise IT Change Management Process and Procedures.

Professional Experience

Work experience:

Guardian Life, NYC, NY /Holmdel NJ (Investments /Application Development) jan 31 2022 till Present

Role :Sr. Data Engineer

Environment: Informatica 10.5,SQL server 2019, JIRA and Agile development,NeoXam DataHub 6.1 (EDM),IDB2.0,BIG DATA/Data Lake,Python,Linux,AWS,SQL,Oracle 11g,Cntrl M, Bloomberg /PAM in-bound and out-bound feeds,Cntrl M,Unix scripts.

Working on SandP LSTA /Commercial Mortgage Loans(CML) /IDB2/Invest DataMart /IDB1 to IDB2 to migration/ Historical Rating/Pricing/Holdings/Trade/Portfolios/Foreign exposure data/Automated monthly and quarterly CML reports .Using Neoxam DataHub/Informatica 10.5/SQL server/Linux.

Familiarity with Private Equity/Real Estate/PLM-CML /Bloomberg /Epam /Burgiss/ 57star /BlackRock/Markit/State Street process.

Creating operational manual /Runbooks/Dataflow /How to do documents to ease the day to day production process.

Senior Software Engineer at Guardian life/ BIG DATA /DATA Lake /Data warehousing /Data Integration Engineer (ETL - Informatica) Developer

Guardian Life, NYC, NY /Holmdel NJ (ETL services /Data Integration) May 07 till Jan 31 2022

Environment: Informatica 7.x -10.5 /cloud, Data Warehousing/BIG DATA/Hadoop/Data Lake environment, Oracle 10/11 g, IBM AIX 5.3,IBM Mainframe,DB2 UDB 9.1,DB2 Mainframe, SQL server 2000-/2008,Teradata 12, IMS,VSAM, Informatica Power exchange, Erwin, Windows NT/2000,Shell Scripts and Business Objects XI, Cntrl M, Siebel CRM,TOAD, Teradata SQL Assistant, MySQL, SharePoint, WinSQL, DMX-h Syncsort, Salesforce, Hive/Presto, AWS, Cloud computing and SSIS, JIRA and Agile Development, Python,Git,Bitbucket,Jenkins, Serena Dimensions,pgAdmin4,PostgreSQL 12.3 .

Provided support to IT and Business Units 's for development and Administration projects involving ETL /Data Integration. This involves assisting with initial design, estimates, on-going support during development lifecycle.

Provided Mentor/training for new team members/business owners, Explained the present complex ETL/Data Extraction process,Supported them on various stages of project.

Worked on various BIGDATA, MDM, Customer Hub,Data Lake, Data warehousing / Data Integration projects like LAGER ( Large Area Group expenses Report ), ACT (Agency Compensation Transformation) –ODS FINRA, Transend - Financial Metrics,GPCS/NAVI/SAMS/PWC Audit process, Retirement Solutions, Group Sales Report Phase1/2/3, Score Card, SPC (special procedure Compensation), Sum Lives, Report5500, LCS/SPL/BDI/GDI to EZDATA (Disability products), Siebel Archival/ Restore,CE (customer Experience), HR, CPPM, Guardian Any Time, STP extract, UCV, GAR/DART,Flex plan,Siebel CRM, GDW (data warehouse ), MMCS (middle management compensation System),BRC (Business Resource center ), CRU report, AEP,IL (Individual Life) products, GA metrics and Ingenix.

Worked on Teradata to UDB conversion project. Converted Teradata sources /Targets into UDB on ETL mappings, Converted Teradata bteq scripts into ETL mappings / UDB scripts. Tested and compared UDB vs Teradata. Involved in performance tuning and code debugging/fixing.

Involved ETL objects migration from DEV to UAT to PROD migration. Involved in user’s creation, folder creation, and assigning permission to the users and folders.

Developed various SQL-PL/SQL and Shell scripts for file handling,error checking along with database and ETL process.

Contribute to developing standard documentation including ‘How-To’ documents/ Run Books for knowledge sharing.

Created Effective ETL processes (Informatica/Shell Scripts) which handle Data cleansing and as well error checks.

Responsible for Production Support (24 X 7) and Involved in Company Wide Disaster Recovery

Involved in Data Analysis, Data Profiling,Data quality,Data Cleansing/Validation/Testing and ETL Subject Mater expert on UCV/TRA-RS_RPT/R5500/Sum lives/Group Sales Reporting/SPC

Involved Various ETL/Data Quality tools evaluation, Proof of concept.

SME (subject mater expert) of ETL/Data analysis/Data Lineage for GroupGA/GroupSales/SPC/SAS replacement/UCV /UCV MART/R5500/SumLives/PB360/Group Renewal/AEP/Clubs and non Clubs/TRA ->RS_RPT,CRU_RPT,CPPM_PROMO .

Informatica 7.1.1 Informatica Developer/Administrator (System Specialist)

Union Bank of California, Monterey Park (MUFG), California Sep05 to May 07

Environment: Informatica 7.1.1/7.1.4, Data Warehousing environment, Oracle 9i, IBM AIX, IBM Mainframe,informatica 5x, Oracle 9i, MKS version control, Erwin, TWS(Scheduler),SQL Server 2000, Windows NT/2000,Shell Scripts and Business Objects

Worked as a Informatica 7.1.1 Administrator for ODS/EDW, CDW and ICRS (Integrated credit Information system), A major Data Warehousing System.

24*7 Production Primary support.

Provided Mentor/training for new team members/business owners, Explained the the present complex ETL/Data Extraction process,Supported them on various stages of project.

Participated in Major code merge, Code migration for ODS/EDW and CDW and ICRS. Production/non-Production Daily, monthly and Batch, INTRADAY process.

Gave effective cross training to the rest of the team members, Users and Developers.

Created an environment for major UAT for running numerous Test cycles before Prod and PPE (post production) migration.

Installed and set-up Informatica 7.x and patches for DEV, UAT, Prod and PPE environments.

Created meta- data repository queries to know the Workflow status, Error finding and to know the statistics.

Senior Informatica 6.0 Developer/Administrator

Client: Ameriquest Mortgage / Citi bank, Orange, California Feb 04 to Aug 05

Employer: Amsol inc,Newark, Delaware

Environment: Informatica 6.0, SQL Server 2000, Windows NT/2000, Oracle 9i, PVCS, Erwin, PL/SQL Development,

SQL Server Procedures/ Jobs and Business Objects.

Worked as Informatica 6.0 Developer/Administrator for IRIS (Investor Remit/Report Information System), SNAP, TCC, ODS, CIR and Power Seller.

Involved in replacing the existence SQL Server jobs into Informatica Mappings/workflows/worklets.

Studied the complete system in SQL server, replacing them with Informatica to ease the process of maintaining, error handling and debugging.

In depth Analysis of IRIS acquire /refresh daily job loads/complex procedures and DTS process.

Monitor day-to-day scheduled execution of existing DW ETL sessions. Responsible for Production Support (24 X 7 )

Investigate ETL related issues (i.e. debug job/session failures). Assist Lead ETL Developer with streamlining existing ETL.

Data Warehouse Analyst /ETL Developer

Client: Union Bank of California (ICRS-Phase 1) /Soft Master, Los Angeles, CA June 03 to Feb 04

Employer: Amsol inc,Newark, Delaware

Environment: Oracle 8i/9i, Informatica Power center client 5.1.1, Power client Server, Windows NT, AIX, PL/SQL, Mainframe, Focus, Erwin, Excel, Visio, DB2 UDB 5.0, TOAD and Unix Shell Scripting.

Union Bank of California, ICRS (Integrated Credit Reporting Systems) is a Financial and Banking Industry; this Project involves developing Data Warehouse for the purpose of Credit Reporting Systems.

Involved in the in-depth Analysis on Various Source Systems including LCP (Loan Consolidation Program) and AFS (Customer Information).

Involved in the Source (LCP) to CDR (Data Stage) Detail Data Mapping Design Document.

Involved in the interaction with Various Business Users to transform the Business Logic to ETL Process.

Involved in the development of Informatica Power center 5.1 ETL Mappings from LCP/AFS to CDR.

Involved in the Debugging and Designing using Informatica Power Center and Server Manager.

Involved in the Data Stage development to ease the complexity of Business Logic for the ETL Process.

PL- SQL Developer

Client: ISD Corp/California State Legal System/Soft Master, Corona, CA Sep02 to June 03

Employer: Master soft

ISD Corporation is the leading provider of software solutions for automating the judicial and legal systems in the State of California.

Environment: Oracle 8i, PL/SQL, Windows NT, Sun Solaris, TOAD, Apache Server, Crystal Reports and Excel

Involved in the PL/SQL Stored Procedure development including packages, Cursors, and functions.

Modified and created Packages and Procedures to meet the new requirement.

Involved in the development of Cursors and functions to support front-end application.

Involved in the Application that provides the automation of all court case types including Civil, Offense Tracking and Juvenile (delinquency and dependency) over three thousand users in forty-two separate locations.

Involved in the system that provides the court with the flexibility to tailor the system through user-defined tables.

Data Warehouse /ETL Developer June 02-Sep 02

Client: BellSouth/Accenture, Perimeter Center, Atlanta, GA

Employer: ASAP Staffing LLC

Environment: Sybase 12.0, Oracle 8.1, Informatica Power center, Windows NT, Sun Solaris, PL/SQL, SQL Server, Erwin, Excel, MicroStrategy 7 /7i, RapidSQL5.6, Visio, TOAD and Unix Shell Scripting.

Involved in designing and developing the data acquisition process for the data warehouse including the initial load and subsequent refreshes.

Using Informatica Designer, Extract & Transform the data from various source systems by incorporating various business rules for different applications by using the different objects and functions which the tool supports.

Involved in writing SQL Stored procedures to access data from Sybase and Oracle.

Involved in the Analysis, design, and Modeling. Worked on Star Schema, Data Modeling, Data Elements, Issue/Question Resolution Logs, and Source to Target Mappings, Interface Matrix and Design elements.

Involved in the study for user requirement and developed various Metrics, Hierarchies, filters, prompts and attributes by using MicroStrategy Desktop and Administrator. Troubleshooting and back up of various Projects. Involved in the Development of Unix Shell Scripting .

Database /JAVA /PL-SQL Developer July 2000 to May 2002

Client /Employer t: Object vista /Aim 2000 systems /Paragon Consultants

Environment: Java,J2EE,IBM Visual Age, Unix( Sun /AIX), WebSphere App server, Apache Web Server, Oracle 7/8, Db2 UDB 4.0/5.0,JDBC,TOAD

Web Design with JSP, Java Servlets, JDBC,HTML,RMI,Swings,Java Beans,EJB, DHTML (J2EE). Design and Develop of Client Server Application. Client server Application Development using Oracle / UDB /Sybase/ Borland Server /IBM Visual Age / Apache server / Web Sphere Application server . SQL and PL/SQL Development. Java core programming. Supporting WebSphere Application server on calls from the Clients for IBM .

. Worked with the client IBM Lab in Triangle Park, North Carolina, Department of Revenue for the State of North Carolina.

Worked on AIX /Sun Solaris/Windows 2000 platforms. Experience with Problem solving and Root cause Analysis /Debugging.

AS 400 / Y2K / Oracle Developer / Programmer May 97 – July 2000

Client: Simplex Solution, Bangalore. India

Environment: Oracle 7.3, Developer 2000 (Forms 4.5, Reports 2.5), C, C++, Pro*C, PL/SQL, AS 400

Developed user interface using Developer 2000 (Forms 4.5, Reports 2.5)

Created tables, indexes, sequences, constraints and snapshots.

Developed many procedures, functions and database triggers using PL/SQL for auditing and enforcing business rules

Generated reports using Reports designer and graphical reports using graphics designer

Involved in C, C++ and Pro*C programming. Transferred data using SQL*Loader.

Performed database administrator activities to import/export the data, manage user security and did trouble shooting for database related problems. AS 400 Development on RPG and CL on OS 400 environment .Worked on Various Y2K and In-house projects.

Awards and Recognitions:

●Nominated Thrice in the Team category of IT ELITE award for Teradata to UDB conversion projects, Financial Metrics and BDI EZDATA projects with the Business customers.

Contact this candidate