Sr. Data Developer
Job Description
Job Title: Sr. Data Developer
Need w2 consultants and must be locals only
Visa : H1B ,or USC
Experience Level: 10 years
Skills & Job Responsibilities
* Informatica ETL Developer responsibilities:
* Create Informatica mappings with Oracle database objects to incorporate critical business functionality to load the data into the Salesforce application.
* Create/Use connections to retrieve data from various sources.
* Work with relational databases like Oracle to understand the data and be able to analyze/troubleshoot data issues.
* Actively participate in all phases of SDLC from requirements gathering, architecture design, development, testing, and data migration.
* Provide documented operation and user procedures, when required, and perform supporting training for respective users.
* Provide data flow diagrams describing the solution, when required.
* Document implementation instructions for production and lower-environment deployments.
* Run jobs and facilitate procurement of test data, when needed, in order to test code to satisfaction.
* Be available for occasional off-hours (Eastern time zone) production deployments in order to support dev ops team if questions/issues arise with ETL code.
* Import/export objects using IICS and knowing the impacts of all of the options.
* Troubleshoot and analyze error logs and job results that do not meet the requirements.
* Communicate effectively and in a timely, respectful, professional manner with all teammates.
* Required experience:
* 5-7 years of ETL experience using Informatica IICS
* 5-7 years practical experience with SQL (standard query language) on relational databases
* Effectively communicate in English, both written and spoken language
* Preferred experience:
* Using Salesforce Developer Console with SOQL (Salesforce Object Query Language)
* Maintaining production systems
* Data modeling
* Creating and maintaining business reports
* Intermediate-level expertise in Microsoft Excel (vlookups, pivot tables, etc)
* Running Salesforce DataLoader
* Promoting code between environments
* Working with MSDOS batch files as pre- and post-conditions for IICS jobs
* IICS server configurations
* Analyzing and retrieving full production error logs from server
