We provide IT Staff Augmentation Services!

Sr. Informatica Etl Developer Resume

SUMMARY:

  • 9 years of experience in data analysis, design and development of various business applications.
  • Experience in implementing Data Warehousing applications using Informatica Power Center.
  • Expertise in relational (MS - SQL Server, DB2 and Oracle) databases.
  • Well verse with UNIX shell scripting.
  • Complete hands on experience in all phases of SDLC.
  • Experience in performance tuning of mappings, sessions, workflows.
  • Worked on Slowly Changing Dimensions (SCD's), implemented Type1, Type 2 to keep track of historical data.
  • Extensive experience in extraction, transformation and loading of data from heterogeneous source systems like flat files, excel, relational DB.
  • Worked extensively on complex mappings.
  • Strong Business knowledge in Compliance, Surveillance, Financial Domain and Investment Banking.
  • Experienced in working on Migration project.
  • Extensive knowledge and experience in AGILE (Scrum) Methodology.

TECHNICAL SKILLS:

ETL Tool: Informatica 9.6, 9.1, 8.6 and 8.1 (Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager)

Languages: SQL, UNIX Shell Scripting and UNIX

IBM DB2, MS: SQL Server, Oracle

Other Tools: Autosys, Perforce, JIRA, BCP Utility, WinSCP, Deployment tool, Migration tool, Service Now, SharePoint, Toad Data Point, NPR, Tidal 6.2, One Identity TPAM, HP QC

Techniques: Data Warehousing, Business Intelligence and Agile Methodology

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Informatica ETL Developer

Responsibilities:

  • Worked closely with the BST team to plan and analyze data requirements and mapping documents.
  • Created design documents listing the ETL process flow and flowcharts for each application code.
  • Developed ETL mappings using Informatica Powercenter and performed peer review for the team.
  • Developed various Autoentry and Reconciliation tools using complex mapping transformations.
  • Created complex views which were treated as source to the mapping and as Lookup table.
  • Created Unit Test Cases to validate the code.
  • Added jobs and created grouping for pre-migration and migration in Tidal job scheduler.
  • Managed Non-Production Request System(NPR) for deploying code, scripts, and jobs from DUT to SIT/UAT.
  • Performed Unit Testing, Integration Testing and User Acceptance Testing.
  • Worked on various Conversion Pilot(CP) and Migration Rehearsals(MR) before the actual Go Live.
  • Maintained Activity Tracker which records the progress of all the tracks during migration cycles.
  • Performed Defect triage and reworked on migration tools ahead of upcoming MR.
  • Participated in reporting Status and metrics to PMO on tasks, schedule and results.

Confidential

Sr. Informatica ETL Developer

Responsibilities:

  • Design and implement the application for consuming the source feed data from upstream.
  • Design various data model and pipeline for different type of data sources.
  • Apply strategic approach to deal with very large data set.
  • Implemented Slowly Changing Dimension (SCD) - Type 2 logic using Informatica mapping. Worked on SCD, truncate and incremental load.
  • Create very complex ETL mappings with extensive use of aggregator, union, filter, router, normalizer, joiner, sequence generator, stored procedure and lookup transformation.
  • Worked extensively to identify issues and improve the performance across various aspects.
  • Package the different components and deploy the solution to QA and UAT environments.
  • Lead the discussions with upstream and BA team to streamline the Job scheduling and execution.
  • Address production issues by performing root cause analysis, implementing and deploying the fix within the SLAs.
  • Coordinate with development and RTB team for production deployment. Create CR and incident using Service Now.
  • Perform the post deployment (QA/UAT/PROD) health checks and monitor for any issues during the initial job execution.
  • Perform cross region and peer review of new development and enhancement as per business requirement.
  • Closely worked with client on audit queries.

Confidential

Informatica ETL Developer

Responsibilities:

  • Work on architecture to consume large amount of data receive and process them in most efficient and optimize manner, considering dependency on other data load/feeds.
  • Develop the system to consume data feeds received from front office, middle office and back office up-streams.
  • Work with Controller/Users to analyze the requirements and translate them into high level technical design.
  • Perform data quality check for data consumed and processed by our system.
  • Building the infrastructure which is capable of processing huge amount of data from multiple sources.
  • Created a new System/Database (COG-US) where millions of records are loaded and extracted every 15 mins.
  • Created a complex solution to handle extraction of data at run time and auditing every single transaction.
  • Interact with business users to analyze the production issues, perform root cause analysis and provide permanent fix.
  • Assist QA/BA team for data testing.
  • Performance tuning in ETL, SQL, Stored Procedure and Scripting.
  • UNIX shell scripting to process files and archiving process.
  • Unit test, integration test and deployment of code to upper environment.
  • Work with Production Support team during deployment of code.

Confidential

Informatica ETL Developer

Responsibilities:

  • Contributed in data analysis and design, according to business requirement of client.
  • Extensively worked in Data ETL process from source to target systems using various tools and languages.
  • Developed and implemented the UNIX shell script for various requirements.
  • Tuned and tested the mapping using different logics to provide maximum efficiency.
  • Performed unit testing at various levels of the ETL.
  • Developed a Dynamic mapping which is used to handle varying number of data element from the source feed.

Hire Now