We provide IT Staff Augmentation Services!

Technology Lead (informatica Senior Developer) Resume

4.00/5 (Submit Your Rating)

Madison, WI

PROFESSIONAL SUMMARY:

  • Over 9+ years of IT experience with a strong background in SDLC, Data Integration tools
  • Expertise in Informatica Power Center and Power exchange 9.x/8.x/7.x/6.x extracting data from Oracle, SQL Server and DB2 databases.
  • Extensive experience in Extraction, Transformation and Loading of data using Informatica from heterogeneous sources.
  • Extensive experience with Healthcare, Energy and Media domains.
  • Strong ability to analyze source systems and business requirements, identify and document business rules, design data architecture for cohesive decision support and prepare dimensional data models.
  • Extensive knowledge of Dimensional Data Modeling like Star and Snowflake schemas and knowledge in designing tools like Erwin and Power Designer.
  • Extensively worked in development of Informatica Mappings and Informatica Workflows.
  • Experience with Informatica Advanced Techniques - Dynamic Caching, Memory Management, Parallel Processing to increase Performance throughput.
  • Extensively involved in Optimization and Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management and parallel threading.
  • Experience in creating and using Stored Procedures, Functions, Triggers, Views, Synonyms, and Packages in SQL Server 2000/2005, Oracle 10g/9i/8i and DB2.
  • Proficiency in Performance/ Query tuning. Generation /interpretation of explain plans and tuning SQL to improve performance.
  • Highly Skilled in Unix Shell Scripting and experience on different UNIX platforms.
  • Extensive knowledge in scheduling of ETL jobs using Autosys, TWS, Tivoli, ZENA, ZEKE .
  • Knowledge in developing reports using Crystal reports
  • Extensively used various ticketing tools for change management and production incident ticket handling using Service Now, JIRA, CA Service desk, Remedy.
  • Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per business requirements.
  • Experience in working in an onsite-offshore structure and effectively coordinated tasks between onsite and offshore teams.
  • Experience in the full-cycle software development including requirements gathering, prototyping, and proof of concept, design, documentation, implementation, testing, maintenance and production support.
  • A highly motivated self-starter and a good team leader and player with excellent verbal and written communication skills.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.6.1/9.5/9.1 /8. x/7.x/6.x, Informatica PowerExchange 9.6.1/9.5/9.1 /8. x/7.x/6.x

Databases: Oracle 7.x/8.x/9x/10g/11g, MS SQL Server 2012/2008/2005/2000 , DB2 UDB 7.2,v8.1, Sybase, PostgreSQL, MS-Access, MS SQL Server 2008/2005

Database Tools: Quest, TOAD, SQL*PLUS, Oracle SQL Developer, WinSQL, PGAdmin.

Data Modeling tools: Erwin, MS Visio

OLAP Tools: , Crystal Reports 2008/ XI R2, Business Objects XI, Crystal Reports 10

Languages: SQL, PL/SQL, Shell Scripting (K-shell/B-shell), HTML, XML

Scheduling Tools: Autosys, TWS, Tivoli, Zena, Zeke

CURRENT PROJECT PROFILE:

Technology Lead (Informatica Senior Developer)

Confidential, Madison, WI

Responsibilities:

  • Production defects fixing after warranty support is over.
  • Fixing Infogix checkout jobs for ABC(Audit, Balancing and Control) process
  • Extensive analysis of end to end flow of application which involves analysis of autosys batch jobs and job run for analyzing production defects.
  • Enormous use of various functionality of JIRA and CA Service desk for production defect closure and progress computation.
  • Analysis/ modify/testing of existing complex Informatica mappings using Unconnected Lookup, Dynamic lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, dynamic Lookup and Router transformations to extract, transform and loaded data to ODS and propagate through CSA and then ADL layer.
  • Write Unit Test cases and executed test scripts successfully for modified mapping.
  • Write and modified existing complex PLSQL scripts /functions/procedures/packages for Change request.
  • Accomplish Performance tuning of Informatica and SQL/PLSQL scripts
  • Support during PROD deployments and bug fixes.
  • Execute SQL scripts through informatica external procedure transformation using UNIX shell script.
  • Code Review as per ETL/Informatica standards and best practices
  • Modify/Create Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager for production code fixes.
  • Write UNIX Korn shell scripts for file transfer/archiving./Email notifications for change request.
  • Resolved blocker production defects which has SLA of 1-2 days coming from various subject areas of Auto/Property/Watercraft Insurance
  • Extensive use of Autosys batch jobs for scheduling Informatica workflows
  • Work with various databases Oracle, PostgreSQL, DB2 .
  • Fix production autosys batch job failure.
  • Handling emergency production deployment by raising emergency Change Order.
  • Working in offshore onsite model as Lead developer.

Technologies used: Informatica PowerCenter 9.6.1/9.5/9.1 , Informatica PowerExchange 9.5/9.1, oracle 11g, XML, XSD, PL/SQL, Autosys, PostgreSQL.PGAdmin III, Oracle SQL Developer, WinSQL,JIRA, CA Service Desk.

Confidential, Windsor, CT

Associate-Projects

Responsibilities:

  • Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
  • Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
  • Created salesforce External loader application and used this application to connect to salesforce.com.
  • Created Mapplets, reusable transformations and used them in different mappings.
  • Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
  • Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for clean-up and update purposes.
  • Implemented parallelism in loads by partitioning workflows using Pipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
  • Validation of Informatica mappings for source compatibility due to version changes at the source.
  • Trouble shooting of long running sessions and fixing the issues.
  • Developed shell scripts for Daily and weekly Loads and scheduled using TWS (Tivoli) tool.
  • Involved in writing SQL scripts, stored procedures and functions and debugging them.
  • Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
  • Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
  • Used Service Now to create change request and handing production incident ticket of various priority (Sev1,2,3) which might have raised by Job failure / business users because of bad data. SLA Sev1 -2 hours, Sev-2: 4hrs and Sev-3: 2 days
  • Worked with reporting team to help understand them the user requirements on the reports and the measures on them. Helped them in creating reports.
  • Migrated repository objects, services and scripts from development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
  • Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.

Environment: Informatica PowerCenter 9.1,PowerExchange 9.1, oracle 11g, salesforce, XML, XSD, PL/SQL, Unix, Unix Shell Script, Erwin, TWS,Visio., MS SQL Server 2012, ServiceNow.

Confidential

Informatica Developer

Responsibilities:

  • Analyzed issues related to Enterprise data warehouse (EDW), Stored procedures in OLTP system and analyzed, design and develop ETL strategies.
  • Developed mappings, sessions and workflows in Informatica Power Center.
  • Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
  • Worked with heterogeneous source to extract data from Oracle database, XML and flat files and loaded to a relational Oracle/DB2 warehouse.
  • Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
  • Performed tuning of SQL queries and Stored Procedure for speedy extraction of data to resolve and troubleshoot issues in OLTP environment.
  • Troubleshooting of long running sessions and fixing the issues related to it.
  • Worked with variables and parameters in the mappings to pass the values between sessions.
  • Involved in the development of PL/SQL stored procedures, functions and packages to process business data in OLTP system.
  • Carried out changes into Architecture and Design of Oracle Schemas for both OLAP and OLTP systems.
  • Worked with Services and Portal teams on various occasion for data issues in OLTP system.
  • Worked with the testing team to resolve bugs related to day one ETL mappings before production.
  • Creating the weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
  • Used JIRA for defect fixing.
  • Involved in meetings with production team for issues related to Deployment, maintenance, future enhancements, backup and crisis management of DW.
  • Worked with production team to resolve data issues in Production database of OLAP and OLTP systems.

Environment: Informatica PowerCenter 9.1, oracle 10g, PL/SQL, SQL Developer 3.0.1, Toad 11, Quest Central, Putty, UNIX, TOAD, MS SQL Server 2008, JIRA

Confidential

Informatica Developer

Responsibilities:

  • Requirement gathering from on-site and customers.
  • Performed requirement analysis and depending upon this created design documents
  • Developed mappings workflows and session,
  • Performed unit testing and prepared unit test cases and test plans to ensure defect free delivery.
  • Provided assistance during System testing and Production Implementation.

Confidential

Informatica Developer

Responsibilities:

  • Implemented CDC by tracking the changes in critical fields required by the user.
  • Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
  • Extensive use of Persistent cache to reduce session processing time.
  • Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
  • Modified the shell/Perl scripts as per the business requirements.
  • Maintained warehouse metadata, naming standards and warehouse standards for future application development.
  • Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions.
  • Developed shell scripts for Daily and weekly Loads and scheduled using Unix Maestro utility.
  • Developed shell scripts for file transferring
  • Extensively used Putty Utilities to load and execute sql scripts using Unix.
  • Implemented screen door process for cleaning flat files as per the business requirements.
  • Preparing ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
  • Involved in Unit testing, Iterative testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
  • Preparing and using test data/cases to verify accuracy and completeness of ETL process.
  • Actively involved in the production support and also transferred knowledge to the other team members.
  • Used remedy for production incident ticket handling raised because of Job failure.
  • Co-ordinate between different teams across circle and organization to resolve release related issues.

Environment: Informatica PowerCenter 8.6.1, Putty, Informix, MS SQL Server 2005, Erwin 4.1, Windows XP, UNIX, UNIX Shell Script, Remedy.

Confidential

Informatica Developer

Responsibilities:

  • Written SQL in DB2 v 8.0 which is the only database used in this project.
  • Used Business Objects Server for publishing crystal reports.
  • Responsible for Business Requirement Understanding..
  • Responsible for Requirement Analysis, Design related issue gathering & get solution from Business / On-site team.
  • Designed complex reports, dashboards, graphs, graph embedded reports in Crystal Report XI.
  • Performed Unit Testing and tuned the mappings for better performance and built Unit-Testing plan preparation and & Unit testing of Reports.
  • Worked on defect fixing for System Testing & UAT.
  • Prepared of the Design & Approach documents for Reports.
  • Developed XML which has served as the basic block in query customization for reports, alerts there by developing queries on the fly with the help of input provided by particular user using his or her credential.
  • Created insert shell script in UNIX for populating fields’ in metadata tables for query customization and layout customization which made the process faster and easier.
  • Used Concurrent Versioning System (CVS), Version control system software to keep track of all work and all changes in a set of files.
  • Developed XML which has served as the basic block in query customization for reports, alerts there by developing queries on the fly with the help of input provided by particular user using his or her credential.
  • Developed informatica workflows, mappings, sessions for Extraction loading and transformation for data cleansing purpose.
  • Interacted with business analysts and translate business requirements into technical specifications.
  • Designed and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
  • Extensively worked on Informatica to extract data from Flat files, Excel files, and MS Access database to load the data into the target database.
  • Implemented the Incremental loading of Dimension and Fact tables.
  • Created Stored Procedures for data transformation purpose.
  • Created Tasks, Workflows, Sessions to move the data at specific intervals on demand using Workflow Manager.
  • Developed the control files to load various sales data into the system via SQL*Loader.
  • Developed Unix Shell scripts for maintaining Files.
  • Created PL/SQL Stored procedures and implemented them through the Stored Procedure transformation.
  • Develop, test and implement break/fix change tickets for maintenance.
  • Involved in writing test cases, assisting Testing team in testing.
  • Developed the document of the complete ETL process.

Environment: Informatica 8.6.1, UNIX, TOAD, IBM DB2 8.1, Oracle 10g (SQL/PLSQL), UNIX, UNIX Shell Script, Zena, Zeke, MS SQL Server 2005

Confidential

Informatica Developer

Responsibilities:

  • Analyzed business process and gathered core business requirements. Interacted with business analysts and end users.
  • Prepared a handbook of standards for Informatica code development.
  • Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all application and systems.
  • Developed Custom metadata repository.
  • Used Informatica designer for designing mappings and mapplets to extract data from MS SQL Server, Sybase and Oracle sources.
  • Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.
  • Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
  • Used Debugger to test the data flow and fix the mappings.
  • Created and monitored workflows and task using Informatica PowerCenter Workflow Manager.
  • Partitioned Sessions for concurrent loading of data into the target tables.
  • Tuned the workflows and mappings.
  • Involved in identifying the bottle necks and tuning to improve the Performance.
  • Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
  • Executed Workflows and Sessions using Workflow Monitor.
  • Dealt with data issues in the staging flat files and after it was cleaned up it is sent to the targets.
  • Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.
  • Executed the workflow using pmcmd command in UNIX.
  • Environment: Informatica PowerCenter 8.1.1/7.1.3 , Oracle 10g/9i/8i, MS SQL Server 2000, PL/SQL, Erwin, TOAD, SQL*Plus, SQL*Loader, UDB, Sybase, XML, Windows, Linux and HP-UNIX

Environment: Informatica 7.1.1, UNIX, TOAD, IBM DB2 8.1, Oracle 8i (SQL/PLSQL), MS Access 2006, Win 2000, Autosys, MS Excel 2006, UNIX, UNIX Shell Script.

We'd love your feedback!