We provide IT Staff Augmentation Services!

Lead Informatica Developer Resume

Manhattan, NyC

SUMMARY:

I am an ETL/Informatica developer with over 9 years of professional experience in the banking, financial, and pharmaceutical and retail industries. I have experience with many different software methodologies such as the waterfall and Agile models. Good experience with Informatica Real time integration and Salesforce Integration.

TECHNICAL SKILLS:

ETL Tools: Information PowerCenter versions 7.x through 9.x

Databases: Oracle 8.x/9.x/10g/11g, SQL Server 2008/2005/2003/2000 , DB2 UDB 7.2, Mainframe, MS - Access.

Editors: SQL Navigator, Toad

Oracle Tools: Oracle Enterprise Manager, Quest TOAD, SQL*PLUS, SQL*Loader, SQL*Net, SQL Navigator Export/Import

Microsoft Office: MS Word, Excel, PowerPoint

Operating systems: UNIX, Windows ME/2000/2003/NT/XP, IBM AIX

Scripting/Querying Skills: UNIX Shell scripting, SQL, SQL*PLUS, PL/SQL

Data Modeling Skills: ERWIN

Scheduling Tool: Control M, Autosys

Defect Tracking: JIRA, HP QC/ALM

EXPERIENCE:

Lead Informatica Developer

Confidential, Manhattan, NYC

Responsibilities:

  • Responsible for creating mapping,sessions,workflows and worklets.
  • Developed standard and reusable Mappings and Mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup (connected/unconnected), and filter
  • Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from Oracle
  • Worked with business analysts, technical analysts, and DBAs to understand the data, the expected formats, data hierarchies and the functional hierarchies of various datasets
  • Involved in unit testing, system testing, and integration testing to check whether the data loaded into the target is accurate
  • Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors
  • Fine tuned ETL code to improve performance by identifying bottlenecks and taking corrective measures
  • Used Pushdown optimization to improve performance on loading data to Target.
  • Utilized Netezza Bulk writer to load billions of rows quickly.

Technical Environment: InTechnical Environment: Informatica 9.6.1, Netezza, MS SQL Server, Windows 7, Linux, Tidal Job scheduling tool

Lead Informatica Developer

Confidential, Jersey City, NJ

Responsibilities:

  • Responsible for leading the Trades team and directing Informatica developers onsite and offshore
  • Developed standard and reusable Mappings and Mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup (connected/unconnected), and filter
  • Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from Oracle
  • Worked with business analysts, technical analysts, and DBAs to understand the data, the expected formats, data hierarchies and the functional hierarchies of various datasets
  • Wrote various SQL queries for better performance in Source Qualifier.
  • Wrote SQL queries for each asset class for Trades stream ABORLite Delta processing.
  • Troubleshoot and fixed issues in ABORLITE for Trades including Data match rate differences and data issues.
  • Worked on troubleshooting/debugging/fixing PL/SQL packages,functions and procedures.
  • Deployed PL/SQL packages to higher environments.
  • Involved in unit testing, system testing, and integration testing to check whether the data loaded into the target is accurate
  • Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors
  • Converted ETL mappings into SQL queries to run for each Security class for Delta run.
  • Fine tuned ETL code to improve performance by identifying bottlenecks and taking corrective measures

Technical Environment: InTechnical Environment: Informatica 9.5, Oracle 11g, PL/SQL, MS SQL Server, Windows 7, Linux

Senior Informatica Developer

Confidential, Brooklyn, NYC

Responsibilities:

  • Involved in understanding and preparing technical requirements and acquiring application knowledge from Business Managers & Application Owners
  • Performed extensive data analysis along with subject matter experts, identified source data and implemented data cleansing strategy
  • Prepared mapping documents for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards
  • Used PowerExchange to capture changes and load data continuously into Oracle tables
  • Responsible for creating Real time web service mappings using web service consumers to consume the SOA services in giving a proper response
  • Created mapping for loading data into Salesforce tables via Informatica for Salesforce Integration
  • Prepared a Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information required for the maintenance and operation of the application
  • Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community

Technical Environment: Informatica 9.5, Informatica Real time Integration, Oracle 11g, Web services, Salesforce Integration, CDC PowerExchange for Oracle, SQL Developer, UNIX, Erwin Designer 4.1.

Informatica Developer

Confidential, Parsippany, NJ

Responsibilities:

  • Involved in the full development lifecycle from requirement gathering through designing, building, QA, deployment and providing support using Informatica Power Center and SQL Server objects
  • Resolved source system data issues (XML files and XSD schema) with Source System Owners
  • Worked closely with business analysts to gather functional specifications and turn them into technical specifications
  • Co - ordinated and monitored the Data Feed loads from offshore team
  • Worked on data profiling, data transformation, and data cleansing
  • Worked on Informatica tools Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer and Transformation Developer.
  • Built Workflows and Worklets to schedule, sequence and parameterize different ETL tasks.
  • Designed and wrote Unit Test Plans.
  • Prepared and executed test cases
  • Built, maintained, and fine-tunes ETL mappings to load data from XML source to Relational Pre-Staging, then from Pre-Staging to Staging, then from Staging to Data warehouse using Informatica Power Center.

Technical Environment: Informatica Power Center8.x, Oracle 10g, PL/SQL, Visio, Erwin, Windows, UNIX Shell Scripts, AIX.

Informatica Developer/Tester

Confidential, Wilmington, DE

Responsibilities:

  • Responsible for gathering test requirements and creating and scoping out the test plan.
  • Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
  • Responsible for anayzing business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project using Informatica, Shell Scripting.
  • Created and maintained test reports, identified bugs and reported findings using Quality Center
  • Prepared testing strategy, testing schedule, test Cases depending upon the Requirement documents for integration and system testing.
  • Defect management, bug tracking and bug Reporting using Quality Center.
  • Queried databases using SQL queries in TOAD and SQL Server Management Studio to validate the data loaded into target tables.
  • Tested Informatica mappings and workflows, and worked extensively with Informatica for data sourcing, data transformation and data loading.

Hire Now