We provide IT Staff Augmentation Services!

Sr. Informatica Developer/lead Resume

4.00/5 (Submit Your Rating)

Milwaukee, WI

SUMMARY

  • Around 8 years of experience in IT Software Development Life cycle involved in Business Requirement Analysis, Application Design, Data Modeling, Development, Testing and Implementation of Data Warehousing applications in Manufacturing, Travel and Insurance domains.
  • Extensive experience in writing SQL, Stored procedures, Functions, Packages, Database triggers, Shell - Scripts and SQL Loader scripts.
  • Proficient in T-SQL queries using Store Procedure, Dynamic SQL, joins, Views, User defined functions, Triggers, Cursors, CTE, DML, DDL and etc.
  • Very strong in SQL Query Tuning, Database Triggers, Stored Procedures, reducing time for night batch jobs by reviewing PLSQL code, modifying database parameters.
  • Extensively worked in Client-Server application development using Oracle 11g/10g/9i/8i Forms 9i/6i, Reports 10g/6i/6.0, SQL, PL/SQL, Oracle 9iDS, Oracle Import and Export Utilities.
  • Extensive experience in data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, bulk and batch processing.
  • Expertise in conducting requirements gathering sessions, feasibility studies and Impact Analysis, Risk analysis & management, base lining acceptance criteria.
  • Provided strategic thinking and solutions while driving Architectural Recommendations specific to data warehouse applications and business intelligence tools focusing on ETL functions.
  • Provided project level design, data analysis and application performance analysis.
  • Very Strong wif Data Warehousing: analysis, modeling, manipulation (ETL), mapping, has used front End tools like TOAD, PL/SQL Developer etc.
  • Expertise in managing several projects simultaneously for the whole project life cycle.
  • Extensive experience in the development, implementation, deployment & integration strategies wifin a team oriented environment, utilizing quantitative & qualitative analytical skills.
  • Strong Knowledge of SDLC and Agile (Scrum) methodology.
  • Experience in using Informatica Power Center, an ETL tool in extracting the data from various sources like Flat files, XML files, Oracle and COBOL on UNIX and Windows platform
  • Good understanding of ETL, Dimensional Data Modeling, Slowly Changing Dimensions (SCD) and Data Warehouse Concepts.
  • Experience in using Informatica Power Exchange to extract the data from and load the data to the salesforce application using Bulk API, Soap API and Metadata API concepts in Salesforce.
  • Experience in integration of various Operational Data Source (ODS) s wif Multiple Relational databases like Oracle, Teradata, SQL Server and Worked on integrating data from flat files of fixed width and delimited.
  • Hands on expertise wif SQL Server, Oracle and DB2 Databases.
  • Hands on expertise wif UNIX Shell Scripting to connect web portal and download the xml and csv files.
  • Writing scripts in Unix to process source files, target files, to automate the email notifications, Archive the files, copy, ftp and cleanse the files to process in ETL.
  • Extensive experience in creating documents for - Low level and High level design docs, Unit test plans, test cases and test scripts.
  • Expert level understanding of Oracle Database Capabilities and DW best practices including appropriate use of Index, Partitions, Materialized Views etc.
  • Worked on Stored Procedures, Triggers, Cursors, Indexes and Functions.
  • Excellent management, communication, documentation, interpersonal, analytical skills and strong ability to perform as part of a team

TECHNICAL SKILLS

Business Intelligence: Informatica 10.1/9.x/8.x, Test Data Management

Data Bases: Oracle 10g/9i/8i, DB2, SQL Server 2000/2005/2008, Teradata

Languages: SQL, PL/SQL, Shell Scripting, PostgreSQL, C, Java

Tools: PLSQL Developer, TOAD, Control M, Subversion

OS/Environment: Windows 9X, DOS, UNIX

Software Development: Agile Methodology

PROFESSIONAL EXPERIENCE

Confidential - Milwaukee, WI

Sr. Informatica Developer/Lead

Responsibilities:

  • Perform requirement analysis through coordination wif business analysts and define business and functional specifications.
  • Provide documentation of ETL design and technical specifications, high level and low level design specifications.
  • Create test cases for Unit testing, Integration testing and User acceptance testing.
  • Create mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and update strategy etc.
  • Create mappings, sessions, workflows and run those using workflow manger and monitor jobs using workflow monitor.
  • Involved in upgrading Informatica 9.6 to 10.1
  • Connecting and loading data from SAP and AZURE source systems.
  • Made use ofPost-Session successandPost-Session failurebatch scripts in the Session task to execute scripts needed for cleanup and update purposes.
  • Assist wif task identification and effort estimates for ETL development as per Agile Development methodology.
  • Work wif offshore team to develop and deliver the ETL tasks.
  • Review and deploy the code.
  • Create Control M jobs to schedule the dependencies.
  • Using Debugger to test the data flow and fix the mappings.
  • Prepare and use test data/cases to verify accuracy and completeness of ETL process.
  • Involve in Production Support and troubleshooting data quality and integrity issues.

Environment: Informatica Power Center 10.1/9.6.1, AZURE, SQL Server, Oracle, Windows, Control M

Confidential - Bloomington, IL

Sr. Informatica Designer/Developer

Responsibilities:

  • Worked on multiple projects as an ETL designer and developer across Confidential . Extensively used Informatica Power center to develop mappings.
  • Interact wif the Business users and the requirements team to identify process metrics, various key dimensions and measures.
  • Developed mapplets, reusable transformationsand use them in different mappings.
  • Worked extensively wif Xml sources and targets.
  • Worked on identifying and automating the process wherever possible resulting in extensive project cost benefit to the client.
  • Designed the ETL mappings between sources to operational staging targets, tan to the data warehouse using Powercenter Designer.
  • Extensive implementation of the Bulk API, Soap API and Metadata API concepts in Salesforce.
  • Used Webservice transformation and Webservice targets to call and execute functionalities in the Salesforce (WSDL).
  • Extensively used the power exchange for Salesforce to read, look up and load the data.
  • Designed and Developed ETL audit and control model and components.
  • 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.
  • Preparing and using test data/cases to verify accuracy and completeness of ETL process.
  • Worked in different POC’s across Confidential .
  • Involved in defining ETL framework, Data Integration points, ETL naming standards, ETL Development-QA-Production migration process.
  • Developed Shell scripts to automate file manipulation and data loading procedures

Environment: Informatica Power Center 9.5.0, Salesforce.com, DB2, Unix, Control M

Confidential - Chicago, IL

Sr. Informatica Developer

Responsibilities:

  • Involved in ETL design and effort estimation.
  • Assist wif task identification and effort estimates for ETL development per Agile Development methodology.
  • Worked wif offshore team to Develop and deliver the ETL tasks.
  • Developed the ETL jobs to automate the Data validation process across the systems (Web trends and In house) using Informatica and notifying the variances to stakeholders.
  • Developed shell scripts to access the websites and download the CSV files using RESTUrl.
  • Developed Shell scripts in Unix to make the email notification reusable and consistent.
  • Used Teradata utilities TPT, TPump, BTEQ, fastload, fastexport and multi load.
  • Involved in performance tuning and optimization to handle and process large volume of data in Teradata.
  • Developed various mappings using Mapping Designer and worked wif Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations
  • Worked wif testing team to define a robust test plan and support them during the functional testing of the application.
  • Contribute to performance tuning and volume testing of the application.
  • Review and deploy the code.
  • Track and Report the status of the project in frequent intervals.

Environment: Informatica Power Center 9.0, GreenPlum, PostgreSQL, PL/SQL, Opswise, UNIX

Confidential - Milwaukee, WI

Sr. Informatica Developer

Responsibilities:

  • Design ETL Best Practice Methodology for the Creation of an Enterprise Data Warehouse (EDW) for Confidential .
  • Build and promote the use of repeatable EDW processes, templates, and tools.
  • Provide integration testing & UA testing for the entirety of the DataMart business processes.
  • Act as point of contact for the design, development and evolution of DataMart design for the inclusion of business processes.
  • Maintain account lineage.
  • Reconcile the month end loan balances in Confidential ’s general ledger (GL) to the month-end loan balances in the credit risk data mart.
  • Provide vintage analysis (vintage delinquency, payoff trend, charge-off curves) and HELOC (home equity line-of-credit).
  • Provide probability of default (PD), loss given default (LGD), exposure at default (EAD) and dynamic cohort reporting.
  • Join business discussions to attribute the business and functional requirements and qualify and quantify data requirements and project planning.
  • Provide documentation of ETL design and technical specifications, high level and low level design specifications.
  • Design and build reconciliation process.
  • Police code maintenance and code deployments.

Environment: Informatica PowerCenter 9.5.0, Oracle 11g, SQL Server, Windows, Control-M 7, Quality Center 11.52, Cognos

Confidential - Cincinnati, OH

Informatica Developer

Responsibilities:

  • Understand and translate the business needs into technical requirements.
  • Create the low level design and help the developers understand it.
  • Assist wif task identification and effort estimates for ETL development.
  • Design ETL jobs to load data in the data warehouse tables.
  • Review application code to ensure best standards are being followed
  • Build test cases and test scripts, performing unit and integration testing.
  • Responsible for the code delivery to the client and point of contact during deployment of the code and postproduction issues.
  • Used Teradata utilities TPT, TPump, BTEQ, fastload, fastexport and multi load.
  • Involved in performance tuning and optimization to handle and process large volume of data in Teradata.
  • Assist wif data analysis and fulfill adhoc requests required for financial month end close.

Environment: Informatica Power Center 9.0, GreenPlum, PostgreSQL, Teradata, Cognos 8.6 and Unix

Confidential - Cincinnati, OH

Informatica Developer

Responsibilities:

  • Involved in gathering software requirement specifications by having Interactive Sessions wif the Clients
  • Develop robust ETL designs (functional and technical) for the ETL solution
  • Architect, design and deliver ETL framework for DW solution.
  • Define and implement project level standards and guidelines and ensure adherence to enterprise level policies.
  • Involved in design and development of common framework for error logging and parameter management for the project.
  • Conduct peer reviews for ETL code and testing strategies.
  • Identifying Performance bottlenecks and fine-tuning ETL mappings and workflows to improve performance
  • Creation of Informatica mappings, using mapplets and reusable transformations to reduce the coding efforts.
  • Design, develop and test ETL jobs according to the requirements.
  • Worked extensively on different types of transformations like Source qualifier, Expression, Filter, Aggregator, Lookup, Sequence generator, Router and Joiner.
  • Created and scheduled worklets, Configured email notifications. Set up Workflow to schedule the loads at required frequency using Power Center Workflow Manager, Generated completion messages and status reports using Workflow Manager.
  • Developed complex Views and materialized views for the reporting needs and refresh using Appworx modules.
  • Create Change Management Requests using HPSD.

Environment: Informatica 8.6, COGNOS 8, Oracle, Teradata, PL/SQL, Appworx, UNIX Shell Programming, UNIX, Erwin, J.D. Edwards

We'd love your feedback!