informatica 9.1 latest project scenario and 2015 first page

Hi Folks,

I have a one table project_est_db,in this table two columns like s_no,DAY_DT  like this data:

S_NO        Day_DT

1                           04-jan-2015

2                            05-jan-2015

3                          06-jan-2015

4                          07-jan-2015
5              08-jan-2015
.               ---------------
.               ----------------
.               ---------------
.               ----------------
.               ----------------
29            30-jan-2015

This is actually dimentional table.this table use to all related dates,time_stamp realted.so that i am

face one scenario actually. that is ??

In same above table i want next 2 weeks data and previous 2 weeks data.I think  confusee right ??

so data like this,

S_NO   Day_DT        Next_week1  Next_week2   Prev_week1  Prev_week2

1           04-jan-2015   20150104       20150111        20150103     20141227
2           05-jan-2015   20150105       ----------           20150102     20141226
3           --------------    -----------         ---------            --------------   -----------
4           --------------  ------------         -----------          20141231     -----------
5           --------------  -------------        -----------          ------------      ----------
6           --------------  -------------        -----------           -----------      ------------
7           10-jan-2015 20150110         20150116          20141228     20141221





You can use  this queries:

1.For Next_week1

UPDATE project_est_db D1 SET Next_week1=
(SELECT to_number(to_char(D.day_dt+(7*1),'YYYYMMDD')) FROM project_est_db D WHERE D1.DAY_DT=D.DAY_DT);

2.For Next_week2

UPDATE project_est_db D1 SET Next_week2=
(SELECT to_number(to_char(D.day_dt+(7*2),'YYYYMMDD')) FROM project_est_db D WHERE D1.DAY_DT=D.DAY_DT);

3.For Prev_week1

UPDATE project_est_db D1 SET Prev_week1=
(SELECT to_number(to_char(D.day_dt-(7*1),'YYYYMMDD')) FROM project_est_db D WHERE D1.DAY_DT=D.DAY_DT)

4..For Prev_week1

UPDATE project_est_db D1 SET Prev_week2=
(SELECT to_number(to_char(D.day_dt-(7*2),'YYYYMMDD')) FROM project_est_db D WHERE D1.DAY_DT=D.DAY_DT)

Informatica 9.1 Roles and Responsibilities

1. About 3 – 7  years of experience in using ETL tools business intelligence, data warehousing or data management
2. Formal Certification in Informatica would be preferred.
3. Use your technical and resume below points.as soon as possible to in market shortist. 

• • Create effective ETL specifications from functional requirements.
  • Work with developers to build ETL workflows, sessions and source-to-target mappings including error-handling and audit processes.
  • Participate in the full development cycle from design to implementation, documentation, and maintenance.
  • Ensure ETL quality through code reviews, inspections and knowledge sharing.
  • Create and execute unit test plans based on system and validation requirements
  • Troubleshoot, optimize and tune ETL processesKnowledge of Dimensional Modeling.
  • Expert in Informatica PowerCenter administration and development including PowerCenter 9.x
  • Experience with Kimball methodology and Star Schemas.
  • The Informatica architect will be responsible for full software development lifecycle of the ETL solutions leveraging Informatica, including requirements definition, analysis, design, development, and support of testing and migration to Production.
  • Maintain consistent ETL standards, configuration management strategies and production deployment standards.
  • Responsible for ETL technical design, perform design/code reviews and work with ETL Engineers to deliver an efficient ETL solution.
  • May assist in one or more components of the overall architecture of the data warehouse system.
  • Participate with team in formal and informal peer reviews, scheduling, and design presentations.
  •   Applicant should be knowledgeable and experienced in all types of data modeling, including strong dimensional modeling techniques.
  • Applicant should be experienced with data quality tools and knowledgeable in data quality approaches and techniques.
  • Experience working with data warehousing standards, strategies, and tools.
    Experience with large Data Warehousing projects.
  • Knowledge of ETL processes and dimensional modeling such as:
    CDC (Change data Capture)
    SCD (Slowly Changing Dimensions).
  • Understand reusability, parameterization, workflow design, etc.
    Caching, parallel processing & other performance tuning.
  • Experience in Metadata Management, Data Governance and Data Quality.
  • Extensive experience in performance tuning Informatica ETL jobs. Solid knowledge of Unix shell scripting. Demonstrated ability to implement scalable ETL processes. 
  • Ability to work independently and multi-task to meet critical deadlines in a rapidly changing environment.
  • Must be a team player and be able to mentor other developers Good communication and presentation skills and must have the ability to work with people in various groups and departments.
  • Knowledge of finance and accounting processes would be a plus.
  • A bachelor degree in Computer Science / Computer Information System or closely related field.
  • Provide operational support to batch and payment processes.
  • Develop, enhance and support web based and standalone applications developed in Java.
  • Deployment of software to QA and Production environments Develop reports to disseminate data to business entities Support to business users during the financial close.
  • Demonstrated ability in Informatica ETL Developer role with strong hands on experience in developing complex ETL processes. (Informatica PowerCenter 9.0.1 or higher is a must.
  • Strong experience implementing Data Warehousing and Business Intelligence solutions.
  • Understanding of RDBMS principles and hands on experience Oracle in development of procedures/ packages / triggers and table design Some hands on development on any programming language like C++ or Java is a plus Good understanding of Data warehousing project life cycle, especially tasks within the ETL phase.
  • Design, Develop, Test and debug ETL to pull data from transactional systems to ERP interfaces.
  • Develop datamarts using ETL and data warehousing concepts for large data sets.
  • Develop and test UNIX scripts for pre and post loading processes.
  • Performance tune Informatica ETL mappings for optimal performance.
  • Analyze different source systems using XML/RDBMS/FLATFILES.
  • SQL performance tuning, scripting Unix shells and integrating with Workflows.
  • Deep understanding of Informatica transformations and workflow components.
  • Participate in design workshops, providing technical insight and knowledge.
  • DB analysis to determine health and usage, ETL Benchmarking and workflow workload testing.
  • Excellent analysis skills and foresight / understanding of Informatica development
    Excellent communication and interpersonal skills.
  • Strong team player skills and team motivator.
  • Ability to coordinate with multiple internal and external teams.
  • Initiative, self-motivation and a sense of urgency.
  • Solid 3+ years of development projects hands on experience using Informatica Power Center.
  • Development of Informatica Mappings/Mapplets/Sessions/Workflows by using key Informatica Transformations.
  • ETL development experience with combination of Informatica & Teradata database environment is preferred.
  • Experience in writing sql queris with basic performance tuning & understanding of the database concepts like joins/views/indexing/partitioning etc.
  • Knowledge on basic UNIX commands and shell scripts.
  • Good communications skills.
  • Strong Hands on experience with Extract, Transform & Load process using Informatica Power Center. 
  • Experience in Error Handling, Scheduling, Identifying ETL Job Dependency and Recovery mechanisms.
  •  Extensive experience in designing and developing ETL mappings using Informatica Designer, and configuring sessions/workflows using Workflow Manager. 
  • Understanding configuration, migration and deployment of ETL mappings.
    Good knowledge of any one database.
  • Extensive experience in performance tuning of Informatica Mappings/Sessions. 
  • Experience in estimating ETL requirements, designing and architecting integration solutions.
  • Understanding the change data capture, Data Profiling and Data Reconciliation concepts.
  • Good knowledge dimensional modeling and DWH concepts. 
  • Proficient in identifying, analyzing and solving problems. 
  • Good analytical and communication skills. 
  • strong customer relationships and creates processes with customer viewpoint.
  • Strong analytical skills – strong problem solving skills, communicates in a clear and succinct manner and effectively evaluates information / data to make decisions, anticipates obstacles and develops plans to resolve.
  • Change oriented – actively generates process improvements, supports and drives change and confronts difficult circumstances in creative ways.
  •  Demonstrated ability to independently develop and execute ETL modules and assist Functional clients in design and testing initiatives.
  • Prior experience with global functional teams that are not co-located
    Strong coding, analytical skills to generate effective ETL solutions and robust testing to align with the business requirements and IT strategy related to business intelligence.
  • Experience with industry-wide BI tools such as Informatica
    Experience in SAS, Hadoop, Bigdata technologies will be added advantage not essential, OBIEE, Business Objects, Qlikview or Spotfire, MDM.
  •  Able to articulate technical concepts in non-technical terms
    Resourceful and quick learner, able to efficiently seek out, learn, & apply new areas of expertise as needed.
  • Highly self-motivated, able to work independently.
  • Should be able to handle aggressive timelines, deliverables Black belt or Lean certified.
  • Strong track record of understanding and interest in current and emerging technologies.
  • demonstrated through training, job experience and / or industry activities.
  • Strong team player – collaborates well with others to solve problems and actively incorporates input from various sources.
  • Demonstrated customer focus – evaluates decisions through the eyes of the custome
  • builds strong customer relationships and creates processes with customer viewpoint.
  •   Module level design & Architecture and Design.
  • Code - Reviews.
  • Resolving Technical Issues.
  • Project Documentation.
  • Understands application architectures and has good command over module platforms.
  • Can convert business requirements into a design.
  •  Has ability to see through the modular issues.
  • Lead and execute your ETL project deliverables supporting the defined reporting and data management strategies.
  • Contribute to the technical designs, architecture, development, documentation, implementation and maintenance of IT solutions.
  • Accountable for module delivery including module reviews, feasibility, initiation, execution and closure for all module work.
  • Own module support activities, including the development of internal and external communications, establishing development coding benchmarks.
  • Support, assist, and resolve problems for client users.
  • Works with project manager, architect and other stakeholders to define and plan solutions.
  • Ensures compliance and contribute with the project management methodologies and the Project Management Office processes and standards.
  •  Ensure conformance to system architecture, standards and practices.
  • Ensuring the deliveries are on time and with the prescribed quality adhering to the functional and technical designs and standards.
  • Develop unit test plans, manage dependencies, minimize risks.
  • Manage Agile / Scrum teams, backlog, release schedules.
  • Proactively identify corrective actions to address code issues and bugs.