We provide IT Staff Augmentation Services!

Technical Lead Resume

Phoenix, AZ

PROFESSIONAL SUMMARY:

  • Over 7 years of diverse progressive experience in Information Technology, with emphasis on Data warehousing, Application Development and Business Analysis.
  • Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse and Data Marts using Informatica PowerCenter tools (Repository Manager, Mappings Designer, Workflow Manager, and Workflow Monitor).
  • Experienced in handling the data for warehousing in E - commerce, Security systems and financial domains.
  • Participated in design sessions where decisions are made involving the transformations from source to target.
  • Experienced in developing various data extracts and loading routine using Informatica, Oracle stored procedures.
  • Expertise in implementing complex business rules by creating robust Mappings, Mapplets, Sessions and Workflows using Informatica PowerCenter
  • Extensively used ETL methodologies for supporting data extraction, transformation and loading process using Informatica Power Center.
  • Worked extensively with mappings using Expressions, Joiners, Routers, Lookup and Update strategy, Source Qualifiers, Aggregators to develop and load data in to different target types.
  • Extensive experience in creating the Workflows, Worklets, Mappings, Mapplets and Sessions.
  • Knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling
  • Strong experience in Data Warehousing (ETL & OLAP) environment and acquired excellent analytical, co-ordination, interpersonal skills, have immense leadership potential.
  • Skilled in the development of Informatica mappings and mapplets and tuning them for optimum performance
  • Experience is End to end testing for Informatica mappings, workflows and outputs based on the specification.
  • Experience in using Automation Scheduling tools like Automation engine, Autosys and Control-M.
  • Managed and complied documentation for all ETL processes like Consulting manuals, periodicals and technical reports to learn new ways to develop programs and maintain existing skills and knowledge
  • Establishing a detailed program specification through discussion with clients. Experience working in an agile development environment.
  • Experience in coordination with offshore teammates in assigning the tasks, taking daily update calls and sprint planning & closing meetings.

TECHNICAL SKILLS:

Tools: Informatica Power Center 9.6.1/10.1, UNIX

Databases: Oracle 11g/10g, Netezza Aginity, SQL Server 2012/2008

Documentation Tools: MS Word, MS Excel, MS Access, MS Outlook

Operating Systems: Linux, Windows 10/8/7/XP

Methodologies: SDLC, Agile

Schedulers: Control-M, Automic Engine

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Technical Lead

Responsibilities:

  • Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
  • Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
  • Used Informatica PowerCenter- Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformation
  • Involved in extracting the data from the Flat Files and Relational databases into staging area.
  • Wrote UNIX shell scripts to schedule Informatica workflows and oracle database scripts to populate data in to data warehouse and database.
  • Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
  • Used Informatica PowerCenter Workflow manager to create sessions and batches to run with logic embedded in the mappings
  • Created folders, users, repositories, and deployment group using Repository Manager
  • Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
  • Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
  • Imported various heterogeneous files using Informatica Power Center 9.x Source Analyzer.
  • Developed several reusable transformations and mapplets that were used in other mappings.
  • Prepared Technical Design documents and Test cases.
  • Implemented various Performance Tuning techniques.

Environment: Informatica Power Center 9.6/10.1, Oracle 11g, Natezza Aginity, Automic Engine.

Confidential, Santa Ana, CA

Informatica Developer

Responsibilities:

  • Presented all work in design review and code review sessions to senior team members, and explain and support decisions made and actions taken.
  • Developed ETL data workflows and code for new data integrations and maintain/enhance existing workflows and code.
  • Developed Informatica mappings, reusable transformations and created PL/SQL Stored procedures/packages for extracting data from source systems to staging and processing and loading to the data warehouse.
  • Performance tuned Informatica mappings by adopting explain plans, cutting down query costs using Oracle hints, changing the mapping designs.
  • Performed Error Handling and Debugging of bugs in PL/SQL programs.
  • Used Informatica PowerCenter- Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformation.
  • Interfaced with business analysts, project managers and clients to clarify requirements.
  • Assisted other team members with their assignments (e.g., onboarding new team members).
  • Tested own work and contribute to the development of test plans.
  • Prepared documentation that describes installation and operating procedures, including application user guides, with limited guidance.
  • Provided first/second level troubleshooting, technical and operational support with limited guidance.
  • Participated in technical design. Can develop from specifications, under limited guidance.
  • Involved in troubleshoot of applications problems, with limited support.
  • Effectively identified and escalated issues as appropriate.
  • Worked under Agile methodology and used version one to track the tasks

Environment: Informatica PC 9.6.1, SQL Server Management Studio

Confidential

Informatica Developer II

Responsibilities:

  • Responsible for designing and developing of mappings, mapplets, sessions and work flows for loading the data from source to target database using Informatica Power Center and tuned mappings for improving performance.
  • Performed Informatica Admin role by creating new repositories, users and maintaining TEST and PROD environments.
  • Developed the Informatica Mappings, sessions and workflows required to load the data into oracle application from flat files and staging tables.
  • Involved in ETL process from development to testing and production environments.
  • Extracted date from various sources like Flat files, Oracle and loaded it into Target systems using Informatica PC.
  • 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.
  • Created Informatica tasks and workflows to execute ETL processes and Wrote complex SQL Query as per business requirement to fetch the data from relational tables
  • Optimized complex SQL query to improve performance and Created Slowly Changing Dimension SCD type1, type2, Slowly Growing Targets, and Simple Pass through Informatica mappings to meet business requirements.
  • Performed Unit testing, Integration testing/User Acceptance testing for ETL/SQL/Unix script codes
  • Developed UNIX shell scripts to run the workflows and SFTP source/target files from various systems and Informatica process automation.
  • Tuned mappings and SQL queries for better performance and efficiency.
  • Performed Unit testing and validated the data.
  • Created and ran the Workflows using Workflow manager in Informatica Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
  • Created tables and partitions in database Oracle and Written stored procedures in Oracle.

Environment: Informatica PC 9.5.x/9.6, Oracle SQL * PLUS, Windows XP.

Confidential

ETL Developer

Responsibilities:

  • Mainly involved in ETL developing Creating the mappings and transformations using Informatica.
  • The data from the staging area was transformed and loaded to the target on Oracle using Informatica Tool.
  • Extensively worked on developing Informatica Designer, Workflow manager and Workflow monitor for data loads.
  • Responsible for the development of Meta data transformations and establishing load schedule.
  • Created different changes, for example, Expression, Lookup, Joiner, Router, Filter, Aggregator and Sequence Generators.
  • Optimizing/Tuning mappings for better performance and efficiency.
  • Extensively used transformations like Filter, Aggregation, Joiner, Expression, Lookup, Router, and Update Strategy.
  • Developed map, reusable objects, transformation, and Mapplets using Mapping Designer, Transformation Developer and Mapplets Designer
  • Created reusable transformations and mapplets and used them in mappings
  • Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse.
  • Managed enhancements and coordinated with every release with in Informatica objects
  • Creating validation and loading the rejected records into the relevant tables and send to the users for re-submitting.
  • Involved in designing the mapplet and reusable transformation according to the business needs.
  • Wrote UNIX shell scripts to schedule Informatica workflows and oracle database scripts to populate data in to data warehouse and database.
  • Knowledge of slowly changing dimension tables and fact tables.
  • Used the mapping parameter to make the mapping more flexible and Involved in Unit testing.

Environment: Informatica 9.1, Oracle SQL developer, MS Office Products - MS Excel, Word, MS Project.

Hire Now