We provide IT Staff Augmentation Services!

Onsite Team Lead Resume

Usa, NC

PROFESSIONAL SUMMARY

  • Having 8 years of experience in software development with emphasis in Analysis, Design, Development, Testing and Implementation of various Data Warehousing, BI and Software Applications.
  • Involved in Business Analyst roles for few projects that includes understanding the system engineering concepts, Cost/benefit Analysis, Modeling techniques along with HLD and LLD review
  • Technical Specification documents preparation
  • Involved in analyzing, design, Architect and developing application software in Data warehouse using
  • Involved in ETL process from Architecture, Design development to testing and production environments.
  • Extracted date from various sources like Flat files, Mainframe using Power exchange navigator data maps, Oracle and loaded it into Target systems like Teradata using Informatica
  • Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
  • Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.
  • Used Informatica Power exchange to connect to SAP,Mainframe sources to informatica and load in to required databases
  • Tuned mappings and SQL queries for better performance and efficiency.
  • Performed Unit testing and validated the data.
  • Created & Ran shell scripts in UNIX environment.
  • Created and ran the Workflows using Workflow manager in Informatica Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager
  • Updated the odbc.ini file when required.
  • Extensively used loader, FTP and Relational loading process in informatica tool to design and develop dataflow paths for loading transforming and maintaining data warehouse
  • Involved in conversion of all the FTP scripts to NDM process. Most of the mainframe Files are NDM’d to UNIX/Linux and viceversa to process the ETL process through Informatica
  • Architected and developed Fast Load and MLoad scripts in control file, developed BTEQ scripts to process the data in staging server.
  • Involved in identifying the performance bottlenecks and optimizing the time for Efficient data loading databases and processes for performance improvement.
  • Lead team of developers, allotted work, resolved issues, was an active bridge between data modeler, business users and developers in both offshore and onsite.
  • Experienced in troubleshooting Teradata scripts, fixing bugs and performance tuning.
  • Strong development skills including the ability to work through the entire development life (SDLC) cycle from gathering requirements through implementation, development, testing, production, support and documentation of the complete project.
  • Sound knowledge of Informatica Power center 9.1 with Teradata DB and hands in designing the mappings Sessions and workflow and writing Teradata SQL’s, BTEQ scripts, making use of Teradata utilities like, Fast Load, Fast Export, Multi Load and TPUMP
  • Proficient in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and CDC (change data capture), Error Handling techniques for ETL process.
  • Involved in Requirement Analysis, Functional Studies, Quality Reviews and Testing
  • Strong skills in defining and implementing solutions, tools, processes and procedures to provide enterprise data integration and ETL services that meet business requirements
  • Having good knowledge on SDLC and Data Warehousing Concepts.
  • Thorough and extensive knowledge on Dimensional modeling, star/snowflake schemas
  • Worked with SET and MULTISET tables for performance evaluation of the scripts
  • Created tables with appropriate UPI and PI taking into consideration of both planned access of data and even distribution of data across all the available AMPS
  • Scheduling workflows and invoking them using Autosys scheduler using PMCMD Commands in Unix shell scripting
  • Involved while upgrading the power center from one version to another in Bank of America projects

Informatica Power Center/ Exchange and UNIX/LINUX expertise:

  • Involved in technical design based on functional requirements
  • Interacting with client/business to gather & understand the requirements
  • Coordinating with offshore team on development activities on regular basis for efficient project delivery
  • Impact analysis for the interface, design changes
  • Extensively worked with Functional requirements and Source to Target Mapping documents.
  • Worked on design of generic processes for Data extraction, Data Quality check and related transformations.
  • Working with Aggregator,Joiner,Custom,Expression,Filter,Look up Transformations
  • Working with Transform components
  • Involved in Shell scripting to invoke the informatica workflows through Autosys to load the data in to Teradata or other database tables
  • Working with Database components
  • Working with aggregate and rollup functions for summarizing data
  • Exposure to Enterprise Meta environment (EME)
  • Involved in unit, integration and system testing
  • Involved in implementation by supporting the production team for code migration
  • Involved in Unit Testing, System Testing.
  • Involved in User Acceptance Test

Teradata expertise:

  • Have thorough understanding of Teradata architecture.
  • Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints and SQL Trace both in Teradata
  • Excellent Experience with different indexes (PI, SI, JI, AJIs, PPI (MLPPI, SLPPI)) and Collect Statistics
  • Used Teradata utilities fastload, multiload, tpump to load data
  • Wrote BTEQ scripts to transform data
  • Wrote Fastexport scripts to export data
  • Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL
TECHNICAL SKILLS

RDBMS: Teradata, Oracle 9i

Tools & Utilities:Informatica 8.X,Informatica 9.X, Mainframe JCL

Operating systems: Unix (AIX),LINUX Windows NT, Windows95/98/XP

Load Utilities: Multi Load, Fast Load, Fast Export, BTEQ, Tpump

Programming Languages: PL/SQL, UNIX Shell Scripting

Scheduling Tools: Autosys

Domain: Banking

Other tools: TOAD,SQL Assistance

PROJECT PROFILE

Role: Onsite Team Lead

Confidential

Responsibilities:

  • Involved in Architecture responsibilities like Assess requirements for completeness and accuracy
  • Develop full SDLC project plans to implement ETL solution and identify resource requirements.
  • Conduct impact assessment and determine size of effort based on requirements
  • Determine if requirements are actionable for ETL team
  • Collaborate with product development teams and senior designers to develop architectural requirements to ensure client satisfaction with product
  • Interacting with client/business to gather & understand the requirements
  • Lead and guide development of an Informatica based ETL architecture.
  • Develop solution in highly demanding environment and provide hands on guidance to other team members
  • Worked with business users to create the functional and Technical design for ETL process
  • Coordinating with Onshore Dev team on development activities on regular basis for efficient project
  • Delivery.
  • Involved in technical design for the functional/business requirements.
  • To verify if Informatica mappings and workflows were developed according to the requirement given
  • Extract the data from different interface systems or sources and transform/ map the data to the target format and load into the Warehouse
  • The data is pulled based on the business logic which is turned technically using INFORMAITICA tool
  • Shell scripting is developed wherever is necessary.
  • Performance tuning and maintenance of existing system.
  • Implemented various Quality procedures and Adhered to the coding standards of the company related to the project
  • Worked on enhancements of systems and change of code for the changing requirements from the business.
  • Performing code review and resolving the queries.
  • Involved in incorporating new changes as per business requirements, resolving existing technical issues. Also involved in Bug Fixation and Code promotion
  • Writing Unit test plan and documented unit test results.
  • Have been involved in Implementation, for migrating the Code to Prod Environment

Confidential, USA, NC

Role: Offshore Module Lead and Onsite team Lead

Responsibilities:

  • Interacting with the client to understand the requirements. Analyzing requirements.
  • Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translate business rules and functionality requirements into ETL processes.
  • Involved in Design of various workflows using Informatica.
  • Developed data Mappings between source systems and warehouse components.
  • Responsible for creating business solutions for Incremental and Full loads.
  • Extensively used Relational, Loader process to load the file in to database using Informatica
  • Populated the Teradata warehouse using utilities Fast Load, Multi Load, BTEQ and TPump.
  • Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
  • Involved in design documentation.
  • Responsible for creating Test cases to make sure the data originating from source makes it to the target in the proper format
  • Coding, Unit Testing, implementation and reviewing the documents viz. Unit Test plan, test cases etc
  • Have been involved in Implementation, for migrating the Code to Prod Environment
  • Perform as active, leading role in shaping and enhancing overall ETL Informatica architecture
  • Resolve difficult design and develop issues.
  • Identify bugs when developers are not able to do so.

Hire Now