Data Engineer

The following requirement is open with our client.

Client                              : TCS

Title                                 : Data Engineer

Location                       : Sunnyvale, CA (Onsite)

Duration                      : 6 Months

Visa                                  : Any

      Pay rate                            :$60\hr on C2C

       Relevant Experience (in Yrs.)    : 4+

        Detailed Job Description:

Data Strategy
• Understands, articulates, and applies principles of the defined strategy to routine business problems that involve a single function.
Data Transformation and Integration
• Extracts data from identified databases.
• Creates data pipelines and transforms data to a structure that is relevant to the problem by selecting appropriate techniques.
• Develops knowledge of current analytics trends.
Data Source Identification
• Supports the understanding of the priority order of requirements and service level agreements.
• Helps identify the most suitable source for data that is fit for purpose.
• Performs initial data quality checks on extracted data.
Data Modeling
• Analyses complex data elements, systems, data flows, dependencies, and relationships to contribute to conceptual, physical, and logical data models.
• Develops the Logical Data Model and Physical Data Models including data warehouse and data mart designs.
• Defines relational tables, primary and foreign keys, and stored procedures to create a data model structure.
• Evaluates existing data models and physical databases for variances and discrepancies.
• Develops efficient data flows.
• Analyses data-related system integration challenges and proposes appropriate solutions.
Code Development and Testing
• Writes code to develop the required solution and application features by determining the appropriate programming language and leveraging business, technical, and data requirements.
• Creates test cases to review and validate the proposed solution design.
• Creates proofs of concept.
• Tests the code using the appropriate testing approach.
• Deploys software to production servers.
• Contributes code documentation, maintains playbook, and provides timely progress updates.
Problem Formulation
• Translates business problems within one''s discipline to data-related or mathematical solutions.
• Identifies what methods (for example, analytics, big data analytics, automation) would provide a solution for the problem.
• Shares use cases and gives examples to demonstrate how the method would solve the business problem.
Applied Business Acumen
• Provides recommendations to business stakeholders to solve complex business issues.
• Develops business cases for projects with a projected return on investment or cost savings.
• Translates business requirements into projects, activities, and tasks and aligns to overall business strategy.
• Serves as an interpreter and conduit to connect business needs with tangible solutions and results.
• Recommends new processes and ways of working.
Data Governance
• Establishes, modifies, and documents data governance projects and recommendations.
• Implements data governance practices in partnership with business stakeholders and peers.
• Interprets company and regulatory policies on data.
• Educates others on data governance processes, practices, policies, and guidelines.
• Provides recommendations on needed updates or inputs into data governance policies, practices, or guidelines.

Must Have skills :

•         Data Engineering / ETL Pipelines

•         SQL & Relational Databases

•         Data Modeling

                  Python / Data Engineering Programming

                  Data Governance & Data Quality