We provide IT Staff Augmentation Services!

Sr. Etl Developer/ Specialist Resume

Plano, TX

SUMMARY:

  • Over 11+ years of IT experiences in Data Warehousing (ETL) Requirements Gathering, Analysis, Design, Development, Implementation, Integration, Testing, Profiling, Cleansing and Validation of data using the Technology, Informatica PowerCenter/Data Quality (IDQ) from versions 7.1 to 10.1.0 for Health Care, Insurance, Banking and Wireless Industries with different Methodologies in Linux and Windows Servers.
  • Experienced in Migration of codes from Repository to Repository, wrote up Technical/Functional Mapping Specification Documents for each Mapping along with unit testing for future development.
  • Proficient in Designing the Automation Process of Workflows and configuring/scheduling the Workflows for load frequencies. Skilled to Develop, Test, Tune and Debug the Mappings, Sessions and Monitor the system.
  • Experienced to Profile, Analysis, Standardize, Clean, Integrate, Score Carding, Reference Data from various source systems using Informatica Data Quality (IDQ) Toolkit. Worked with Address Doctor, different algorithms, Biogram/Jaro/Edit/Hamming/Reverse distance in IDQ to prepare the MDM data.
  • Skilled to interact with business users. Pioneered in different load strategies from heterogeneous sources to target. Successfully implemented SCD Type1/Type2 load, Capture Data Changes to maintain the Data history.
  • Experienced to identify the Bottlenecks of data load and Tuned the Bottlenecks for better performance.
  • Extensive experiences to create Logical & Physical Data Modeling on Relational (OLTP), Dimensional Data Modeling (OLAP) on Star schema for Fact & Dimension tables using CA ERwin.
  • Experienced in Informatica Administration for installing and configuring Repository, Web Hub services for configuration of Domain/Gateway Services using the Administration Consol, Repository Manager tools.
  • Excellent to write the Stored Procedures, Triggers, Indexes, Functions by PL/SQL, SQL Scripts. Developed various reports, dash board using MicroStrategy reporting tools.
  • Experienced as Database Administration in Oracle 9i, Flashback, RMAN to Recover the data, Database Design, Enterprise level Backup/ Recovery procedure, Performance Tuning, Table Partitioning, Database Architecture, Monitoring, and Database Migration, SQL Developer.
  • Team Player, excellent communication & interpersonal skills, vivid analytical ability to solve the problems.

TECHNOLOGIES:

ETL/IDQ Tools: Informatica PowerCenter/Data Quality (IDQ)/MDM 9.6.1HF1 - 7.1, SSIS, SSRS, SSAS

Database: Oracle 12r-8i, SQL-Server 2005/2008r, DB2, Teradata, MySQL, Netezza.

Reporting Tools: OBIEE, Business Object, Tableau

GUI Tools: SQL-Developer, TOAD 9.5, SQL*Plus, IIR, Web Services (WSDL), SOAP, JIRA, MDM, SAP, Putty, WinSCP, Salesforce, BTEQ, SAP HANA, Squirrel, Eclipse, Aginity, LAMP.

Languages: SQL, PL/SQL, Java, C, C#, T-SQL, XML, Shell Scripting, Perl, Python, BigData, Hadoop, Hive, Pig.

Operating Systems: Windows 93/95/98/ME/NT/XP/ 7/8, Vista, Unix, Mac.

Scheduling Tools: Tivoli, Control-M, UC-4, Autosys.

Modeling Tools: CA Erwin, Embercado, Power Designer.

PROFESSIONAL EXPERIENCES:

Sr. ETL Developer/ Specialist

Confidential, Plano, TX

Responsibilities:

  • Participated in daily/weekly meetings, monitored the work progresses of teams and proposed ETL strategies.
  • Parsed high-levels design specification of ETL coding. Developed new SCD Type1/Type2 complex mappings, fixed the old mappings into different layers and proposed strategies for future growth of the data.
  • Fixed the existing mappings on bug/defects and developed new mappings based on new requirements. Figured out the bottle necks of existing process and optimized them to accelerate the processes.
  • Migrated the codes from Dev to Test to Prod environment and wrote up the Team Based Development technical documents to smooth transfer of project. Prepared ETL technical Mapping documents along with test cases for each Mapping for future developments to maintain SDLC. Wrote scripts for Fastload, Multiload, T-Trump in BTEQ to fetch and to load data into Teradata tables.
  • Created Pre-& Post-Sessions UNIX Scripts, Functions, Triggers and Stored Procedures to drop & re-create the indexes and to solve the complex calculations on data. Responsible to transform and load of large sets of structured, semi-structured and unstructured data from heterogeneous sources.
  • Extensively worked on CDC to capture the data changes into sources and for delta load.
  • Used Debugger to validate the Mappings and gained troubleshooting information about the data and error conditions.
  • For each Mapping prepared effective Unit, Regression, Integration and System test cases for various stages to capture the data discrepancies/inaccuracies to ensure the successful execution of accurate data loading.
  • Peer-reviewed the code to cross-check if the logics are accurate or not to meet the business requirements and client standardization based on Tech Specs, fixed them if there are any discrepancies. Identify the feasible alternative approaches, systems and equipment reduce cost, improve efficiency while meeting the expectations.

Environment: - Informatica PowerCenter 9.6.1 HF2, SQL-Server-2012R, DB2, TeraData, BTEQ, SQL, PL/SQL, TOAD 9.5, Putty, WinSCP, UNIX ShellScripting, SQL-Developer, Control-M, Service Now, Squirrel, Aginity.

Sr. ETL Developer/ Specialist

Confidential, Mounds View, MN

Responsibilities:

  • Worked with stakeholders for requirements gathering, analysis, design, development, testing for N-to-N solutions and successfully implemented the project. Guided and supervised six off-shore resources.
  • Designed logical and physical data model using Power Designer and created Business Object (BO) Universe along with DDLs for different types of reports in SAP HANA.
  • Arranged daily & weekly meetings to monitor the resources and updated the client about work progresses.
  • Based on business requirements wrote the Tech Specs for each process, designed ETL process as a model for each layer and provided the solutions in a mission critical situation wherever the resources stuck on.
  • Wrote all DDL scripts to create Tables, Views, Transaction Tables, Triggers, Store Procedures for base tables and CDC processes in all layers. Designed Jobs by Unix Scripts for Tivoli to schedule workflows. Wrote SOP/AID documents for smooth transfer of project.
  • Migrated codes from Dev to Test to Pre-Prod. Created effective Unit, Integration test of data on different layers to capture the data discrepancies/inaccuracies to ensure successful execution of accurate data loading.
  • Extensively worked on CDC to capture the data changes into sources and for delta load. Used Debugger to validate the Mappings and gained troubleshooting information about the data and error conditions.
  • Debugged the invalid mappings and tasted Mappings, Sessions, and Workflows to figure out the Bottlenecks and tuned them for better performance. Built Unit test queries to test data accuracy.
  • Peer-reviewed the code to cross-check if the logics are accurate or not to meet the business requirements and client standardization based on Tech Specs, fixed them if there are any discrepancies. Identify the feasible alternative approaches, systems and equipment reduce cost, improve efficiency while meeting the expectations.

Environment: - Informatica PowerCenter 9.6.1 HF2, Oracle 11g/10g, SQL, PL/SQL, TOAD 9.5, Putty, WinSCP, UNIX ShellScripting, SQL-Developer, Tivoli, Hive, Pig, SAP-HANA, Business Object, SQL-Server, LAMP.

Sr. ETL Developer/ Specialist

Confidential, Jefferson City, MO

Responsibilities:

  • Participated in daily/weekly team meetings. Worked with the Business Analyst/Stakeholders to develop the FDD. Proposed new ETL processes for DST (Determination Summery Tables). Wrote the DDD and TDD documentations along with different test cases for smooth transfer of project and to maintain the SDLC.
  • Parsed high-levels design specification of ETL coding. Developed new SCD Type1/Type2 complex mappings, fixed the old mappings into different layers and proposed strategies for future growth of the data.
  • Guided the other developers and provided the technical solutions in need, peer reviewed their codes to meet the accurate business requirements and project standardization. Verified the unit testing results.
  • Tested mappings, workflows and sessions to figure out the bottleneck to tune them for better performance. Prepared effect Unit, Integration and System test cases for various stages to capture the data discrepancies/ inaccuracies to ensure the successful execution of accurate data loading. Worked on BTEQ scripts to extract the data from Teradata tables.
  • Extensively worked on CDC to capture the data changes into sources and for delta load. Used Debugger to validate the Mappings and gained troubleshooting information about the data and error conditions.
  • Migrated the codes from Dev to Test and Test to Prod. Wrote the migration documentation in details for system compatibility, objects and parameter files to smooth transfer of code into different environments.
  • Designed the automation process of Sessions, Workflows, scheduled the Workflows, created Worklets (command, email, assignment, control, event wait/raise, conditional flows etc) and configured them according to business logics & requirements to load data from different Sources to Targets.
  • Created Pre-& Post-Sessions UNIX Scripts, Functions, Triggers and Stored Procedures to drop & re-create the indexes and to solve the complex calculations on data.

Environment: - Informatica PowerCenter 9.6.1 HF4, DB2, Oracle 11g/10g, SQL, PL/SQL, TOAD 9.5, Putty, WinSCP, UNIX Shell Scripting, SQL-Developer, JIRA. XML, Control-M, SQL-Server-12, Teradata, LAMP.

Sr. ETL Developer/ Data Analyst

Confidential, Los Angeles, CA

Responsibilities:

  • Supervised the data warehousing functions of data compilation, extraction, loading, cleansing and modeling.
  • In corporate the advanced technologies, application tools and analysis techniques available in the market within the organization. Validate the provided data for accuracy, authenticity and legality.
  • Participated in team meetings and proposed ETL strategy based on Agile Methodology.
  • Based on Subject Areas, provided concrete solutions for complex/critical Mappings. Successfully implemented SCD Type1/ Type 2 for insert, CDC, and delete operation to maintain the data history. Created Mapping & Sessions Variables/Parameters, Parameters files, Mapplets to reuse during life cycle development.
  • Created batches based on Subject Areas for different layers to run Workflows/Worklets and Sessions, scheduled the Workflows for load frequencies and configured them to load data.
  • Involved in debugging the invalid Mappings. Tasted Mappings, Sessions, and Workflows to figure out the Bottlenecks and tuned them for better performance. Built Unit test queries to test data accuracy.
  • Migrated the codes from Development to Test, Test to Production. Created effective Unit, System, Integration test of data on different layers to capture the data discrepancies/inaccuracies to ensure the successful execution of accurate data loading. Created technical documentations for each Mapping for future developments.
  • Designed and coded change request as per the new requirements. Created Pre-& Post-Sessions UNIX Scripts, Stored Procedures to drop & re-create the indexes and to solve the complex calculation.
  • Perform Data quality analysis. Based on records, undertake actions to make improvements within the data.
  • Identify the feasible alternative approaches, systems and equipment reduce cost, improve efficiency while meeting the expectations.

Environment: - Informatica PowerCenter 9.6.1 HF4, MS-SQL 2008, Oracle 11g/10g, SQL, PL/SQL, TOAD 9.5, Putty, WinSCP, UNIX Shell Scripting, MS-SQL Server 2008, SQL-Developer, NoSQL, SSIS, SSRS,SSAS, T-SQL.

Sr. Data Warehousing(ETL)/IDQ Developer

Confidential, San Francisco, CA

Responsibilities:

  • Worked on Agile Methodology, participated in daily/weekly team meetings, guided two groups of seven developers in Informatica PowerCenter/Data Quality (IDQ), peer reviewed their development works and provided the technical solutions. Proposed ETL strategies based on requirements.
  • Designed and developed various complex SCD Type1/Type2 mappings in different layers, migrated the codes from Dev to Test to Prod environment. Wrote down the techno-functional documentations along with different test cases to smooth transfer of project and to maintain SDLC.
  • Tested mappings, workflows and sessions to figure out the bottleneck to tune them for better performance. Prepared effect Unit, Integration and System test cases for various stages to capture the data discrepancies/ inaccuracies to ensure the successful execution of accurate data loading.
  • Analyzed the data based on requirements, wrote down the techno-functional documentations and developed complex mappings using Informatica Data Quality (IDQ) 9.5.1 Developer to remove the noises of data using Parser, Labeler, Standardization, Merge, Match, Case Conversion, Consolidation, Address Validation, Key Generator, Lookup, Decision etc Transformations and performed the unit testing for accuracy of MDM data.
  • Used different algorithms like Biogram, Edit, Jaro, Reverse and Hamming Distance to determine the threshold values to identify and eliminate the duplicate datasets and to validate, profile and cleanse the data. Created/modified reference tables for valid data using IDQ Analyst tools for MDM data.
  • Used the Address Doctor to validate the address and performed exception handling, reporting and monitoring the system. Created different rules as mapplets, Logical Data Objects (LDO), workflows. Deployed the workflows as an application to run them. Tuned the mappings for better performance.
  • Created Pre-& Post-Sessions UNIX Scripts, Functions, Triggers and Stored Procedures to drop & re-create the indexes and to solve the complex calculations on data. Responsible to transform and load of large sets of structured, semi-structured and unstructured data from heterogeneous sources.

Environment: - Informatica PowerCenter 9.5.1 HF4, Informatica Data Quality (IDQ), MDM, Oracle 11g/10g, SQL, PL/SQL, TOAD 9.5, Putty, WinSCP, UNIX Shell Scripting, MS-SQL Server 2008, SQL-Developer, JIRA, Python.

Sr. ETL Developer-Informatica

Confidential, Beverly Hills, CA

Responsibilities:

  • Participated in daily/weekly meetings, monitored the work progresses of teams and proposed ETL strategies.
  • Migrated the codes from Dev to Test to Prod environment and wrote up the Team Based Development technical documents to smooth transfer of project. Prepared ETL technical Mapping documents along with test cases for each Mapping for future developments to maintain SDLC.
  • Worked on various complex SCD Type1/Type 2 Mappings in different layers to maintain the data history. Used Mappings & Sessions Variables/Parameters, Parameters files, Reusable Transformations & Mapplets to maintain the life cycle development and fixed other's Mappings.
  • For each Mapping prepared effective Unit, Integration and System test cases for various stages to capture the data discrepancies/inaccuracies to ensure the successful execution of accurate data loading.
  • Designed the automation process of Sessions, Workflows, scheduled the Workflows, created Worklets (command, email, assignment, control, event wait/raise, conditional flows etc) and configured them according to business logics & requirements to load data from different Sources to Targets.
  • Created Pre & Post-Sessions UNIX Scripts to merge the flat files and to create, delete temporary files, change the file name to reflect the file generated date etc.
  • Used Debugger to validate the Mappings and gained troubleshooting information about the data and error conditions. Involved in fixing the invalid Mappings. Wrote various Functions, Triggers and Stored Procedures to drop, re-create the indexes and to solve the complex calculations.

Environment: - Informatica PowerCenter 9.5.1 HF4, Oracle 11g/10g, SQL, PL/SQL, TOAD 9.5, Putty, WinSCP, UNIX Shell Scripting, MS-SQL Server 2005, SharePoint, HIPPA, IIR, Web Services (WSDL), MySQL, Hadoop.

Sr. ETL / IDQ Developer- Informatica

Confidential, Sacramento, CA

Responsibilities:

  • Coordinated in daily team meetings, technical code review meetings and interacted with business people for better technical solutions and proposed ETL strategy based on Agile Methodologies.
  • Validated, debugged old Mappings, tested Workflows & Sessions and figured out the better technical solutions. Identified the Bottlenecks in old/new Mappings and tuned them for better Performance.
  • Worked on Team Based development to migrate the codes from Dev to Test to Prod environment and wrote up the Team Based Development technical documents to smooth transfer of project.
  • Prepared effective Unit, Integration and System test cases of Mappings for various stages to capture the data discrepancies/inaccuracies to ensure the successful execution of accurate data loading.
  • Created Pre-& Post-Sessions UNIX Scripts, Functions, Triggers and Stored Procedures to drop & re-create the indexes and to solve the complex calculations. Transformed and loaded of large sets of structured, semi-structured and unstructured data coming from different sources Hadoop, CSV, Flat file MS-SQL, Oracle etc.
  • Worked with Informatica Data Quality (IDQ) 9.5.1 Developer/Analyst Tools to remove the noises of data using different transformations like Standardization, Merge and Match, Case Conversion, Consolidation, Parser, Labeler, Address Validation, Key Generator, Lookup, Decision etc.
  • Created Reference tables using IDQ Analyst tools. Used the Address Doctor Geo-coding table to validate the address and performed exception handling, reporting and monitoring the data.
  • Built the Logical Data Objects (LDO) and developed various mapping, mapplets/rules using the Informatica Data Quality (IDQ) based on requirements to profile, validate and cleanse the data. Identified and eliminated duplicate datasets and performed Columns, Primary Key, Foreign Key profiling using IDQ 9.5.1. for MDM.
  • Worked on Web Services (WSDL) to extract data from different Web Links and created Mappings load the data into target tables. Used WSDL link to represent the data in MS-Word, MS-Excel in Ads-on menu.

Environment: Informatica Power Center 9.1.0-9.5.1 HF2, Oracle 11g, PL/SQL, Toad 9.5, Dynamic SQL, UNIX Shell Scripting, SSIS, SSRS,SSAS, T-SQL Hadoop, Embercado, Web Services (WSDL), MDM, Netezza, OBIEE.

Sr. ETL / IDQ Developer- Informatica.

Confidential, San Josh, CA

Responsibilities:

  • Participated in team meetings and proposed ETL strategy based on Agile Methodology.
  • Worked on Informatica PowerCenter 8.6.1-9.1.0. HF1 Tools- Repository Manager, Informatica Designer, Workflow Manager/ Monitor, Informatica Data Quality(IDQ) Developer and Analyst Toolkits.
  • Created batches based on Subject Areas for different layers to run Workflows/Worklets and Sessions, scheduled the Workflows for load frequencies and configured them to load data.
  • Involved in debugging the invalid Mappings. Tasted Mappings, Sessions, and Workflows to figure out the Bottlenecks and tuned them for better performance. Built Unit test queries to test data accuracy.
  • Migrated the codes from Development to Test, Test to Production. Created effective Unit, System, Integration test of data on different layers to capture the data discrepancies/inaccuracies to ensure the successful execution of accurate data loading. Created technical documentations for each Mapping for future developments.
  • Designed and coded change request as per the new requirements. Created Pre & Post-Sessions UNIX Scripts, Stored Procedures to drop & re-create the indexes and to solve the complex calculation.
  • Worked with Informatica Data Quality (IDQ) 9.5.1 Developer/Analyst Tools to remove the noise of data using different transformations like Standardization, Merge and Match, Case Conversion, Consolidation, Parser, Labeler, Address Validation, Key Generator, Lookup, Decision etc. Wrote scripts for Fastload, Multiload, T-Trump in BTEQ to fetch and to load data into Teradata tables.
  • Created Reference/Master data for profiling using IDQ Analyst tools.
  • Used the Address Doctor Geo-coding table to validate the address and performed exception handling, reporting and monitoring the data.
  • Built the Physical Data Objects and developed various mapping, mapplets/rules using the Informatica Data Quality (IDQ) based on requirements to profile, validate and cleanse the data. Identified and eliminated duplicate datasets and performed Columns, Primary Key, Foreign Key profiling using IDQ 9.5.1. for the MDM.

Environment: Informatica Power Center 9.1.0/8.6.1 , Teradata, Oracle 11g, PL/SQL, UNIX, Toad 9.5, Dynamic SQL, Shell Scripting. Web Services (WSDL), Hadoop, IDQ 9.5.1, IIR, BTEQ, MDM, OBIEE, Python.

Sr. ETL Developer- Informatica

Confidential, Burbank, CA

Responsibilities:

  • Developed various complex Mappings and successfully implemented SCD Type1/Type 2 to keep the data history changes. Designed and coded change request as per the new requirements.
  • Migrated the codes from Repository to Repository. Used debugger to validate the Mappings and gained troubleshooting information about the data and error conditions. Involved in fixing the invalid Mappings. Tested the Mappings, Sessions, Workflows and Worklets. Wrote the test queries to check if the data was loading to dimension tables and fact tables properly.
  • Created and reviewed the logical and physical data model for the fact and dimension tables according to business requirements to be used for EDW. Created DDL scripts to implement Data Model changes. Created ERwin reports in HTML, RTF format depending upon the requirements, published Data Model in Model Mart, co-coordinated with DBAs to apply the data model changes.
  • Created effective Unit, System and Integration Test cases for various stages of ETL to capture the data discrepancies and inaccuracies to ensure the successful execution of accurate data loading.
  • Wrote Functions, Stored Procedures to drop & re-create the indexes and to solve the complex calculation as needed. Tested and maintained data integrity among various Sources and Targets.
  • Worked on Performance Tuning to tune the data loading by identifying the Bottlenecks in Sources, Targets, Mappings, Transformations, Sessions, Database, Network then fixing them.
  • Involved in providing Informatica Technical Support to the team members, as well as the business.

Environment: Informatica PowerCenter/Power Exchange 8.6.1/9.1, Teradata, Oracle 10g, MS-Server 2008, PL/SQL, ERwin 8.2, Toad 9.5, Putty, WinSCP, UNIX, SOAP, SAP, COBOL, Web Services (WSDL), MySQL, OBIEE.

Hire Now