Consultant/etl Tech Lead Resume
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