We provide IT Staff Augmentation Services!

Software Developer & Integrator Resume

2.00/5 (Submit Your Rating)

San Antonio, TX

SUMMARY

  • Over nine years of ETL and data integration experience using DataStage and Informatica Power Center 9.x/8.x/7.x/6.x
  • Experience in all phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
  • Extensive experience in developing ETL mappings, data integration, data profiling, and master data management using Informatica Power Center 9.x/8.x and DataStage 11.
  • Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
  • Expertise in handling various aspects of Business Intelligence viz. Data Warehouse Design, Development, Administration and Architecture, ETL Administration, Development and Production Support, Informatica PowerCenter / Data Quality / B2B / Master Data Management, Talend Data Integration / Data Quality / MDM, Abinitio, Oracle PL/SQL, Teradata PL/ SQL, Netezza PL /SQL / DataStage/ BI - Crystal Reports/Control-M/MobaXterm/SQL Developer and UNIX Shell Scripting.
  • Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
  • Experience in integration of various data sources like Oracle, DB2, Sybase, SQL server and MS access and non-relational sources like flat files into staging area.
  • Experience in development, creation of tickets and support to different vendor applications like; Charles River Investment Application, Eagle Investment, PAM, Fiserv APL, NFS, Bloomberg, State Street, Northern Trust, Golden Source and Factset.
  • Experienced in data loading from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
  • Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
  • Experience in Performance tuning of Power Center mappings, and SQL scripts for maximum efficiency and performance.
  • Expertise with IDQ/IDE tools for data profiling, data enrichment and standardization.
  • Experienced in UNIX work environment, file transfers, job scheduling and error handling.
  • Involved in Unit testing, System testing to check whether the data loads into target are accurate.
  • Experience in support and knowledge transfer to the production team.
  • Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.
  • Extensive functional and technical exposure. Experience working on high-visibility projects
  • Assign work and provide technical oversight to onshore and offshore developers
  • Excellent analytical/ communication skills and good team player

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.5/9.1/8.6.1/8.5/8.1.1 , Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor, DataStage Designer, Client, DBAdmin

ETL / MDM Tools: Informatica Master Data Management (MDM) Multi-Domain, Informatica Metadata Manager, Informatica Test data Management, Informatica PMPC, Informatica Data Replication.

Dimensional Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN.

Database: Oracle10g/9i, MS SQL Server 2008 / 2005, Teradata, DB2, MS Access, SQL, PL/SQL, SQL*Plus

Programming GUI: C, C++, Python, SQL, PL/SQL, Java, SQL Plus, XML.

Shell Scripting: Unix Shell Scripting, Korn shell scripting.

Scheduler: Control M, Autosys.

Other Tools and Vendor Application: SAP Business Object, Crystal Reports, Web Intelligence, Oracle Business Intelligence (OBIEE), SQL * PLUS, TOAD, PL/SQL Developer, Charles River Investments, Eagle Investment, PAM, Bloomberg, Golden SourceState Street, BNY Mellon, IDC, FactSet, APL, Northern Trust

Operating Systems: WINDOWS, WINDOWS- NT/2000/XP Professional, MS-DOS, UNIX, Sun Solaris and HPAIX.

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

Software Developer & Integrator

Responsibilites:

  • Identified ideas to improve system performance and impact availability.
  • Provided functional and/or technical guidance in evaluating applications systems or evaluating requests for proposals.
  • Coordinated changes and influences and prioritizes tasks with business and technical departments.
  • Identified and created solutions to improve existing processes in ra id delivery and support
  • Facilitated root cause analysis of data issues, supported front end including vendors to minimize impact and future occurrences.
  • Created system documentation/play book(s) and served as a lead technical reviewer and contributor in requirements, design and code reviews.
  • Acted as a resource between IT and the business with Serving, Analyzing, developing proper solution and presenting to the business.
  • Developed accurate estimates on work packages and ensures the accuracy of estimates developed by less experienced internal and third party team members.
  • Acted as a technical resource throughout the Agile Development life cycle.
  • Contributed to the technical and soft skills development of team members.
  • Assisted team leads and management with delegation of technical work packages to cross-functional and third party team members for execution through the full development life cycle.
  • Developed and reviewed Detail Design Document and Technical specification docs for end to end ETL process flow for each source systems using DataStage.
  • Worked as a medics and on-call and coordinates system application transition from development teams to maintenance and production teams, and/or constructs and implements necessary controls to assure system/application traceability for twenty four hour up and running service.
  • Worked for development, creation of tickets and support to different vendor applications like; Charles River Investment Application, Eagle Investment, PAM, Fiserv APL, NFS, Bloomberg, State Street, Northern Trust, Golden Source and Factset.
  • Created, supported and debugged the issues in Contrl-M Automation tool.

Environment: IBM Datastage designer and client, IBM Contol-M, Oracle 11g, SQL Developer, Micro strategy, Mainframe DB2, MS Visio, MobaXterm, Charles River Investment Management System 9.8, Windows, UNIX, Shell Scripting, BI-Crystal Reports, Eagle Investment System, Bank of New York Application, Bloomberg, PAM

Confidential, Pittsburgh, PA

Sr. ETL Developer

Responsibilities:

  • Involved in all phases of SDLC from requirement, design, development, testing, Production and support for production environment.
  • Handled 2 Terabytes of data warehouse database.
  • Involved in End-to-End development from OLTP systems to creation of Data Marts.
  • Involved in Performance tuning of different tables containing 1 TB data by creating partitions and using stored procedures.
  • Cleanse and Scrub the Data in uniform data type and format applying MDM Informatica and IDQ tools and Load to STAGE and HUB tables and then to the EDW and Finally to Dimension and rollup/aggregate the data by the business grains into the FACT tables.
  • Primary activities include data analysis identifying and implementing data quality rules in IDQ and finally linking rules including Address Doctor to Power Center ETL processes and delivery to MDM Data Hub and other data consumers.
  • Created Queries Query Groups and packages in MDM Hub Console
  • Used Informatica Power Exchange for loading/retrieving data from mainframe systems.
  • Tuned the mappings in the transformations by tracking the reader, writer, transformation threads in the session logs and used tracing level to verbose during development & only with very small data sets.
  • Used PMCMD to start and abort sessions and tasks. Also used INFACMD to track the status of the applications and also automate the service notification emails.
  • Created Oracle Stored Procedure to implement complex business logic for better performance.
  • Created Materialized view for summary data to improve the query performance
  • Responsible for loading data into warehouse from different sources using Oracle loader to load millions of records and used Import/Export utility to load small tables.
  • Supported Oracle 10g databases running mission critical 24*7 systems.
  • Used PMCMD extensively to start, stop, schedule, and monitor Informatica workflows.

Environment: Informatica Power Center 9.6.1, Informatica Master Data Management 9.6.1, Power Exchange, Oracle 11g, PL/SQL, Golden gate, Micro strategy, Mainframe DB2, MS Visio, ERWIN, TOAD, Windows, UNIX AIX

Confidential, Plantation - FL

Technical Lead/ Sr. Informatica Developer

Responsibilities:

  • Worked with Data Architects and Business Analysts to understand the data flow, existing logic and creation of Business Requirement Documents on the business logic involved in creation of feeds.
  • Created logical and physical design for Dimensional data warehouse using CA/ERWIN; Quest/Toad, Oracle RDMS based on Ralph Kimball Methodology.
  • Created technical specification for the development of Informatica extraction, transformation and loading (ETL) mappings in order to load data into classified tables in DATA Marts and defined ETL standards.
  • Performed Data Model Updates and Enhancements to existing Oracle Designer data models as required
  • Informatica Power Exchange for Mainframe was used to read/write VSAM files from/to the Mainframe.
  • Optimized mappings, sessions/tasks, source, and target databases as a part of performance tuning.
  • Extensively involved in Recovery process for capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively.
  • Engaged in designing and developing test cases, error control routines, data validation, load processes, audit and log controls using PL/SQL, SQL.
  • Created drill down and drill through reports using SAP Business object (SAP BOBJ) for customized and ad-hoc Queries.
  • Worked with production support in finalizing scheduling of workflows and database scripts using Tidal Scheduler.

Environment: Informatica Power Center 9.5.1, Power Exchange, Oracle 11g, MS SQL Server 2008/2012,, Tidal, Windows 7, Micro Strategy 9.1, ERWin 3.5, TOAD.

Confidential, Beaverton, OR

Sr. ETL Informatica Devleoper

Responsibilities:

  • Involved in JAD sessions for the requirements gathering and understanding.
  • Developing and reviewing Detail Design Document and Technical specification docs for end to end ETL process flow for each source systems.
  • Developed mappings in Informatica to load the data from various sources using different transformations like Look up (connected and unconnected), Normalizer, Expression, Aggregator, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy, Rank and Router transformations.
  • Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
  • Writing MultiLoad scripts, FastLoad and Bteq scripts for loading the data into stage tables and then process into BID.
  • Developed Scripts to load the data from source to staging and staging area to target tables using different load utilities like Bteq, FastLoad and MultiLoad.
  • Performed application level DBA activities creating tables, indexes, monitored and tuned Teradata BTEQ scripts using Teradata.
  • Query Analysis using Explain for unnecessary product joins, confidence factor, join type, order in which the tables are joined.
  • Collected Multi-Column Statistics on all the non-indexed columns used during the join operations & all columns used in the residual conditions.
  • Used extensively Derived Tables, Volatile Table and GTT tables in many of the ETL scripts.

Environment: Teradata 14, Teradata SQL Assistant, UNIX, Informatica 9x, BTEQ, MLOAD, TPUMP, FASTLOAD, FASTEXPORT, TPT, Autosys.

Confidential, Santa Clara, California

Sr Informatica Developer

Responsibilities:

  • Interacted with the business community and database administrators to identify the business requirements and data realties.
  • Created Design Document and Informatica mappings based on business requirement.
  • Moved the mappings from development environment to test environment and then to production environments.
  • Played a vital role in moving the project to Production and prepared the documentation at every level.
  • Involved in the Release Management team and verify the Production checklist documents necessary for the Production Activities
  • Used PMCMD to start and abort sessions and tasks. Also used INFACMD to track the status of the applications and also automate the service notification emails.
  • Perform Maintenance, including: Manage Space, Remove Bad Files, Remove Cache Files and monitoring services.
  • Also involved in conducting and leading the team meetings and providing status report to project manager

Environment: Informatica Power Center 8.1.1/7.1, Business Objects 6.5.1, Oracle 10g/9i, PL/SQL, Windows NT, ERWIN (4.5), PL/SQL Developer, OBIEE 10.1.3.3, DB2, and UNIX.

Confidential, Columbus, OH

Informatica Developer

Responsibilities:

  • Analyzed the business requirements and functional specifications.
  • Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
  • Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data in the data warehouse.
  • Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
  • Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
  • Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
  • Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.
  • Created Test cases for the mappings developed and then created integration Testing Document.
  • Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica Power Center 8.6.1, Oracle 10g/ 9i, MS-SQL Server, Toad, HP Quality Center, Windows XP and MS Office Suite

We'd love your feedback!