We provide IT Staff Augmentation Services!

Computer Programmer (technical Lead / Sr. Etl/informatica Developer) Resume

SUMMARY

  • Nine plus (9 Years and 9 Months) years of IT experience in the Analysis, Design, Development, Testing, and Implementation of business application systems for Banking and Financial Services (US Banking, Risk Management & Finance) Sector.
  • Strong experience in the Analysis, Development, User Acceptance Testing, and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
  • Strong Data Warehousing ETL experience of using Informatica 10.2/9.5/9.1/8.6/8.5 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools like Informatica Server, Repository Server manager.
  • Expertise in Data Warehouse/Data mart, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modelling, Effort Estimation, ETL Design, development, System testing, Implementation, and production support.
  • Involved in building the ETL architecture & data flow using Microsoft Visio.
  • Strong experience in Extraction, Transformation and Loading (ETL) and extensive testing data from various sources into Data Warehouses and Data Marts using Informatica Power Center 10.2/9.6/9.5/9.1/8.6/8.5 (Repository Manager, Designer, Workflow Manager, Workflow Monitor) and Power Exchange as ETL tools on Mainframe, Oracle, Teradata and SQL Server Databases.
  • Expertise in working with relational databases such as Oracle 12c/11g/10g/9i, SQL Server 2016/2012/2008 and Teradata.
  • Experience in Agile Methodology and extensive use of Jira to Create and Implement the Stories and releases.
  • Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using Oracle PL/SQL.
  • Worked on MS SQL Server queries and hands on procedures.
  • Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
  • Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
  • Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
  • Experience in using Automation Scheduling tools like CA7 and Control-M.
  • Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, design documentation, data mapping, build, unit testing, systems integration, user acceptance testing and defect fixing.
  • Semantic Code checking using Harvest/uDeploy version control tool.
  • Conducting unit testing by creating and executing of test cases to ensure successful load of data. Review on components and test results prepared by other team members.
  • Monitored Job runs through CA7, IDASH & Informatica Monitor Tools.
  • Resolving Service Now Incidents and application issues in production environment.
  • Excellent interpersonal and communication skills and is experienced in working with senior management, business users and developers across multiple disciplines.
  • Daily Stand up with Scrum Master and Weekly status meeting with Business Owner & project manager.
  • Managed an environment of trust and cooperation through an open exchange of ideas.

TECHNICAL SKILLS

Databases: Oracle 12c/11g/10g/9i/8x, MS SQL Server 2012/2008, Teradata 16.2

Operating Systems: UNIX, LINUX, Windows 2010/2007/XP, Mainframes

Database tools: TOAD, PL/SQL Developer, SQL*Plus, SQL Developer

ETL tools: Informatica PowerCenter 10.2, 9.6, 9.5.1 & 8.6.1, Informatica Power Exchange, NDM

Reporting Tool: OBIEE 12c/11g/10g, Business Objects

Data Modeling Tools: Microsoft Visio

Other Supporting Tools: Harvest, IBM uDeploy, ALM 11.0, PUTTY, Revelus, Atlassian Jira, Acorn PA 5g, Acorn EPS,Service NOW

Scheduling Tools: CA7, Control-M

Languages: SQL, PL/SQL, XML, Linux Shell Scripting

Domain Knowledge: Banking & Financial Services

PROFESSIONAL EXPERIENCE

Confidential

Computer Programmer (Technical Lead / Sr. ETL/Informatica Developer)

Environment: Oracle 12c, Informatica Power Center 10.2.1, Informatica Power Exchange, uDeploy, Artifactory, LINUX, PL/SQL, SQL Server 2016/2012, Putty/WinSCP, Atlassian Jira, Microsoft SQL Server Management Studio, Toad, Teradata Studio, Shell Scripts, Service NOW, Acorn PA5g, Mainframes, CA7, Windows 2010, OBIEE 12c

Responsibilities:

  • Working with business partners to support critical issues/requirements and make sure that identified issues are tracked, reported on and resolved in a timely manner.
  • Involved in building the ETL architecture for SSM and Source to Target mapping to load data into Oracle database.
  • Involving in requirement analysis, understanding of business requirements, identifying the flow of information and analysing the existing systems.
  • Identifying strengths and weaknesses in existing processes to enhance existing ETL processes to meet evolving requirements.
  • Created stored procedure for complex Reconciliation for GL process.
  • Creating and verifying Informatica Power Center data mappings/sessions/workflows for SSM.
  • Worked on Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Stored Procedure, Sequence Generator, Filter, Sorter, Web Services Consumer and Source Qualifier.
  • Developed Database procedure as a part of value add to restate the historical data in FACT and Dimensional tables for volume, Expense and Rates.
  • Created Shell Script to NDM the source files from Business SharePoint server(wss) to Informatica Linux Server.
  • Participating in test-driven, peer review, agile development methodology and scrum Meeting.
  • Preforming unit testing on modified SSM components.
  • Experienced in analysing query logs and explain paths. Identify performance bottlenecks and optimize respective databases and processes for performance improvement.
  • Defining load strategy and created schedules for existing and new processes to meet business SLA.
  • Created Informatica Job to pull OFS rates report from OBIEE Dashboard using Web Services Consumer transformation and sent to Business Users as part of email communication.
  • Sematic Code Checking using Udeploy/Harvest/Artifactory version control tools.
  • Peer review on the ETL components, test results and code deliverables.
  • Extensive use of Acorn PA 5g to calculate expenses and rates.

Confidential

Computer Programmer (Technical Lead / Sr. ETL/Informatica Developer/Prod Support)

Environment: Oracle 12c/11g, Informatica Power Center 10.2.1/9.6, Informatica Power Exchange, uDeploy, Harvest, Artifactory, LINUX, PL/SQL, SQL Server 2012, Putty/WinSCP, Atlassian Jira, Microsoft SQL Server Management Studio, Toad, Teradata Studio, Shell Scripts, Service NOW, Acorn PA5g, Mainframes, CA7, Windows 2010, OBIEE 12c/11g

Responsibilities:

  • Monitored Job runs through CA7, IDASH & ETL Tools.
  • Monitoring on Database, Linux and Windows patching.
  • Worked on decommissioning of old servers.
  • Health Check-up of all the applications in Confidential Run the Bank area.
  • Extraction, Transformation and Loading (ETL) of data by using Informatica Power Centre.
  • Understanding existing business model and customer requirements to support the implemented code in Production.
  • Understanding the functionality of the existing systems.
  • Participation in knowledge sharing sessions with application teams to understand the flow of the data.
  • Finding the risk and issue during the requirement and design phase.
  • Resolving Incidents and application issues in production environment.
  • Weekly status meeting with project manager.

Confidential

Computer Programmer (Technical Lead / Sr. ETL/Informatica Developer)

Environment: Oracle 11g, Informatica Power Center 9.6, Informatica Power Exchange, Harvest, UNIX, PL/SQL, SQL Server 2008, Putty/WinSCP, Atlassian Jira, Microsoft SQL Server Management Studio, Toad, Teradata Studio, Shell Scripts, Service NOW, Acorn EPS, Mainframes, CA7, Windows 2007, OBIEE 11g

Responsibilities:

  • Working with business partners to support critical issues/requirements and make sure that identified issues are tracked, reported on and resolved in a timely manner.
  • Designed Process flow to Generate Volumes for the 16 Operations Service Groupings as a part of Phase I objective.
  • Involving in requirement analysis, understanding of business requirements, identifying the flow of information and implement the design to ETL End-End process.
  • Created stored procedure for reconciliation for Org Hierarchy process.
  • Created Complex ETL to generate the GL amount using the Rolled up and Actual GL's and Cost Centres.
  • Created CA7 DOC5, DOC40 documents for Job scheduling.
  • Creating and verifying Informatica Power Center data mappings/sessions/workflows for SSM.
  • Worked on Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Stored Procedure, Sequence Generator, Filter, Sorter, Web Services Consumer and Source Qualifier.
  • Created Shell Script to call the Oracle wallet to generate the information from Volume table and send across over email to business users.
  • Participating in test-driven, peer review and development team meeting.
  • Preforming unit testing on newly created or modified SSM components.
  • Created Informatica Job to pull SSM Volume report from OBIEE Dashboard using Web Services Consumer transformation and sent to Business Users as part of email communication.
  • Peer review on the ETL components, test results and code deliverables.
  • Extensive use of Acorn EPS to calculate expenses and rates.
  • Resolved the issue for Organizational Hierarchy w.r.t Cost centre allocations in production environment.

Confidential

Computer Programmer (ETL/Informatica Developer)

Environment: Oracle 10g, Informatica Power Center 9.5/8.6/8.5, Informatica Power Exchange, Harvest, UNIX, PL/SQL, SQL Server 2008, Putty/WinSCP, Microsoft SQL Server Management Studio, Toad, Teradata Studio, Shell Scripts, Service NOW, Mainframes, CA7, Windows 2007/XP, OBIEE 10g

Responsibilities:

  • Designed Process flow to Generate Reserve amount for Consumer, Commercial lending systems.
  • Created Oracle stored procedure to implement Roll rate methodology to calculate the inherent losses.
  • Created Complex ETL to segregate the portfolios for loans and lease account based on delinquency period.
  • Worked with business partners to support critical issues/requirements and make sure that identified issues are tracked, reported on and resolved in a timely manner.
  • Created CA7 DOC5, DOC40 documents for ALLL Job scheduling.
  • Creating and verifying Informatica Power Center data mappings/sessions/workflows for ALLL.
  • Created Shell Script to NDM Source files from Windows server to Linux server for ETL processing.
  • Participating in test-driven, peer review and development team meeting.
  • Preforming unit testing on newly created or modified ALLL components.
  • Peer review on the ETL components, test results and code deliverables.
  • Extensive use of OFSAA Revelus DEFQ reports to generate allowance and losses.
  • Defect prevention and causal analysis activities.
  • Resolved the issue for Student lending portfolio loans w.r.t delinquency mismatch in production environment.
  • Weekly status meeting with project manager.

Hire Now