Us Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 19th Nov 2020
Title: ETL Developer
Expected contract duration: 6+ Contract
Location: Deerfield Beach, FL
Pay rate : $52-54.00/hr on C2C
Looking for only GC and US Citizens
Short description:
Sr, ETL IICS Developer / Data Modeling that describes how data is processed, stored, and utilized. Manage the data structures required to support the enterprise through the BI program.
Provide the means of system integration by understanding the source and target data and build the data mapping. Determine architectural approaches for data environments and help ensure that the data needs of the enterprise are being met.
Responsible for developing and maintaining a formal description of the data and data structures this can include data definitions and data models. Build strategy and design for managing data history. This candidate must have the ability to develop in Informatica IICS, with Data Center experience.
Duties / Responsibilities:
Understand and translate business needs into data models supporting long-term solutions.
Work with the SA’s DA’s and Application Development team to implement data strategies, build data flows and develop conceptual data models.
Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
Optimize and update logical and physical data models to support new and existing projects.
Maintain conceptual, logical and physical data models along with corresponding metadata.
Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
Recommend opportunities for reuse of data models in new environments.
Perform reverse engineering of physical data models from databases and SQL scripts.
Evaluate data models and physical databases for variances and discrepancies.
Validate business data objects for accuracy and completeness.
Analyze data-related system integration challenges and propose appropriate solutions.
Develop data models according to company standards.
Review modifications to existing software to improve efficiency and performance.
Examine new application design and recommend corrections if required.
ETL:
Minimum Experience: 5 years of hands on Informatica Power center and IICS development
Has to be using Informatica in the current project
Intermediate level of SQL and Unix knowledge
Looking for someone who can start working with minimal Guidance.
The interview will be highly technical and focus on Informatica, SQL and UNIX questions
On site interview will require candidate to demonstrate Informatica, SQL and UNIX skills
Informatica needs to be primary skill
Data Modeling experience is a must
Certificates:
Informatica ETL Certifications a Plus
Informatica Cloud Knowledge a Plus
Skills / Requirements / Qualifications :
Complex Problem Solving — identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
Programming — Writing computer programs for various purposes.
Systems Analysis — Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.
Judgment and Decision Making — Considering the relative costs and benefits of potential actions to choose the most appropriate one.
Systems Evaluation — Identifying measures or indicators of system performance and the actions needed to improve or correct performance, relative to the goals of the system.
Critical Thinking — using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
Operations Analysis — Analyzing needs and product requirements to create a design.
Active listening — Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times.
Mathematics — using mathematics to solve problems.
Speaking — talking to others to convey information effectively.
Reading Comprehension — Understanding written sentences and paragraphs in work related documents.
Technology Design — Generating or adapting equipment and technology to serve user needs.
Time Management — managing one's own time and ability to work on multiple projects at the same time.
Troubleshooting — determining causes of operating errors and deciding what to do about it.
Writing — communicating effectively in writing as appropriate for the needs of the audience.
------------------------------------------------------------------------------------------------------------------------------
Mohammed Nadeem | Lead Talent Acquisition Specialist
Panzer Solutions
50 Washington Street,9th Floor, SONO Corporate Center Norwalk CT 06854
Email: Mohd.Nadeem@panzersolutions.com
Contact: 203-652-1444 Ext:- 106
Direct: 203-442-9701
PANZER AN ISO 9001:2015 CERTIFIED COMPANY.