Get job as soon as 2 days (HURRY UP) ENROLL NOW or Call   +1 (804)-454-3215
+


Job ID : 35441

Location : Texas City, TX

Company Name : MSIT

Job Type : Full-Time, Part-Time, Contract, Training

Industry : Information Technology

Salary : $155000 - $168000  per year

No. of Positions : I have ongoing need to fill this role


Required Skills : SQL, data storage techniques, Big Data technologies..

Benefits : Medical Insurance, Dental Insurance, Vision Insurance, 401K, Life Insurance


Job Description :

Responsibilities:

  • Data Profiling, Scorecards and Understanding data gaps and Interaction with Data Stewards and Business SME’s and apply Business and Data transformation rules.
  • Data Cleansing, Data Validation, Data Standardization, Customer Address Validation using Address Doctor and migrate the cleansed data to Salesforce AWS3 Buckets, Data Platform HIVE DB and Mule Soft, downstream applications using Informatica Power Center under AWS and Informatica Intelligence Cloud Services.
  • Preparation of ETL Technical specifications and identification of GAP's and get it reviewed by Data Architect's, Business SME's and proper sign off and developer handover.
  • Using Informatica Power Exchange connector to read DB2 Mainframe Sales system data and load into Salesforce (Sales & Marketing Clouds) using Salesforce Connector.
  • Bulk Data loads and Deletion in Salesforce objects by using automated informatica ETL Jobs.
  • Understanding GDW Teradata BTEQ scripts and enhancements based on new requirements and providing required Salesforce objects names and its data types under change list of Salesforce Agile accelerator and interaction with Salesforce team.
  • ETL code development, Unit testing code peer review by Data Architects and proper hand over to QA team and then code deployment across the environments. Preparation of Technical design document. Post production and warranty.

 Requirement:

  • Expert designer, coder and tester for data warehouse programming by using Informatica Power Center, Informatica Developer Tool, Informatica Power Exchange.
  • Experience in Data profiling, Data Cleansing and Standardization and building reusability logic.
  • Able to Read/Write data from/to different DB’s and applications like – Teradata, SQL Server, DB2, Oracle, Salesforce, AWS S3, DP Hive.
  • Experience in design reviews and extensive documentation of standards, best practices, and ETL procedures.
  • Evaluate all functional requirements and map documents and perform troubleshoot on all development processes.

Key Skills:

  • SQL competence.
  • Understanding of data modeling concepts.
  • Knowledge of at least one ETL tool.
  • Knowledge of different SQL/NoSQL data storage techniques and Big Data technologies.

Recommended jobs for you

  • Etl Developer

    Dart Point Texas City, TX

    Responsibilities : Responsibilities: Understanding existing ETL Workflows. Modifying/re-architect ETL workflows. Design, develop, implement, and continuously expand data

    View Job
  • Etl Developer

    Apollose Texas City, TX

    Responsibilities : Responsibilities: Collaborate with 3rd parties and government agencies to understand data integration requirements and ensure compliance with data security and re

    View Job

Thanks For Your Feedback

We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.

Attach A Resume First