Thoughtwave@15years

News


    Added on
  • October 30, 2020
  • by
  • Admin

Current Openings at Thoughtwave Software and Solutions Inc

1) Sr Technical Lead ETL Developer

Posted on: 09/25/2020

Duration: 12 Months + Transfer

Location: Alpharetta,GA

Education Qualification: Bachelor’s in computer science or its equivalent

Job Description: 

 

  • Develop mappings, define workflows and tasks, monitor sessions, export and import mappings and workflows and perform backup and recovery.
  • Extracting relevant data from appropriate data sources for the execution of the project.
  • Code necessary transformations to convert source data as per the business requirements to load data warehouse using ETL Informatica tool.
  • Create BTEQ scripts, Fast Export, Fast Load, and Multi Load to extract and load the data to data warehouse from Teradata
  • Create data Modeling (2NF, 3NF) and OLAP Dimensional modeling (Star and SnowFlake) using Erwin (conceptual, logical and physical data models).
  • Work with various versions of Informatica, Informatica Power Center 9.6.1/9.1/8.6.1/7.1, and Informatica power exchange 9.6/9.1. Informatica IDQ 9.6.1
  • Extract relevant data from Teradata, oracle, IBM Mainframe and flat files for the execution of the project.
  • Work in a migration project where data migration from Teradata on premises to Redshift AWS cloud.
  • Responsible for extracting relevant data from Teradata, oracle, IBM Mainframe and flat files for the execution of the project.
  • Created mappings using Informatica Cloud transformations Source and target, Data mask, Expression, Filter, Hierarchy Builder, Hierarchy parser, joiner, lookup, Router, sequence Generator, sorter, SQL, and Web services transformations to load the data from Salesforce to Oracle Databases
  • Create data models on business processes and data.  
  • Responsible for creation and execution of test plans for integration and system tests.
  • Design and develop specifications for complex and cross-functional systems and data structures.
  • Work with cross functional teams to analyze and recommend new technologies.
  • Responsible for Coordinating and transitioning the detailed requirements to offshore. Review offshore development codes and verify the test results to make sure they meet the requirements.
  • Analyze and improve the database queries performance.
  • Data quality check – Ensuring data integrity by cross checking the extracted data with the relevant stakeholders for data accuracy and consistency.
  • Working with the test lead in creation of system integration test cases and system integration test cases execution.
  • Deploying the developed, tested code in production to go live and resolve critical issues.
  • Share all the intermediate and final deliverables with the client in order to establish cadence and seek timely feedback for the same.
  • Resolving the post production defects and enhancing the applications.
  • Responsible for Creating BTEQ scripts, Fast Export, Fast Load, and Multi Load to extract and load the data to data warehouse from Teradata.
  • Collaborating with CVS business users and other stake holders in order to understand the business background, clearly define the scope and provide solution clarity.
  • Developing clear statement of objectives and performance metrics.
  • Analyzes system and program requirements for complex Informatica projects.
  • Understanding the client’s (CVS) business requirements in detail to plan and convert into technical requirements.
  • Analyzing database schemas and table volume.
  • Assessing the impact of project implementations on the database schemas and tables.
  • Assessing the landscape and architecture of the existing databases including, environment, coding and integration standards.
  • Preparing high level design documents for CVS.
  • Assessing design, build and Development Process.
  • Discussing the strengths and weaknesses of various alternative solution approaches with respective business units.
  • Working with the client and business analysts to finalize technical documents in order to start coding.
  • Discuss and review Development strategy.
  • Setup periodic design review session with architecture team.
  • Interacting with IT/business consumers, understand requirements and translate into technical requirements for implementation after consultation with architecture team.
  • Interfaces with clients to determine requirements, resolve problems, and perform testing.
  • Designs and develops specifications for complex or cross-functional systems and
  • Data structures.
  • Work with cross functional teams to analyze and recommend new technologies.
  • Extracting relevant data from appropriate data sources for the execution of the project.
  • Understanding application and information governance, defined standards and best practices.
  • Create data models on business processes and data.
  • Designs, codes, tests, and documents programs and sub-systems.
  • Code necessary transformations to convert source data as per the business requirements to load data warehouse using ETL Informatica tool.
  • Develops specifications and technical design for complex projects using Informatica.
  • Project implementation and Production deployment.
  • Data quality check – Ensuring data integrity by cross checking the extracted data with the relevant stakeholders for data accuracy and consistency.
  • Working with the test lead in creation of system integration test cases and system integration test cases execution.
  • Deploying the developed, tested code in production to go live and resolve critical issues.
  • Share all the intermediate and final deliverables with the client in order to establish cadence and seek timely feedback for the same.
  • Reiterating over the results to improve model accuracy and effectiveness of the solution, if necessary.
  • Collating and presenting the recommendations and insights that would enable continuous measurable improvement in the client’s business decisions.
  • Preparing executive summary of the results for the senior management.
  • Resolving the post production defects and enhancing the applications.
  • Demonstrates advanced understanding of software development and research Tools

 

Please reach us at profiles@thoughtwavesoft.com; Phone: +1-630-448-6681


Leave a Reply

Your email address will not be published. Required fields are marked *

Go to Top