We provide IT Staff Augmentation Services!

Project Lead/technical Lead Resume

SUMMARY

  • 12+ year experience in various phases of Data warehouse Lifecycle that includes Requirements Gathering, Design, Development, Implementation and testing for end - to-end IT solution offerings.
  • Strong knowledge and development Experience in Informatica Power Center, Informatica MDM, Oracle, PL/SQL and Data Warehouse concepts.
  • 5+ years of experience with MDM architecture and design in multiple implementation.
  • Worked on Product, Customer and Postal codes end to end MDM implementation.
  • Creation and configuration of IDD(BDD) in multiple implementations.
  • Configured Product and Customer MDM hierarchies.
  • Data cleansing and configuration of trust and validation rules in the MDM load process.
  • Provided assistance to the API development.
  • Created MDM mapping and configured match and merge rules to integrate the data received from different sources.
  • Configuration of MDM Stage and Base jobs and Creation of Batch Groups to execute MDM jobs.
  • Wrote the Pre and Post user exit procedures.
  • Worked on SIF and Composite services.
  • 4+ years of experience of working on Data quality tools like Informatica Data Quality and data profiling.
  • 9+ Years of extensive experience with ETL tool Informatica in designing and developing complex mappings & strong Experience in Integration of various data sources like Oracle, Fixed Width and Delimited Flat Files in all my previous projects.
  • Optimized the Solution using various performance tuning methods (SQL tuning, ETL tuning (i.e. optimal configuration of transformations, Targets, Sources, Mappings and Sessions), Database tuning using Hints, Indexes, partitioning, Materialized Views, External Table, Procedures, functions).
  • Experience in Performance Tuning and Debugging of existing ETL processes.
  • 8 years of experience in development and maintenance of SQL, PL/SQL, Stored Procedures, Functions, Package, View, Materialized view, Indexing, Partitioning etc.
  • Sound knowledge of Data warehouse concepts and principles - Star, Snowflake schema, SCD, Surrogate keys, and Normalization/De normalization.
  • Rich Domain Experience in Banking and Finance like Mortgage/Investment Banking and also in Life Science and Health Care domain.
  • Experience in leading a team. Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.

PROFESSIONAL EXPERIENCE

Confidential

Project Lead/Technical Lead

Responsibilities:

  • Interacting with Business users to gather business/functional requirements.
  • Analyze the functional requirements and discuss tasks/issues with the client team and propose optimal design solutions.
  • Project planning, tracking and monitoring or milestones and ensuring the on time deliveries.
  • Anticipating risk to project and mitigate the risk factor.
  • Coordination with technology partners to resolve system issues, as needed.
  • Setup and coordination of business/technical meetings with the project stack holders and preparation of Minutes of Meetings, weekly and monthly reports.
  • Build a master data operations team responsible for delivering and supporting best practice data governance and management processes across the enterprise.
  • Develop and evolve Master Data Management services in partnership with different sources and vendors.
  • Develop and implement productivity metrics and reporting.
  • Creating user stories for IT development and support effort
  • Architecting the technical solution
  • Preparation of High and Low level technical design.
  • Manage risks to project activities and come up with mitigation plan to ensure the assigned tasks are under control and should not affect the project delivery timelines.
  • Code review and optimization.

Confidential

Tech Architect(ETL)

Responsibilities:

  • Interacting with Business users to gather business/functional requirements.
  • Analyze the functional requirements and discuss tasks/issues with the client team and propose optimal design solutions for the corporate/Interim releases.
  • Architecting the technical solution
  • Preparation of High and Low level technical design.
  • Manage risks to project activities and come up with mitigation plan to ensure the assigned tasks are under control and should not affect the project delivery timelines.
  • Code review and optimization.

Confidential

Tech Architect: MDM lead

Responsibilities:

  • Interacting with Business Analysts to understand the requirements
  • Analyze the functional requirements and discuss tasks/issues with the client team and propose optimal design solutions for the corporate/Interim releases.
  • Designing of Landing, Staging and Base tables in Informatica MDM.
  • Created MDM mapping and configured match and merge rules to integrate the data received from different sources.
  • Applied trust and validation rules in the MDM load process.
  • Creation and Configuration of IDD application.
  • Knowledge of ActiveVOS Installation.
  • Provided assistance to the API development and worked on SIF and Composite services.
  • Plan and estimate the ETL effort and scripting involved.
  • Assign the work to offshore and manage the deliverables.

Technologies: Informatica Power Center, 10.1, Informatica MDM 10.1, IDQ 10.0.1, SQL-Server Management Studio

Confidential

Informatica ETL/MDM lead

Responsibilities:

  • Interacting with Business Analysts to understand the requirements
  • Analyze the functional requirements and discuss tasks/issues with the client team and propose optimal design solutions for the corporate/Interim releases.
  • Work with client leads and business analysts closely in prioritizing the tasks and determining the implementation of fast track code fixes.
  • Manage risks to project activities and come up with mitigation plan to ensure the assigned tasks are under control and should not affect the project delivery timelines.
  • Involved in the designing of Landing, Staging and Base tables in Informatica MDM.
  • Created MDM mapping and configured match and merge rules to integrate the data received from different sources.
  • Applied trust and validation rules in the MDM load process.
  • Plan and estimate the ETL effort and scripting involved.
  • Analyzing the sources and targets, transforming the data, mapping the data and populating the data into targets by using Informatica Designer, Workflow Manager and Workflow Monitor.
  • Code review and optimization.

Technologies: Informatica Power Center 10.6, Informatica MDM 10.6, IDQ, SQL-Server, Oracle, Teradata.

Confidential

Informatica MDM and ETL Tech lead

Responsibilities:

  • Analyze the functional requirements and discuss tasks/issues with the client team and propose optimal design solutions for the corporate/Interim releases.
  • Work with client leads and business analysts closely in prioritizing the tasks and determining the implementation of fast track code fixes.
  • Manage risks to project activities and come up with mitigation plan to ensure the assigned tasks are under control and should not affect the project delivery timelines.
  • Designing of MDM Architecture Landing, staging and Base objects. .
  • Created MDM mapping and configured match and merge rules to integrate the data received from different sources.
  • Applied trust and validation rules in the MDM load process.
  • Configured IDD application.

Technologies: Informatica Power Center 9.1, Informatica MDM 9.1, IDQ, Oracle, Unix scripting.

Confidential - Columbus, OH

Informatica ETL Developer

Responsibilities:

  • Involved in ETL designing and coding.
  • Parameterized the whole process by using the parameter file for the variables.
  • Designed the staging table’s structure and created the tables on Oracle database to minimize the ETL design mappings complexity.
  • Used pushdown optimization on certain sessions to push the transformation logic to target table and improve the session run time
  • Mainly involved in performance tuning in Informatica Load.
  • Analysis of existing windows/UNIX scripts to load validation data and providing new ETL solution.
  • Enhancement of existing mappings to load dimension tables.
  • Created Mappings to load data using various transformations like Source Qualifier, Sorter, Lookup, Expression, Router, Joiner, Filter, Update Strategy and Aggregator transformations.
  • Created Reusable Transformations and Mapplets to use in Multiple Mappings and also worked with shortcuts for various informatica repository objects.
  • Parameterized the whole process by using the parameter file for the variables.

Technologies: Informatica Power Center 9.1, Oracle, Netezza, Unix scripting.

Hire Now