17 Apr
Informatica Power Center Developer
Vacancy expired!
Note : Please reply ONLY if you1) have all the Required skill set and have worked as a "Informatica PowerCenter Developer" in a large & Complex IT Environment. Prefer Public Sector Experience2) can meet the min required experience as defined under the MANDATORY Skill 3) can provide at least 3 verifiable experience from completed and/or substantially completed jobs that closely match this request + fill out a skill Matrix + Resume Certification Form4) Can go through a background check including fingerprinting + Agree to a Mandatory F-2-F interview at your own cost once you are 1 of the TOP candidates.5) have A Competitive Rate6 will be available in
April 2021 timeframe as the Start date after a successful interview takes a minimum of 3 weeks.s and those authorized to work in the US are encouraged to apply. We are unable to sponsor H1b candidates at this time.NOTE: GIS will utilize the U.S. Department of Homeland Security's E-Verify system to verify the employment eligibility of all persons employed during the term of the ContractNote to Consulting Companies : ANY CONSULTANT’S RESUME YOU SEND ME “MUST” BE ON YOUR COMPANY’S PAYROLL, NO H1-VISA TRANSFER, NO PRO-MARKETING, NO SISTER COMPANY RESUMES. The resume should have the DIRECT contact info and email of the candidate otherwise the candidate will NOT be considered. ALL H1 candidates including those onWOULD need to provide I-797 + DL Copy (no exceptions).Each staff member assigned to this project must have a background screening that is equivalent to a Level Two (2) screening standard.This is a fixed fee/hourly based project which is inclusive of travel, lodging, per diem expenses and all other costs associated with the completion of the associated tasks.May be required to periodically travel between Boc, Pompano Beach and OrlandoPurpose:Our Client needs an Intermediate Informatica PowerCenter Developer to join their datawarehouse team.This person will be expected to apply best practices in the management of Informatica PowerCenter ETL platform, work closely with a team to design, develop and support the ETL process in the datawarehouse environment.This person will contribute to the datawarehouse security and quality standards across the ETL process and will be called upon to investigate and resolve ETL/data quality issues.This is an onsite position.Skills & Experience WeightingA = Candidate must have these attributesB = Management strongly desire the candidate has these attributesC = Management desires the candidate has these attributesMANDATORY Technical/Business Skill Set Requirements• A- Informatica PowerCenter development (version 9/10)• A- Oracle development with pl/sql, stored procedure and package(version 11g/12c or higher)• A- Shell script development on Solaris 11.x, RHEL 7.x• A- Documentation skill for logical mapping and process flow design• A- Effective Data analysis, trouble shooting, and problem solving skills• A- Bi-weekly Production On-call• A- Excellent interpersonal, verbal, and written communication skills• A- Team Player, Self Driven, Proactive, No conflicts• B- Informatica PowerCenter Administration (version 9/10)• B -Informatica PowerCenter Migration (version 9 to 10)• B -CA Workload Automation scheduler application• B- Multidimensional data modeling• B- Data quality assurance skill• C- Informatica Metadata ManagerKnowledge and Experience Needed• A- Understand datawarehouse methodologies and business intelligence that depict the ETL process flow between systems and business functions• A- Knowledge of information flow, data issues and transformation of business requirements into Informatica PowerCenter mapping/session/workflow• A- In depth knowledge of Informatica PowerCenter tool set, minimum 5 years with Informatica PowerCenter version 9/10.• A- Knowledge of meta data concepts, querying repository• A- Experience and ability to apply Informatica PowerCenter best practices for performing ETL process• A- Extensive working knowledge of Oracle database, relational and dimensional data modeling (logical, physical) and full life cycle of datawarehouse development (top-down, bottom-up)• B- Knowledge of OLAP/MOLAP application development• B- Practical experience in a high volume/availability OLTP and datawarehouse environment (top-down, bottom-up)• B- Experience of Informatica PowerCenter version 9/10 deployment process, documentation and data migration• C- Documentation using Informatica Velocity templates• C- Cognos 10/11 experience as an end user• C- Public Sector experienceResponsibilities • Substantially contribute to the system architecture and ETL layer• Write requirements specifications according to standard templates, using clear, unambiguous, and simple language.• Transfer high-level business and user requirements into functional requirements• Design, develop and test(unit, volume, regression, performance), Informatica PowerCenter mapping as well as session and workflow based on ETL standards and specifications• Participate in data gathering, defining, and analysis of ETL requirements• Support cross-functional efforts to in Cognos reporting performance• Perform impact analysis on required changes in an expeditious manner• Maintain and support Informatica ETL processes in development, testing and production, on-call• Perform Informatica administrative tasks• Effectively communicate in person and via e-mail• Work with system architects to improve existing OLTP model, increase data quality, and improve ETL performance• Work with the DBA, Unix team and leads to maintain ETL stability, and security• Recommend to IT management changes to improve processes and ensure performance• Prepare SOPs (standard operating procedures) to document ETL jobs, operations & failure recoveryMeasures of Performance• Successful ETL processing across the data warehouse environment• Operational performance of ETL processes supported• Successful recovery from disasters and disaster simulations• Feedback from key customer or project representatives• Customer satisfaction measures• Satisfying or exceeding requirements development schedules, resource constraints, and quality goalsEducation and certifications • Relevant Bachelors Degree or equivalent experience• Informatica Professional Certification preferredIncumbent may be required to work before, during and/or beyond normal work hours or days in the event of an emergency. Emergency duty required of the incumbent includes working in special needs or Red Cross shelters, or performing other emergency duties including, but not limited to, responses to or threats involving any disaster or threat of disaster, man-made or natural."When replying please make sure to list your (All Inclusive) Compensation requirements "Note : This is a Full time ON SITE Contract Position Start date : April 2021No phone calls please.Local ONLY candidates with an exact match will be contactedNo relocation assistance provided.Candidates should be authorized to work in the US. Questions1) What is your current status (, holder etc…) ?2) What is your Rate/hr (All Inclusive) on 1099 OR Copr-2-Corp basis ?3) What is your Rate/hr (All Inclusive) on W-2 basis ?4) Have you been approached from any other firm about this opportunity ?5) Can you provide 3 References where you worked as a “Informatica Power Center Developer ”.6) Do you give your consent to a Criminal back ground check (including finger printing) by the client once selected ?7) Can you fill out a resume certification form, matrix and Reference form ? See attached8) Would you be able to start the project in late April 2021 ?9) What is the BEST Contact number and time to reach you ?10) Do you Consent to coming for a F-2-F in Boca Raton, FL @ your own expense if required by the client ?11) Are you currently employed – (Y/N) ? If yes why do you wish to move and if not how can you be available for this project as it will begin sometimes in late April 2021 ?12) Can you sign a Rate Agreement with us after All the terms have been agreed upon ?Vacancy expired!