We provide IT Staff Augmentation Services!

Consultant/etl Tech Lead Resume

4.00/5 (Submit Your Rating)

Atlanta, GA

SUMMARY:

  • Overall 12 years of experience in Information Technology and 10 years of experience in the design, development , Application support and testing of applications using Informatica and IDQ. Having good knowledge on Teradata and JAVA.
  • Experience in Developing mappings using Informatica Power Center 7.x, 8.x and 9.x
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
  • Very strong in implementation of data profiling, creating score cards, creating reference tables and documenting Data Quality metrics/dimensions like Accuracy, completeness, duplication, validity, consistency.
  • Have good skills on understanding and development of business rules for its Standardization, Cleanse and Validation of data in various formats.
  • Very good Knowledge of Informatica Data Quality transformations like Address validator, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations.
  • Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
  • Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
  • Experience in Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Repository Manager, Workflow Manager, and Workflow Monitor.
  • Worked with Teradata utilities like BTEQ, Fast Load, and Multi Load.
  • Creating various transformations such as Source Qualifier, Expression, Joiner, Normalizer, Router, Aggregator, Lookup, Update Strategy and Java transformation and mappings using Informatica Designer.
  • Implemented slowly changing dimensions.
  • Tuned the Informatica mappings for optimal load performance.
  • Creating the reusable mappings.
  • Validating mappings, sessions, and workflows in all the layers and ensuring that the coding standards for ETL such as parameterization and naming conventions are followed.
  • Experience in Support and Enhancement projects.
  • Good Knowledge on Hadoop Echo System.
  • Experience in Domains like Public sector, Banking, Insurance, and Life Sciences domains

TECHNICAL SKILLS:

ETL Tools: Informatica 7.x/8.x/9.x, Informatica IDQ

Operating Systems: MS Windows NT, MS - DOS, and UNIX

Languages: JAVA, HTML, XML

Databases: Oracle, SQL, DB2, Teradata

Scripting: Shell Scripting (UNIX)

Supporting Tools: Putty, SQL Developer, WinSCP, SAS EG, Autosys

Configuration Tools: MS Visual Source Safe

Acrobat Products: Adobe Life Cycle Designer 7.0.5 and Acrobat Reader 7.0

Other: SAS

Scheduling tools: Control-M

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Consultant/ETL Tech Lead

Responsibilities:

  • Responsible for Development and App support activities
  • Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets
  • Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
  • Used Informatica Data Quality transformations like Address validator, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations to develop the maps
  • Involved in migration of the maps from IDQ to power center
  • Validation, Standardization and cleansing of data will be done in the process of implementing the business rules.
  • Implementing the Error Logging Mechanism to handle the error records
  • Validating mappings, sessions, and workflows in all the layers and ensuring that the coding standards for ETL such as parameterization and naming conventions are followed
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
  • Creating various transformations such as Source Qualifier, Expression, Joiner, Normalizer, Router, Aggregator, Lookup, Update Strategy and Java transformation and mappings using Informatica Designer.
  • Performing the Load monitoring, reporting on SLAs and data availability
  • Troubleshooting the data discrepancy and missing data issues
  • Fixing the ETL load failures due to resource constraints, missing/invalid data/files, Bugs and infrastructure component issues
  • Working on Incidents like Failures/Missing or Invalid Data, Delayed data
  • Working on Problems like Repeated incidences not permanently fixed
  • Change management like Bug Fixes and Break Fixes
  • Communicating with different source systems during the Outages and Scheduled downtime of the source systems as part regular maintenance
  • Performing the data analysis to confirm the correct data is flowing in to the system
  • Documenting the RCAs for all critical and non-critical issues
  • Creating the PIER tickets for defects and assigning them to appropriate teams
  • Code Deployments for production issues
  • Involved in the release management activities
  • Working on the Enhancements of the system
  • Conducting team Status meetings.

Environment: Informatica Power Center 10.x, Putty, UNIX Scripting, Teradata, SQL, IDQ, PIER, CONTROL-M.

Confidential, Bloomington, IL

Consultant/ETL Tech Lead

Responsibilities:

  • Preparing the detail level design document using FDD
  • Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications
  • Profile source data and determine all source data and metadata characteristics; Design and execute a Data Quality Audit/Assessment; Design and execute the data quality mappings that will cleanse, de-duplicate
  • Implement data quality processes including transliteration, parsing, analysis, standardization and enrichment at point of entry and batch modes
  • Informatica Data Quality transformations like Address validator, Parser, Labeler, Match, Exception, Association, Standardizer to develop the maps
  • Developing the complex mappings as per the business requirements
  • Creating various transformations such as Source Qualifier, Expression, Joiner, Normalizer, Router, Aggregator, Lookup, and Update Strategy using Informatica Designer.
  • Implementing the Error Logging Mechanism to handle the error records
  • Validating mappings, sessions, and workflows in all the layers and ensuring that the coding standards for ETL such as parameterization and naming conventions are followed
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
  • Used the Teradata utilities like Fast Load, Multi Load to load the Teradata database
  • Implemented Informatica Push Down optimization (PDO).
  • Improved session Performance by enabling property incremental aggregation to load incremental data into target table. Tuned the Informatica mappings for optimal load performance
  • Migrated the code into QA (Testing) and supported QA team and UAT (User Validating the weekend production results
  • Scheduled the tasks using Autosys
  • Developing DB2 test scripts to validate the data that has been loaded into the database.
  • Enhancement work for Auto shoppers and fire shoppers.
  • Running the daily jobs for Auto shoppers and fire shoppers.
  • Testing and documenting the mapping results

Environment: Informatica Power Center 9.0, DB2, Putty, UNIX Scripting, Teradata, Host, IDQ

Confidential

Consultant/Sr.ETL Developer

Responsibilities:

  • Created mapping documents to outline data flow from sources to targets.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
  • Developed mapping parameters and variables to support SQL override
  • Converting the Mutual Fund mappings compatible to new process.
  • Modified existing mappings for enhancements of new business requirements.
  • Developed reusable Mapplets and Transformations
  • Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
  • Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions
  • Used Debugger to test the mappings and fixed the bugs.
  • Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 9.0, DB2, Putty, UNIX Scripting

Confidential

Senior Software Engineer/ETL Developer

Responsibilities:

  • Involved in Requirements Analysis and ETL Designing
  • Involved in preparing the mapping documents
  • Developed the complex mappings as per the business requirements.
  • Created the reusable components
  • Performance tuning for informatica mappings.
  • Implemented the delta loads and full loads based on the requirement.
  • Performed Unit Testing with sample data.
  • Documenting the mapping details, unit test plan and unit test results.
  • Involved in debugging and defect fixing

Environment: Informatica Power Center 8.6, DB2, TOAD, Putty, UNIX

Confidential

Senior Software Engineer/ETL Developer

Responsibilities:

  • Gathered business requirements from Business Analyst.
  • Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
  • Designed and developed Informatica ETL mappings to extract master and transactional data from heterogeneous data feeds and load
  • Installed and Configured the Informatica Client tools.
  • Designed the procedures for getting the data from all systems to Data Warehousing system.
  • Created the environment for Staging area, loading the Staging area with data from multiple sources.
  • Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
  • Used workflow manager for session management, database connection management and scheduling of jobs.

Environment: Informatica, Power Center 8.6, DB2, TOAD, Putty, UNIX

Confidential

Senior Software Engineer/ETL Developer

Responsibilities:

  • Creating mappings to truncate and load the data into the Staging tables from the Source flat files
  • Developing mappings to load Dimension and Fact tables from Staging to ODS
  • Propagating the data through mappings from ODS to DDS and then to ADS, which will be used for reporting
  • Implementing error logging mechanism using the Normalization technique
  • Performing unit testing with sample data and debugging the issues using session logs
  • Developing Oracle test scripts to validate the mappings and verifying the test cases developed by the testing team
  • Performing system integration testing and UAT load

Environment: Informatica Power Center 8.6, Oracle 10g, SQL Developer, Putty, Winscp, and UNIX.

Confidential

Senior Software Engineer/ETL Developer

Responsibilities:

  • Developing ETL mappings for loading the data mart tables
  • Analyzing the business-related changes that need to be accommodated in the mappings
  • Validating the data loaded into the data mart tables against the source system
  • Performing a historical load activity in the production environment
  • Analyzing the data quality issues during load
  • Documenting the mapping details, unit test plans, and unit test results

Environment: Informatica Power Center 8.1, Oracle 10g, SQL Developer, Putty, MS Windows NT, and UNIX.

Confidential

Software Engineer/Java Developer

Responsibilities:

  • Developing JSP screens
  • Writing classes for the formulas for the calculation of MSRTax
  • Generating reports for the deals and loans
  • Debugging and fixing bugs
  • Providing production support for the monthly and quarterly loads

Environment: Core Java, Oracle 9i, Toad, Putty, MS Windows NT and UNIX

Confidential

Software Engineer/Java Developer

Responsibilities:

  • Coding and Designing the PDFs using the AdobeLifeCycledesigner.
  • Bug fixing on Correspondence & Forms.
  • Creating web-based applications using JSP and Servlets
  • Interactions with onsite to get the input
  • After implementation support for this application

Environment: Core Java, Adobe life cycle designer, Oracle 10g, Web Sphere 6.1

We'd love your feedback!